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

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