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

Home » FUDforum » FUDforum Installation Issues » FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33878 is a reply to message #33859] Sun, 24 September 2006 19:09 Go to previous messageGo to previous message
robertmonaghan is currently offline  robertmonaghan   United States
Messages: 4
Registered: September 2006
Location: Santa Barbara, CA
Karma:
Junior Member
Well, it sort of works.. I now get the following error..

.../htdocs/FUDforum2/index.php:1219<br />
) : ERROR:  syntax error at or near "ORDER" at character 855<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
                        FROM fud26_fc_view v
                        INNER JOIN fud26_cat c ON c.id=v.c
                        INNER JOIN fud26_forum f ON f.id=v.f
                        INNER JOIN fud26_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id
                        LEFT JOIN fud26_msg m ON f.last_post_id=m.id
                        LEFT JOIN fud26_users u ON u.id=m.poster_id  LEFT JOIN fud26_forum_read fr ON fr.forum_id=f.id AND fr.user_id=3 LEFT JOIN fud26_mod mo ON mo.user_id=3 AND mo.forum_id=f.id LEFT JOIN fud26_group_cache g2 ON g2.user_id=3 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',
  'S' =&gt; 'ef6f5102b2006a73e04a1ea48e89311c',
)<br />
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Newsgroup import problem - sql error ?
Next Topic: can not get installation to work - errors
Goto Forum:
  

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

Current Time: Sat Nov 23 21:40:56 GMT 2024

Total time taken to generate the page: 0.04846 seconds