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

Hey typohannes! Before you update to v3, you’ll first want to update to the latest version of v2. Once you’ve done that, give the v3 upgrade a try again. Let me know if you have any issues or hit up the fine folks in ExpressionEngine Slack!

Hello,

Thanks for the reply, so I downloaded 2.11.9 and tried upgrading my current version 2.5.5 first to the latest V2, and unfortunately upon following the Wizard I still got the same error message, see below

“A Database Error Occurred

Error Number: 1265

Data truncated for column ‘total_entries’ at row 27

ALTER TABLE exp_members CHANGE total_entries total_entries mediumint(8) UNSIGNED DEFAULT ‘0’ NOT NULL

Filename: /var/www/system/expressionengine/libraries/Smartforge.php

Line Number: 227”

Already reported the same error in the Slack channel too

Thanks

That’s very unusual; it sounds as if something wrote an invalid value to the total_entries column in your v2 database. It should only contain integers. If you look at that table in phpMyAdmin or similar, and then sort ascending and descending, do you see anything out of the ordinary? Flipping asc/desc search should make any incorrect datatypes pop to the top of the list.

Hi Derek,

Thanks for the reply, it’s all good now, I manage to resolve the issue by myself, the issue is not related to the column itself but to the table row.

Thanks

Interesting, glad you found it! If you are able to, please elaborate on the cause and how you fixed it, in case someone else bumps into this issue, or if there’s something we can do in the app to help prevent it from occurring.