Hi we are experiencing problems with the forum
Two days when the site was down showing error 522 and possible 524.
Our host said it was a MySQL problem so they ran a repair and possibly restarted it.
Beware I hade previously week upgraded from MySQL 5.6 to 5.7 and I wonder after reading the last line in yesterdays error log
it reads
LIMIT 25 - Server shutdown in progress do you see any problems with this? What does LIMIT 25 stands for?
Today I also have experienced about same problems but not reported it yet to my host.
Any Ideas with this info?
Thanks
Script: /xxxx/xxxxx/xxxxx/xxxx/scripts/showflat.inc.php - Line: 651
SELECT
p.POST_ID, u.USER_DISPLAY_NAME, u.USER_IS_BANNED, p.POST_POSTED_TIME, p.POST_POSTER_IP,
p.POST_SUBJECT, p.POST_BODY, p.POST_IS_APPROVED, up.USER_AVATAR, up.USER_TITLE,
up.USER_CUSTOM_TITLE, up.USER_NAME_COLOR, p.POST_ICON, p.POST_HAS_POLL,
p.POST_HAS_FILE, p.POST_PARENT_ID, u.USER_MEMBERSHIP_LEVEL, up.USER_SIGNATURE,
p.POST_LAST_EDITED_TIME, p.POST_LAST_EDIT_REASON, p.POST_LAST_EDITED_BY,
up.USER_LOCATION, up.USER_TOTAL_POSTS, u.USER_REGISTERED_ON, up.USER_RATING, up.USER_LIKES,
up.USER_AVATAR_WIDTH, up.USER_AVATAR_HEIGHT, u.USER_ID, p.POST_PARENT_USER_ID,
up.USER_BIRTHDAY, up.USER_PUBLIC_BIRTHDAY, p.POST_ADD_SIGNATURE, up.USER_ACCEPT_PM,
up.USER_HOMEPAGE, up.USER_VISIBLE_ONLINE_STATUS, up.USER_MOOD, p.POST_POSTER_NAME,up.USER_GROUP_IMAGES
FROM
ubbt_POSTS AS p USE INDEX (indx_2),
ubbt_USERS AS u,
ubbt_USER_PROFILE AS up
WHERE
p.POST_ID = 584663
AND p.POST_IS_APPROVED = 1
AND p.USER_ID = u.USER_ID
AND p.USER_ID = up.USER_ID
ORDER BY
p.POST_ID
LIMIT 25 - Server shutdown in progress
