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

Recent

Welcome to TinyPortal. Please login or sign up.

December 04, 2024, 11:43:01 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,443
  • Total Topics: 21,252
  • Online today: 158
  • Online ever: 6,457 (November 30, 2024, 02:40:09 PM)
Users Online
  • Users: 0
  • Guests: 113
  • Total: 113

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.

tty456

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:

10.10.11.27
896535194166c9d5d81748d5380bebed
https://wealdencaving.org.uk/forum2/smf/index.php?action=admin;area=packages;sa=install2;package=TinyPortal-2.2.2-1-test2b.zip;pid=0
/home/wealdencaving.org.uk/public_html/forum2/smf/Packages/temp/install.php (Line 354)  Backtrace information

#0: smf_db_error()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/Subs-Db-mysql.php on line 495
#1: smf_db_query()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/DbPackages-mysql.php on line 476
#2: smf_db_change_column()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/DbPackages-mysql.php on line 346
#3: smf_db_add_column()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Packages/temp/install.php on line 354
#4: require()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/Packages.php on line 1064
#5: PackageInstall()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/Subs.php on line 6016
#6: call_helper()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/Packages.php on line 91
#7: Packages()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/Sources/Admin.php on line 499
#8: AdminMain()
Called from /home/wealdencaving.org.uk/public_html/forum2/smf/index.php on line 191

@rjen

Running Latest TP on SMF2.1 at: www.fjr-club.nl

tino

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

https://github.com/SimpleMachines/SMF/pull/7604

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


tino

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.

tty456

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

O0