yoyoman
April 6th, 2004, 01:32 PM
I have phpMyAdmin, but when I try to run the squirrelcart.sql to set everything up, I get this:
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNqlkd9umzAUxiPtzld9hHNRqYkEFJM/TZF2QZjToQJhQCvlChFwV0vEUNtMyWX7ML3eA+w59jyD
VZ3WdlIqzZLlI5/fd875bBLHq9gGF4NrgU9CG0zAMJueoSTt7o8Qcq8TG4690gZ5V zW5kFQYFdsY
zW2jfQPLmIFlmpNTE5+a52CNbXxmWxhEvmklkF0DxyjYJ198Gy aGaeC5LlXOy1yU6CqJYZVo4FyQ
MNXgmnT9grwAj8DUsMYoChy7qz81ZrooMIo+Rz2jrZK+lGWMwW e83SHfCS9soFxnstbn8+m5jtHv
fkfyrmVC0KrIhTK64Qf/vT78fOyPH6Zc9rsLtwsvfE093M+/DwZuTJyUQOosfAJOWQoqZbasxTZL
qFKMf5UwRACCFrUoM95uN1QA42qI8QjCVQrhle9D3qo6Y7wQdE u50jrBglVVp86WjFalBEV36g/e
52Pa26ZldghMblnTvKvSQfITvcnbSmU3tcierXodx/i+dzT5y1D5hMKJedIrnaKoW64Oz3AIdPus
YPQfqSUTUmVPwP7tE7+a6NnLe/ko9gInXsMlWQMMX3znCI0gXUfkY7D3Eif4BQZ28ck=
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 0 1 657
STR:
CVS: $Id: sqlparser.lib.php,v 2.6 2004/01/09 23:17:21 rabus Exp $
MySQL: 4.0.18-standard
USR OS, AGENT, VER: Mac IE 5.23
PMA: 2.5.6-rc1
PHP VER,OS: 4.2.3 Linux
LANG: en-iso-8859-1
SQL: squirrelcart.sqlÖ?¼0sF¼0sFmBIN‚?8°CREATE TABLE Address_Form_Settings (
record_number int(11) NOT NULL auto_increment,
Billing_Fields text NOT NULL,
Required_Billing_Fields text NOT NULL,
Shipping_Fields text NOT NULL,
Required_Shipping_Fields text NOT NULL,
Default_for_Address_Is tinyint(4) NOT NULL default '0',
Account_Fields text NOT NULL,
Required_Account_Fields text NOT NULL,
Countries text NOT NULL,
First_Country int(11) NOT NULL default '0',
Default_Country int(11) NOT NULL default '0',
PRIMARY KEY (record_number)
) TYPE=MyISAM
----END RAW----
SQL-query*:*
squirrelcart.sqlÖ?¼0sF¼0sFmBIN‚?8°CREATE TABLE Address_Form_Settings ( record_number int(11) NOT NULL auto_increment, Billing_Fields text NOT NULL, Required_Billing_Fields text NOT NULL, Shipping_Fields text NOT NULL, Required_Shipping_Fields text NOT NULL, Default_for_Address_Is tinyint(4) NOT NULL default '0', Account_Fields text NOT NULL, Required_Account_Fields text NOT NULL, Countries text NOT NULL, First_Country int(11) NOT NULL default '0', Default_Country int(11) NOT NULL default '0', PRIMARY KEY (record_number) ) TYPE=MyISAM
MySQL said:
#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 'squirrelcart.sql' at line 1
I have no clue what this means, other than an unhappy client if I can't get it to work!
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNqlkd9umzAUxiPtzld9hHNRqYkEFJM/TZF2QZjToQJhQCvlChFwV0vEUNtMyWX7ML3eA+w59jyD
VZ3WdlIqzZLlI5/fd875bBLHq9gGF4NrgU9CG0zAMJueoSTt7o8Qcq8TG4690gZ5V zW5kFQYFdsY
zW2jfQPLmIFlmpNTE5+a52CNbXxmWxhEvmklkF0DxyjYJ198Gy aGaeC5LlXOy1yU6CqJYZVo4FyQ
MNXgmnT9grwAj8DUsMYoChy7qz81ZrooMIo+Rz2jrZK+lGWMwW e83SHfCS9soFxnstbn8+m5jtHv
fkfyrmVC0KrIhTK64Qf/vT78fOyPH6Zc9rsLtwsvfE093M+/DwZuTJyUQOosfAJOWQoqZbasxTZL
qFKMf5UwRACCFrUoM95uN1QA42qI8QjCVQrhle9D3qo6Y7wQdE u50jrBglVVp86WjFalBEV36g/e
52Pa26ZldghMblnTvKvSQfITvcnbSmU3tcierXodx/i+dzT5y1D5hMKJedIrnaKoW64Oz3AIdPus
YPQfqSUTUmVPwP7tE7+a6NnLe/ko9gInXsMlWQMMX3znCI0gXUfkY7D3Eif4BQZ28ck=
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 0 1 657
STR:
CVS: $Id: sqlparser.lib.php,v 2.6 2004/01/09 23:17:21 rabus Exp $
MySQL: 4.0.18-standard
USR OS, AGENT, VER: Mac IE 5.23
PMA: 2.5.6-rc1
PHP VER,OS: 4.2.3 Linux
LANG: en-iso-8859-1
SQL: squirrelcart.sqlÖ?¼0sF¼0sFmBIN‚?8°CREATE TABLE Address_Form_Settings (
record_number int(11) NOT NULL auto_increment,
Billing_Fields text NOT NULL,
Required_Billing_Fields text NOT NULL,
Shipping_Fields text NOT NULL,
Required_Shipping_Fields text NOT NULL,
Default_for_Address_Is tinyint(4) NOT NULL default '0',
Account_Fields text NOT NULL,
Required_Account_Fields text NOT NULL,
Countries text NOT NULL,
First_Country int(11) NOT NULL default '0',
Default_Country int(11) NOT NULL default '0',
PRIMARY KEY (record_number)
) TYPE=MyISAM
----END RAW----
SQL-query*:*
squirrelcart.sqlÖ?¼0sF¼0sFmBIN‚?8°CREATE TABLE Address_Form_Settings ( record_number int(11) NOT NULL auto_increment, Billing_Fields text NOT NULL, Required_Billing_Fields text NOT NULL, Shipping_Fields text NOT NULL, Required_Shipping_Fields text NOT NULL, Default_for_Address_Is tinyint(4) NOT NULL default '0', Account_Fields text NOT NULL, Required_Account_Fields text NOT NULL, Countries text NOT NULL, First_Country int(11) NOT NULL default '0', Default_Country int(11) NOT NULL default '0', PRIMARY KEY (record_number) ) TYPE=MyISAM
MySQL said:
#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 'squirrelcart.sql' at line 1
I have no clue what this means, other than an unhappy client if I can't get it to work!