TinyPortal 2.2.0

[@rjen]

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

[Skb]

Getting this error when trying to install. New install of SMF 2.1.1

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

[Skb]

This is the code around line 912

Code Select Expand

$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}',

[Skb]

From the error log

$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

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

[tino]

What version of php, MySQL and TinyPortal (previous one)?

[Skb]

PHP - 7.4
MySQL - 5.7
TinyPortal - 2.1.0 (previous one)

[tino]

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.

[Skb]

Maybe I'll go in for a fresh install of SMF instead of upgrade. Will revert.

[tino]

Getting this error when trying to install. New install of SMF 2.1.1

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.

[tino]

This is the code around line 912

Code Select Expand

$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