TinyPortal
Development => Support => Topic started 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
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