Sainkho Posted July 28, 2003 Posted July 28, 2003 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 < 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.
Guest Posted July 28, 2003 Posted July 28, 2003 You have to create an empty database before starting installation and then follow these directions http://wiki.oscommerce.com/helpInstallNew HTH The_Bear
Sainkho Posted July 29, 2003 Author Posted July 29, 2003 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.