need mysql assistance

nicedomain4sale · 05-16-2005, 02:04 AM

Please help me. I try to restore backup from phpmyAdmin. But this error happened.

My version:
PHP version 4.3.10
MySQL version 4.0.24-standard

SQL-query:

Code:

 CREATE TABLE `ibf_admin_logs` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`act` varchar( 255 ) default NULL ,
`code` varchar( 255 ) default NULL ,
`member_id` int( 10 ) default NULL ,
`ctime` int( 10 ) default NULL ,
`note` text,
`ip_address` varchar( 255 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

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 'DEFAULT CHARSET=latin1' at line 10

eagle12 · 05-16-2005, 06:04 AM

remove all instances of:

Code:

DEFAULT CHARSET = latin1

It looks like the version of MySQL you are running doesn't support it. If you remove the above line, you should be able to run it without problem.

nicedomain4sale · 05-16-2005, 06:09 AM

Thanks.
It fixed now.

05-16-2005, 02:04 AM	#1 (permalink)
nicedomain4sale Account Closed Join Date: Mar 2005 Location: Singapore Posts: 674 0.00 NP$ (Donate)	need mysql assistance Please help me. I try to restore backup from phpmyAdmin. But this error happened. My version: PHP version 4.3.10 MySQL version 4.0.24-standard SQL-query: Code: CREATE TABLE `ibf_admin_logs` ( `id` bigint( 20 ) NOT NULL AUTO_INCREMENT , `act` varchar( 255 ) default NULL , `code` varchar( 255 ) default NULL , `member_id` int( 10 ) default NULL , `ctime` int( 10 ) default NULL , `note` text, `ip_address` varchar( 255 ) default NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 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 'DEFAULT CHARSET=latin1' at line 10

05-16-2005, 06:04 AM	#2 (permalink)
eagle12 NamePros Member Join Date: Nov 2003 Location: Ontario, Canada Posts: 91 80.80 NP$ (Donate)	remove all instances of: Code: DEFAULT CHARSET = latin1 It looks like the version of MySQL you are running doesn't support it. If you remove the above line, you should be able to run it without problem.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 01:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
mysql problem	Shof515	Programming	3	12-14-2004 09:20 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

05-16-2005, 06:09 AM	#3 (permalink)
nicedomain4sale Account Closed Join Date: Mar 2005 Location: Singapore Posts: 674 0.00 NP$ (Donate)	Thanks. It fixed now.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)