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.

       

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.