'Bad SQL query' when trying to access product list in back-office.

[Tiphaine Desmasures]

Hi, everything in the 'catalog' tab is working fine except the product list. When I click on 'products' I got this message:
 

Bad SQL query
Table 'my_db_name.ps_order_detail' doesn't exist.

 

 

Problem is i'm using prefix 'ps16_' not 'ps_', the table ps16_order_detail exists and orders are working just fine.

I guess it has something to do with a 'DB_PREFIX' error or something but I can't figure how to fix this.

I'm on Prestashop 1.6.1.0 and haven't made significant changes recently...

 

Any help would be much appreciated.

Thanks.

 

edit: 'db_prefix' in 'settings.inc.php' is correctly defined:

'_DB_PREFIX_', 'ps16_'

I'm using this Prestashop installation for a while now, and the problem only occured this morning, everything else (orders, products, combinations...) is working fine.

Edited May 18, 2016 by FLORENT GERAULT (see edit history)

[vekia]

you've got some kind of override? maybe the "ps_" is just hardcoded somewhere in the function that generates the query.

[Tiphaine Desmasures]

Hi, my problem is solved.

It was caused by a module wich customize the back-office, it's working fine except for the "products" part. Maybe a conflicts with an override or something.