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

[@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.