FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » SQL Error has occurred
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: SQL Error has occurred [message #39192 is a reply to message #39190] Tue, 09 October 2007 13:05 Go to previous message
derek is currently offline  derek   United Kingdom
Messages: 21
Registered: May 2007
Karma:
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 &amp; 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) &amp; 1 &gt; 0)) ORDER BY v.id<br />
_GET: array (
  't' =&gt; 'index',
  'rid' =&gt; '13',
  'S' =&gt; '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

[Message index]
 
Read Message
Read Message
Previous Topic: non-standard postgres port
Next Topic: Can't upgrade
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 20:29:23 GMT 2024

Total time taken to generate the page: 0.04242 seconds