FIXED Changing A User To Admin


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: [Download] [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

Profile PM  
Subject: Re: Changing A User To Admin
It's already fixed by MG... I think will be ok on the next GIT version... ;)

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.

Profile PM  
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.

Subject: Re: Changing A User To Admin
Yes, now it is working fine.
Thanks Luca

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0834s (PHP: 21% SQL: 79%)
SQL queries: 10 - Debug Off - GZIP Enabled