Page 1 of 1

SQL Error

Posted: 20. April 2010 10:51
by webslug
Your Portal Version: 1.0.5
Your phpBB Type: Premodded phpBB
MODs installed: Yes
Your knowledge: Advanced Knowledge

What have you done before the problem was there?


What have you already tryed to solve the problem?


Description and Message
Hi I'm getting the following error when I try access the following page on my portal.

portal.php?np=5&news=4

I'm using PHPBB 3.07 PL1 with the 1.05 version of the Board 3 portal.



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 = 53 AND forum_id =

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 1569
CALL: dbal_mysql->sql_query()

FILE: portal/block/news.php
LINE: 236
CALL: get_complete_topic_tracking()

FILE: portal.php
LINE: 152
CALL: include('portal/block/news.php')

I noticed there is no forum_id in the SQL query. I have no idea why this is empty, its very peculiar.

Thanks in advance.[/i]

Re: SQL Error

Posted: 20. April 2010 10:55
by webslug
I forgot to mention, I've checked the news.php file and it is up to date with no modifications.

The rest of the portal seems to run ok.

Re: SQL Error

Posted: 20. April 2010 12:13
by Marc
I'll need a link to your board in order to check that. I don't even know how you get that link. The link usually looks like this: portal.php?np=5#n