HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome to TinyPortal. Please login or sign up.

July 21, 2024, 09:15:06 AM

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

All parts of a PRIMARY KEY must be NOT NULL

Started by tty456, November 24, 2022, 10:35:35 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


Edit: just seen your updated while was posting, left below in case helps!

ah right sorry, below is from SMF log after TP 2.2.2 install fails, there looks to be log entry for each loop, the first is:
/home/ (Line 354)  Backtrace information

#0: smf_db_error()
Called from /home/ on line 495
#1: smf_db_query()
Called from /home/ on line 476
#2: smf_db_change_column()
Called from /home/ on line 346
#3: smf_db_add_column()
Called from /home/ on line 354
#4: require()
Called from /home/ on line 1064
#5: PackageInstall()
Called from /home/ on line 6016
#6: call_helper()
Called from /home/ on line 91
#7: Packages()
Called from /home/ on line 499
#8: AdminMain()
Called from /home/ on line 191


Running Latest TP on SMF2.1 at:


Quote from: @rjen on November 25, 2022, 02:36:13 PM
I remembered reading this...

Yep going back to SMF 2.1.2 shows this in the logs when I install

ALTER TABLE smf_tp_articles CHANGE COLUMN `id` `id` int(11) NOT NULL auto_increment


Quote from: tty456 on November 25, 2022, 02:29:28 PM
Edit: just seen your updated while was posting, left below in case helps!

Thanks, although not ideal you should be able to update to SMF 2.1.2 then install the latest TinyPortal and install the patch to SMF 2.1.3. This should mean you are on the latest TinyPortal and SMF. It's a bit of a fudge but should work.


Thanks for your help, I will hold off upgrading live for now then and keep an eye on that ticket before trying again.