1064 - You have an error in your SQL syntax

[jason.b]

I wonder if anyone has had an issue updating sql patches with a template.

I've had a template installed , by the seller, and Ive tried to run the sql patch for cross selling and I get a "page not found" issue.

I did a little look around the forums and it seemed I needed to contact my hosting company as something may have been switched off.

They said all was ok their end it looked like the template was at fault.

Ive contacted the template company who says its an issue with the sql patch and a line that says

products_xsell.sql is not included to the template package. Nevertheless we have tried to import it to your database. We have got the following error:
products_xsell.sql

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 'TYPE=MyISAM' at line 15

Can anyone shed some light ?

REgards

Jason

[jason.b]

Ive read this again and am wondering if maybe xsell isnt compatible with my template ?

[DrByte]

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 'TYPE=MyISAM' at line 15

It's got nothing to do with your "template".

That's a MySQL error, which is caused by using the old MySQL4 syntax with the new MySQL5 software.

"TYPE=" was deprecated in favor of "ENGINE=".

So, it would appear that the addon you're trying to install was written for a VERY old version of MySQL.

And as such it was also probably intended to be installed on a VERY old version of Zen Cart. And consequently you might have further troubles using it if you try to apply it directly to a modern-day version of Zen Cart.

[jason.b]

Thanks very much for the help.