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
Switch to threaded view of this topic Create a new topic Submit Reply
FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33768] Wed, 20 September 2006 07:10 Go to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

I upgraded this morning FUDforum to version 2.7.6 (I'm using PostgreSQL v 7.4.7).
I now get a blank page, and in the system error logs, it says:

apache2: PHP Warning:  pg_query(): Query failed: ERROR:  argument of OR must be type boolean, not type integer in /var/www/cabal/index.php on line 95
apache2: PHP Fatal error:  SQL Error has occurred, please contact the <a href="mailto:foo(at)foobar(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /var/www/cabal-FUDforum/include/core.inc on line 188


On line 95 of index.php, I have:
$GLOBALS['__FLPG__'] = pg_query(fud_sql_lnk, $q) or die (fud_sql_error_handler($q, pg_last_error(fud_sql_lnk), '', get_version()))
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33775 is a reply to message #33768] Wed, 20 September 2006 19:35 Go to previous messageGo to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

If that can help, here is the faulty PostgreSQL request (where you can see the wrong "WHERE (mo.id IS NOT NULL OR (COALESCE(g2.group_cache_opt, g1.group_cache_opt)) & 1)>0 ORDER BY v.id":

SELECT
		s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id,
		t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt,
		u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.topics_per_page,
		u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc
	FROM fud25_ses s
		INNER JOIN fud25_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END)
		INNER JOIN fud25_themes t ON t.id=u.theme
	WHERE s.ses_id='3e73c29b399ccf6e6ec15a6368fa8ea1'UPDATE fud25_users SET last_visit=1158780607 WHERE id=3UPDATE fud25_ses SET sys_id='', forum_id=0, time_sec=1158780607, action='Browsing the <a href="index.php?t=index">forum list</a>', returnto='t=index&rid=0' WHERE id=28311SELECT count(*) FROM fud25_msg_report mr INNER JOIN fud25_msg m ON mr.msg_id=m.id INNER JOIN fud25_thread t ON m.thread_id=t.id INNER JOIN fud25_mod mm ON t.forum_id=mm.forum_id AND mm.user_id=3SELECT count(*) FROM fud25_thr_exchange te INNER JOIN fud25_mod m ON m.user_id=3 AND te.frm=m.forum_idSELECT count(*) FROM fud25_msg m INNER JOIN fud25_thread t ON m.thread_id=t.id INNER JOIN fud25_forum f ON t.forum_id=f.id  INNER JOIN fud25_mod mm ON f.id=mm.forum_id AND mm.user_id=3 WHERE m.apr=0 AND (f.forum_opt>=2 AND (f.forum_opt & 2) > 0)SELECT count(*) FROM fud25_pmsg WHERE duser_id=3 AND fldr=1 AND read_stamp=0SELECT
				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
			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=3 LEFT JOIN fud25_mod mo ON mo.user_id=3 AND mo.forum_id=f.id LEFT JOIN fud25_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)) & 1)>0 ORDER BY v.id
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33779 is a reply to message #33768] Thu, 21 September 2006 11:46 Go to previous messageGo to next message
pssc is currently offline  pssc   United Kingdom
Messages: 6
Registered: September 2006
Karma: 0
Junior Member
I got somthing similar with portgress too
see:-

http://fudforum.org/forum/index.php?t=tree&th=7061&start=0&



lstep wrote on Wed, 20 September 2006 08:10

I upgraded this morning FUDforum to version 2.7.6 (I'm using PostgreSQL v 7.4.7).
I now get a blank page, and in the system error logs, it says:

apache2: PHP Warning:  pg_query(): Query failed: ERROR:  argument of OR must be type boolean, not type integer in /var/www/cabal/index.php on line 95
apache2: PHP Fatal error:  SQL Error has occurred, please contact the <a href="mailto:foo(at)foobar(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /var/www/cabal-FUDforum/include/core.inc on line 188


On line 95 of index.php, I have:
$GLOBALS['__FLPG__'] = pg_query(fud_sql_lnk, $q) or die (fud_sql_error_handler($q, pg_last_error(fud_sql_lnk), '', get_version()))


Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33793 is a reply to message #33779] Thu, 21 September 2006 22:09 Go to previous messageGo to next message
Ilia is currently offline  Ilia   United States
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This patch will fix the problem
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11601


FUDforum Core Developer
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33851 is a reply to message #33793] Sun, 24 September 2006 02:55 Go to previous messageGo to next message
robertmonaghan is currently offline  robertmonaghan   United States
Messages: 4
Registered: September 2006
Location: Santa Barbara, CA
Karma: 0
Junior Member
Hi!

I applied this patch, but I still get the same error in my sql_errors log.

What should be done to get the forum to recognise this change?

bob..
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33859 is a reply to message #33851] Sun, 24 September 2006 16:13 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Did you rebuild the theme after applying the patch?

FUDforum Core Developer
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33875 is a reply to message #33859] Sun, 24 September 2006 18:58 Go to previous messageGo to next message
robertmonaghan is currently offline  robertmonaghan   United States
Messages: 4
Registered: September 2006
Location: Santa Barbara, CA
Karma: 0
Junior Member
That worked! Thanks!

bob..
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 next message
robertmonaghan is currently offline  robertmonaghan   United States
Messages: 4
Registered: September 2006
Location: Santa Barbara, CA
Karma: 0
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 />
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33883 is a reply to message #33878] Sun, 24 September 2006 19:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Here is the fix
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11611


FUDforum Core Developer
Re: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33884 is a reply to message #33768] Sun, 24 September 2006 19:37 Go to previous message
robertmonaghan is currently offline  robertmonaghan   United States
Messages: 4
Registered: September 2006
Location: Santa Barbara, CA
Karma: 0
Junior Member
Excellent!

That definately works now.

Thanks for the quick fix!!

bob..
  Switch to threaded view of this topic Create a new topic Submit Reply
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: Wed Nov 27 21:48:59 GMT 2024

Total time taken to generate the page: 0.03664 seconds