[Genjuro-Sensei]

Originally Posted by itsid

well, in the unaltered database of vb 3.6.3 there has to be the column post.visible , that's the item that handles softdeleted posts (userdeleted but visible to mods and admins)
I cannot say where the problem comes from, maybe another hack that removes or alters this column (nerver heard of such, but that doesn't mean anything)

Dermio had/has almost the same problem a page ago, so I verified the existance of this table and column.
Same friend of mine (who gave me the sql-layout) installed this hack in his very clean 3.6.3 testboard and it worked without any errors.
Again, I have to say sorry, but I have no idea what's causing your problems

hang on a sec, i'll try to im my friend to find some hint in vb3.6.3
[EDIT]
So.. that's fast isn't it ?
there are 59 hits, searching for "post.visible" within the original vb 3.6.3 files.
for example this one:

PHP Code:

file (functions_forumdisplay.php)
$mythreads = $vbulletin->db->query_read_slave("
            SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
            FROM " . TABLE_PREFIX . "post AS post
            WHERE post.userid = " . $vbulletin->userinfo['userid'] . " AND
            post.visible = 1 AND
            post.threadid IN (0$ids)
            GROUP BY threadid
        "); 


So, I'm sure that's somewhere else to search the error but the missing column
maybe we run different versions of MySQL and/or php.

Just to try:
Open the xml file with an appropate Editor (notepad++ ultraedit or even a simple wordpad) something with numbered lines best.
Edit Line 173 : find post.visible replace with visible
same in line 272 and 341.
save and try again.

I can't promise that this will help, but I assume
do not edit the way mentioned if you do not have THIS ERROR

'sid

Thank you very mutch, it solved the problem ^^
Thanks to you !! really !!