osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

bts 1.2a SQL syntax error

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: ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v1.7 Forums > osCMax v1.7 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 08-21-2004, 02:23 PM
nfmg's Avatar
Member
 
Join Date: Oct 2003
Location: Montana
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
nfmg
Default bts 1.2a SQL syntax error

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());
My host doesn't provide PHPMYAdmin, just a box to paste SQL queries in.
Anybody see a syntax error there?

Thanks,
Tim
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 08-21-2004, 02:43 PM
nfmg's Avatar
Member
 
Join Date: Oct 2003
Location: Montana
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
nfmg
Default

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 12:11 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax