NeMoD Posted September 26, 2006 Share Posted September 26, 2006 I had a coppermine photo gallery, installed a year ago, before I got rid of my site I backed up all the files and the db.Now I have a new site and would like to import it, I copied over the files, pointed the config to the newly created db, and triedimporting the old db into the new one, but I keep getting this error[code]MySQL said: Documentation#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `cpg133_albums` VALUES (1, 'IG Community', 'Click h [/code]heres up to the line, where it errors out[code] SQL query:-- -- Table structure for table `cpg133_albums`-- 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` ))---- Dumping data for table `cpg133_albums`-- INSERT INTO `cpg133_albums`VALUES ( 1, 'IG Community', 'Click here for pictures of some active (and inactive) unreal instagib players.', 0, 'YES', 'YES', 'YES', 100, 0, 0, 0, '0000-00-00 00:00:00', 'NO', NULL ) [/code]any help is appreciatedI'm positive I'm using mysql5 for my new host, my old host had 4.1.18 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 27, 2006 Share Posted September 27, 2006 Strange... it all looks fine, maybe just a missing semi-colon between statements. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.