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



Quote Originally Posted by CJPinder View Post
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.