2008-11-17, 02:35 PM
(This post was last modified: 2008-11-17, 02:36 PM by Chris W. B..)
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:
PostgreSQL 8.3.4
PHP 5.2.6
MyBB 1.4.3
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
