Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
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

Last edited by Morgan; 07/06/2021 4:36 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
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


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
Found out that if I disable the portal page the forum works but if I enable portal page again it does not..
Strange indeed


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,102
Likes: 76
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,102
Likes: 76
Originally Posted by Morgan
- Server shutdown in progress
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)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
Giz
Did you see the comment after regarding the portal page enabling/disabling?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,102
Likes: 76
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,102
Likes: 76
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
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


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,387
Likes: 53
Offline
Joined: Dec 2003
Posts: 6,387
Likes: 53
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.

Last edited by Ruben; 07/07/2021 4:23 PM. Reason: Added Comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
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


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 911
Likes: 23
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 911
Likes: 23
Oh I have tried and cleared cache without any luck until I turned off the portal page


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,387
Likes: 53
Offline
Joined: Dec 2003
Posts: 6,387
Likes: 53
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: Morgan
Joined: Dec 2003
Posts: 6,387
Likes: 53
Offline
Joined: Dec 2003
Posts: 6,387
Likes: 53
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.

Last edited by Ruben; 07/23/2021 3:24 PM. Reason: Added Comment.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Better moderator notification answer
by Morgan - 07/24/2021 7:29 AM
well this sucks..
by Bad Frog - 07/21/2021 6:15 PM
What does it mean?
by Morgan - 07/14/2021 3:21 AM
Look for advice. Forum doesn’t load properly.
by Morgan - 07/06/2021 4:31 AM
Who's Online Now
0 members (), 49 guests, and 92 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5