products_attributes.php- error in your SQL syntax

[livetv]

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

[MrPhil]

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.

[livetv]

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