Error installing TinyPortal

[Marius]

Good morning everyone.

I recently uninstalled TinyPortal 2.3.0 because it was obsolete but when installing the newer 3.0.2 it gives the following error...

How can I solve it? Thanks.

Link to my forum: https://www.mysite.it/forum/index.php (sorry for the privacy)
SMF version: 2.1.14
TP version: 3.0.2
Default Forum Language: Italian
Theme name and version: Theme name here SMF Default Theme - Curve2
Browser Name and Version: Chrome 136.0.7103.114 
Mods installed: Curve2 Color, Changer Ad Management, Google Analytics, Code Ultimate Menu, SMF 2.1.4 Update
Related Error messages: File: /web/htdocs/www.mysite.it/home/forum/Packages/temp/install.php
Linea: 983

[@rjen]

Sorry, I cannot help you right now. Out of the country on holiday. Perhaps someone else will reply .

[Marius]

Hi @rjen, I'll wait patiently.

[lurkalot]

I would try and help, but if I'm honest I'm not sure why it's happening. 

I do however remember there was a problem installing the previous version TP 2.3.0 in SMF 2.1.3 and there was a fix packages mod that had to be installed prior to installing it.  This mod had to be uninstalled before upgrading to SMF 2.1.4

[Marius]

Hello lurkalot. Yes I uninstalled the patch but I don't remember if before or after the update to SMF 2.1.4.

The error message is this...

Duplicate column name 'display'
File: /web/htdocs/www.mysite.it/home/forum/Packages/temp/install.php
Line: 983

Line 983 is this...

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

What does this mean! How can I fix it!

[lurkalot]

Not sure tbh.  But it does sound very much like these problems that someone was having on two occasions. 

https://www.tinyportal.net/index.php?topic=37002.0

and more recently here,

https://www.tinyportal.net/index.php?topic=36961.0

[@rjen]

Just an fyi. The error is happening when the upgrader is trying to create an index on the articles table and the subject column is missing.

It seems your TinyPortal tables are not correct somehow.

First question is how you uninstalled your old install?
Something seems very wrong.

Next question is to use phpmyadmin and check the tp_articles table.
I would like to see the definition af the table and the contents.

[Marius]

Thanks everyone for the help, I deleted the display field and everything is back to normal.

[@rjen]

Then I misread you message earlier. Good you got it fixed. I'll mark this solved