Zend_Db_Statement_Exception Object
I can no longer access the backend or frontend of my Magento site. When trying to do either, I get a long error that constantly refreshes. I’ve pasted part of it here, but the actual error is much longer and I can provide more if needed. I was trying to execute a dataflow profile to import new products and was receiving this error: “SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction”. When I tried to flush the cache via admin panel afterwards, this error message appeared. I’m not sure if this is related to the main problem.
As far as I can tell its a MySQL error, however I’m very limited in my knowledge of anything and would appreciate any help, as simple as possible for lamens!
Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'report_viewed_product_aggregated_daily' already exists
[string:Exception:private] =>
[code:protected] => 42
[file:protected] => /home/unions8/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
That error means that there is an existing table or view named report_viewed_product_aggregated_daily and the script that is failing is likely trying to create it. As for a cause, that seems to be a Magento specific reason based upon the research. There are many forum posts relating to that error and it's fix but they all seem to be a bit different.
You may want to do a search for the error "Base table or view already exists:" and see which post relates to your situation.
Best Regards,
Scott M