database error when upgrading to a new version of tinyportal

[mack420]

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

I checked the line number 354 and there is no NULL to replace nor is there the word UNIQUE

the exact line numbered 354 is as follows

$smcFunc['db_add_column']('{db_prefix}' . $table, $column);

there is a line 393 that has Null in it I am posting below this

checkTextColumnNull($table);

my php version is 7.4.33 and it is you need 7.0 or higher for tinyportal, so I don't know what to do

maybe my site is broken and I can no longer use this portal which sucks because i like the shoutbox and the blocks, but whatever, hopefully someone can help me when they get a moment as I would appreciate it as always, still just a dumbass user, not a technician, so please help and no rude comments

[Steve]

1. Even though it's an extremely minor curse word, keep in mind we do try to keep this a family-friendly forum for future reference.

no rude comments

2. This was completely unnecessary. Telling people not to do something tends to make them do it. 

3. If this is a Tiny Portal problem, you need to ask about it here: TinyPortal

And lastly, if it is not a Tiny Portal problem, i.e. your forum is borked no matter what mod you try, then someone more proficient than I in this area will respond as soon as they can.

[Illori]

this is a bug in SMF

https://github.com/SimpleMachines/SMF/issues/7631

[mack420]

thank you for the link, Illori

I was able to find a real simple way to solve this bug as ya called it

I just downgraded to 2.1.2

installed tinyportal

then upgraded back to 2.1.3 and everything works, so yea, thanks and no hard feelings to the db who was rude

peace ya all

[Steve]

Being the 'db who was rude', nothing I posted was rude or meant to be in any way (hence the smiley).

But you chose to take it that way and post it publicly which has been removed (not by me).

[mack420]

the fact that you felt the need to reply proves you were rude and it had nothing to do with the way I took it

only thing removed on my end was because I chose to react with a fight fire with fire mentality and I should not have done that

But I can admit to that, you cannot admit you were wrong, so leave it there and move on if you are truly not rude

[Aleksi "Lex" Kilpinen]

Lets stop here. Among other things, you directly called Steve a "rude douchebag", and so the post got removed by another team member. This is what I believe Steve means when he says it wasn't him.