Help!! MYSQL error
Permalink
What can I do to rectify this error? It happens everytime I try to add any add-ons.
Exception Occurred: mysql error: [1146: Table 'mysite_concrete.btBloggaPostsList' doesn't exist] in EXECUTE("truncate table btBloggaPostsList")
#0 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'mysite...', 'truncate table ...', false, Object(ADODB_mysql))
#1 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('truncate table ...', false)
#2 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/database.php(73): ADOConnection->Execute('truncate table ...')
#3 /home/mysite/public_html/packages/blogga/controller.php(35): Database->__call(Array, Array)
#4 /home/mysite/public_html/packages/blogga/controller.php(35): Database->Execute('Execute', Array)
#5 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/controllers/dashboard/install.php(228): BloggaPackage->uninstall('truncate table ...')
#6 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/controller.php(190): DashboardInstallController->do_uninstall_package()
#7 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/controller.php(169): Controller->runTask()
#8 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/view.php(600): Controller->setupAndRun(Array, Array)
#9 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/dispatcher.php(246): View->render('do_uninstall_pa...', Array)
#10 /home/mysite/public_html/concrete/startup/updated_core_check.php(6): require('/home/mysite/...')
#11 /home/mysite/public_html/concrete/dispatcher.php(14): require('/home/mysite/...')
#12 /home/mysite/public_html/index.php(2): require('/home/mysite/...')
#13 {main}
Exception Occurred: mysql error: [1146: Table 'mysite_concrete.btBloggaPostsList' doesn't exist] in EXECUTE("truncate table btBloggaPostsList")
#0 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'mysite...', 'truncate table ...', false, Object(ADODB_mysql))
#1 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('truncate table ...', false)
#2 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/database.php(73): ADOConnection->Execute('truncate table ...')
#3 /home/mysite/public_html/packages/blogga/controller.php(35): Database->__call(Array, Array)
#4 /home/mysite/public_html/packages/blogga/controller.php(35): Database->Execute('Execute', Array)
#5 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/controllers/dashboard/install.php(228): BloggaPackage->uninstall('truncate table ...')
#6 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/controller.php(190): DashboardInstallController->do_uninstall_package()
#7 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/controller.php(169): Controller->runTask()
#8 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/view.php(600): Controller->setupAndRun(Array, Array)
#9 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/dispatcher.php(246): View->render('do_uninstall_pa...', Array)
#10 /home/mysite/public_html/concrete/startup/updated_core_check.php(6): require('/home/mysite/...')
#11 /home/mysite/public_html/concrete/dispatcher.php(14): require('/home/mysite/...')
#12 /home/mysite/public_html/index.php(2): require('/home/mysite/...')
#13 {main}
> I'm running on Linux all along.
Got my webhost to look at the error and they said it is due to missing tables. How can I add the required tables in that case?
The log entries below lead me to believe a blogga add-on uninstall failed in some way:
Just guessing... Not yet sure the best way to proceed.
#5 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/controllers/dashboard/install.php(228): BloggaPackage->uninstall('truncate table ...') #6 /home/mysite/public_html/updates/concrete5.4.1.1/concrete/libraries/controller.php(190): DashboardInstallController->do_uninstall_package()
Just guessing... Not yet sure the best way to proceed.
http://www.concrete5.org/community/forums/installation/table-names-...
http://www.concrete5.org/community/forums/installation/uncaught_exc...
http://www.concrete5.org/community/forums/installation/move_from_xa...