Forum - SQL ERROR - can't access forums

The worst monsters in the Hearthlands warp the fabric of space and time..
zdenuch
Posts: 3
Joined: Fri Jun 28, 2013 5:02 pm

Forum - SQL ERROR - can't access forums

Post by zdenuch »

General Error
SQL ERROR [ mysql4 ]

Duplicate entry '<my_account_name>' for key 'users_username_clean' [1062]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Can anybody help me with this?

I've probably had an old account by that name and when I started playing again I registered a duplicate. Which I shouldn't be able to imho :)) nvm that, can someone clear that out for me?
User avatar
borka
Posts: 9965
Joined: Thu Feb 03, 2011 7:47 pm
Location: World of Sprucecap

Re: Forum - SQL ERROR - can't access forums

Post by borka »

there's only this account with this name in hearthlings memberlist: memberlist.php?sk=a&sd=a&first_char=z&start=650

zdenuch 1 Fri Jun 28, 2013 6:02 pm Tue Jul 02, 2013 1:30 pm

can you login at game?
zdenuch
Posts: 3
Joined: Fri Jun 28, 2013 5:02 pm

Re: Forum - SQL ERROR - can't access forums

Post by zdenuch »

borka wrote:there's only this account with this name in hearthlings memberlist: memberlist.php?sk=a&sd=a&first_char=z&start=650

zdenuch 1 Fri Jun 28, 2013 6:02 pm Tue Jul 02, 2013 1:30 pm

can you login at game?
It's actualy about my leny-m account. I didn't want to specify the name as I would bet I'm not the only one with this issue. Checking the db for duplicates in the specified table was the solution I was expecting :)
General Error
SQL ERROR [ mysql4 ]

Duplicate entry 'leny-m' for key 'users_username_clean' [1062]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
zdenuch
Posts: 3
Joined: Fri Jun 28, 2013 5:02 pm

Re: Forum - SQL ERROR - can't access forums

Post by zdenuch »

I've checked that Leny-m is here only once as well. I can log the game in but I can't access forums from that account. Definitely DB based problem.
Parchir
Posts: 177
Joined: Fri Dec 10, 2010 10:35 pm

Re: Forum - SQL ERROR - can't access forums

Post by Parchir »

I had this problem when my friend was logged in on forum with this same account that i was logged ;P
leny-m5
Posts: 1
Joined: Sat Jul 06, 2013 8:48 am

Re: Forum - SQL ERROR - can't access forums

Post by leny-m5 »

Parchir wrote:I had this problem when my friend was logged in on forum with this same account that i was logged ;P
Someone would have to be logged in 24/7 and I haven't given the pass to anyone :-/

Return to “Bugs”