-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I'm trying to move my Mambo (content management) database from one server into another.
In the old server, the mysql version is 4.0.13, while in the new one it's 4.0.15. The error was when restoring: ERROR 1064 at line 141: 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 'option varchar(50) DEFAULT '' NOT NULL, ordering int(11) unsi These are the corresponding lines: # # Table structure for table `mos_components` # CREATE TABLE mos_components ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', link varchar(255) NOT NULL default '', menuid int(11) unsigned NOT NULL default '0', parent int(11) unsigned NOT NULL default '0', admin_menu_link varchar(255) NOT NULL default '', admin_menu_alt varchar(255) NOT NULL default '', option varchar(50) NOT NULL default '', ordering int(11) unsigned NOT NULL default '0', admin_menu_img varchar(255) NOT NULL default '', iscore tinyint(4) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; Is there any syntax that I should fix? Many thanks guys. - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 13:21:13 up 3:46, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAtYj0kp5CsIXuxqURAjl/AJ9hx4ELePlv/somJvoUURWSBC8JSwCfTfpd BKjnEcNC4ibMsC55uCK8sxg= =49fG -----END PGP SIGNATURE-----
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________
