little SQL help

[Guest]

Hello forum

 

I am solving time zone offset problem

 

in instruction there is one note

 

1) RUN THE FOLLOWING SQL ON YOUR SQL 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 ('', 'Time Zone Offset', 'TIME_ZONE_OFFSET', '0', 'The time zone difference between your store and the server. Enter +h, 0 or -h where ''h'' is the number of hours. If your store time zone is ahead of the server time zone, use +', 1, 7, NULL, '0001-01-01 00:00:00', NULL, NULL);

 

 

I am totally fool at SQL

How should I do via PHPmyadmin. I know how to import table, but what does it mean, what should I do?

 

thanks

[burt]

Use PHP My Admin (usually standard on most Hosting Control Panels). Once you get into PHPMYAdmin, click on your databse name, then the SQL tab. Insert that into the box and press "go".

 

Suggest a backup of your database first!

[Guest]

I did this

 

but what should I write in field and so on

[burt]

I don't know what that SQL does - it looks like it adds an extra option in your Admin area somewhere...check your admin area?

[Guest]

I got this note:

 

Inserted rows: 1

Inserted row id: 148 (Query took 0.0178 sec)

SQL query:

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 (

'', 'Time Zone Offset', 'TIME_ZONE_OFFSET', '0', 'The time zone difference between your store and the server. Enter +h, 0 or -h where ''h'' is the number of hours. If your store time zone is ahead of the server time zone, use +', 1, 7, NULL , '0001-01-01 00:00:00', NULL , NULL

[burt]

Yep, now check inside your osCommerce Shop Admin Area and find the new input field that might (should) have been created, ready for you to change...

[Guest]

thanks man

did everything what I intended