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

Recent

Welcome to TinyPortal. Please login or sign up.

March 28, 2024, 08:33:04 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,104
  • Total Topics: 21,212
  • Online today: 174
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 160
  • Total: 160

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.

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

Kokoro


@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


Running Latest TP on SMF2.1 at: www.fjr-club.nl

Kokoro


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

Kokoro

Awesome!  That did the trick!  Thank you!