Page 1 of 1

PM Archiving SQL Error

PostPosted: Wed Apr 11, 2007 1:01 pm
Author: Omni-Lee
Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: http://www.mithrilcrowns.net

PHP Version:
MySQL Version:


What was done before the problem appeared?
In the process of Archiving a back-log of PM.


What was done to try to solve the problem?
N/A



De.scription and Message

After archiving a few pages of PM's on the website today I suddenly recieved the following error.

Error querying Private Messages Text table.

DEBUG MODE

SQL 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 ' , '', , , , '', , , , )' at line 2

INSERT INTO phpbb_privmsgs_archive VALUES (, , '', , , , '', , , , )

Line : 346
File : admin_priv_msgs.php

I thought there might be a corrupted PM, but was unable to discover which PM it would be. Has this occurred for anyone else? If so, what was done to correct the problem?

Omni-Lee