This is a discussion on bts 1.2a SQL syntax error within the osCMax v1.7 Discussion forums, part of the osCMax v1.7 Forums category; Hi All, Funny, this didn't happen last time I updated a 1.5.5 with the bts 1.2a. This time I get: ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| Hi All, Funny, this didn't happen last time I updated a 1.5.5 with the bts 1.2a. This time I get: Error Number: 1064 Error Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO configuration (configuration_title, configuratio Here's what the SQL looks like when unzipped on XP machine with Winzip. Code: INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Default Template Directory', 'DIR_WS_TEMPLATES_DEFAULT', 'aabox', 'Subdirectory (in templates/) where the template files are stored which should be loaded by default.', '1', '22', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Template Switching Allowed', 'TEMPLATE_SWITCHING_ALLOWED', 'true', 'Allow template switching through the url (for easy new template testing).', '1', '22', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now());
Anybody see a syntax error there? Thanks, Tim |
| Sponsored Links | ||
| ||
| |
|
#2
| ||||
| ||||
| Hmmm, never mind. I just had to paste them in as two separate queries. It's funny how getting up and walking away from a problem often seems to allow the solution to come to me... I dream of solutions to my Css positioning problems. |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 1064 - You have an error in your SQL syntax. | jamie74 | osCommerce 2.2 Modification Help | 0 | 10-20-2004 12:45 PM |
| SQL syntax error | barnkin | osCommerce 2.2 Installation Help | 1 | 09-14-2004 10:13 PM |
| 1064 - You have an error in your SQL syntax. | j0ly | osCommerce 2.2 Installation Help | 1 | 08-24-2004 04:13 PM |
| 1064 - You have an error in your SQL syntax | Anonymous | osCMax v1.7 Installation | 3 | 05-10-2004 11:48 AM |
| SQL syntax error | americamba | osCommerce 2.2 Installation Help | 1 | 01-05-2004 09:34 AM |