Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] [PostgreSQL] Adding a attachment [R]
#1
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



Messages In This Thread
[F] [PostgreSQL] Adding a attachment [R] - by Chris W. B. - 11-17-2008, 02:35 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)