4 replies to this topic

[redik]

Hello!

I have a big Problem... if i wanna go to catalog>productattributes in the administration area, i get this error:

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

Whats the Problem?

Greez

[oscgchd]

redik, on 10 December 2009, 16:00, said:

Hello!

I have a big Problem... if i wanna go to catalog>productattributes in the administration area, i get this error:

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

Whats the Problem?

Greez

I'm getting the EXACT same error....ANY HELP. Please.

[mdtaylorlrim]

In /catalog/admin/includes/languages/*****/product_attributes.php you will see these difinitions. Look for

define('MAX_ROW_LISTS_OPTIONS', 10);


Add that line anywhere before the last ?>; if it is not there. Where the 10 is, that must be a positive whole number.

[oscgchd]

mdtaylorlrim, on 15 March 2010, 20:22, said:

In /catalog/admin/includes/languages/*****/product_attributes.php you will see these difinitions. Look for

define('MAX_ROW_LISTS_OPTIONS', 10);


Add that line anywhere before the last ?>; if it is not there. Where the 10 is, that must be a positive whole number.

This is what I have. Are you saying to repeat the definition in BOLD again?

<?php
/*
$Id: products_attributes.php 1739 2007-12-20 00:52:16Z hpdl $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright © 2002 osCommerce

Released under the GNU General Public License
*/

define('HEADING_TITLE_OPT', 'Product Options');
define('HEADING_TITLE_VAL', 'Option Values');
define('HEADING_TITLE_ATRIB', 'Products Attributes');

define('TABLE_HEADING_ID', 'ID');
define('TABLE_HEADING_PRODUCT', 'Product Name');
define('TABLE_HEADING_OPT_NAME', 'Option Name');
define('TABLE_HEADING_OPT_VALUE', 'Option Value');
define('TABLE_HEADING_OPT_PRICE', 'Value Price');
define('TABLE_HEADING_OPT_PRICE_PREFIX', 'Prefix');
define('TABLE_HEADING_ACTION', 'Action');
define('TABLE_HEADING_DOWNLOAD', 'Downloadable products:');
define('TABLE_TEXT_FILENAME', 'Filename:');
define('TABLE_TEXT_MAX_DAYS', 'Expiry days:');
define('TABLE_TEXT_MAX_COUNT', 'Maximum download count:');

define('MAX_ROW_LISTS_OPTIONS', 10);

define('TEXT_WARNING_OF_DELETE', 'This option has products and values linked to it - it is not safe to delete it.');
define('TEXT_OK_TO_DELETE', 'This option has no products and values linked to it - it is safe to delete it.');
define('TEXT_OPTION_ID', 'Option ID');
define('TEXT_OPTION_NAME', 'Option Name');
?>

[mdtaylorlrim]

No, I said add it IF IT'S NOT THERE.

The next thing that could change this is the language. You need to look in the database and see what language '2' is, and look for that php file in that language directory. '2' could be pointing to a language that you do not even have installed, causing the error.