https://www.icyphoenix.com/viewtopic.php?f=29&t=8133 ----------------------------------- TheSteffen Sun 02 Oct, 2011 11:08 Changing A User To Admin ----------------------------------- Error when changing a user to admin [img]http://www.icyphoenix.com/files/images/85/user_to_admin.png[/img] If I click submit I get this error [code linenumbers=false]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()[/code] 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 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 Re: Changing A User To Admin ----------------------------------- Thanks [b]andrea75[/b] 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 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 Re: Changing A User To Admin ----------------------------------- Yes, now it is working fine. Thanks Luca