Page 3 of 4

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 14:26
by Stoker
Update to 1.0.6
That will fix it.

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 16:43
by RMcGirr83
Stoker wrote: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. ;)

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 17:20
by Stoker
Why is that Rich?

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 17:24
by Napster
..and there will be a fourth time from looking at the code
yep.after install i just get a white page on index

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 17:31
by Stoker
Napster wrote:
..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 ;)

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 18:03
by martin123456
White page on 1.0.6 too back on 1.0.5 and all is good

Bummer wrong topic sorry

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 18:29
by Stoker
Please redownload and try again ;)

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 18:58
by RMcGirr83
Stoker wrote: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!! :)

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 19:41
by Solidjeuh
Yes! everythingg works now with 1.0.6!
Thank you so much!
:D

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 19:43
by martin123456
confirmed it works :D