I installed 7.5 last night and today I have a few hundred kbs of MySQL error logs. Also, forum features appear to be intermittently slow.
They are predominately like this... (I guess 95% relate to showprofile.inc.php)
I asked my host if there was any issue with the MySQL server and there isn't. All the other scripts on my site using php/MySQL appear to be ok.
Php Code:
Script: /-----/forums/scripts/showprofile.inc.php - Line: 418
select t2.USER_AVATAR,t2.USER_AVATAR_WIDTH,t2.USER_AVATAR_HEIGHT,t3.USER_DISPLAY_NAME,t3.USER_ID,t4.ONLINE_LAST_ACTIVITY,t2.USER_MOOD
from ubbt_ADDRESS_BOOK as t1
left join ubbt_ONLINE as t4 on t4.USER_ID = t1.USER_ID,
ubbt_USER_PROFILE as t2,
ubbt_USERS as t3
where t1.ADDRESS_ENTRY_USER_ID = 272
and t1.USER_ID = t2.USER_ID
and t2.USER_ID = t3.USER_ID
- Lost connection to MySQL server during query
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Even though your host states no problem. I would be highly suspicious of "Lost connection to MySQL server during query" But for the rest of it. I noticed when I upgraded to 7.5 I had similar errors other than the connection issue. I recall about 4 entries but I believe a different line.
Call it coincidence but when I enabled the profile comments. The errors did not return.
To your question about slow I did notice at first that viewing profiles seemed to stall a little but not now. But if you are having Mysql connection issues, that would slow down everything.
But in any case I think this should be in the Bug forum.
I didn't post it in the bug forum as I figured that if it was a bug it would have affected others (and there didn't appear to be a more appropriate forum).
Quote:
Call it coincidence but when I enabled the profile comments. The errors did not return.
Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Well, the benefit of the error logging is it blatantly tells you the problem in the error message; if you're loosing connections to MySQL it's generally the MySQL servers fault
you, 
Previous Topic
Index
