SQL ERROR [ mysql4 ]

[~HG~]

Your Portal Version: 1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Advanced Knowledge
Boardlink: http://phpbb-tutorials.com

PHP Version: 3.0.4
MySQL Version: 5.0.67-community

What have you done before the problem was there?
No more than add a number of topics to the forum. After I added the topics I went to the portal to view latest topics and received the error outlined below.

What have you already tryed to solve the problem?
I have looked at the lines and preceding lines relating to the errors on all of the files indicated but I can't see any problem.

Description and Message
I am receiving this error message when I try to visit the portal page.

General Error
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 'AND in_message = 0 ORDER BY filetime DESC' at line 4 [1064]

SQL

SELECT * FROM phpbb_attachments WHERE post_msg_id = AND in_message = 0 ORDER BY filetime DESC

BACKTRACE


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

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

FILE: portal/block/news.php
LINE: 30
CALL: phpbb_fetch_posts()

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

The index and all other pages work fine and can be accessed via http://phpbb-tutorials.com/index.php

[Kevin]

Have you changed something to the news.php?
If so, already tried a original one?

[Christian_N]

Your Portal Version: 1.0.2

this bug is in 1.0.3 fixed.
please updated your B3P to 1.0.3

[~HG~]

I have now upgraded to v1.0.3 and the problem is resolved thank you.