Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Tsch, tsch, tsch, basic step one question


Sainkho

Recommended Posts

Posted

So, via PHPAdmin I try to browse to the file to create my database.

 

I browse to cataloginstalloscommerce.sql.

 

Is that right? Cos what I get spat back at me is below;

 

SQL-query:

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', 'tep_cfg_select_option(array('asc', 'desc'), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', '1', '9', 'tep_cfg_select_option(array('products_name', 'date_expected'), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language's currency when it is changed', '1', '10', 'tep_cfg_select_option(array('true', 'false'), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 &lt

 

MySQL said: You have an error in your SQL syntax near '; INSERT INTO configuration (configuration_title, configuration_key, configurati' at line 1

 

I ain't no rocket scientist. I'm thinking this is not right. Is it?

 

I'll apologise now for all the questions I am doubtless going to post here, but hey, you seem a truely helpful bunch and I really want to play shopkeepers with this app.

 

Ta.

Posted

Big Bear, thanks. I have been using (trying to use) those instructions. I take your meaning to be create the database but not the tables within, which is how I had interpreted it.

 

I'll give it a shot and be back for more.

 

Ta.

Archived

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

×
×
  • Create New...