mysql error
Posted: 25. June 2009 13:19
Your Portal Version: v1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Beginner
Boardlink: http://cnkinship.co.uk/phpbb3/
What have you done before the problem was there?
Updated to 3.0.5 on the 9th of June everything was working until today when I try to access my site I get a mysql error.
What have you already tryed to solve the problem?
checked admin logs to see if any other admin had accessed and changed any settings, no-one had accessed acp.
Description and Message
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Beginner
Boardlink: http://cnkinship.co.uk/phpbb3/
What have you done before the problem was there?
Updated to 3.0.5 on the 9th of June everything was working until today when I try to access my site I get a mysql error.
What have you already tryed to solve the problem?
checked admin logs to see if any other admin had accessed and changed any settings, no-one had accessed acp.
Description and Message
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/announcements.php
LINE: 27
CALL: phpbb_fetch_posts()
FILE: portal.php
LINE: 107
CALL: include('portal/block/announcements.php')