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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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 03:10 Go to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member
add to buddy list
ignore all messages by this user

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 15:35 Go to previous messageGo to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member
add to buddy list
ignore all messages by this user

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 07:46 Go to previous messageGo to next message
pssc is currently offline  pssc   United Kingdom
Messages: 6
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 18: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
add to buddy list
ignore all messages by this user
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] Sat, 23 September 2006 22: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
add to buddy list
ignore all messages by this user
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 12: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
add to buddy list
ignore all messages by this user
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 14: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
add to buddy list
ignore all messages by this user
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 15: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
add to buddy list
ignore all messages by this user
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 15: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
add to buddy list
ignore all messages by this user
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 15: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
add to buddy list
ignore all messages by this user
Excellent!

That definately works now.

Thanks for the quick fix!!

bob..
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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 Jan 24 02:48:26 EST 2018

Total time taken to generate the page: 0.00531 seconds