PDA

Voir la version complète : Erreur sql


Spirere
25/11/2007, 12h11
Bonjours, quand je clique sur certains des membres connecter actuelement, j'ai une erreur sql... :s


Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT IF(thread.threadprefix <> '', CONCAT('', thread.threadprefix, '', thread.title), thread.title) AS title, thread.threadid, thread.forumid, thread.postuserid, thread.visible
,post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM thread AS thread
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
WHERE thread.threadid IN (0,114);

MySQL Error : Unknown column 'thread.threadprefix' in 'field list'
Error Number : 1054
Date : Sunday, November 25th 2007 @ 12:10:08 PM
Script : /forum/member.php?u=22
Referrer : /forum/
IP Address : 83.194.69.249
Username : WeT
Classname : vb_database

Allan
25/11/2007, 12h27
A priori, tu a un souci en relation au hack préfixe.

Spirere
25/11/2007, 13h11
Problémme régler, cela venais bien du hack thread prefix, j'avais inverser les fichiers modifier à upper