SQL ERROR [ mysql4 ]
Posted: 15. April 2009 01:26
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
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