We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

updating problem A Database Error Occurred Error Number: 1146

Development and Programming

amra01's avatar
amra01
45 posts
9 years ago
amra01's avatar amra01

trying to update from ee 2.9.2 to 2.11.1 I have followed the procedure, trying to run the update and I get this error.

I was getting the same error trying to access the templates

A Database Error Occurred
Error Number: 1146

Table 'desigov6_eecreate.exp_template_routes' doesn't exist

SELECT `exp_template_routes`.`template_id`, `route_required`, `route` FROM (`exp_templates`) JOIN `exp_template_routes` ON `exp_templates`.`template_id` = `exp_template_routes`.`template_id` WHERE `route_parsed` is not null

Filename: updates/ud_2_09_03.php

Line Number: 142

« Back

I can access my webpage but no admin can anyone help me? is there any other procedure to run the update?

       
FountainInternet's avatar
FountainInternet
53 posts
9 years ago
FountainInternet's avatar FountainInternet

The safest way to re-run the update is to restore your core files and database back to what they were before the update and then run the update again.

However, if you don’t have a very recent backup, you might be able to get away with winding back the version number in the system/expressionengine/config.php file to the number prior to the update and then run it again. This is the setting to look for:

$config['app_version']
       
amra01's avatar
amra01
45 posts
9 years ago
amra01's avatar amra01

thanks for the info, problem solved with the support I got from slack ee forum. There was a problem with updater plugin I changed inside the config file the app version back to 260 then updated again to 270 update again and I got to 2.11.1 everything is working now.

       
chesterkmarrone's avatar
chesterkmarrone
1 posts
one year ago
chesterkmarrone's avatar chesterkmarrone

It’s frustrating when so many things happen especially when trying to install a new version. It would be great to have troubleshooting steps to help people who encounter this situation.

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.