EEConf 2024 is around the corner! EEConf 2024
Hello Guys,
So I’m upgrading my old site from 2.55 to the latest version (kinda outdated piece of software please don’t laugh), so I followed the instruction from this page https://docs.expressionengine.com/v3/installation/upgrade_from_2.x.html, check modules, permissions etc. and viewed the site at http://dev.local/system I got Exception Caught error
“SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘eh6316a.exp_plugins’ doesn’t exist:
SELECT plugin_package
FROM (exp_plugins
)
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116”
or http://dev.local/admin.php
SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘total_entries’ at row 27:
ALTER TABLE exp_members
CHANGE total_entries
total_entries
mediumint(8) UNSIGNED NOT NULL DEFAULT ‘0’
What could be the issue, can someone enlighten me, please?
Thanks
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.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.