insaini, on May 2 2008, 04:37 AM, said:
http://forums.oscommerce.com/index.php?s=&...t&p=1242251
once you make the change and run it on the database again you should be fine..
J
J,
Close but no cigar. The automated labels portion of the SQL code still errors.
If you remove it and run the last portion for CP shipping module it runs fine.
Now I have a new error that appears in the Manufacturers module.
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 ' countries_id manufacturers' at line 1 select count(*) as total from, countries_id manufacturers [TEP STOP]
Here is the SQL error that pops up when trying to run Automated label script portion.
########################################################################## # CANADA POST AUTOMATED LABELS DB QUERIES ########################################################################## ALTER TABLE products ALTER TABLE manufacturers ADD countries_id INT NOT NULL; 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 'TABLE manufacturers ADD countries_id INT NOT NULL' at line 3
What am I missing?
Appreciate the help more than you can know.









