Block display on certain boards not working after upgrade

[riomargroup]

Link to my site: broken https://54.85.222.211 working https://forums.poz.com
SMF version: 2.0.14
TP version: 1.3
Default Forum Language: English
Theme name and version: Theme name here
Browser Name and Version: Chrome 62
Mods installed: reCAPTCHA for SMF, Stop Spammer
Related Error messages: Block per-forum display restrictions are not being applied

Greetings,

I am migrating our site to a new host. I transferred the files and MySQL and then went and upgraded SMF & TP to the newest version (we were on SMF2.07 and TP1.107). Everything seems to be fine, but TinyPortal block display controls seem to not be functioning properly.

Certain blocks - welcome messages, advertising etc, are only supposed to display on certain forums. These restrictions do not seem to be taking place. The most obvious of these is the four advertising blocks under the login panel on the left side. Only one should be displayed. There are total four blocks, but they only are set to display one at a time depending on the forum.

How can I troubleshoot this issue?

Thank you.

[lurkalot]

Link to my site: broken https://54.85.222.211 working https://forums.poz.com
SMF version: 2.0.14
TP version: 1.3
Default Forum Language: English
Theme name and version: Theme name here
Browser Name and Version: Chrome 62
Mods installed: reCAPTCHA for SMF, Stop Spammer
Related Error messages: Block per-forum display restrictions are not being applied

Greetings,

I am migrating our site to a new host. I transferred the files and MySQL and then went and upgraded SMF & TP to the newest version (we were on SMF2.07 and TP1.107). Everything seems to be fine, but TinyPortal block display controls seem to not be functioning properly.

Certain blocks - welcome messages, advertising etc, are only supposed to display on certain forums. These restrictions do not seem to be taking place. The most obvious of these is the four advertising blocks under the login panel on the left side. Only one should be displayed. There are total four blocks, but they only are set to display one at a time depending on the forum.

How can I troubleshoot this issue?

Thank you.

Strange one, not seen this before. Are the block settings all correct for each block when you look at them? Or have they changed for some reason?

[riomargroup]

I've gone over every option and check box. They are identical from the old, working site and the new, busted one. I can't figure it out.

[lurkalot]

I've gone over every option and check box. They are identical from the old, working site and the new, busted one. I can't figure it out.

Ok, thanks.  Could you try recreating one of those blocks and see if it responds to the settings you give it. 

[riomargroup]

I did try that. Had two chrome windows side by side - one old site, one new site. I duplicated everything by hand, and still no luck. It gave me an error "var3" has no default value, so I applied the my.cnf 'sql_mode = ""' fix, and the error went away.

[lurkalot]

I did try that. Had two chrome windows side by side - one old site, one new site. I duplicated everything by hand, and still no luck. It gave me an error "var3" has no default value, so I applied the my.cnf 'sql_mode = ""' fix, and the error went away.

Really not sure what happened to your test install tbh, as I haven't seen this happen either when moving to new host, or when making clone of my sites for testing.

How did you upgrade Tinyportal, did you uninstall the old one and install the latest version, or did you install over the top?

[riomargroup]

I installed the new mod over top, then deleted the old one.

I even fully uninstalled TP and did a fresh install. The only thing I can think of I haven't tried is a fresh TP install with a fresh mysql import of the TP database.

[lurkalot]

I installed the new mod over top, then deleted the old one.

I even fully uninstalled TP and did a fresh install. The only thing I can think of I haven't tried is a fresh TP install with a fresh mysql import of the TP database.

OK, that'll likely be the problem.  The last couple of versions of TP have no been upgrade version, in other words the old one must be uninstalled before installing the new one.  I guess you have some stuff doubled up somewhere.  You should have seen a warning on install about uninstalling the older versions first.

[riomargroup]

I don't remember a warning, but that definately doesn't mean there wasn't one. I'll try this out.

[lurkalot]

I don't remember a warning, but that definately doesn't mean there wasn't one. I'll try this out.

Should be, a warning in the package manager.  But I think that's what the problem is with your blocks etc, it must have doubled something up somewhere, database or files.  Might be wise to re-clone it, and then uninstall TP, then install new TP

[riomargroup]

Uninstalled TP
Deleted TP files
Deleted all TP tables from mysql
Download TP fresh from, well, here
Installed TP
Imported mysql freshly dumped from live site
Same problem

Is there any log file or something I can offer to help?

[lurkalot]

Uninstalled TP
Deleted TP files
Deleted all TP tables from mysql
Download TP fresh from, well, here
Installed TP
Imported mysql freshly dumped from live site
Same problem

Is there any log file or something I can offer to help?

Ok, something doesn't sound right there. So to be sure,

1: Copy files from live site to test site
2: Create a blank (empty) database and give it a different name from your live one.
3: Import copy of live database in to new one.
4: Make sure testsite is looking at you new database by changing it in the Settings.php file
5: Run repair_settings.php

Make sure all is working. 

6: Uninstall Tinportal
7: Install new version Tinyportal

See if it all works as expected.

[riomargroup]

This is what I've done.

1. Create new vm
2. copy files from live site to new site
3. import database from mysqldump of old site
4. Settings.php points to correct database
5. Ran repair_settings.php The only thing it didn't have was SSI username, but it said that was optional.
6. Uninstall Tinyportal
7. Deleted all smf_tp tables from the SM database.
8. Install TinyPortal
9. Import smf_tp tables from live database

[lurkalot]

This is what I've done.

1. Create new vm
2. copy files from live site to new site
3. import database from mysqldump of old site
4. Settings.php points to correct database
5. Ran repair_settings.php The only thing it didn't have was SSI username, but it said that was optional.
6. Uninstall Tinyportal
7. Deleted all smf_tp tables from the SM database.
8. Install TinyPortal
9. Import smf_tp tables from live database

OK, I must not have read your original question correctly, or I don't understand.

I thought you were moving your live site to new host, and basically the exact same database content and files from your original live site to what will be your new live site.  If that's the case then there's no need for step 9 because you already imported those tables when you imported the database step 3, that should already contain the all the tables required.

[riomargroup]

I'm sorry, I must have explained improperly.

I originally did what only what said (Steps 1-5). Step 5.5 is upgrading to current SMF and TP - you said in-place TP upgrades tend not to go well, so I removed TP as much as possible (steps 6, 7 & and then added it in via a "clean install" - step 9.

[lurkalot]

I'm sorry, I must have explained improperly.

I originally did what only what said (Steps 1-5). Step 5.5 is upgrading to current SMF and TP - you said in-place TP upgrades tend not to go well, so I removed TP as much as possible (steps 6, 7 & and then added it in via a "clean install" - step 9.

Strange.  You shouldn't have to touch the database to uninstall TP, Just uninstall old TP via package manager, and install new TP.  Really not sure what's happening, but I've done this many times without having the problem you are having.

[riomargroup]

Here's one to really drive you mad:

I just deleted one of the offending blocks that wouldn't properly follow the display rules. I then manually re-entered it, copying the setting directly from the working site, double checking every button and setting. Doesn't work.

[lurkalot]

OK, is a strange scenario I agree, but as I haven't seen this on any other site using TP, and haven't had reports of this problem I'm still convinced the problem is with your setup.  Also you know it works because your live site works ok.

Unless anyone else on the team has any ideas, then all I can say is you need to check your test site again.

[riomargroup]

My next attempt will be installing SMF & TP from scratch. I will report back.