|
Re: SQL Error has occurred [message #39192 is a reply to message #39190] |
Tue, 09 October 2007 13:05 |
derek
Messages: 21 Registered: May 2007
Karma: 0
|
Junior Member |
|
|
Additional info from the FUDforum/errors/sql_errors file:
?1503 ?1191934543?(docs/forum/index.php:95<br />
docs/forum/index.php:89<br />
docs/forum/theme/default/index.php:152<br />
docs/forum/index.php:1219<br />
) : ERROR: parser: parse error at or near "ORDER" at character 864<br />
Query: SELECT
m.subject, m.id, m.post_stamp,
u.id, u.alias,
f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.post_count, f.thread_count,
fr.last_view, mo.id, COALESCE(g2.group_cache_opt, g1.group_cache_opt) AS group_cache_opt,
(c.cat_opt & 4) = 4
FROM fud25_fc_view v
INNER JOIN fud25_cat c ON c.id=v.c
INNER JOIN fud25_forum f ON f.id=v.f
INNER JOIN fud25_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id
LEFT JOIN fud25_msg m ON f.last_post_id=m.id
LEFT JOIN fud25_users u ON u.id=m.poster_id LEFT JOIN fud25_forum_read fr ON fr.forum_id=f.id AND fr.user_id=13 LEFT JOIN fud25_mod mo ON mo.user_id=13 AND mo.forum_id=f.id LEFT JOIN fud25_group_cache g2 ON g2.user_id=13 AND g2.resource_id=f.id WHERE (mo.id IS NOT NULL OR ((COALESCE(g2.group_cache_opt, g1.group_cache_opt) & 1 > 0)) ORDER BY v.id<br />
_GET: array (
't' => 'index',
'rid' => '13',
'S' => 'b1c66e1b7dbc5c387f04d291aad9db58',
)
Seems as though the error occurs when following a new user link from an email, or while logged in and the user clics on 'Home' (but they can read/post OK).
Any advice very welcome... thanks
Derek
[Updated on: Tue, 09 October 2007 15:45] Report message to a moderator
|
|
|