Run this SQL query on your database: - HELP

[UncleSteve]

Well I'm stumped :(

 

I'm stuck in the middle of inserting a minimum order contrib. and come across an instruction I've no experience of.

 

I've done contribs where a *.sql file has been included, but this is a new one on me :(

 

These are the instructions I'm faced with;

______________________________________________

STEP 5:

______________________________________________

Run this SQL query on your database:

 

INSERT INTO `configuration` (`configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function`)

VALUES ('', 'Minimum Orders', 'MINIMUM_ORDERS', 'true', 'Whether or not to enforce minimum orders', '1', '19', NOW( ) , NOW( ) , NULL , NULL);

______________________________________________

STEP 6:

______________________________________________

Run this SQL query to modify your "products description" table:

 

ALTER TABLE `products` ADD `minorder` INT( 4 ) DEFAULT '1' NOT NULL ;

Can anyone give me guidence on how to acheive the above please?

 

Thanks in advance :)

[pyramids]

1] Go into phpMyAdmin. On the left side, click the name of the database you are using for vBulletin.

2] On the right side, once the page loads, scroll down and find the box that says "Run SQL query/queries on database yourdatabasename" above it.

3] In that box, type (or copy and paste) the query you were told to run.

4] Press the Go button.

5] If your query is successful, it will reload the page and at the very top say "xxx has been yyy" where xxx is the name of the table or field you performed yyy action on, or give a blank white screen. Otherwise, it will give an error message. If it gives an error, copy that error and come back to this thread and post it.

[UncleSteve]

1] Go into phpMyAdmin. On the left side, click the name of the database you are using for vBulletin.

2] On the right side, once the page loads, scroll down and find the box that says "Run SQL query/queries on database yourdatabasename" above it.

3] In that box, type (or copy and paste) the query you were told to run.

4] Press the Go button.

5] If your query is successful, it will reload the page and at the very top say "xxx has been yyy" where xxx is the name of the table or field you performed yyy action on, or give a blank white screen. Otherwise, it will give an error message. If it gives an error, copy that error and come back to this thread and post it.

Hi pyramids,

 

Thanks for your help, its so easy when you know how :D

 

I think you phpMyAdmin is laid out different to mine, but once I got the navigation sorted, I was away :D

 

Everything is now working

 

Thanks again

 

Steve