FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql) [message #33768] |
Wed, 20 September 2006 07: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 #33775 is a reply to message #33768] |
Wed, 20 September 2006 19:35 |
|
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 |
pssc
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 #33878 is a reply to message #33859] |
Sun, 24 September 2006 19:09 |
robertmonaghan
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 & 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) & 1 > 0)) ORDER BY v.id<br />
_GET: array (
't' => 'index',
'S' => 'ef6f5102b2006a73e04a1ea48e89311c',
)<br />
|
|
|
|
|