Changing A User To Admin »  Show posts from    to     

Icy Phoenix


Old Bugs - Changing A User To Admin



TheSteffen [ Sun 02 Oct, 2011 11:08 ]
Post subject: Changing A User To Admin
Error when changing a user to admin

user_to_admin

If I click submit I get this error
Code: [Hide] [Select]
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3) GROUP BY (u.user_id) ORDER BY u.user_id ASC' at line 4 [1064]

SQL

SELECT u.user_id, u.user_level FROM ipgit_users u, ipgit_forums_watch fw WHERE u.user_id = fw.user_id AND fw.forum_id IN ('3', '4', '5') AND u.user_id NOT IN (,3) GROUP BY (u.user_id) ORDER BY u.user_id ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: includes/class_notifications.php
LINE: 307
CALL: sql_db->sql_query()

FILE: adm/admin_ug_auth.php
LINE: 144
CALL: class_notifications->delete_not_auth_notifications()


Testet on latest git version
Using: php 5.2.12 / mysql 5.1

It could be that it is the same error like this http://www.icyphoenix.com/viewtopic.php?f=2&t=8128


andrea75 [ Sun 02 Oct, 2011 11:45 ]
Post subject: Re: Changing A User To Admin
It's already fixed by MG... I think will be ok on the next GIT version...


TheSteffen [ Wed 05 Oct, 2011 09:32 ]
Post subject: Re: Changing A User To Admin
Thanks andrea75 for the answer...

Till now it is not fixed for me. I will keep it in my mind and check with next update again.


Mighty Gorgon [ Wed 05 Oct, 2011 23:52 ]
Post subject: Re: Changing A User To Admin
I have just updated GIT and released the first beta. Let me know if it is fixed now.

Thanks for reporting.


TheSteffen [ Sat 08 Oct, 2011 00:11 ]
Post subject: Re: Changing A User To Admin
Yes, now it is working fine.
Thanks Luca




Powered by Icy Phoenix