HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome to TinyPortal. Please login or sign up.

July 16, 2024, 08:38:25 PM

Login with username, password and session length
  • Total Posts: 195,319
  • Total Topics: 21,233
  • Online today: 79
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 63
  • Total: 63

Upgrade from 2.1.2 to 2.1.3 Database Error

Started by Kokoro, November 28, 2022, 12:59:57 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


Link to my forum:
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.


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

Same issue as reported here:

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



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

Running Latest TP on SMF2.1 at:



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


Awesome!  That did the trick!  Thank you!