Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

products_attributes.php- error in your SQL syntax


livetv

Recommended Posts

Hello,

When going to http://...admin/products_attributes.php

Grtting - 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 '-0, MAX_ROW_LISTS_OPTIONS' at line 1

 

select * from products_options where language_id = '2' order by products_options_id limit -0, MAX_ROW_LISTS_OPTIONS

 

[TEP STOP]

 

HEADING_TITLE_OPT

Warning: Division by zero in /admin/includes/classes/split_page_results.php on line 33

 

Warning: Division by zero in /admin/includes/classes/split_page_results.php on line 47

 

 

Thank you

Link to comment
Share on other sites

Check the file /catalog/admin/includes/languages/english/products_attributes.php. It should have a line

define('MAX_ROW_LISTS_OPTIONS', 10);

at around line 29 or so.

 

If you're using a non-English language, compare the file to the English version, to see if some lines were left out.

Link to comment
Share on other sites

Hello MrPhil,for your instruction, this was the issue problem! as in the new language pack the products_attributes.php file was missing.My advice to those who need to add new language is:

  1. Create new folger for the new language in - /catalog/admin/includes/languages .
  2. in the admin interface, select Localization->Language , add new language
  3. copy all files from the english folder -
    /catalog/admin/includes/languages/english
    to the new languge folder - /catalog/admin/includes/languages/New_Language

  4. extract the new language pack to the - /catalog/admin/includes/languages/New_Language

Thank you

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...