Installing update error
Permalink
When I attempt to the do the upgrade I get the following error screen:
An Unexpected Error occurred while upgrading: #0 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(641): adodb_throw('mysqlt', 'DOQUOTE', -9999, 'Numeric field t...', '', false, Object(ADODB_mysqlt)) #1 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/model.php(44): ADOConnection->outp_throw('Numeric field t...', 'DOQUOTE') #2 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(845): Concrete5_Library_Model->doquote(Object(ADODB_mysqlt), true, 'I') #3 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/models/block_types.php(763): ADODB_Active_Record->Replace() #4 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/models/block_types.php(671): Concrete5_Model_BlockType->doInstallBlockType('guestbook', Object(BlockType), '/hsphere/local/...', '16', '/hsphere/local/...') #5 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/models/block_types.php(632): Concrete5_Model_BlockType->installBlockType('guestbook', '16') #6 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/helpers/concrete/upgrade/version_563.php(17): Concrete5_Model_BlockType->refresh() #7 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/controllers/single_pages/upgrade.php(272): ConcreteUpgradeVersion563Helper->run() #8 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/controllers/single_pages/upgrade.php(64): Concrete5_Controller_Upgrade->do_upgrade() #9 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/controller.php(267): Concrete5_Controller_Upgrade->view('tools', 'required', 'upgrade.php') #10 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/controller.php(237): Concrete5_Library_Controller->runTask(Array, Array) #11 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/view.php(787): Concrete5_Library_Controller->setupAndRun('view', Array) #12 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/tools/upgrade.php(6): Concrete5_Library_View->render() #13 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/startup/tools_upgrade_check.php(9): include('/hsphere/local/...') #14 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/dispatcher.php(105): require('/hsphere/local/...') #15 /hsphere/local/home/bigjohn7/om-im.org/concrete/startup/updated_core_check.php(7): require('/hsphere/local/...') #16 /hsphere/local/home/bigjohn7/om-im.org/concrete/dispatcher.php(25): require('/hsphere/local/...') #17 /hsphere/local/home/bigjohn7/om-im.org/index.php(2): require('/hsphere/local/...') #18 {main}
Help!
An Unexpected Error occurred while upgrading: #0 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(641): adodb_throw('mysqlt', 'DOQUOTE', -9999, 'Numeric field t...', '', false, Object(ADODB_mysqlt)) #1 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/model.php(44): ADOConnection->outp_throw('Numeric field t...', 'DOQUOTE') #2 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(845): Concrete5_Library_Model->doquote(Object(ADODB_mysqlt), true, 'I') #3 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/models/block_types.php(763): ADODB_Active_Record->Replace() #4 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/models/block_types.php(671): Concrete5_Model_BlockType->doInstallBlockType('guestbook', Object(BlockType), '/hsphere/local/...', '16', '/hsphere/local/...') #5 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/models/block_types.php(632): Concrete5_Model_BlockType->installBlockType('guestbook', '16') #6 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/helpers/concrete/upgrade/version_563.php(17): Concrete5_Model_BlockType->refresh() #7 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/controllers/single_pages/upgrade.php(272): ConcreteUpgradeVersion563Helper->run() #8 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/controllers/single_pages/upgrade.php(64): Concrete5_Controller_Upgrade->do_upgrade() #9 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/controller.php(267): Concrete5_Controller_Upgrade->view('tools', 'required', 'upgrade.php') #10 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/controller.php(237): Concrete5_Library_Controller->runTask(Array, Array) #11 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/core/libraries/view.php(787): Concrete5_Library_Controller->setupAndRun('view', Array) #12 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/tools/upgrade.php(6): Concrete5_Library_View->render() #13 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/startup/tools_upgrade_check.php(9): include('/hsphere/local/...') #14 /hsphere/local/home/bigjohn7/om-im.org/updates/concrete5.6.3.2/concrete/dispatcher.php(105): require('/hsphere/local/...') #15 /hsphere/local/home/bigjohn7/om-im.org/concrete/startup/updated_core_check.php(7): require('/hsphere/local/...') #16 /hsphere/local/home/bigjohn7/om-im.org/concrete/dispatcher.php(25): require('/hsphere/local/...') #17 /hsphere/local/home/bigjohn7/om-im.org/index.php(2): require('/hsphere/local/...') #18 {main}
Help!
What version of Concrete5 are you starting with and what version are you trying to go to?
I am currently running 5.6.2.1 upgrading to 5.6.3.2....the environment settings show me having 5.6.3.2.
If you made a database backup before you started and can revert back to 5.6.2.1 I would do that, then you need to upgrade to 5.6.3 and then 5.6.3.2, there is something in that 5.6.3 upgrade that needs to run before you can upgrade further.
Thanks. I did make a backup before I installed the update. It's on my work computer so I will reinstall it on Monday and then follow your steps. It's funny that my site works fine but the Dashboard "Search Users" gives an error. There might be other errors in Dashboard but everything on the site runs OK.
Dropped all current tables, installed backup. Everything works except for the the "Search Users" in the Dashboard. I get this error:
An unexpected error occurred.
Unable to get permission key for access_user_search_export
Any suggestions?
An unexpected error occurred.
Unable to get permission key for access_user_search_export
Any suggestions?
It looks like you're not the only person to get this error.
http://www.concrete5.org/community/forums/installation/moved-site-t...
http://www.concrete5.org/community/forums/installation/moved-site-t...
Thanks! Did their suggestion and everything is back to normal. Really appreciate your help!