SQL ERROR [ mysqli ]
Posted: 17 Nov 2011, 14:26
Update to 1.0.6
That will fix it.
That will fix it.
Database and Demo for phpBB3 BBCodes, Mods and Smilies
https://phpbb3bbcodes.com/
You're welcomeStoker wrote:Great. Now I am able to troubleshoot the error.
And your fix works 100% - Thanks a lot Rich
..and there will be a fourth time from looking at the code.But Dammit!!! Now I have to resubmit for the third time...
yep.after install i just get a white page on index..and there will be a fourth time from looking at the code
Then check your edits.Napster wrote:yep.after install i just get a white page on index..and there will be a fourth time from looking at the code
For starters using quote for coloring purposesStoker wrote:Why is that Rich?
you are missing the table delineation (aka t) and topic_approved should have a value....egWHERE ' . $db->sql_in_set('t.forum_id', $flist) . ' AND topic_moved_id = 0 AND topic_approved
ORDER BY topic_last_post_time DESC';
Code: Select all
WHERE ' . $db->sql_in_set('t.forum_id', $flist) . ' AND t.topic_moved_id = 0 AND t.topic_approved = 1
ORDER BY t.topic_last_post_time DESC';
Code: Select all
and forum_type = 1
Code: Select all
AND forum_type = ' . FORUM_POST . '
Code: Select all
if (!defined('INCLUDES_FUNCTIONS_TOP_STATS_PHP'))
{
define('INCLUDES_FUNCTIONS_TOP_STATS_PHP', true);
$flist = $auth->acl_getf('f_read', true);
$flist = array_unique(array_keys($flist));
// Recent Active Topics
if (!empty($config['tsrat_enable']) && sizeof($flist))
{