On occasion, I get an email from our server noting a vBulletin Database Error. While the error varies slightly, it is more or less always tied to the line "GROUP BY pmtextid' at line 3"
I have verified that my private.php file is the correct file from the 4.2.2. package.
I can't find anything like that line in private.php
When looking at the script line, it looks like the PM is being deleted.
When looking at the referrer line, it looks like the PM is being displayed.
Is the system trying to display a deleted PM? I don't know. I just want to stop seeing this error. Any help would be greatly appreciated.
As a note, I have tried quite a few different things myself, but can't seem to replicate this issue.
I have verified that my private.php file is the correct file from the 4.2.2. package.
I can't find anything like that line in private.php
When looking at the script line, it looks like the PM is being deleted.
When looking at the referrer line, it looks like the PM is being displayed.
Is the system trying to display a deleted PM? I don't know. I just want to stop seeing this error. Any help would be greatly appreciated.
As a note, I have tried quite a few different things myself, but can't seem to replicate this issue.
Code:
Database error in vBulletin 4.2.2: Invalid SQL: SELECT pmtextid, COUNT(pmtextid) AS total FROM pm AS pm WHERE pmid IN () GROUP BY pmtextid; MySQL Error : 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 ') GROUP BY pmtextid' at line 3 Error Number : 1064 Request Date : Friday, June 27th 2014 @ 05:43:51 AM Error Date : Friday, June 27th 2014 @ 05:43:51 AM Script : [URL]http://www.therpf.com/private.php?do=managepm&dowhat=delete&pmid=3613379[/URL] Referrer : [URL]http://www.therpf.com/private.php?do=showpm&pmid=3613379[/URL] IP Address : 173.219.121.87 Username : fantome2024 Classname : vB_Database_MySQLi MySQL Version :
Comment