Page 1 of 1

Error after un-locking user

PostPosted: Mon May 01, 2006 7:42 am
Author: Angelus
Hi after I unlocked a user he has to set some informations in his account inclunding security question. But after he has set everything he gets the error message:

Could not rename users group

DEBUG MODE

UPDATE phpbb_groups SET group_name = 'C''as En-vÃÂÂ ®l' WHERE group_name = 'C'as En-vÃÂÂ ®l'

Line : 470
File : profilcp_board_config.php


I hav also reset the security question of my testuser and reentered it and everything worked fine. The only thing I did was transfering 3 posts from another user to him because he re-registered under another name. But I changed the topic poster to him and the 2 other postings to his poster id.
Does anyone can help? I'm running a 1.4.0 with phpBB 2.0.17

Greetings
Thorsten

PostPosted: Mon May 01, 2006 8:30 am
Author: Adrian Rea
I wonder if it is to do with th '-' in the En-vil name?

I am not sure.

A

Re: Error after un-locking user

PostPosted: Mon May 01, 2006 8:44 am
Author: Angelus
Does not seem to be the "-" but the " ' " in the name. Sometimes the name was displayed C'as En-vÃÂÂ ®l . So I renamed the name simply to Cas and than everything worked fine. I also registered a User named C'as En-vÃÂÂ ®l2 in acp. When I wanted to log in I had to enter the security question birthday and so on (this can't be set in acp) and had also the error. So integra seems to have a problem with " ' " in names.

Greetings and thanks for the hint
Thorsten

PostPosted: Mon May 01, 2006 8:58 am
Author: Adrian Rea
Sorry, yes you are right, I thought it was just the way it displated it, but a ' in ant titles can cause issues. Nicely fixed.

A

PostPosted: Mon May 01, 2006 9:03 am
Author: Jason Sanborn
I know I fixed the ' issue on my live site. Unfortunately, I don't remember how I did it. It had to do with how sql statements are parsed, and changing a call to a sql statement.

Re: Error after un-locking user

PostPosted: Mon May 01, 2006 9:13 am
Author: Angelus
If you find these changes again please let me know!
Greetings
Thorsten