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
I have repaired the table from Admincp and from PHPMYADMIN as well but still in vain

[SLIDE]http://screensnapr.com/u/gwsxmg.png[/SLIDE]

[SLIDE]http://screensnapr.com/u/84ry3p.png[/SLIDE]
 
upload tools.php in install.php
upload in root
command
yourdomainname.com/tools.php
Repair Table prob should be solve;)
 
People here don't understand what this shit means :
"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"

also he already saying :
I have repaired the table from Admincp and from PHPMYADMIN as well but still in vain.

Arthur try to disable hooks system from forum settings and tell us the results
 
Oh sorry didn't read that.

Mostly these problems are caused by unexperienced users that try to mod their forum.

Did you remember what you changed for the last time?
 
Oh sorry didn't read that.

Mostly these problems are caused by unexperienced users that try to mod their forum.

Did you remember what you changed for the last time?

mate, am not unexpereinced user. Forum was working fine suddenly my uploader told me that he is not be able to create any thread.... then i found that there is something wrong in my db....
 
People here don't understand what this shit means :
"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"

also he already saying :
I have repaired the table from Admincp and from PHPMYADMIN as well but still in vain.

Arthur try to disable hooks system from forum settings and tell us the results

Thanks for reminding that things XL.. Well yeah i had disabled the hook system but still that stupid error :(
 
Status
Not open for further replies.
Back
Top