SQL ERROR [ mysqli ]

[Stoker]

Update to 1.0.6
That will fix it.

[RMcGirr83]

Great. Now I am able to troubleshoot the error.
And your fix works 100% - Thanks a lot Rich

You're welcome

But Dammit!!! Now I have to resubmit for the third time...

..and there will be a fourth time from looking at the code.

[Stoker]

Why is that Rich?

[Napster]

..and there will be a fourth time from looking at the code

yep.after install i just get a white page on index

[Stoker]

..and there will be a fourth time from looking at the code

yep.after install i just get a white page on index

Then check your edits.

And if you are interested in support for the mod, then open a topic and ask for it

[martin123456]

White page on 1.0.6 too back on 1.0.5 and all is good

Bummer wrong topic sorry

[Stoker]

Please redownload and try again

[RMcGirr83]

Why is that Rich?

For starters using quote for coloring purposes

WHERE ' . $db->sql_in_set('t.forum_id', $flist) . ' AND topic_moved_id = 0 AND topic_approved
ORDER BY topic_last_post_time DESC';

you are missing the table delineation (aka t) and topic_approved should have a value....eg

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

should be

Code: Select all

AND forum_type = ' . FORUM_POST . '

for example

The tabbing is also off within this file

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))
{

which is more of a readability thing than anything else and indent is your friend!!

[Solidjeuh]

Yes! everythingg works now with 1.0.6!
Thank you so much!

[martin123456]

confirmed it works