UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Look for advice. Forum doesn’t load properly.

Hi
I’m looking for advice,
I’m away with only a phone in my hand visiting granddaughter for the first time in +six months.
At least two days ago our forum started to become slow and not respond properly.
Timeout error, no connection messages, max amount of connections etc. Sometimes it work sometimes not.
I opened a support ticket at my 5 slices and two cores VPS host.
The replied that I had some old configurations so they updated and increase storage and memory which was good.
I used the ubbt_test.php and alerted possible problem with 120 max_execute_time so I reduced 60. When I got message of to many connections Host changed value from 151 to 512.

Still same problems.

Have anyone of you experienced these problems ?
I’m thankful for any advice.
Forum is located at
www.Britbike.com/forums
Ps have not changed anything prior to the problems.
The rest of the website works fine it’s as fast as it should be

Info
Have one error log with lots of this type of messages

Script: /XX/xxxx/xxccc/xxxx/libs/user.inc.php - Line: 447
SELECT
USER_IGNORE_LIST, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED, t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_TOTAL_POSTS, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN, t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET, t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF, t2.USER_GROUP_IMAGES, t2.USER_TIME_FORMAT, t2.USER_LOCATION
FROM
ubbt_USERS AS t1,
ubbt_USER_PROFILE AS t2
WHERE
t1.USER_ID = 0
AND t1.USER_ID = t2.USER_ID
- Server shutdown in progress

Found out that if I disable the portal page the forum works but if I enable portal page again it does not..
Strange indeed

The error logs are pretty straightforward, you have the database query that failed followed by the error message. In this case it would seem that your database server was being restarted while the query was being executed. (Just Googled the error)

Giz
Did you see the comment after regarding the portal page enabling/disabling?

Is the portal page modified at all? In it's stock state this page is a very simple database query that checks for entries in forms marked as news forms.

I'm assuming you've been using the same portal setup for years, I'd be interested in knowing what kind of server maintenance or updates have been recently applied.

No no its not modified
I have both left and right column activated

With some islands that have been there for a long time

I am on away from home so connected to a WiFi I normally don’t use and I’m also off WiFi

According to our members it started before I went away from home.

As long as it works for now with portal page disabled I’m not doing anything until I get home next Tuesday

I can't for the life of me see why.
See if you have the following two items both checked:

Only Show Left Column On The Portal

Only Show Right Column On The Portal
I did this myself once and broke the site.
When you say activated they should be off if you want both left and right to display.
I think this was fixed in a newer version.

There is nothing special except for say:

Forums To Pull News From
Or
Portal Cache Settings

Maybe you have a bad post in a forum you are pulling from
or your cache time is corrupted to like 0 minutes.

Ruben
Only show right side portal is ticked not the left
Cache is set to 90 min
Portal page is not enabled now I will keep as is until I get home next week.

Portal page has been enabled for a year without previous problems

Oh I have tried and cleared cache without any luck until I turned off the portal page

Hold on.
I think there is something amiss with the portal.
At least in V7.7.5
Reported by my members for the search feature stopped working.
Turned off portal and works again.
Also some portal settings affect the forum not the portal now.
.

Unfortunately my test site is down now because I am replacing drives and re-seeding my desktop.

Okay with just the settings in the portal section I see a issue.
Later I will test to see what is reported to break when enabled.

With:
Enable The Portal - Unchecked.
Only Show Left Column On The Portal - Enabled
Only Show Right Column On The Portal - Disabled.
Forum Summary only displays the right column.

With:
Enable The Portal - Checked.
Only Show Left Column On The Portal - Enabled
Only Show Right Column On The Portal - Disabled.
Forum Summary only displays the right column.
Portal displays both columns.

With:
Enable The Portal - Unchecked.
Only Show Left Column On The Portal - Disabled
Only Show Right Column On The Portal - Enabled .
Forum Summary only displays the left column.

With:
Enable The Portal - Checked.
Only Show Left Column On The Portal - Disabled
Only Show Right Column On The Portal - Enabled .
Forum Summary only displays the left column.
Portal displays both columns.

Also
Allow Members To Turn Off The Left/right Column - Disabled

Looks to me that the language file needs to be addressed for the correct side and that it has nothing to do with the portal enabled or not so far.
But should it not impact the portal only? Not the forum summary since we have settings for that already in another cp area.
Control Panel ->Portal & Islands->Column Layout

If I can ever get my test machine up again I will test for the bugs reported.
New drive went RAW just when I finished up all the installs and settings.