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


