products_attributes.php error? or not?

[djsingle]

To make it quick and simple this is the message i get when i go to my Products Attributes page of my shopping cart admin. This first message shows at the very top of the page:

 

cts 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'); ?>

 

 

This next message shows in the body of the page:

 

1064 - You have an error in your SQL syntax near 'MAX_ROW_LISTS_OPTIONS' at line 1

 

select * from products_options where language_id = '1' order by products_options_id LIMIT 0, MAX_ROW_LISTS_OPTIONS

 

[TEP STOP]

 

HEADING_TITLE_OPT

 

TEXT_OPTION_IDTEXT_OPTION_NAME

 

Warning: Division by zero in /www/s/sugoi75/htdocs/shopping/admin/products_attributes.php on line 214

 

This problem never occurred before but ever since my server installed PHP 4.3 it just happened. This error only appears in the Products Attributes page of my Admin. I was suggested that maybe the OUTPUT_BFFERING in my PHP.INI of my server should be turned OFF, but i don't know how to do that. I asked my server admins what the problem mite be and they said it is a scripting error.

 

Now unless you guys/gals wanna duke it out with my server admins, i need some help. i like the shopping cart a lot and would not want to resort to another one. thanx and hope someone gets this message.

[cpfs]

I also had this problem and I have been watching to see if anyone posted an answer over the last few days. I'm also on php 4.3.0. I also notice that by searching on

1064 - You have an error in your SQL syntax near 'MAX_ROW_LISTS_OPTIONS' at line 1

you get quite a few people having asked about this over the last few months and none of the suggested replies work!

 

Looking at the error message, the mySQL select statement should not have the MAX_ROW_LISTS_OPTIONS in it, it should read someting like

select * from products_options where language_id = '1' order by products_options_id LIMIT 0, 20

So presumably, whether its anything to do with php 4.3.0 or not, the products_attributes.php program is not replacing the variable MAX_ROW_LISTS_OPTIONS with a value like '20'.

 

Now I know this is a hack and isn't the answer to the problem, but at least it will work and you will be able to change the product attributes without getting errors everywhere.

 

Edit the file products_attributes.php, and change the following lines:

 

Line 198 change

 

$per_page = MAX_ROW_LISTS_OPTIONS;

 

to

 

$per_page = 20;

 

also change line 393 and line 562 to:

 

$per_page = 20;

 

(I can't remember the exact line they used to be)

 

The resulting product attributes output is a bit messy, but at least you can now use it. :)

[djsingle]

thanx for the idea but i actually fixed it by downloading the latest daily snapshop of the admins folder. once i reloaded the admin's folder, it worked fine. i guess it was a scripting error.