Results 1 to 2 of 2

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

      
  1. #1
    Member nfmg's Avatar
    Join Date
    Oct 2003
    Location
    Montana
    Posts
    49
    Rep Power
    0


    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

  2. #2
    Member nfmg's Avatar
    Join Date
    Oct 2003
    Location
    Montana
    Posts
    49
    Rep Power
    0


    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.

Similar Threads

  1. 1064 - You have an error in your SQL syntax.
    By jamie74 in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 10-20-2004, 12:45 PM
  2. SQL syntax error
    By barnkin in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 09-14-2004, 10:13 PM
  3. 1064 - You have an error in your SQL syntax.
    By j0ly in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 08-24-2004, 04:13 PM
  4. 1064 - You have an error in your SQL syntax
    By Anonymous in forum osCMax v1.7 Installation
    Replies: 3
    Last Post: 05-10-2004, 11:48 AM
  5. SQL syntax error
    By americamba in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 01-05-2004, 09:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •