From Cory Booth.
What I was saying is... I have seen multiple posts addressing this particular SQL error. I assume this error is from the Post Thanks Scoring Hack? In anycase, I too have received this error.
But when I took the SQL from the email and pasted it into phpAdmin I got a NULL result.
To figure out why or what the query wanted I removed parts specifically "AND languageid IN (-1, 0, 1);"
This gave me the language phrase I belive the script was looking for. Therefore I assumed the languageid code was the problem for getting a NULL script.
So I played with the languageid code (changed it from -1 to 1) and reran the original SQL.
I got the return.
Out of confussion, I changed the languageid code back to -1 and I then got the return again.
Hmmmm....
So I imagine the SQL insert for this particular phase and languageid might be putting in a -1 with a blank space? Somehow the -1 for postthanks is corrupt?
|