GOTP Posted March 16, 2006 Posted March 16, 2006 I have been reserching the database for answers to my question. I deleted my Manufacturers(all) and received an error and all my buttons disipered >_< Manufacturers 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 '-20, 20' at line 1 select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20 [TEP STOP] So i think this is what i need to enter in mysqladmin? INSERT INTO manufacturers VALUES (1,'Matrox','manufacturer_matrox.gif', now(), null); INSERT INTO manufacturers_info VALUES (1, 1, 'http://www.matrox.com', 0, null); INSERT INTO manufacturers_info VALUES (1, 2, 'http://www.matrox.de', 0, null); INSERT INTO manufacturers_info VALUES (1, 3, 'http://www.matrox.com', 0, null); But where? And i use my hosting company to load sql, i guess? I was looking in mysqladmin, and for the life of me cannot figuar it out, i have a call and e-mail into my hosting co. but dont think thay are in a hurry to help, sooo! I found a post with step by step on a similar issue. please help! eather way thanks for you time. TP
Jack_mcs Posted March 16, 2006 Posted March 16, 2006 You would also need this DROP TABLE IF EXISTS manufacturers; CREATE TABLE manufacturers ( manufacturers_id int NOT NULL auto_increment, manufacturers_name varchar(32) NOT NULL, manufacturers_image varchar(64), date_added datetime NULL, last_modified datetime NULL, PRIMARY KEY (manufacturers_id), KEY IDX_MANUFACTURERS_NAME (manufacturers_name) ); The typical way to make database changes is with the phpmyadmin program. You should check with your host to see if that is available to you. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Guest Posted March 16, 2006 Posted March 16, 2006 http://www.oscommerce.com/forums/index.php?sho...&hl=1064+syntax The_Bear
Recommended Posts
Archived
This topic is now archived and is closed to further replies.