mysql error while installing database?

[ryans1000]

I ran accross a database error while running the oscommerce.sql file in phpmyadmin 2.2.6 on the daily release for 1/28/03 unix. I am brand new to this, any help would be greaty appreciated. Pasted error below

 

--------------------------------

 

SQL-query :

 

INSERT INTO geo_zones (geo_zone_id,geo_zone_name,geo_zone_description,date_added) VALUES (1,"Florida","Florida local sales tax zone",now())

 

MySQL said:

 

 

You have an error in your SQL syntax near ' VALUES (1,"Florida","Florida local sales tax zone",now())' at line 1

 

Back

[ryans1000]

Could their possibly just be an error on the daily release I downloaded or am I doing something wrong?

[ryans1000]

Ohh, I enjoy having conversations with myself. Anyway, just thought that I would post the solution to my problem that I was having above.

 

Apparently the problem is with these two lines:

INSERT INTO geo_zones (geo_zone_id,geo_zone_name,geo_zone_description,date_added)?VALUES (1,"Florida","Florida local sales tax zone",now());

INSERT INTO zones_to_geo_zones (association_id,zone_country_id,zone_id,geo_zone_id,date_added)?VALUES (1,223,18,1,now());

 

Before the word 'VALUES' in each line is a wierd character, I believe its called a control character. Dont know how or why its in the 'oscommerce.sql' file but they are definitely in the orignial source file I got strait from the oscommerce website. phpMyAdmin doesn't like those characters. I found the characters while viewing the file in VI in Unix. The characters are not visible in windows with notepad or wordpad.

 

Anyway my solution was to delete the space before 'VALUES' and rekey the space with and save the file. I did this with wordpad on windows. Everything works great now.

 

I guess I should report this as a bug.