Driver Error

[Noob Saibot 38]

Every now and then I receive a driver error on the forums. Sometimes refreshing the page fixes it and other times it doesn't. I suggest Marked that you install this Hook: Driver Error Viewer 1.0.0 as it will allow you to view What the driver error is and causing it. I say you install it ASAP and see if any what errors are there and fix them. No doubt probably from the new Side Hook you installed...

[Marked 197]

No doubt? Haha, you underestimate my php skills. Actually, that hook is based off of the recent posts hook from some more conditions on the WHERE clause, and a few other modifications.

 

I don't know why there is a mod. In fact, I'm sure all it does it read files that every admin can access via FTP anyway. The files are stored in forums/cache.

 

There have been an usually spike in the SQL error logs over the last 3 days, the majjority of them are the following:

Error: 2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 104

 

My initial thoughts are that this is host related rather than script related. I also get connection errors around the website which is obviously independent of the forums, so that is the main indication that it is host related.

[Noob Saibot 38]

http://www.rmxpunlimited.net/forums/index.php?app=core&module=search&do=user_activity&mid=325

 

 

(I make no claim the error will appear again)

[Marked 197]

Interesting error. I'll show it to you.

Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '40610,50172,42761,48161,36003,45043,49117,50170,50152,49997,49255,49823,49953,49' at line 1

And the query is:

SELECT t.tid, t.title, t.topic_prefix FROM [table] t, ibf_posts p WHERE t.tid=p.topic_id and p.pid in (49981,48571,50421,50445,50499,50442,,40610,50172,42761,48161,36003,45043,49117,50170,50152,49997,49255,49823,49953,49366,49477,49866,49640,49541)

Ok, so you can see that in the list of IDs one of them is not showing up, causing this: ',,' and that is causing the error. I know what file it is occurring in but I won't go and look at the code. The file is default from the software, and Im going to assume there is a certain topic that you made or posted in that no longer exists or something, or for some strange reason the ID wasn't returned properly, and therefore this error will stop once you make a few more posts.