New Products SQL Error

[bettysue]

It says 1.

thank you,
betty

Log in to your Admin, click on the Configuration menu then Maximum values. What does it say against 'New Products Listing- Number Per Page'?

Regards,
Christian.

[CJPinder]

It says 1.

Try changing that to a larger number like 10 and see if that fixes the problem.

Regards,
Christian.

[bettysue]

No that didn't fix it, I still get the same error message.

thank you,

betty

[CJPinder]

Hmm..very odd. The SQL error you posted earlier would only occur if 'New Products Listing- Number Per Page' was set to 0. It also looks as if 'New Product Listing - Limited to ...' is also set to 0.

If 'New Products Listing- Number Per Page' is set to something other than zero then it could be that the Configuration table in your database has become corrupt. Do you have a recent backup of your database from before the error started happening?

Regards,
Christian.

[bettysue]

The main issue is that the site owner doesn't know how long it has been doing this. There are database backups but since we cannot put a finger on when it started, there would be no way to tell which database to restore. Plus he said he has made changes to the site over the past couple of weeks that he doesn't want to lose which a db restore would do.

Is there any other method other than a restore to fix it?

thank you,
betty

Hmm..very odd. The SQL error you posted earlier would only occur if 'New Products Listing- Number Per Page' was set to 0. It also looks as if 'New Product Listing - Limited to ...' is also set to 0.

If 'New Products Listing- Number Per Page' is set to something other than zero then it could be that the Configuration table in your database has become corrupt. Do you have a recent backup of your database from before the error started happening?

Regards,
Christian.

[CJPinder]

First thing we can try is replacing the specific configuration key that might be causing the problem. Take a backup of the database then carefully copy and paste the following into Admin->Tools->Install SQL Patches and click Send :

DELETE FROM `configuration` where configuration_title='New Products Listing- Number Per Page';
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products Listing- Number Per Page', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Number of new products listed per page', '3', '14', now());

Let me know if that fixes the problem.

Regards,
Christian.

[bettysue]

That did it

Thank you so much for the help and the fix. It is greatly appreciated.

betty