MyBB Community Forums

On a forum that is running PostgreSQL, a user can't add a attachment.

To reproduce the error, follow the steps below:

1. In a thread, click the "New Reply" button
2. Enter a message into the new thread input box
3. In the "Attachments" section, click "Browse"
5. Select the file you want to attach
6 Now click "Add attachment"

The following error is returned:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    22P02 - ERROR: invalid input syntax for integer: "" 
Query:
    SELECT * FROM trunk_attachments WHERE filename='logo.gif' AND (posthash='fa4510cdde8caa64188cef558b7e1ed5' OR (pid='' AND pid!='0')) 

PostgreSQL 8.3.4
PHP 5.2.6
MyBB 1.4.3

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