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.

[@rjen]

Now I am not sure what your current issue is. In the first message you mentioned an issue with a database column, now you are mentioning that the package cannot be installed

"either it was not for this version or corrupted"

Those are two completely different issues.

Please tell me exactly what error it is you are trying to solve.


At this time I understand this:
- You are on 2.1.4
- TinyPortal is not installed, but in the table tp_settings you see version 2.0.0 (this means that was the last TP version installed by the way)

Now I suspect I know where this weird problem may come from: at some point in time it seems you have 'downgraded' TinyPortal to version 2.0. which may have laft the TinyPortal tables in an incorrect state.

Mind you: this would NOT explain the installer givign you this message: "either it was not for this version or corrupted"
That message indicates something is wrong with the package itself..

There are two ways forward:
1. Start TinyPortal from scratch

You will need to drop all tp_tables from the database ans install TinyPortal 3.0.1. This way you will lose ALL existing articles and blocks and you have a clean install

2. You will have to make corrections to database tables

It may be that by changing the version in the tp_settings table the installer will correctly install again.


I am trying to help here, but tbh with conflicting messages and multiple days delays between replies it is hard for me to understand and help...

[darkangel]

I know and I am sorry, I thought that maybe part of the reason was the multiple tries to install it so on the server, since in packages there exists nothing TP for installing, I removed all folders that used to be tp.

Since our main usage of TP is for the blocks and the contents of them. I hope that makes sense, we have not used articles and such.

Not touched DB hoping to get the error again...attached is the error

I will go and get rid of the tables for TP and hope it lets me install. Oh by the way before when I got the error it said it was line 924 so this line # may be due to all files/folder for TP have been deleted from the server.

[@rjen]

If you drop all tp_ tables while TinyPortal is not installed, you effectively remove all off TinyPortal leaving you with a clean database and code (TP wise)

From there version 3.0.1 should install without errors

[darkangel]

YAY!!! I deleted the tables and then installed 3.0.1c and it installed without a hitch. Now I just need to recreate my stuff from before. Thanks guys, I can always count onn you all not getting frustrated or mad at my questions.

[@rjen]

marked solved...