DB problem when createing new thread on my forum

Status
Not open for further replies.

Arthur

Active Member
1,244
2010
338
20
Hello, I am receiving this error when i want to create new thread at my forum. Interesting thing is this that only Registered User Group can post a thread. Any other user group holder (e.g. MOD, SMOD, UPlOADER etc) user can't be able to create a thread not even a Admin Group as well

MY site is:

Code:
http://www.ghostwarez.com/

Demo user to chk the error:

User: demo
pass: Demo1


Error that I am facing while creating a thread from any User group EXCEPT Registered User Group:

PHP:
Database error in vBulletin 4.0.6:

Invalid SQL:

                SELECT
                    fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
                    a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
                    at.contenttypes
                FROM attachment AS a
                INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
                LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
                WHERE
                    a.posthash = 'e26062bd0e206782e465b2b499ea14d5'
                        AND
                    a.userid IN (1)
                        AND
                    a.contenttypeid =
            
ORDER BY a.contentid, a.displayorder;

MySQL Error   : 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 'ORDER BY a.contentid, a.displayorder' at line 15
Error Number  : 1064
Request Date  : Wednesday, December 8th 2010 @ 12:20:10 PM
Error Date    : Wednesday, December 8th 2010 @ 12:20:10 PM
Script        : http://www.ghostwarez.com/newthread.php?do=newthread&f=109
Referrer      : http://www.ghostwarez.com/porn-xxx/
IP Address    : ----------
Username      : King Arthur
Classname     : vB_Database
MySQL Version : 5.0.91-community
I found this on Internet but not working for me

Code:
http://www.vbulletin.com/forum/archive/index.php/t-358696.html
Now Please tell me what should I do
Thank you
 
20 comments
Wawo found another interesting thing

"Interesting thing is this that only Registered User Group can post a new thread. Any other user group holder (e.g. MOD, SMOD, UPlOADER etc) user can't be able to create a thread not even a Admin Group as well"

WTF is this?
 
Status
Not open for further replies.
Back
Top