phpBB : настройка и модификация

Код: Выделить всё

Общая ошибка
SQL ERROR [ mysql4 ]

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

SQL

SELECT COUNT(t.topic_id) as topics_count FROM (bb_topics_watch i CROSS JOIN bb_topics t) WHERE i.post_id = 0 AND i.topic_id = t.topic_id AND i.user_id = 2 AND 1=1

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 193
CALL: dbal->sql_error()

FILE: [ROOT]/includes/ucp/ucp_main.php
LINE: 820
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/ucp/ucp_main.php
LINE: 366
CALL: ucp_main->assign_topiclist()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: ucp_main->main()

FILE: [ROOT]/ucp.php
LINE: 338
CALL: p_master->load_active()

Код: Выделить всё

		$sql_array = array(
			'SELECT'	=> 'COUNT(t.topic_id) as topics_count',

Код: Выделить всё

		$pb_sql = ($mode == 'bookmarks') ? 'i.post_id = 0 AND' : '';

Код: Выделить всё

			'WHERE'		=>	'i.post_id = 0
				AND i.topic_id = t.topic_id

Код: Выделить всё

			'WHERE'		=>	$pb_sql . '
				i.topic_id = t.topic_id