TinyPortal

Development => Support => Topic started by: DinoToyForum on January 10, 2023, 11:50:22 PM

Title: Database error during install
Post by: DinoToyForum on January 10, 2023, 11:50:22 PM
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!
Title: Re: Database error during install
Post by: tino on January 11, 2023, 12:20:38 AM
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.
Title: Re: Database error during install
Post by: DinoToyForum on January 11, 2023, 12:30:56 AM
Thank you so much for the swift reply. I'll give that a try and let you know how it goes.
Title: Re: Database error during install
Post by: DinoToyForum on January 11, 2023, 01:19:29 AM
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.