trouble updatig the TP

[darkangel]

OK, bare bones install of  SMF so not many mods yet. I had 2.3.1TP installed, then when it came up that there was a newer version I cme both here and SMF and noticed that when I click on 3.0.0 version it downloads as 3.0.1c

I have tried installing by uninstalling the previous version, and now can't update nor install the older version or 3.0.0 version

I get the following

Code Select Expand

version 2.3.1


Database Error
Duplicate column name 'display'
File: /home/fantasies/public_html/thefantasiesattic/attic/Packages/temp/install.php
Line: 924

version 3.0.0 and 3.0.1
Database Error
Duplicate column name 'display'
File: /home/fantasies/public_html/thefantasiesattic/attic/Packages/temp/install.php
Line: 916
I want my TP back please.

I forgot to tell you the mods I have now:
Enhanced Quick Reply 1.0.3
Stop Forum Spam 1.5.6
Separate the Sticky Topics 1.0.1
Mod Version Checker 1.1

site: https://www.thefantasiesattic.net/attic/index.php


17 yrs and it still gives me problems...LOL

[@rjen]

I am wondering if there is something wrong with your packages.

The install of 2.3.1. could fail on line 924, which is trying to update blocks.. and changing column names...

Code Select Expand

    $smcFunc['db_change_column']('{db_prefix}tp_blocks', 'access2', array( 'name' => 'display', 'type' => 'text', 'default' => ($db_type == 'mysql' ? null : '')));
The installer should not do that if the names are already there. So question is, why is it trying to do that?
How did you uninstall TinyPortal from the last working state?

1. What version did you have?
2. Did you select to uninstall data?
3. Dit you ininstall forst or did you upgrade?

Knowing the steps you took may help finding the cause...


The 3.0 install does not hold that statement on line 916. Therefor I doubt if it is in fact running the 3.0.0 or 3.0.1 install scrtipt...

Code Select Expand

unction articleChanges()
{
global $smcFunc, $render, $db_type;
$smcFunc['db_change_column']('{db_prefix}tp_articles', 'parse', ['name' => 'parse', 'type' => 'smallint', 'size' => 6, 'default' => '0']);
$smcFunc['db_change_column']('{db_prefix}tp_articles', 'ID_THEME', ['name' => 'id_theme', 'type' => 'smallint', 'size' => 6, 'default' => '0']);
$smcFunc['db_change_column']('{db_prefix}tp_articles', 'authorID', ['name' => 'author_id', 'type' => 'int', 'size' => 11, 'default' => '0']);
$smcFunc['db_change_column']('{db_prefix}tp_articles', 'body', ['name' => 'body', 'type' => ($db_type == 'mysql' ? 'longtext' : 'text'), 'default' => ($db_type == 'mysql' ? null : '')]);
$render .= 'Processed column definitions articles table<br>';
}
I have no time tomorrow to look into this, but feel free to provide as much information as possible...

[darkangel]

I started with the 2.3.1 on this freshly installed update from 2.0.19 to 2.1.4

had to emulate 2.1.0 and it installed, it was the only mod installed. Then when I installed a few more I got a message that there was an update to 3.0.1 which I downloaded but at bot there and SMF it gives you 3.0.1c and it won't install no matter what.

I have tried lowering the PHP from PHP8.2 to 8.0 and it just doesn't do it. I am hoping I don't need to remove all mods then try doing the portal first again.

[@rjen]

This is not a php issue or a conflict with mods, it seems the installer is finding a situation it is not ready for.

From what you are reporting it is not clear to me what has happened.
2.3.1 may have something to do with it... there is no reason you should have emulated 2.1.0 to install that.

Need to look into this later...

[@rjen]

First of all : dou you have TinyPortal installed? What version?

Then try this: uninstall that version while NOT removing data

Delete the package in the package manager

Upload latest TP (3.0.1) and try to install that...

[@rjen]

If that does not work, we will need to see the database tables, starting with the version listen in tp_settings table

[darkangel]

Link to my forum: https://www.thefantasiesattic.net/attic/index.php
SMF version: SMF 2.1.4
TP version: TP 2.31-3.0.1c
Default Forum Language: English
Theme name and version: default that came with SMF
Browser Name and Version: Firefox 13.2.01
Mods installed: in image
Related Error messages: either it is  corrupt or not for this version.

Do I need to uninstall everything then reinstall TP like I did the first time. I originally installed TP with no mods at all.

[@rjen]

Why the new topic?

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

[darkangel]

sorry the mind is not in my head lately, I thought I had posted earlier but darn it all----it went hiding on me.


Please lock this one I answered in the other thread.

[darkangel]

I started with smf 2.0.19 I think. Then I upgraded to 2.1.4 due to PHP change. It would not upgrade even with an older one from between the2 versions. It decided that it would not upgrade and that I needed to do a clean install of smf.

Lo and behold I had the new version and it worked. The very first thing I tried to install of TP was 2.3.1 and it worked, I was estatic.

After I. installed a few more mods...I waited a day or so in between uploads and then tried  to hunt down any mods that I used to have for this version.

Sometime during this I got a message that TP had an update to 3.0.1 so I went hunting and found it but when downloading it it sent me 3.0.1c then the headaches began.

I did what I used to do to install mods, I went to the old TP and chose the uninstall button. That went just find but installation trys gabe me either it was not for this version or corrupted.

I even thought [but not did yet] to uninstall everything mod-wise clear cache/cooki for the site andt ry installing TP again.

I forgot that the DB says the version of TP is 2.0.0 but none is installed in admin.