thank for the update

thank for your good work i like it

Go phpBB go... Respected : Developers, Supporters.
Code: Select all
SQL ERROR [ mysqli ]
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause [1140]
SQL
SELECT b.*, COUNT(c.cmnt_id) AS cmnt_count, ct.cat_title, u.username, u.user_colour FROM (phpbb_blog b CROSS JOIN phpbb_blog_comments c CROSS JOIN phpbb_blog_categories ct CROSS JOIN phpbb_users u) WHERE ct.cat_id = b.blog_cat_id AND c.cmnt_blog_id = b.blog_id AND u.user_id = b.blog_poster_id AND b.blog_tags LIKE '%Test%' ORDER BY b.blog_id DESC
BACKTRACE
FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()
FILE: [ROOT]/blog.php
LINE: 678
CALL: dbal_mysqli->sql_query()
To fix that :Fatal error: Call-time pass-by-reference has been removed in [root]/includes/mods/functions_blog.php on line 165
Code: Select all
#
#-----[ OPEN ]------------------------------------------------
#
includes/mods/functions_blog.php
#
#-----[ FIND ]------------------------------------------------
#
$s = submit_post('post', $subject, $user->data['username'], POST_NORMAL, &$poll, &$data);
#
#-----[ REPLACE WITH ]----------------------------------------
#
$s = submit_post('post', $subject, $user->data['username'], POST_NORMAL, $poll, $data);
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM
Thanks, I'll apply this fix shortly.ABDev wrote:Hi,
There is an issue when PHP 5.4 is used :
To fix that :Fatal error: Call-time pass-by-reference has been removed in [root]/includes/mods/functions_blog.php on line 165
Code: Select all
# #-----[ OPEN ]------------------------------------------------ # includes/mods/functions_blog.php # #-----[ FIND ]------------------------------------------------ # $s = submit_post('post', $subject, $user->data['username'], POST_NORMAL, &$poll, &$data); # #-----[ REPLACE WITH ]---------------------------------------- # $s = submit_post('post', $subject, $user->data['username'], POST_NORMAL, $poll, $data); # #-----[ SAVE/CLOSE ALL FILES ]-------------------------------- # # EoM
<!-- IF SCRIPT_NAME eq blog and BLOG_CAT_ID eq 1 --> class="current"<!-- ENDIF -->
?Code: Select all
#
#-----[ OPEN ]------------------------------------------------
#
blog.php
#
#-----[ FIND ]------------------------------------------------
#
$sql = 'SELECT COUNT(cmnt_id) AS cmnt_count
FROM ' . BLOG_CMNTS_TABLE . '
WHERE cmnt_blog_id = \'' . $blog_id . '\' ' . (($perm != true) ? 'AND cmnt_approved = \'1\'' : '');
#
#-----[ REPLACE WITH ]----------------------------------------
#
$sql = 'SELECT COUNT(cmnt_id) AS cmnt_count
FROM ' . BLOG_CMNTS_TABLE . '
WHERE cmnt_blog_id = ' . $blog_id . (($perm != true) ? ' AND cmnt_approved = 1' : '');
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM