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

Recent

Welcome to TinyPortal. Please login or sign up.

April 18, 2024, 01:07:53 AM

Login with username, password and session length
Members
  • Total Members: 3,885
  • Latest: Growner
Stats
  • Total Posts: 195,164
  • Total Topics: 21,219
  • Online today: 143
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 158
  • Total: 158

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.

dinotoyforum

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!

tino

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.

dinotoyforum

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

dinotoyforum

#3
EDIT- Thanks for your help, all fixed now!

I was able to install using @rjen's suggestion here: https://www.tinyportal.net/index.php?topic=36798.msg302728#msg302728

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.