Quote:
Originally Posted by fixer
it gives error in vb3.6.8
|
It works, but there is a slight problem within the document. It says:
Code:
==== Find in forumdisplay.php
$stickies = $db->query_read_slave("
SELECT thread.threadid, lastpost, open
FROM " . TABLE_PREFIX . "thread AS thread
WHERE forumid = $foruminfo[forumid]
AND sticky = 1
$visiblethreads
==== Replace with
$stickies = $db->query_read_slave("
SELECT thread.threadid, lastpost, open
FROM " . TABLE_PREFIX . "thread AS thread
WHERE forumid = $foruminfo[forumid]
AND (sticky = 1
OR threadid IN ($personalstickysq)
$visiblethreads
The replacement is missing a closing paranthesis - it needs a double )) after $personalstickysq
It should look like this for the replacement
Code:
==== Replace with
$stickies = $db->query_read_slave("
SELECT thread.threadid, lastpost, open
FROM " . TABLE_PREFIX . "thread AS thread
WHERE forumid = $foruminfo[forumid]
AND (sticky = 1
OR threadid IN ($personalstickysq))
$visiblethreads
AND there was a step left out that was part of the original installation.
Working on 3.6.8 PL2 - Complete Update Installation Revision is attached!