TinyPortal 2.2.0

[Skb]

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

This is the code in the line 

[tino]

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

This is the code in the line

What I think has happened is you installed TinyPortal 2.x.x then went back to TinyPortal 1.6.x (or similar)

[Skb]

I did a fresh SMF install and I still have the same problem. I cannot install TP. I think TP is having some issue with the database as I had reported here

The database value you're trying to insert does not exist: access2
Function: require

[@rjen]

Looking back it, I think you have broken your install previously. Can you give me the structure of tp_blocks?

[Skb]

Looking back it, I think you have broken your install previously. Can you give me the structure of tp_blocks?

I think you are right. What exactly do you mean 'structure of tp_blocks'. I removed latest version and tried installing 1.6.2 onwards but I still get this problem.

[tino]

I did a fresh SMF install and I still have the same problem. I cannot install TP. I think TP is having some issue with the database as I had reported here

The database value you're trying to insert does not exist: access2
Function: require

Do you mean a completely empty database with no TinyPortal tables? As this shouldn't happen, and is what I tested. Which works.

[Skb]

No database is the same one only the install is full install not upgrade.

[tino]

No database is the same one only the install is full install not upgrade.

Then we need to see the structure of the database. Which can be viewed by phpMyAdmin.

It should be noted, and we are quite explicit. Going back from TinyPortal 2.x.x to TinyPortal 1.x.x will cause issues. This is one of them. You are going to have to manually correct your database.

[Skb]

Is this what you need to see.

[tino]

Yes, it should look like the attached screenshot.

There are other things likely to be broken also, which I can't remember at the moment.