Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

little SQL help


Guest

Recommended Posts

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...