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?

August 09, 2022, 08:31:35 AM

Login with username, password and session length
Members
  • Total Members: 3842
  • Latest: Kokoro
Stats
  • Total Posts: 193479
  • Total Topics: 21088
  • Online today: 57
  • Online ever: 1035
  • (November 26, 2020, 04:45:12 AM)
Users Online
Users: 1
Guests: 49
Total: 50

Author Topic: TinyPortal 2.2.0  (Read 1042 times)

0 Members and 1 Guest are viewing this topic.

Online @rjen

  • Support Team
  • *
  • Posts: 3285
    • FJR-club Nederland
TinyPortal 2.2.0
« on: February 11, 2022, 12:10:52 PM »
The TinyPortal Team is pleased to announce the release of TinyPortal 2.2.0

TinyPortal 2.2.0 can be used on SMF 2.0 and 2.1

Minimum required PHP version : 7.2.0
Highest supported PHP version (tested) 8.1.1

Changelog: TinyPortal 2.2.0

Relevant to SMF 2.0 and 2.1:

New functionality:
- added most standard SSI functions as options to SSI block
- updated stats block to use thousand separators
- added font-awesome icons for menu options in specials themes
- updated installer to provide more consistent log information

Bugfixes:
- fixed block access page shows incorrect panels for blocks
- fixed Save button on block access pages showing between blocks when uneven #items
- fixed missing div on Downloads page when top downloads not activated
- fixed broken category links in profile articles view and use short names when available
- fixed link to article category from Profile
- fixed mini calendar blockcode for PHP 8.1
- fixed singleshout blockcode for 2.1.x
- general code updates for PHP8 compatibility

Note:
when updating from TinyPortal versions older than 2.1.0, shoutbox blocks are enhanced with a new block setting: "Characters to display in titles".
Due to this change any pre-existing shoutbox blocks 'may' have a changed title length after installing the new version of TP. Please check any shoutbox blocks and adjust the block setting "Characters to display in titles" to the desired length...

Download:
https://www.tinyportal.net/index.php?action=tportal;sa=download;dl=item172
« Last Edit: February 12, 2022, 03:21:28 AM by @rjen »
Running Latest TP on SMF2.1 at: www.fjr-club.nl

Testing TP on SMF2.0
Testing TP on SMF2.1 (latest Github)
Want to check what php version I am testing on? See: PHP Info

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #1 on: February 12, 2022, 03:30:46 AM »
Getting this error when trying to install. New install of SMF 2.1.1

Quote
Duplicate column name 'display'
File: /home2/diabesv6/public_html/Packages/temp/install.php
Line: 912

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #2 on: February 12, 2022, 03:33:18 AM »
This is the code around line 912

Code: [Select]
$third = explode(',', $second);

// build new ones

if(count($third) > 1)

{

foreach($third as $t => $tr)

$new[] = $first.$tr;

}

else

$new[] = $first.$second;

}

}

else

$new[] = $row['display'];



$smcFunc['db_query']('', '

UPDATE {db_prefix}tp_blocks

SET display = {string:display}

WHERE id = {int:blockid}',

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #3 on: February 12, 2022, 03:36:16 AM »
From the error log

Quote
$smcFunc['db_change_column']('{db_prefix}tp_blocks', 'access2', array( 'name' => 'display', 'type' => 'text', 'default' => ($db_type == 'mysql' ? null : '')));

A previous 'critical' error has this

Quote
The database value you're trying to insert does not exist: access2
Function: require
« Last Edit: February 12, 2022, 04:03:01 AM by Skb »

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2613
Re: TinyPortal 2.2.0
« Reply #4 on: February 12, 2022, 04:37:16 AM »
What version of php, MySQL and TinyPortal (previous one)?

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #5 on: February 12, 2022, 06:31:43 AM »
PHP - 7.4
MySQL - 5.7
TinyPortal - 2.1.0 (previous one)

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2613
Re: TinyPortal 2.2.0
« Reply #6 on: February 12, 2022, 07:00:51 AM »
PHP - 7.4
MySQL - 5.7
TinyPortal - 2.1.0 (previous one)

Thanks, I have just done the update from TinyPortal 2.1.0 to TinyPortal 2.2.0 three times in my test environment and none of them show the issue you are experiencing.

Admitedly it was a new TinyPortal 2.1.0 install after I'd cleared out all my old data from the previous update so not quite your scenario but as close as I could get it.

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #7 on: February 12, 2022, 07:02:25 AM »
Maybe I'll go in for a fresh install of SMF instead of upgrade. Will revert.

SMF 2.1 RC4 (default theme) / TP 2.1.0

Offline tino

  • Developer
  • *
  • Posts: 2613
Re: TinyPortal 2.2.0
« Reply #8 on: February 12, 2022, 07:03:23 AM »
Getting this error when trying to install. New install of SMF 2.1.1

Quote
Duplicate column name 'display'
File: /home2/diabesv6/public_html/Packages/temp/install.php
Line: 912

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

Did you by chance go back to an older version after previously updating.

Offline tino

  • Developer
  • *
  • Posts: 2613
Re: TinyPortal 2.2.0
« Reply #9 on: February 12, 2022, 07:05:45 AM »
This is the code around line 912

Code: [Select]
$third = explode(',', $second);

// build new ones

if(count($third) > 1)

{

foreach($third as $t => $tr)

$new[] = $first.$tr;

}

else

$new[] = $first.$second;

}

}

else

$new[] = $row['display'];



$smcFunc['db_query']('', '

UPDATE {db_prefix}tp_blocks

SET display = {string:display}

WHERE id = {int:blockid}',

That's not line 912? I have it around 455

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: 2613
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

Online @rjen

  • Support Team
  • *
  • Posts: 3285
    • 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

Testing TP on SMF2.0
Testing TP on SMF2.1 (latest Github)
Want to check what php version I am testing on? See: PHP Info

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: 2613
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: 2613
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: 2613
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.

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #20 on: February 12, 2022, 08:31:02 PM »
I restored the database from a backup which was made before upgrading to SMF 2.1.1
I have been able to install TP 2.1.0 but have lost the last few posts because of that. Otherwise things seem to be in order.

SMF 2.1 RC4 (default theme) / TP 2.1.0

Online @rjen

  • Support Team
  • *
  • Posts: 3285
    • FJR-club Nederland
Re: TinyPortal 2.2.0
« Reply #21 on: February 13, 2022, 12:01:36 AM »
And what is the structure of the tp_blocks table now?
Running Latest TP on SMF2.1 at: www.fjr-club.nl

Testing TP on SMF2.0
Testing TP on SMF2.1 (latest Github)
Want to check what php version I am testing on? See: PHP Info

Offline Skb

  • Full Member
  • ***
  • Posts: 128
    • Metabolically Challenged
Re: TinyPortal 2.2.0
« Reply #22 on: February 13, 2022, 02:06:13 AM »
Now it is this

SMF 2.1 RC4 (default theme) / TP 2.1.0

Online @rjen

  • Support Team
  • *
  • Posts: 3285
    • FJR-club Nederland
Re: TinyPortal 2.2.0
« Reply #23 on: February 13, 2022, 02:29:03 AM »
The table is as it should be now, I do not see any reason for issues atm
Running Latest TP on SMF2.1 at: www.fjr-club.nl

Testing TP on SMF2.0
Testing TP on SMF2.1 (latest Github)
Want to check what php version I am testing on? See: PHP Info