Base table or view not found...how to fix
How Do I?
I am working on upgrading from 2.7x to v3. And when attempting to run the upgrade I am getting the following error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxxxxxx.exp_plugins’ doesn’t exist:
SELECT plugin_package FROM (exp_plugins)
ee/legacy/database/drivers/mysqli/mysqli_connection.php:122
How do I fix this and move on with the upgrade.
Thanks, Jack
The exp_plugins table was added in 3.0- if you look at the ud_3.0.0.php file in the installer, you’ll see it’s one of the first things that should happen:
public function do_update()
{
ee()->load->dbforge();
$steps = new \ProgressIterator(
array(
'_move_database_information',
'_update_email_cache_table',
'_update_upload_no_access_table',
'_insert_comment_settings_into_db',
'_insert_cookie_settings_into_db',
'_create_plugins_table',Based on the error, we really can’t tell where it’s trying to query the plugin table, but it doesn’t exist at that point. Do you know what version it’s on when it’s failing? Check the config.php- what’s it say you got to?
When I look at /system/ee/installer/config/config.php I am not seeing anything that shows any type of version number or something to tell me where/when its failing.
Am I looking at the correct config file? It seems there are numerous config files.
The above error shows up as soon as I go to http://mywebsite.com/admin.php
Thanks for the advice!
Jack
If I had to bet, it’s trying to load the site rather than show the installer. If that’s what’s up- does this help: https://github.com/expressionengine/expressionengine/#if-youre-installing-from-the-repository