Page 1 of 1
Board3 2.0.0 error debug mode
Posted: 9. March 2012 23:05
by 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?
Re: Board3 error debug mode
Posted: 9. March 2012 23:11
by metal master
Re: Board3 2.0.0 error debug mode
Posted: 11. March 2012 22:50
by Marc
Why is there a announcement=10 in your link? If you click on "read all", it will append 0 and not 10.
Re: Board3 2.0.0 error debug mode
Posted: 12. April 2012 17:10
by 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);
Re: Board3 2.0.0 error debug mode
Posted: 12. April 2012 19:44
by 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
Re: Board3 2.0.0 error debug mode
Posted: 12. April 2012 22:20
by metal master
I added the extra code in the file portal_announcements.php and now no longer gives error
Thank you very much
