tp: none for now error installing update and now won't reinstall old on

[darkangel]

https://www.thefantasesattic.net/forum
smf: 2.1.4

Code Select Expand

Database Error
Duplicate column name 'display'
File: /thefantasiesattic/attic/Packages/temp/install.php
Line: 983


offending line:

Code Select Expand

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

[@rjen]

Please describe what you are trying to do, and what steps you took te get here....

[darkangel]

1. uninstalled last version
2. uploaded this version
3. clicked to install this version
4. got the error
5. deleted it
6. tried to reinstall the previous version
7. checked DB and there is no duplicate only the original access2 and other parts of that table.

it no wanna and still gave the error message. I dont wish to lose all the info for the TP.

[@rjen]

What version did you have before?
What error message?
What version are you trying to install?

Latest and previous version is not specific enough

[darkangel]

omg where did the info go? I did write it in there been a member lng enough to know better...here is the runaway info:


Link: https://www.thefantasiesattic.net/attic/index.php?action=forum
however that won't come up since no  TP behaving so https://www.thefantasiesattic.net/attic/index.php for now
SMF: 2.1.4
TP version: none right now but it was 3.0.0
Default Forum Language: English
Theme name and version: DarkModern214b
Browser Name and Version:  Firefox 137.02
Mods installed:
1. Forum Width Setting 1.2
2. SMF Staff Page 2.1
3. ArantorSidebar 1.0.1
4 Enhanced Quick Reply 1.0.3
5. Stop Forum Spam 1.5.6
6. SMF-Snowflakes 1.85
7. TinyPortal 3.0.1
8. Contact Page 7.1
9. TinyPortal 3.0.0 uninstalled for now
10. SCEditor Max Height 1.0.1
11. Separate the Sticky Topics 1.0.1
12. Mod Version Checker 1.1
13. Join Reason 3.0.0
14. Simple Audio Video Embedder 7.0.6


Is this not like before where we uninstall the previous version, and it leaves the stuff behind then install the upgrade and it reads/inserts the info?

um another stupid question, I seem to have the 3.0.1c version should it be the 3.0.2 version?

just tried 3.0.2 and get the same error, should I just go ahead and delete the tables? then readd the info to database

[@rjen]

So you had 3.0.0 running and tried to install 3.0.1?

When did you get the error?

And what was it?

[darkangel]

yes had 3.0.0 and it worked as it should

uninstalled it then ran the 3.0.1c version and now tried the 3.0.0 and .02 getting the same error  Post #1


Code Select

Code Select Expand

Database Error
Duplicate column name 'display'
File: /thefantasiesattic/attic/Packages/temp/install.php
Line: 983

offending line:
Code Select

Code Select Expand

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

I get the error after clicking the install button when list of "ingredients" are shown.Members are totally lost  LOL

[lurkalot]

yes had 3.0.0 and it worked as it should

uninstalled it then ran the 3.0.1c version and now tried the 3.0.0 and .02 getting the same error  Post #1

  Am I missing something here.  Only in this topic from November where you were getting the same error, you said you had managed to get TP 3.0.1c installed https://www.tinyportal.net/index.php?topic=36961.msg304550#msg304550

[@rjen]

it appears the upgrader is trying to rename an old column to a new column where that name already exists to the tp_blocks table.

This is really not possible in normal operation, so something went pretty wrong...

You may have to access the table in PHPmyadmin.

Can you check the tp_blocks table and post a screenshot of all columns and content?

[darkangel]

back in Nov was when I tried upgrading smf and all to the latest PHP8.0 or 8.1 and yes I had to delete the tables totally.


now I hav been using smf 2.1.4, all new install with TP also being new from installs too and it updated to 3.0 finally. This time I did the same as usual....uninstalled the older version of TP, uploaded the upgrade which I thought was the lates .01c only to find that 3.0.2 is available. sooooo I tried installing it too and still get the eroor that the database already has that table.

I will come in with the info from the DB in a mo.

here is screenshot: