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:

[@rjen]

Hmm, the access2 column should not be there anymore. Can you also paste the CONTENT of the table?

[darkangel]

content?

of the access2 column or
the actual db file with this section or

here is the first page of that same area of DB
You cannot view this attachment.


I forgot to mention that the installer lists it in the contents to install into smf 2.1.4 and I had to delete all from the server when I did it...including the database, I think

[@rjen]

I cannot read the attachment. What I want to know is, if the content of the access2 and display columns is the same.

If that is the case you can drop the access2 column, which should fix the error.

Before you do so, make a download to sql for all tp_ tables in the database, so you can restore the contents should something go wrong

[darkangel]

I just checked the install.php for 3.0.2 and on line 983 access2 is mentioned

Seems the 2.0 .0 installer for TP installed access2

[@rjen]

That is not an answer to the question

[@rjen]

What I want to know is, if the content of the access2 and display columns is the same.

[darkangel]

aha, no the contents of the display column are the "ingredients " of all the boards and places in the forum where the one I sent you is the items of the tables in the TP area

[@rjen]

I KNOW what the contents of the columns means.

What I want you to tell me is, if both columns in the table have the same values for the blocks. This would indicate that the rename action has only partially completed. As long as you do not provide the actual content of the table I cannot help you...

[darkangel]

whoa nellie! hope you aren't irritated cause I can get that way too.

I just told you that the db shows the column of display as being the names of the forum areas [matching what the forum has]
colum of access 2 is the names of the blocks

this is from the db of the tables:



if this still is not what you want I am so sorry

[@rjen]

I am really trying to help you, but once again you are not answering my questions.

Let me try again:
I need to know the contents of those columns in tp_blocks table. You are sharing the tablestructure and not the tablecontents.

You cannot view this attachment.

Based on the structure I already saw that the table contains two columns that should not really be there: 'access2' and 'editgroups' are not supposed to be there.
(How they got there when installing a clean 3.0.0 install beats me, but that is next.)

The upgrader is now trying to rename column access2 to display, which fails because 'display' is already there.
If you show me the contents of the table I can see what you can try next.

You cannot view this attachment.

Either column 'display' is empty  (no values) or it has the same values as column 'access2'. When we know that, we can determine a path forward.

Note: the screenshots are samples from a functioning 3.0.2 install: I need to same the same information from your forum.

[@rjen]

I just checked the installers from TP3.0.0 and up and in none of the codes is there any mention of the creation of tp_blocks table with the fields access2 and editgroups.

These columns were last used in Tinyportal in version 2.2.0 and dropped 5 years ago.

The only explanation I have for those columns being in your table is that, after you did a clean install of TP 3.0.0 you imported the table into the database from an old install (with TP version 2.2.0). If that is indeed the case then you can simply drop the columns access2 and editgroups from the tp_blocks table, because they are no longer used.
After that the install should run without errors (at least if there are no othet tables affected).

I understand why you would do such a thing to restore settings after the issue you had in November, but the result would be that the table is in an incorrect state.

[darkangel]

ok,more pictures of the entire page cause to me they look alike, sorry


You cannot view this attachment.      You cannot view this attachment.      You cannot view this attachment.


How this happened is beyond me and yes I think that I uploaded the db for the tp in the beginning.If need be I will redo the entire reinstallation of the 3.0.0 or the latest upgrade zip fresh.

[@rjen]

This is what I suspected: when you uploaded the TP database you broke the tables, because you uploaded a 2.0.0 database into a 3.0 install.

FYI: The version change from 2 to 3 indicates a major upgrade with database changes... you should never upload database tables across major versions, as you are now clearly finding out...

Looking at the data you posted it seems you have a mixed set of data:
the data in column 'settings' indicates that you are looking at a table of version 2.0.0. But the existing column 'display' indicates that this tabel has been at 3.0 level before..

Instead of starting new you can try this:
1. Drop column "Display"from the table
2. Then try to install TP 3.0.2 again.

The upgrader should then run and convert the table.

[darkangel]

If I could kick my own fanny I would. I thought that it would be fine since that is how mostly was done to not have to enter all by hand again.

I will try that and see what happens.

drop display column and leave access2 in place?

[@rjen]

Yep, the upgrader will drop access2 and should take care of the other updates

[darkangel]

ok, did as requested, put in 3.0.2 and thar be portal again with all appearing to be as usual. Thank you so very much.

I clicked the install button, it just went lickety split didn't even show me files or anythig and as I said ty ty ty

[@rjen]

marking solved then

[darkangel]

oops forgot to do that.

the only thing that it did do when doing this is that some of my blocks with images in them came out double as the front page block...fixed it though.

another thing about the blocks....I used to be able to add a color tag time to time in the title bar of the block...or even the forum's name area or within the text area which with these newer versions we can't. Is that a TP thing or An SMF thing/

[@rjen]

I think we are now sanitising the title fields to prevent issues.