Can not delete products

[emerce]

Hi - hoping for a bit of help plz. I have a client who has been running v2.6.5 for quite some time without issue. Our server providers upgraded PHP to 5.3 about a month ago - he had one small issue with a 'browser detect' file that I sorted for him and all has been OK.

However he has contacted me today as he can not delete any products from the product table. there are no error messages, if you click 'delete' from the bottom of the 'product detail' page it just takes you to the control panel and a listing of the products - and you can not delete them from here either?

Not sure if this is related to the PHP upgrade as he can not remember when he last tried to delete anything?

Any help would be much appreciated

[Jamie]

I'd recommend upgrading to v3.4.1. Version 2.x is getting long in the tooth and is bound to cause you problems at some point as your host upgrades PHP, MySQL, etc...

I don't know what is causing that, and can't say if an upgrade would fix it or not. I'd recommend first trying to delete one of these product records using the query tool under "Tools > Database > Query" to see if it is a permissions issue for his MySQL user account:

DELETE FROM Products WHERE record_number = 123;

Change the record number to match a record you want to delete. Run that query, and see if the record goes away. If not, your MySQL user account does not have full access to the database.