News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Theme Access Issues Since Update to 2.0.17

Started by WantSome, December 31, 2019, 03:27:54 PM

Previous topic - Next topic

WantSome

Hello,

Today I updated from 2.0.15 through 2.0.16 and now .17.

I can't seem to access the theme options anywhere - in my profile I tried to go and select a different theme, and then in Admin Panel when I try to access the theme options and features, both ways I get a HTTP 500 error.

The theme I am using is Nova and it no longer appears in the themes site and I can't reply to the support topic.  There is an error on my error log referring to the theme files which is how I discovered this all.  I was hoping to check other themes to see if the error persists there but I can't access the themes options to change mine or anyone else's theme at the moment.

Incidentally, the Nova theme's copywrite information now links to gambling websites so I'm assuming it is no longer supported, the people who made it are no longer active, and I'd rather not be using it if that is the case. 

Any help appreciated.

WS

Illori

check your server error log, once you find the error please post it here so we can assist you in resolving the issue.

WantSome

I've just checked the error log and wow.

It seems somewhere I have introduced a www redirect (or taken it away?  I'm not sure).  Here is a selection of the errors, by no means all of them.

http://www.wantsome.co.uk/forum/index.php?wwwRedirect
8: Undefined index: language
File: /forum/Sources/Subs.php
Line: 4069

http://www.wantsome.co.uk/forum/index.php?wwwRedirect
8: Undefined index: groups
File: /forum/Sources/Subs.php
Line: 4069

http://www.wantsome.co.uk/forum/index.php?wwwRedirect
8: Undefined index: total_time_logged_in
File: /forum/Sources/Subs.php
Line: 3400

http://www.wantsome.co.uk/forum/index.php?wwwRedirect
8: Undefined index: total_time_logged_in
File: /forum/Sources/Subs.php
Line: 3399

http://www.wantsome.co.uk/forum/index.php?wwwRedirect
8: Undefined index: avatar
File: /forum/Sources/Subs.php
Line: 3390

I attach my subs.php file here - do you think this could be the reason for being unable to access themes?


dodos26

The problem is probably not with the subs at least at a glance

WantSome


shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

WantSome

Nope.

I used it long ago but have long since removed it.


Sir Osis of Liver

Pretty urls doesn't uninstall cleanly, it may have left something behind that's causing problems after upgrade.  If you revert to 2.0.15 do the errors stop?
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

WantSome

Hi Sir Osis,

I have just cleared the error log and the errors did not come back again.  I went back to 2.0.15 and 2.0.17 and clicked around, and the error log remains blank.  This may be to do with changing the php version as anything more than 5.5 has caused major session time errors on my forum.

HOWEVER, there are still a few areas that I can't access.  Trying to access these areas does not appear to produce an error in the error log.

1. As with the opening post on this thread, anything to do with themes regardless of the url containing or not containing www - I can't change the theme at all for anyone.  I get an HTTP ERROR 500

2. Profile notifications - on the main menu if I hover over profile I get a drop down menu and click on notifications, I get an error "The user whose profile you are trying to view does not exist on the forum."  It appears as if I am not logged in and the url does not have the www prefix.
However if I click on profile, then hover over modify profile then go to notifications that way it works.  Notifications is the only item on the drop down menu that doesn't work.

These issues persist regardless of the version I am emulating.

Sir Osis of Liver

Do you have a .htaccess file in forum root?  Does it contain pretty urls code?
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Kindred

Sir Osis -- Please stop trying to blame PrettyUrls for every issue in a forum.

Nothing in the original post suggests ANY interaction with goodly or badly configured PrettyUrls.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Sir Osis of Liver

The problems he describes I've seen on forums that were damaged by pretty urls, and he did have the mod installed at one time.  It's something to check if only to eliminate it as a possible cause.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

WantSome

It appears my .htaccess file does still contain the pretty urls code.  I have removed it now.

However the original issue still exists.  I can't access themes anywhere on the forum.


On the .htaccess file it has this segment
RewriteRule ^forum\/?$ "http\:\/\/www\.wantsome\.co\.uk\/" [R=301,L]

could that have something to do with the www. redirect errors I was getting?



Sir Osis of Liver

Remove or rename .htaccess (keep a backup copy), see if that helps. Do you have a redirect set for that domain in cpanel?  Don't see why upgrading to .17 should cause this.  Which php version are you currently running?

"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

WantSome

I have cleared the pretty urls code from the .htaccess files.  I am still getting loads of various errors on my error log, mostly to do with failed logins and session issues.   

I have another php related support thread here https://www.simplemachines.org/community/index.php?topic=571085.msg4041874#msg4041874 - I have not responded to this yet as I was waiting for my host to help me (which happened last night but I am still having issues so that is not yet resolved).

I was running php 5.6 when I updated to smf 2.0.17.  I switched to php 7.2 as that is now compatible, and my wordpress main site doesn't work on 5.6 so I was very happy 2.0.16/7 would have this functionality supported.  Up until this I had a redirect which pointed the main site to the portal page on the forum.  I am not really using the main site / blog so don't mind that it redirects permanently to the forum.

Upon switching to 7.2 I had a session time failures and raised the above referenced query.  Based on that advice I have contacted my host and, I don't know what they did, but they have switched me to 7.2 and I have been able to navigate the forum without the bulk of the session time failures EXCEPT I can't access the admin panel (it asks me to log in and gives me a session time issue repeatedly) or any theme options (which gives me an http 500 error).

So I switched back to 5.6 which allows me to access the admin panel but still does not allow access to any theme areas.  Also this requires the redirect of the main site back to the portal page.

I feel a bit stuck, guys.  :-(


WantSome

Sorry for double posting.

Would it help if I run repair settings maybe?

Sir Osis of Liver

Quote from: WantSome on January 07, 2020, 10:37:01 AM
Would it help if I run repair settings maybe?

Probably not, but wouldn't hurt to try.  I would set up a clone, new install, import production database, play with it there.  You might just need to upload a clean set of files.  AFAIK there shouldn't be any problems patching .15 -> .16 -> .17 in php 5.6.  It is odd, though, that juggling php versions has some effect.  Any mods installed?

"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

WantSome

I do have quite a few mods installed, now that I look at the list, it seems a huge amount

SMF Articles   3.0.3a
Real Popup with AdBlock Detection   1.7
Log Karma Actions   3.0
SMF Ajax Chat   1.0.1
SimplePortal   2.3.7   
Drafts   1.2
Ohara YouTube Embed   1.2.5
Dice Roller BBcode   1.3
Bookmarks   2.5
YandexGarland   1.2
View Only Boards   1.2c
SMF 2.0.11 Update   1.0
@mention members   1.1.2   
notCaptcha   1.06
Peoplesign   1.6
SMFShop   3.3.1
Pretty URLs Reverter   1.0
Member Awards   2.2.3   
Tagging System   2.4.3
SMF Gallery Lite   3.1.1
Change All Subjects   1.1.2
Ad Managment   3.0.1   
Signature Area BBCode Buttons   2.0.2   
SMF 2.0.1 Update   1.0
6 Custom buttons / tabs with Sub Menus (4)   0.5
Spoiler BBCode   1.1.3
Display Signatures Only Once Per Page   1.0.3

WantSome

Another double posting. 

I have found another area of the forum that doesn't work.  I went to read my personal messages and tried to sort them by sender.  I got this error message:

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'wnsecmxs_smf1.mem.real_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /forum/Sources/PersonalMessage.php
Line: 702

Not sure if this is related.  I am still on php 5.6

Shambles

Quote from: WantSome on January 08, 2020, 03:18:38 PM
I have found another area of the forum that doesn't work.  I went to read my personal messages and tried to sort them by sender.  I got this error message:

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'wnsecmxs_smf1.mem.real_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /forum/Sources/PersonalMessage.php
Line: 702

Not sure if this is related.  I am still on php 5.6
This is to do with the strictness of your mysql server setup.

You could ask your host to reduce the restriction by removing the ONLY_FULL_GROUP_BY mode, but as that's a whole-server setting I doubt they'd oblige as it affects everyone using mysql on that server.

Instead, you could insert a bit of code into PersonalMessage.php that temporarily removes that restriction from your mysql session. I wrote something recently that does this and it works perfectly. Let me know if you'd like a copy.

Sir Osis of Liver

Set up a clone - clean install, new database, in a different directory.  Import your production database, run repair_settings, see how it works.  You'll probably have to upload a clean set of files at some point, and reinstall mods.  There are too many things wrong with your forum to waste a lot of effort trying to nitpick fixes.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Advertisement: