Upgrade from 2.1.2 to 2.1.3 Database Error

[Kokoro]

Link to my forum: http://www.AnimeRPGs.com/
SMF version: 2.1.3
TP version: 2.2.2
Default Forum Language: English
Theme name and version: Curve
Browser Name and Version: Firefox (107.0 64-bit)
Mods installed: SMF Social Packs, Members Online Today, Post as Another Member, Dice Roller BBCode
Related Error messages: Database Error: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

My host automatically upgraded my forum to the latest 2.1.3 and all my mods were "uninstalled"?.  I tried to reinstall TinyPortal but got the above error message.

[@rjen]

Unfortunately SMF2.1.3 introduced in bug that prevents the TinyPortal installer to complete in SMF2.1.3.

Same issue as reported here: https://www.tinyportal.net/index.php?topic=36797.0

The bug has been reported with SMF and has been flagged for SMF2.1.4.

At this time there is no real solution other then downgrading you forum to SMF2.1.2, then install TinyPortal and patch the forum to SMF2.1.3 afterwards.

Perhaps we can find another work-around, but it is not known at this time...

[Kokoro]

Thank you!  I'll patiently wait.

[@rjen]

Work-around if you have upgraded from 2.1.2 to 2.1.3

Using an FTP client you can restore the previous version of the file DbPackages-mysql.php and install TinyPortal.

To do this :
1. rename the DbPackages-mysql.php file to DbPackages-mysql.php~213 (to keep it safe)
2. Then rename DbPackages-mysql.php~ to DbPackages-mysql.php

You can now install TinyPortal

then restore the files to their old state
3. Rename DbPackages-mysql.php to DbPackages-mysql.php~
4. Rename the DbPackages-mysql.php~213 file to DbPackages-mysql.php

[Kokoro]

I don't have a DbPackages-mysql.php~ file.

[@rjen]

Then your host probably did not upgrade your smf version with the patch (as they should have), but the overwrote everything with the large upgrade package!. It also explains why you lost all modifications...

You can use the file from the SMF2.1.2 install package. I have attached the file here...

This file would need to go into the /sources folder, using an FTP client, then follow the procedure..

[Kokoro]

Awesome!  That did the trick!  Thank you!