Kordy
13/08/2007, 23h06
Bonsoir,
Après avoir désinstallé le hack de lerat pour les préfixe dispo sur vBr, un message d'erreur MySQL apparaît lorsque je me rends dans un forum (forumdisplay, le reste du forum est accessible) :
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, thread.tof AS tof, thread.ts_type AS type, thread.threadprefix AS threadprefix, thread.threadtype AS threadtype, thread.dateetat, thread.etat_ftp AS etatftp, thread.verif_name AS checker
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 62 AND canview = 1)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,791,783,633,632,631,598)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'thread.threadtype' in 'field list'
Error Number : 1054
Date : Monday, August 13th 2007 @ 11:40:15 PM
Script : http://***.*****-**.***/v1/forumdisplay.php?f=15
Referrer : http://***.*****-**.***/v1/index.php
IP Address : 83.197.49.136
Username : KORDY
Classname : vb_databaseJ'ai désactivé le hack Thread Prefixes 1.6.1 et le problème c'est réglé, seulement c'est le hack de lerat que je veux virer ...
Merci d'avance pour votre aide ...
Après avoir désinstallé le hack de lerat pour les préfixe dispo sur vBr, un message d'erreur MySQL apparaît lorsque je me rends dans un forum (forumdisplay, le reste du forum est accessible) :
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, thread.tof AS tof, thread.ts_type AS type, thread.threadprefix AS threadprefix, thread.threadtype AS threadtype, thread.dateetat, thread.etat_ftp AS etatftp, thread.verif_name AS checker
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 62 AND canview = 1)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,791,783,633,632,631,598)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'thread.threadtype' in 'field list'
Error Number : 1054
Date : Monday, August 13th 2007 @ 11:40:15 PM
Script : http://***.*****-**.***/v1/forumdisplay.php?f=15
Referrer : http://***.*****-**.***/v1/index.php
IP Address : 83.197.49.136
Username : KORDY
Classname : vb_databaseJ'ai désactivé le hack Thread Prefixes 1.6.1 et le problème c'est réglé, seulement c'est le hack de lerat que je veux virer ...
Merci d'avance pour votre aide ...