mysql error

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
TheFlyfisher
Active Member
Posts: 2
Joined: 21. January 2009 12:53

mysql error

Post by TheFlyfisher »

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
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')

Topic author
TheFlyfisher
Active Member
Posts: 2
Joined: 21. January 2009 12:53

Re: mysql error

Post by TheFlyfisher »

sorted, some posts were causing the error, dont know why tho but when removed error no longer appeard.
Locked

Return to “board3 Portal 1.0.x - English Support”