TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 29, 2023, 04:57:04 PM

Login with username, password and session length
Members
Stats
  • Total Posts: 194,246
  • Total Topics: 21,146
  • Online today: 49
  • Online ever: 3,540
  • (September 03, 2022, 01:38:54 AM)
Users Online
Users: 0
Guests: 35
Total: 35

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.

MegaBrutal

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

@rjen

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
Running Latest TP on SMF2.1 at: www.fjr-club.nl