MyBB Community Forums

When trying to export private messages using certain conditions on a forum running PostgreSQL, an error is returned.

Reproduction Steps:

1. Go to the user cp
2. Click on "Inbox"
3. Click on "Download Messages"
4. Select the following conditions on the 'Export Private Messages' page:

Folders: All Folders
Date Limitation: Disregard date
Export Unread Messages? Yes
Delete Exported Messages? Yes
Export File Format: HTML

5. Click "Export Private Messages"

The following eror is returned:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    22P02 - ERROR: invalid input syntax for integer: "" 
Query:
    DELETE FROM trunk_privatemessages WHERE pmid IN ('','5','3') 

MyBB: Latest internal version
PostgreSQL 8.3.4
PHP: 5.2.6-2ubuntu4

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group