magento general error 1205

1
votes

I have a multi store magento web project. There I need to specify the categories for each and every store views in catalog --> manage categories. It was working fine, but from today itself suddenly it stopped working.

I can edit the categories, if the store view is "All store views".

If I switch it to any other store, such as store1, I can't make any change.

I have unchecked "default value tab", then if I choose Is Active --> NO, the default please wait loader will appear, and after some time the page throws me an error,

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction.

I am attaching a screenshot hereenter image description here

Why is it so??? Any one can help me?

1
phpmagentomagento-1.9magento-dev
Check this out: stackoverflow.com/questions/6000336/… – liquidflo
Is there any other way without getting into mysql? – hakkim
@hakkim Do you have access to mycnf file of mysql? – Mukesh
Nop. I don't have acces to the database, I got only magento backend and ftp access.. :( – hakkim

1 Answers

1
votes

I found the solution, I went to the phpmyadmin and run this query in sql,

SET innodb_lock_wait_timeout =120

and everything went all right. Thanks guys.