Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome, Guest. Please login or register.
Did you miss your activation email?

February 09, 2023, 01:54:08 AM

Login with username, password and session length
  • Total Posts: 194010
  • Total Topics: 21135
  • Online today: 33
  • Online ever: 3540
  • (September 02, 2022, 06:38:54 PM)
Users Online
Users: 1
Guests: 30
Total: 31

Author Topic: Can't (re)install TinyPortal after major SMF upgrade  (Read 138 times)

0 Members and 1 Guest are viewing this topic.

Offline MegaBrutal

  • Newbie
  • *
  • Posts: 4
Can't (re)install TinyPortal after major SMF upgrade
« on: January 21, 2023, 05:29:57 PM »
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:

Code: [Select]
Invalid default value for 'item_type'
I enabled query logging and found that the install script tried to execute the following query:

Code: [Select]
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:

Code: [Select]
            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:

Code: [Select]
Invalid default value for 'item_type'

Offline @rjen

  • Support Team
  • *
  • Posts: 3497
    • FJR-club Nederland
Re: Can't (re)install TinyPortal after major SMF upgrade
« Reply #1 on: January 22, 2023, 01: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
Running Latest TP on SMF2.1 at: www.fjr-club.nl