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

Home » FUDforum Development » Bug Reports » ERROR: Unable to identify a prefix operator '!' for type 'integer'
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
ERROR: Unable to identify a prefix operator '!' for type 'integer' [message #16484] Sun, 01 February 2004 19:53 Go to previous message
Sebastian_T is currently offline  Sebastian_T   Poland
Messages: 33
Registered: January 2004
Location: Warsaw, Poland
Karma:
Member
FUD on postgreSQL v. 7.3, upgraded from 2.3.8. to 2.6.0

when trying to accept posts in premoderated forum, shows an error:

(/usr/local/apache/htdocs/forum.blizniaki.net/index.php:141
/usr/local/apache/htdocs/forum.blizniaki.net/index.php:232
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/modque.php:1948
/usr/local/apache/htdocs/forum.blizniaki.net/index.php:1185
) : ERROR: Unable to identify a prefix operator '!' for type 'integer' You may need to add parentheses or an explicit cast
Query: SELECT CASE WHEN !(9600246 & 1048576) THEN mm.id ELSE 1 END FROM fud23_msg m INNER JOIN fud23_thread t ON m.thread_id=t.id LEFT JOIN fud23_mod mm ON t.forum_id=mm.forum_id AND mm.user_id=4 WHERE m.id=11314
Server Version:
[Referring Page] http://forum.blizniaki.net/index.php?t=modque&SQ=e0ed5a526d4ddac085e7ac 991945a699



postgreq does not accept '!' as an integer in line:

f (!q_singleval('SELECT CASE WHEN !('.$usr->users_opt.' & 1048576) THEN mm.id ELSE 1 END FROM fud23_msg m INNER JOIN fud23_thread t ON m.t
hread_id=t.id LEFT JOIN fud23_mod mm ON t.forum_id=mm.forum_id AND mm.user_id='._uid.' WHERE m.id='.($appr ? $appr : $del))) {



as a newbe, no ideas... Wink

Sebastian


PS. And so to run something, we changed:

if (!q_singleval('SELECT CASE WHEN !('.$usr->users_opt.' & 1048576) THEN mm.id ELSE 1 END FROM fud23_msg m INNER JOIN fud23_thread t ON m.t
hread_id=t.id LEFT JOIN fud23_mod mm ON t.forum_id=mm.forum_id AND mm.user_id='._uid.' WHERE m.id='.($appr ? $appr : $del))) {

to:

if (!q_singleval('SELECT CASE WHEN (('.$usr->users_opt.' & 1048576) > 0) THEN mm.id ELSE 1 END FROM fud23_msg m INNER JOIN fud23_thread t ON m.t
hread_id=t.id LEFT JOIN fud23_mod mm ON t.forum_id=mm.forum_id AND mm.user_id='._uid.' WHERE m.id='.($appr ? $appr : $del))) {

now it does not show an error, but also does not accept posts Wink


Sebastian

[Updated on: Sun, 01 February 2004 20:26]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ERROR: Relation "f2" does not exist
Next Topic: Error in maillist.php,v 1.38
Goto Forum:
  

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

Current Time: Sat Nov 09 17:41:31 GMT 2024

Total time taken to generate the page: 0.04609 seconds