HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome to TinyPortal. Please login or sign up.

September 26, 2023, 02:41:39 AM

Login with username, password and session length
  • Total Posts: 194,549
  • Total Topics: 21,181
  • Online today: 97
  • Online ever: 3,540
  • (September 03, 2022, 01:38:54 AM)
Users Online
Users: 0
Guests: 94
Total: 94

Database error during install

Started by dinotoyforum, January 10, 2023, 11:50:22 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


Hi, I enjoy this mod and use it on two forums. I recently uninstalled it temporarily on one forum during some trouble-shooting. When I tried to install it again I receive the following Database Error message:

"All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
File: ............................/Packages/temp/install.php
Line: 354"

Can you help me fix this error? Presumably I need to go into the database and fix a column there, but I'm not sure which one?
Thank you!


Unfortunately that is a bug with SMF the only known fix we have is downgrade to SMF 2.1.2 install TinyPortal then upgrade to SMF 2.1.3 again.


Thank you so much for the swift reply. I'll give that a try and let you know how it goes.


EDIT- Thanks for your help, all fixed now!

I was able to install using @rjen's suggestion here:

By the way, it occurred to me that I could emulate 2.1.2 in the package manager to reinstall TinyPortal but that didn't work either.