TinyPortal

Development => Support => Topic started by: MegaBrutal on January 22, 2023, 12:29:57 AM

Title: Can't (re)install TinyPortal after major SMF upgrade
Post by: MegaBrutal on January 22, 2023, 12:29:57 AM
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'
Packages/temp/install.php:354
Title: Re: Can't (re)install TinyPortal after major SMF upgrade
Post by: @rjen on January 22, 2023, 08:41:23 AM
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  https://www.tinyportal.net/index.php?topic=36798.0