Topic Post Text Hover SQL Error when displaying last post

[RTAdams89]

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?

[RMcGirr83]

[RTAdams89]

That change fixed the error.

When I select "First Post" everything works as expected. When I select "Last Post" no tool tip gets displayed. When I select "Both Posts" only the first post appears in the tool tip.

Here is my viewforum.php file:

[SNIP]

[RMcGirr83]

It looks like the mod is installed okay on viewforum.php. Can you please provide, via PM if you like, a link to your forum and ACP access?

[RMcGirr83]

The last topic tooltip is given by hovering over the latest topic icon in viewforum...not by hovering on the topic title. Wasn't sure if you knew that or not. This changed in version 1.0.2 but is standard functionality in 1.0.0