Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#1961 "isUser" not quoted which leads to an error in PostgreSQL

v1.9RC
closed-fixed
5
2005-05-12
2005-05-05
Tiziano Müller
No

"isUser" is not quoted in lib/userslib.php, which
produces the following error when deleting an
admin-user and using PostgreSQL (8.0.2) due to
lower-/Upper-case:

Warning: postgres7 error: ERROR: column "isuser" does
not exist in query:

delete from "tiki_newsletter_subscriptions" where
"email"=? and isUser=?

in /var/www/lusankya/htdocs/tikiwiki/lib/tikidblib.php
on line 134

******

Context:
File /tikiwiki/tiki-adminusers.php
Url
/tikiwiki/tiki-adminusers.php?offset=0&numrows=10&sort_mode=login_asc&action=delete&user=tiziano
Query:
delete from "tiki_newsletter_subscriptions" where
"email"=? and isUser=?
Values:
0 YetAnotherAdminUser
1 y
Message:
Error Message ERROR: column "isuser" does not exist

Discussion

  • Logged In: YES
    user_id=738765

    Thanks for reporting, that will be fixed for 1.9.1.

     
    • status: open --> open-fixed
     
    • assigned_to: nobody --> chealer
    • status: open-fixed --> closed-fixed
     
  • Logged In: YES
    user_id=784615

    Fixed by chealer for 1.9.1