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

Base table or view not found: 1146 Table 'xxx.exp_plugins' doesn't exist

How Do I?

mwm's avatar
mwm
2 posts
6 years ago
mwm's avatar mwm

I know this is a duplicate of another thread but I did upgrade a (very old) site from 2.9.2 to 2.11.9 and the plugins table is still not there. The upgrade completed successfully, but the table was not created.

I used the 2.11.9 zip file from github but I don’t see any schema changes to add the plugins table (or any of the other changes required before I can upgrade to v3 and do the rest of the upgrades).

Any suggestion what I’m doing wrong that the schema is not updating?

       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

That table doesn’t exist (and plugins aren’t installed like other add-ons) until v3.

       
mwm's avatar
mwm
2 posts
6 years ago
mwm's avatar mwm

Thanks Derek, then I’m confused what I’m doing wrong. I did the 2.11 upgrade, then followed the v3 migration steps, but the v3 installer complains about the missing table.

       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

Are you sure it’s the v3 installer? It sounds more like you are hitting the front end or the control panel without having run the installer. Make sure the installer folder is in place with proper read permissions. What are you using as the source of your v3 download?

       
JT121's avatar
JT121
3 posts
6 years ago
JT121's avatar JT121

Did you get this fixed? I’m running into the same exact issue.

       
Robin Sowell's avatar
Robin Sowell
13,158 posts
6 years ago
Robin Sowell's avatar Robin Sowell

Can you walk us through it a bit? Where’s it breaking? When you’re trying to upgrade or after you’ve upgraded to what version?

       
Micah's avatar
Micah
17 posts
6 years ago
Micah's avatar Micah

I am having this same issue, but I’m wondering how to run the installer that is mentioned here? I upgraded to v2.11.9 and followed the instructions here to get to latest version of EE3:

https://docs.expressionengine.com/v3/installation/upgrade_from_2.x.html

It says to just visit /admin.php or /system in browser to run the installer, but instead I get this error. How do I get the site to run the installer?

       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

Hi Micah,

Where are you getting your v3 source files? It sounds like you’re missing the installer folder.

       
Micah's avatar
Micah
17 posts
6 years ago
Micah's avatar Micah

Thanks for the fast reply!

I got v3 here:

https://github.com/ExpressionEngine/ExpressionEngine/tree/master-v3

The installer folder is present under /system/ee, but I don’t know how to make it run.

       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

Try from the releases instead of the source branch. The source branch is not designed to run in production, as it’s not a built app package.

https://github.com/ExpressionEngine/ExpressionEngine/releases/tag/3.5.17

       
Micah's avatar
Micah
17 posts
6 years ago
Micah's avatar Micah

Thanks. I downloaded that and re-started the upgrade instructions. Now I’m getting this error:

You must define the following database parameters: database ee/EllisLab/ExpressionEngine/Service/Database/DBConfig.php:157

If I update that DBConfig.php file directly and set the $defaults array to use the database settings (not sure I am supposed to do that), I then am back to the same error (xxx.exp_plugins doesn’t exist) when visiting /admin.php or /system, and no installer runs.

       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

It still sounds like you don’t have the installer folder in place. Did you download the release zip or the source code zip? You want the former.

       
Micah's avatar
Micah
17 posts
6 years ago
Micah's avatar Micah

That was it–thanks! I downloaded source. Thanks for your fast help. I will post again (likely in a new post) if I have additional issues.

       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

My pleasure!

       
Micah's avatar
Micah
17 posts
about 6 years ago
Micah's avatar Micah

Hi Derek. Do you have a link for the 4.x and 5.x releases also? I used this for 4.3.8, for example:

https://github.com/ExpressionEngine/ExpressionEngine/releases/tag/4.3.8

But there is only an option to download “source” version. And of course when I do that, I’m getting errors again about a bunch of missing tables/columns when visiting /admin.php, instead of the installer. Thanks for any help.

       
1 2

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.