Upgrade to 3.3.12, MYSQL error

[erpe]

I downloaded the changed files package to update from 3.3.11 to 3.3.12.
I have to forums on the same webserver.
First one everything updates smooth.
Second forum I got an sql error (see image attached)
What to do?

FE now displays following error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_last_active' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

[ssl]

In /cache folder delete:

• install folder
• production folder

In /store folder delete:

• install_config.php file
• .lock and migration file

and start the update procedure again

[erpe]

done, but same sql error appeared as before...

[ssl]

Row size too large (> 8126)

The root cause of this issue is that the MySQL/MariaDB database engine (InnoDB) has a maximum row size limit. When this limit is exceeded, the database engine is unable to store any more data in that row. This limit is typically encountered when trying to import large datasets or when the table structure includes large VARCHAR fields.

Read this: https://stackoverflow.com/questions/155 ... -too-large

[Noxwizard]

Can you run these queries in phpMyAdmin and post the results:

Code: Select all

SHOW CREATE TABLE `phpbb_users`;

Code: Select all

SELECT row_format FROM information_schema.tables WHERE table_schema="your database name" AND table_name="phpbb_users" LIMIT 1;

The first will probably be truncated, in the Extra Options menu, choose Full Texts. You'll need to update the second query with the correct database name.

[erpe]

Hey and thanks for quick help.
@noxwizard
1. query result is

Code: Select all

CREATE TABLE `phpbb_users` (
 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `user_type` tinyint(2) NOT NULL DEFAULT 0,
 `group_id` mediumint(8) unsigned NOT NULL DEFAULT 3,
 `user_permissions` mediumtext NOT NULL,
 `user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT 0,
 `user_ip` varchar(40) NOT NULL DEFAULT '',
 `user_regdate` int(11) unsigned NOT NULL DEFAULT 0,
 `username` varchar(255) NOT NULL DEFAULT '',
 `username_clean` varchar(255) NOT NULL DEFAULT '',
 `user_password` varchar(255) NOT NULL DEFAULT '',
 `user_passchg` int(11) unsigned NOT NULL DEFAULT 0,
 `user_email` varchar(100) NOT NULL DEFAULT '',
 `user_birthday` varchar(10) NOT NULL DEFAULT '',
 `user_lastvisit` int(11) unsigned NOT NULL DEFAULT 0,
 `user_lastmark` int(11) unsigned NOT NULL DEFAULT 0,
 `user_lastpost_time` int(11) unsigned NOT NULL DEFAULT 0,
 `user_lastpage` varchar(200) NOT NULL DEFAULT '',
 `user_last_confirm_key` varchar(10) NOT NULL DEFAULT '',
 `user_last_search` int(11) unsigned NOT NULL DEFAULT 0,
 `user_warnings` tinyint(4) NOT NULL DEFAULT 0,
 `user_last_warning` int(11) unsigned NOT NULL DEFAULT 0,
 `user_login_attempts` tinyint(4) NOT NULL DEFAULT 0,
 `user_inactive_reason` tinyint(2) NOT NULL DEFAULT 0,
 `user_inactive_time` int(11) unsigned NOT NULL DEFAULT 0,
 `user_posts` mediumint(8) unsigned NOT NULL DEFAULT 0,
 `user_lang` varchar(30) NOT NULL DEFAULT '',
 `user_timezone` varchar(100) NOT NULL DEFAULT '',
 `user_dateformat` varchar(64) NOT NULL DEFAULT 'd M Y H:i',
 `user_style` mediumint(8) unsigned NOT NULL DEFAULT 0,
 `user_rank` mediumint(8) unsigned NOT NULL DEFAULT 0,
 `user_colour` varchar(6) NOT NULL DEFAULT '',
 `user_new_privmsg` int(4) NOT NULL DEFAULT 0,
 `user_unread_privmsg` int(4) NOT NULL DEFAULT 0,
 `user_last_privmsg` int(11) unsigned NOT NULL DEFAULT 0,
 `user_message_rules` tinyint(1) unsigned NOT NULL DEFAULT 0,
 `user_full_folder` int(11) NOT NULL DEFAULT -3,
 `user_emailtime` int(11) unsigned NOT NULL DEFAULT 0,
 `user_topic_show_days` smallint(4) unsigned NOT NULL DEFAULT 0,
 `user_topic_sortby_type` varchar(1) NOT NULL DEFAULT 't',
 `user_topic_sortby_dir` varchar(1) NOT NULL DEFAULT 'd',
 `user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT 0,
 `user_post_sortby_type` varchar(1) NOT NULL DEFAULT 't',
 `user_post_sortby_dir` varchar(1) NOT NULL DEFAULT 'a',
 `user_notify` tinyint(1) unsigned NOT NULL DEFAULT 0,
 `user_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT 1,
 `user_notify_type` tinyint(4) NOT NULL DEFAULT 0,
 `user_allow_pm` tinyint(1) unsigned NOT NULL DEFAULT 1,
 `user_allow_viewonline` tinyint(1) unsigned NOT NULL DEFAULT 1,
 `user_allow_viewemail` tinyint(1) unsigned NOT NULL DEFAULT 1,
 `user_allow_massemail` tinyint(1) unsigned NOT NULL DEFAULT 1,
 `user_options` int(11) unsigned NOT NULL DEFAULT 230271,
 `user_avatar` varchar(255) NOT NULL DEFAULT '',
 `user_avatar_type` varchar(255) NOT NULL DEFAULT '',
 `user_avatar_width` smallint(4) unsigned NOT NULL DEFAULT 0,
 `user_avatar_height` smallint(4) unsigned NOT NULL DEFAULT 0,
 `user_sig` mediumtext NOT NULL,
 `user_sig_bbcode_uid` varchar(8) NOT NULL DEFAULT '',
 `user_sig_bbcode_bitfield` varchar(255) NOT NULL DEFAULT '',
 `user_jabber` varchar(255) NOT NULL DEFAULT '',
 `user_actkey` varchar(32) NOT NULL DEFAULT '',
 `reset_token` varchar(64) NOT NULL DEFAULT '',
 `reset_token_expiration` int(11) unsigned NOT NULL DEFAULT 0,
 `user_newpasswd` varchar(255) NOT NULL DEFAULT '',
 `user_form_salt` varchar(32) NOT NULL DEFAULT '',
 `user_new` tinyint(1) unsigned NOT NULL DEFAULT 1,
 `user_reminded` tinyint(4) NOT NULL DEFAULT 0,
 `user_reminded_time` int(11) unsigned NOT NULL DEFAULT 0,
 PRIMARY KEY (`user_id`),
 UNIQUE KEY `username_clean` (`username_clean`),
 KEY `user_birthday` (`user_birthday`),
 KEY `user_type` (`user_type`),
 KEY `user_email` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

2. query result (hopefully correct) is

Compact

[erpe]

@ssl
this is a private very small forum, that runs well before I started upgrading.
The other one, that was upgraded first is much more bigger and upgraded successfull as I stated in my first post.
I now asked my hoster to set back files and database but nevertheless I hope we will find the reason for this behaviour.

[erpe]

In the meantime a let my hoster reset the forum.

I then downloaded the restored version (and db) to a local server and did the update to 3.3.12 again and I succeeded without any errors.

[scobu]

ssl's solution worked perfectly for me!
Thanks!

In /cache folder delete:

install folder
production folder

In /store folder delete:

install_config.php file
.lock and migration file

and start the update procedure again