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?

October 04, 2022, 11:12:18 PM

Login with username, password and session length
Members
  • Total Members: 3848
  • Latest: rrolle
Stats
  • Total Posts: 193513
  • Total Topics: 21092
  • Online today: 72
  • Online ever: 3540
  • (September 02, 2022, 06:38:54 PM)
Users Online
Users: 0
Guests: 43
Total: 43

Author Topic: TinyPortal 2.2.0  (Read 1198 times)

0 Members and 1 Guest are viewing this topic.

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #10 on: February 12, 2022, 07:11:08 AM »
Quote
$smcFunc['db_change_column']('{db_prefix}tp_blocks', 'access2', array( 'name' => 'display', 'type' => 'text', 'default' => ($db_type == 'mysql' ? null : '')));

This is the code in the line 

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2615
Re: TinyPortal 2.2.0
« Reply #11 on: February 12, 2022, 07:25:34 AM »
Quote
$smcFunc['db_change_column']('{db_prefix}tp_blocks', 'access2', array( 'name' => 'display', 'type' => 'text', 'default' => ($db_type == 'mysql' ? null : '')));

This is the code in the line

What I think has happened is you installed TinyPortal 2.x.x then went back to TinyPortal 1.6.x (or similar)

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #12 on: February 12, 2022, 08:45:40 AM »
I did a fresh SMF install and I still have the same problem. I cannot install TP. I think TP is having some issue with the database as I had reported here

Quote
The database value you're trying to insert does not exist: access2
Function: require

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline @rjen

  • Support Team
  • *
  • Posts: 3300
    • FJR-club Nederland
Re: TinyPortal 2.2.0
« Reply #13 on: February 12, 2022, 08:47:34 AM »

Looking back it, I think you have broken your install previously. Can you give me the structure of tp_blocks?

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

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #14 on: February 12, 2022, 08:58:38 AM »

Looking back it, I think you have broken your install previously. Can you give me the structure of tp_blocks?


I think you are right. What exactly do you mean 'structure of tp_blocks'. I removed latest version and tried installing 1.6.2 onwards but I still get this problem.

 

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2615
Re: TinyPortal 2.2.0
« Reply #15 on: February 12, 2022, 09:04:00 AM »
I did a fresh SMF install and I still have the same problem. I cannot install TP. I think TP is having some issue with the database as I had reported here

Quote
The database value you're trying to insert does not exist: access2
Function: require

Do you mean a completely empty database with no TinyPortal tables? As this shouldn’t happen, and is what I tested. Which works.

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #16 on: February 12, 2022, 09:19:07 AM »
No database is the same one only the install is full install not upgrade.

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2615
Re: TinyPortal 2.2.0
« Reply #17 on: February 12, 2022, 09:34:41 AM »
No database is the same one only the install is full install not upgrade.

Then we need to see the structure of the database. Which can be viewed by phpMyAdmin.

It should be noted, and we are quite explicit. Going back from TinyPortal 2.x.x to TinyPortal 1.x.x will cause issues. This is one of them. You are going to have to manually correct your database.

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #18 on: February 12, 2022, 09:42:50 AM »
Is this what you need to see.


SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2615
Re: TinyPortal 2.2.0
« Reply #19 on: February 12, 2022, 10:23:15 AM »
Yes, it should look like the attached screenshot.

There are other things likely to be broken also, which I can't remember at the moment.