Board3

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'i.image_reported' in 'where clause' [1054]

SQL

SELECT i.*, a.album_name, a.album_id, a.album_user_id FROM phpbb_gallery_images i LEFT JOIN phpbb_gallery_albums a ON i.image_album_id = a.album_id WHERE (i.image_album_id IN ('2', '8', '3', '4', '5', '6', '7', '12', '11', '10', '9', '13') AND i.image_status = 1 AND i.image_reported = 0) GROUP BY i.image_id ORDER BY i.image_time DESC LIMIT 1

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: portal/includes/functions_album.php
LINE: 171
CALL: dbal->sql_query_limit()

FILE: portal/block/album.php
LINE: 42
CALL: gallery_images_block()

FILE: portal.php
LINE: 245
CALL: include('portal/block/album.php')

Code: Select all

if (!defined('IN_PHPBB') or !defined('IN_PORTAL'))
{
	exit;
}

Code: Select all

if (!defined('IN_PHPBB'))
{
	exit;
}

if (!defined('IN_PORTAL'))
{
	exit;
}

Code: Select all

include($phpbb_root_path . 'portal/block/album.'.$phpEx);