[Hasann]

Originally Posted by Magnumutz

Is that true Hasann?

yes it's true

Originally Posted by arauf

Hasann i have installed your previous HTML Markup ..

i uninstalled that before installing this one but i am getting this Database Error

PHP Code:

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, 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
, hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid
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 = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS hasannuser ON (thread.lastposter = hasannuser.username)
LEFT JOIN user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)
WHERE thread.threadid IN (0,6853,6583,4837,1441,3393,2797,1219,1459,1112,1510,1111,1107,856,913,931,948)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Error Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Script : http://xxx/voiceforums/forumdisplay.php?f=9
Referrer : http://xxx/voiceforums/index.php
IP Address : 77.31.9.228
Username : Kareem
Classname : vB_Database
MySQL Version : 5.0.51a-community 


Help !

did you installed this hack ?
https://vborg.vbsupport.ru/showthread.php?t=199568

Originally Posted by the.code

i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load

I take a look and I'll upgrade it