Topic Post Text Hover SQL Error when displaying last post
Posted: 04 Nov 2008, 18:48
I'm using the latest version of your mod. When I use the ACP to set "Display for the Hover:" to "First Post" everything works as expected. However, if I select "Last Post" or "Both Posts" two major problems occur.
1) Navigating directly to a forum (viewforum.php?f=5), the hover text does not work. It's as though the mod is not active or installed.
2) Navigating to the board index (index.php) results in a "General Error":
-------------------------------------------------------------------------------------
SQL ERROR [ mysqli ]
Unknown column 't.topic_moved_id' in 'on clause' [1054]
SQL
SELECT f.*, ft.mark_time, p.post_text AS last_text_hover FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_posts p ON (f.forum_last_post_id = p.post_id AND t.topic_moved_id = 0) ORDER BY f.left_id
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()
FILE: includes/functions_display.php
LINE: 114
CALL: dbal_mysqli->sql_query()
FILE: index.php
LINE: 28
CALL: display_forums()
---------------------------------------------------------------------------------
Any I've checked the function_display.php file, and the mod code was properly installed here.
Any ideas?
1) Navigating directly to a forum (viewforum.php?f=5), the hover text does not work. It's as though the mod is not active or installed.
2) Navigating to the board index (index.php) results in a "General Error":
-------------------------------------------------------------------------------------
SQL ERROR [ mysqli ]
Unknown column 't.topic_moved_id' in 'on clause' [1054]
SQL
SELECT f.*, ft.mark_time, p.post_text AS last_text_hover FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_posts p ON (f.forum_last_post_id = p.post_id AND t.topic_moved_id = 0) ORDER BY f.left_id
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()
FILE: includes/functions_display.php
LINE: 114
CALL: dbal_mysqli->sql_query()
FILE: index.php
LINE: 28
CALL: display_forums()
---------------------------------------------------------------------------------
Any I've checked the function_display.php file, and the mod code was properly installed here.
Any ideas?