Everything is for free!
Shop is closed.
Due to health issues support is very limited

file SQL query error when selecting Administrator in Groups filter in Config/Users

More
7 years 1 month ago #9602 by Adam_NZ
1064: 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 ')' at line 3 SQL=SELECT user_id, group_id FROM jos_user_usergroup_map WHERE user_id IN (0,)

This happens when in the Users list view then selecting "Administrator" in the Groups filter. It's repeatable.

Have to log out to unset the cookie to reset that page and clear the error.

Adam.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #9609 by carsten888
here is the temp fix.

file:
administrator/components/com_helppages/views/users/view.html.php
line 171
//only get those users we need for performance
		$user_id_string = '0,';
		$first = 1;
		foreach($current_users as $users){
			if($first){
				$first = 0;
			}else{
				$user_id_string .= ',';
			}
			$user_id_string .= $users->id;			
		}
replace with
//only get those users we need for performance
		$user_id_string = '0';		
		foreach($current_users as $users){						
			$user_id_string .= ','.$users->id;			
		}

this will be included in the next update.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago - 7 years 1 month ago #9610 by Adam_NZ
Temp fix works - many thanks!

Oh - and by the way! The 1.1.0 update doesn't update the latest version info, so you keep seeing the link to download it ;)
Last edit: 7 years 1 month ago by Adam_NZ.

Please Log in or Create an account to join the conversation.

Time to create page: 0.114 seconds
Powered by Kunena Forum
 
spicy-sacerdotal