Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysqladmin? H E L P !!!


GOTP

Recommended Posts

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...