Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome, Guest. Please login or register.
Did you miss your activation email?

February 04, 2023, 09:36:30 AM

Login with username, password and session length
Members
  • Total Members: 3856
  • Latest: Bixby
Stats
  • Total Posts: 193945
  • Total Topics: 21131
  • Online today: 51
  • Online ever: 3540
  • (September 02, 2022, 06:38:54 PM)
Users Online
Users: 1
Guests: 50
Total: 51

Author Topic: All parts of a PRIMARY KEY must be NOT NULL  (Read 462 times)

0 Members and 1 Guest are viewing this topic.

Offline tty456

  • Jr. Member
  • **
  • Posts: 7
Re: All parts of a PRIMARY KEY must be NOT NULL
« Reply #10 on: November 25, 2022, 07:29:28 AM »
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

Offline @rjen

  • Support Team
  • *
  • Posts: 3475
    • FJR-club Nederland
Re: All parts of a PRIMARY KEY must be NOT NULL
« Reply #11 on: November 25, 2022, 07:36:13 AM »
I remembered reading this…

https://github.com/SimpleMachines/SMF/pull/7604
Running Latest TP on SMF2.1 at: www.fjr-club.nl

Offline tino

  • Developer
  • *
  • Posts: 2704
Re: All parts of a PRIMARY KEY must be NOT NULL
« Reply #12 on: November 25, 2022, 08:04:46 AM »
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

Code: [Select]
ALTER TABLE smf_tp_articles CHANGE COLUMN `id` `id` int(11) NOT NULL auto_increment

Offline tino

  • Developer
  • *
  • Posts: 2704
Re: All parts of a PRIMARY KEY must be NOT NULL
« Reply #13 on: November 25, 2022, 08:08:45 AM »

Offline tino

  • Developer
  • *
  • Posts: 2704
Re: All parts of a PRIMARY KEY must be NOT NULL
« Reply #14 on: November 25, 2022, 08:12:10 AM »
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.

Offline tty456

  • Jr. Member
  • **
  • Posts: 7
Re: All parts of a PRIMARY KEY must be NOT NULL
« Reply #15 on: November 25, 2022, 08:16:49 AM »
Thanks for your help, I will hold off upgrading live for now then and keep an eye on that ticket before trying again.

 O0