HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome to TinyPortal. Please login or sign up.

May 23, 2024, 10:16:06 AM

Login with username, password and session length
  • Total Posts: 195,197
  • Total Topics: 21,221
  • Online today: 67
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 1
  • Guests: 37
  • Total: 38
  • @rjen

Can't (re)install TinyPortal after major SMF upgrade

Started by MegaBrutal, January 22, 2023, 12:29:57 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


Recently upgraded my test instance from SMF 2.0.19 to 2.1.3. This of course reset the entire installation in regards to mods. I had TinyPortal 2.2.2 installed before the upgrade and now I just want to reinstall it.

However, I get this DB error:

Invalid default value for 'item_type'

I enabled query logging and found that the install script tried to execute the following query:

ALTER TABLE `smf_tp_comments` CHANGE COLUMN `item_type` `item_type` VARCHAR(255) NOT NULL DEFAULT NULL;

I guess "NOT NULL DEFAULT NULL" is not permitted...

Maybe the problem is caused by this line in install.php:

            array('name' => 'item_type', 'type' => 'varchar', 'size' => 255, 'default' => ($db_type == 'mysql' ? null : '')),

I have MariaDB 10.5.18 (as Debian has switched from MySQL to MariaDB a while ago).

Link to my forum: <<Private test instance with HTTP authentication>>
SMF version: 2.1.3
TP version: 2.2.2
Default Forum Language: Hungarian (UTF-8)
Theme name and version: Curve
Browser Name and Version: Mozilla Firefox 108.0.2
Mods installed: <<None>>
Related Error messages:

Invalid default value for 'item_type'


This has been reported multiple times in this board already and is caused by a bug in SMF 2.1.3

Work around procedure can be found here
Running Latest TP on SMF2.1 at: