osCmax v2.5 User Manual
Results 1 to 3 of 3

SQL syntax error please help

This is a discussion on SQL syntax error please help within the osCmax v2 Installation issues forums, part of the osCmax v2.0 Forums category; Hi guys, Could someone please help me? I and trying to upgrade my website from OSMAx1.7 to the new OS2 ...

      
  1. #1
    Active Member
    Join Date
    May 2003
    Posts
    185
    Rep Power
    10


    Default SQL syntax error please help

    Hi guys,
    Could someone please help me? I and trying to upgrade my website from OSMAx1.7 to the new OS2 RC3. I've use mysqldiff to upgrade my database but when I try to import
    the new file to my database I am getting the following error message;

    Error
    SQL query:

    #
    # DDL START
    #
    ALTER TABLE address_book ADD entry_company_tax_id varchar( 32 ) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER entry_company,
     



    MySQL said:

    #1064 - 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 '&nbsp' at line 3


    I looked at the online sql manual to see if I could figure out how to fix the problem but the manual just tells you what the error number message means but it doesn't
    tell you how to fix the problem. I'm not a coder or programmer so I am having a hard time figuring the out any help would be greatly appreciated guys. This is the
    script that is getting the error message, This was created by mysqldiff:

    #
    # DDL START
    #
    ALTER TABLE address_book
    ADD entry_company_tax_id varchar(32) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER entry_company,
        COMMENT='InnoDB free: 9216 kB';

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: SQL syntax error please help

    You need to delete all the   instances from your sql, as that is not valid.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Active Member
    Join Date
    May 2003
    Posts
    185
    Rep Power
    10


    Default Re: SQL syntax error please help

    Thank you Michael for answering both of my questions. I quess what I am going to do is just start all over and delete what I have already done since over the last three months or so that I have been working on this, I have been trying so many different things that I really done remember everything that I have try and I may have my database all screw up by now. At lease now thanks to your answers I have a starting point of referance. Thank you and again sorry about mine earier misunderstanding.

Similar Threads

  1. 1064 - You have an error in your SQL syntax;
    By ozstar in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 07-30-2007, 07:34 AM
  2. SQL syntax error
    By barnkin in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 09-14-2004, 09: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, 03: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, 10:48 AM
  5. SQL syntax error
    By americamba in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 01-05-2004, 08: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
  •