Board3 2.0.0 error debug mode

[metal master]

Site: http://www.napolifans.it
Phpbb3 3.0.10

I installed board3, everything went well but when I post this link (http://www.napolifans.it/portal.php?announcement=10) gives me this error

Code: Select all

SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

SQL

SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id =

BACKTRACE

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

FILE: [ROOT]/includes/functions.php
LINE: 1653
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/portal/modules/portal_announcements.php
LINE: 285
CALL: get_complete_topic_tracking()

FILE: [ROOT]/portal.php
LINE: 103
CALL: portal_announcements_module->get_template_center()

What is this?
you can resolve this error?

[metal master]

Same error with the simil link here: http://www.m-a-styles.de/portal.php?announcement=10

[Marc]

Why is there a announcement=10 in your link? If you click on "read all", it will append 0 and not 10.

[metal master]

The error was discovered through research on google search engine that when indexing the site gives me debug error on that link,

In Control Panel board3 I set it to 10 the number of announcements to display in the portal.
As soon as I click on the link of the first post (http://www.napolifans.it/portal.php?announcement=10) which should match the eleventh announcements, I get out of the error

The file is called the error is portal_announcements.php, line 285.
This is the code line 285:

Code: Select all

$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id, $global_announce_list = false);

[Marc]

If you set the number of announcements to 10 then there will be no link that has announcements=10 appended. This might only happen if you set the number to 11 or more and then set it back to 10 or less, and google still has the incorrect link indexed.

Still I'll see what I can do in order to prevent that error.

edit: This should take care of it: https://github.com/board3/Board3-Portal ... f0a2efe8c0

[metal master]

I added the extra code in the file portal_announcements.php and now no longer gives error

Thank you very much