Critical databse error on post.php - info provided

[wynnyelle]

I am going to give all the info I can for this.

The error:

Code Select Expand



Apply Filter: Only show the error messages of this URL
http://warriorcatsrpg.com/index.php?board=50.0;action=post2
Apply Filter: Only show the errors with the same message
Wrong value type sent to the database. Integer expected. (id_msg)
Function: Post
Apply Filter: Only show the errors from this file
File: /home/warrior/public_html/Sources/Post.php
Line: 630



About 200 of these came in all about the same time. Same error, same IP.

How would I fix this, if anyone knows?

Other threads that refer to similar errors:

http://www.simplemachines.org/community/index.php?topic=458710.0
http://www.simplemachines.org/community/index.php?topic=446459.0

I myself didn't get the error directly, but I found all these in the error log.

[jaideejung007]

Have you chang any function on post.php files?

Checking your files again, try it on!

PS: Disable your mod installed, for checking it!

[wynnyelle]

Which mod would that be?

No, I have no changed any functions, what functions would that be on post.php though?

[wynnyelle]

whatever it is is causing severe delays evety time a post is made. I don't know how to fix it. I need some help.

[kat]

Can you attach Post.php, GS?

We can take a look at it, then.

[wynnyelle]

Here it is.

[kat]

Uh-oh... That looks weird.

Lemme go right through it.

Back in a mo...

[kat]

I just compared it to a virgin RC3 file and it looks OK.

So, I can only suspect that it may be one of the bugs that existed in RC3.

I know your loath to upgrade, Groovy one. But, with you and your error-logs, you're almost cartain to keep getting this stuff happening.

It's the nature of the beast, with what are, essentially, beta versions.

I know you're heavily customis(z)ed. But...

Let's be frank, here... Going THAT heavily on the customisation on a beta was, well, a bit dumb, really.


Just kinda wondering out-loud, here... How would it be, if I tried to help-out with getting you on to v2.0.2 and getting the customis(z)ations done?

[wynnyelle]

I'd take any help from someone who knew what they were doing. That's very kind of you and I thank you for the offer. We have replaced a few of our files with fresh ones from the solid new 2.0, but most of it is still RC 3. I'd rather patch my way because it'd be smoother and we would avoid the dreaded down times.

Where did you get those files to compare with?

[kat]

I have the RC3 install archive on my HD.

[wynnyelle]

Ah I see. I have my own forum which is still mostly using Rc3. About how many files in it have changed since Rc3 to the new current version?

[kat]

Loads, I believe.

Let me see if I can find out exactly which...

[kat]

Judging from the timestamps on the files, pretty-well all of them.

[Arantor]

Virtually every source file, not counting version/header changes, has changed since RC3.

[wynnyelle]

Wow. Okay, thanks for letting me know.

I found another odd error:

Code Select Expand


[Tue Jan 10 10:39:36 2012] [error] [client 31.96.223.163] File does not exist: /home/warrior/public_html/Themes/winterwarriors/images/theme/submit_bg.png/bmi_orig_img/submit_bg.png/bmi_orig_img/submit_bg.png/bmi_orig_img/submit_bg.png/bmi_orig_img/submit_bg.png/bmi_orig_img/submit_bg.png/bmi_orig_img/submit_bg.png, referer: http://warriorcatsrpg.com/profile/meepster-..-29933/area,forumprofile/


[Arantor]

Using a pretty URLs type mod?

[wynnyelle]

We use SimpleSEF.

[Arantor]

That makes some sense. What's happening is that SSEF is interpreting the filename for something incorrectly, rewriting the link and ending up getting into a loop over it (so it redoes the rewrite again) which is why you see that strange behaviour of nesting of things seemingly inside themselves.

Fixing it could be troublesome, since at first glance I see no reason for the bmi_orig_img part to come in... I wonder if it's a form of hack attempt, that's been neutered by rewriting the otherwise bogus link into a harmless enough fashion.

[wynnyelle]

I don't know. But I do often see huge CPU resources being consumed by odd things like tiny or even non existent images. I could post up errors to show you.

I did just get this critical error:

Code Select Expand


Apply Filter: Only show the error messages of this URL
http://warriorcatsrpg.com/index.php?action=findmember;af9910501=fa54d8e833a6dba40fe64f45c2b9fdf0
Apply Filter: Only show the errors with the same message
Wrong value type sent to the database. Array of integers expected. (buddy_list)
Function: findMembers
Apply Filter: Only show the errors from this file
File: /home/warrior/public_html/Sources/Subs-Auth.php
Line: 511


[Arantor]

Got Ultimate Profile installed?