| 2.7.5 -> 2.7.6 Upgrade problems [message #33770] |
Wed, 20 September 2006 13:20  |
pssc
Messages: 6
Registered: September 2006
Karma:
|
Junior Member |
|
|
Upgrade seemed to run ok but only admin can now login
all other users get an error:-
Warning: pg_query() [function.pg-query]: Query failed: ERROR: argument of OR must be type boolean, not type integer in /home/pssc/public_html/FUD/index.php on line 95
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in
log:-
(/home/pssc/public_html/FUD/index.php:95
/home/pssc/public_html/FUD/index.php:89
/home/pssc/public_html/FUD/theme/default/index.php:151
/home/pssc/public_html/FUD/index.php:1219
) : ERROR: argument of OR must be type boolean, not type integer
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_t2fc_view v INNER JOIN fud26_t2cat c ON c.id=v.c INNER JOIN fud26_t2forum f ON f.id=v.f INNER JOIN fud26_t2group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud26_t2msg m ON f.last_post_id=m.id LEFT JOIN fud26_t2users u ON u.id=m.poster_id LEFT JOIN fud26_t2forum_read fr ON fr.forum_id=f.id AND fr.user_id=4 LEFT JOIN fud26_t2mod mo ON mo.user_id=4 AND mo.forum_id=f.id LEFT JOIN fud26_t2group_cache g2 ON g2.user_id=4 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
_GET: array ( 't' => 'index', 'SQ' => '81e16c8ae55af990c8a7d733587af380', )
Server Version:
[Referring Page] http://xxxxxxxxx/~pssc/FUD/index.php?t=login
Running:-
postgresql-7.4.13, solaris 8
Web Server: Apache/2.0.54 (Debian GNU/Linux) PHP/5.1.6-1~bpo.1
Safe mode.
Phill.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]