osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

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


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 02-20-2008, 04:34 PM
Active Member
 
Join Date: May 2003
Posts: 130
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
judoka
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';
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 02-22-2008, 02:46 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,328
Thanks: 68
Thanked 322 Times in 305 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
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 Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 02-22-2008, 03:19 PM
Active Member
 
Join Date: May 2003
Posts: 130
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
judoka
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

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; ozstar osCMax v2 Installation issues 1 07-30-2007 07:34 AM
SQL syntax error barnkin osCommerce 2.2 Installation Help 1 09-14-2004 09:13 PM
1064 - You have an error in your SQL syntax. j0ly osCommerce 2.2 Installation Help 1 08-24-2004 03:13 PM
1064 - You have an error in your SQL syntax Anonymous osCMax v1.7 Installation 3 05-10-2004 10: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 07:15 AM.


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