Solved: 6 Years, 1 Month, 2 Weeks ago Page load time and an sql error (_ _)
#1
Solved: 6 Years, 1 Month, 2 Weeks ago Smile 
For some reason, we have been experiencing these issues for three days now.
My stupid hosting service isn't even responding so I am a bit lost.
Can you guys help me with the mybb-2013 internal sql error?

I know that it isn't that simple....but I haven't created a backup for a very long time and now I don't know what to do.....


Attached Files Thumbnail(s)
   
Reply
#2
Solved: 6 Years, 1 Month, 2 Weeks ago
If you're on shared hosting you'll have to have your web host fix it for you.
Reply
#3
Solved: 6 Years, 1 Month, 2 Weeks ago
(2015-03-25, 03:08 PM)dragonexpert Wrote: If you're on shared hosting you'll have to have your web host fix it for you.

Well, I have been trying to reach them...but no use (_ _)
That's why I am here so that someone might give me some sort of tips, regarding this error.
By the way, I am using godaddy hosting.
Reply
#4
Solved: 6 Years, 1 Month, 2 Weeks ago
Depending on how many posts you are calling that order by rand can be a very expensive query. Try disabling that plugin. Shared hosting dont like badly optimised plugins Smile
Random Fish and Sims Maniac
MY PLUGINS
Help MyBBSupport help you - remember to mark your threads as solved


Reply
#5
Solved: 6 Years, 1 Month, 2 Weeks ago
(2015-03-25, 03:53 PM)Leefish Wrote: Depending on how many posts you are calling that order by rand can be a very expensive query.  Try disabling that plugin. Shared hosting dont like badly optimised plugins Smile

Err...what plugin? 
I am sorry but I am not really familiar with mybb Sad
Reply
#6
Solved: 6 Years, 1 Month, 2 Weeks ago
Something you have installed is making it use a query to get a random result from the posts table. Tbh, I'm not even sure if using ORDER BY RAND() even works when you have table joins. Much better would be to retrieve multiple records then use PHP to pick a random result.
Reply
#7
Solved: 6 Years, 1 Month, 2 Weeks ago
(2015-03-25, 05:00 PM)dragonexpert Wrote: Something you have installed is making it use a query to get a random result from the posts table.  Tbh, I'm not even sure if using ORDER BY RAND() even works when you have table joins.  Much better would be to retrieve multiple records then use PHP to pick a random result.

that's the random function right...."advanced sidebox" for a random post (_ _)
Anyway, thanks guys Smile
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)