Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Server move: Error in SQL syntax when restoring database  (Read 3425 times)

0 Members and 1 Guest are viewing this topic.

isajade

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 67
Server move: Error in SQL syntax when restoring database
« on: July 11, 2007, 03:16:21 pm »
Hi everyone,

Can you please help me, I followed the FAQ to move to another server and got an error in SQL syntax when I restored the database.

#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 'DEFAULT CHARSET=latin1' at line 36
The full line 36 is:
Code: [Select]
) ENGINE = MYISAM AUTO_INCREMENT =633 DEFAULT CHARSET = latin1

More infos:
  • I don't have any mod nor hack installed.
  • SQL file size 257 Ko.
  • Coppermine version 1.4.10 (I started the move process before the new version was released and I'd prefer, if possible, to upgrade as soon as the move is successful, rather than starting something new before the first one is done.)
  • Former server at Lycos.fr http://gallery.angel-us.com
    Version PHP:  4.3.9
  • New server at 1and1.fr http://gallery.juliebenz.net
    Version PHP: MySQL4.0
  • I CHMOD the folder to 755 (as I don't know what means "depending on your server config") and moved to next step. Got the same error when I CHMOD to 777
  • Themes: DFire (modified version (I) posted on this board) and Foliage


Please let me know if you need more informations and thank you for taking the time to help me.
« Last Edit: July 11, 2007, 03:57:19 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: Server move: Error in SQL syntax when restoring database
« Reply #1 on: July 11, 2007, 03:23:54 pm »
The new server is running an older version of MySQL than your old server but you failed to use the compatibility options when exporting the database. Either export again with MySQL 4.0 compatibility or edit the sql file, removing references to 'DEFAULT CHARSET = latin1'
Logged

isajade

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 67
Re: Server move: Error in SQL syntax when restoring database
« Reply #2 on: July 11, 2007, 03:42:34 pm »
Thank you, I removed the 'DEFAULT CHARSET = latin1' and it worked.

I run the gallery at http://gallery.juliebenz.net and got:
MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Logged

Nibbler

  • Guest
Re: Server move: Error in SQL syntax when restoring database
« Reply #3 on: July 11, 2007, 03:56:43 pm »
You'll need to talk to your host, that is not a Coppermine issue.
Logged

isajade

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 67
Re: Server move: Error in SQL syntax when restoring database
« Reply #4 on: July 11, 2007, 04:57:08 pm »
Thank you again, I just did it.
Logged

isajade

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 67
Re: Server move: Error in SQL syntax when restoring database
« Reply #5 on: July 11, 2007, 05:45:25 pm »
I just solved the last issue, here it is, it might help other users.

You need to update your include/config.inc.php file with the new database name, password etc.

Thanks again guys :)
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.037 seconds with 19 queries.