Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error in mysql  (Read 2925 times)

0 Members and 1 Guest are viewing this topic.

Mehidi

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
Error in mysql
« on: October 13, 2005, 08:55:27 pm »
Hello !
When i want to insert my table of coppermine on my new host i had this error :

CREATE TABLE `cpg133_albums` (

`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`pic_count` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`last_addition` datetime NOT NULL default '0000-00-00 00:00:00',
`stat_uptodate` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`keyword` varchar( 50 ) default NULL ,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =101

What does it mean ?
Thanks !
« Last Edit: October 14, 2005, 01:17:49 pm by Abbas Ali »
Logged

Nibbler

  • Guest
Re: Error in mysql
« Reply #1 on: October 13, 2005, 09:13:16 pm »
Remove this bit

Code: [Select]
DEFAULT CHARSET = latin1
Looks like you are moving from a higher version of mysql to a lower version, there is a compatibility option when exporting from phpmyadmin if that is what you used for the export.
Logged

Mehidi

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
Re: Error in mysql
« Reply #2 on: October 14, 2005, 08:05:35 am »
I had put the file that you send to me but i have this error :
CREATE TABLE `cpg133_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`pic_count` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`last_addition` datetime NOT NULL default '0000-00-00 00:00:00',
`stat_uptodate` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`keyword` varchar( 50 ) default NULL ,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) TYPE = MYISAM AUTO_INCREMENT =101

MySQL a répondu:

#1046 - No Database Selected
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error in mysql
« Reply #3 on: October 14, 2005, 08:15:10 am »
well, then select a database first  ;)
Logged

Mehidi

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
Re: Error in mysql
« Reply #4 on: October 14, 2005, 08:28:13 am »
Thanks for your answer !
It's Ok now :)

Have a nice day
Logged

Mehidi

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
Re: Error in mysql
« Reply #5 on: October 14, 2005, 12:36:40 pm »
No it's not Ok LOL
I had make an answer here in french ;)
I you want i translate say it to me :)

http://forum.coppermine-gallery.net/index.php?topic=22701.msg104534#msg104534
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error in mysql
« Reply #6 on: October 14, 2005, 01:52:32 pm »
issue solved then?
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.023 seconds with 16 queries.