Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products Attributes getting - 1064 - You have an error in your SQL syntax;


rbrown2

Recommended Posts

Posted

I changed some code to sort my product attributes better and then I started to get the error listed below. So I search and found some other fixes and made more changes to the "split_page_results.php" (in catalog/admin/include & catalog/include/language/eng folders) and I got even more errors. I fixed the code in split_page_results.php but I can not remember what I changed to sort the product attributes. Whatever page I edited it worked but now when I click on product attributes link in the admin console to add more attributes all I get is the error listed below.

 

 

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 'sort' at line 1

 

select count(*) as total from products_options where language_id = '1' sort

 

[TEP STOP]

 

All your help is greatly appreciated.

:'(

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...