Cannot locate products in Back Office - but all products on website

[finners]

Hi,

I am using 1.5.2 and recently needed to change database names so the old one was backed up and a new database created from the backup

 

On my website I can see all products, add to cart etc

But in back office, when I select Catalog > Products....i cannot view / edit products....it times out when I select products

 

If i select Catalog > Suppliers, I can see suppliers, and approx 15 products however I have a lot of products on my website...more than 5000

 

If i go to php my admin i can see all the products there in the database and edit prices etc...

 

I'm pretty sure it's simple to fix however I cannot find what it is..

 

I've checked the settings.inc.php file and it looks ok...but maybe it's a problem with the token...i dont know!

Edited November 7, 2012 by finners (see edit history)

[PrestaHeroes USA]

try this, config/config.inc.php

 

change define('_PS_DEBUG_SQL_', false);

 

to define('_PS_DEBUG_SQL_', true);

 

and see if you get an sql error message...

 

Cheers, Fred

[lze]

What for should I try this?