Registeration: Incorrect integer value: '' for column 'user_avatar_type' at row 1

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Post Reply
Streamer76
Registered User
Posts: 34
Joined: Mon Dec 17, 2007 6:26 pm

Registeration: Incorrect integer value: '' for column 'user_avatar_type' at row 1

Post by Streamer76 » Mon Jan 22, 2018 4:53 pm

Get this error on new user registeration "Incorrect integer value: '' for column 'user_avatar_type' at row 1" after upgrading to 3.1.12 - same time changed server so don't know yet is it related to upgrade or changing server.

phpBB 3.1.12
PHP Version 5.6.32
10.2.10-MariaDB

Any ideas?

Streamer76
Registered User
Posts: 34
Joined: Mon Dec 17, 2007 6:26 pm

Re: Registeration: Incorrect integer value: '' for column 'user_avatar_type' at row 1

Post by Streamer76 » Mon Jan 22, 2018 7:19 pm

I think this is something to do with MariaDB strict mode, which is on default from 10.2.4.

"With strict mode set (default from MariaDB 10.2.4), the statements will fail, and an error will be returned instead. The IGNORE keyword can be used when strict mode is set to convert the error to a warning." https://mariadb.com/kb/en/library/sql-mode/#strict-mode

This seems to be problem only in registerations, so maybe this is a bug there.

Streamer76
Registered User
Posts: 34
Joined: Mon Dec 17, 2007 6:26 pm

Re: Registeration: Incorrect integer value: '' for column 'user_avatar_type' at row 1

Post by Streamer76 » Mon Jan 22, 2018 8:01 pm

I made a quick fix by changing user_avatar_type to varchar, seems to work now.

Code: Select all

ALTER TABLE `phpbb_users` CHANGE `user_avatar_type` `user_avatar_type` VARCHAR(2) NOT NULL DEFAULT '0';

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: Google [Bot] and 21 guests