https://www.icyphoenix.com/viewtopic.php?f=29&t=8133&p=53967#p53967
-----------------------------------
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


