Forum - SQL ERROR - can't access forums

The worst monsters in the Hearthlands warp the fabric of space and time..

Forum - SQL ERROR - can't access forums

Postby zdenuch » Mon Jul 01, 2013 4:12 pm

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?
zdenuch
 
Posts: 3
Joined: Fri Jun 28, 2013 5:02 pm

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

Postby borka » Tue Jul 02, 2013 4:42 pm

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?
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

Postby zdenuch » Thu Jul 04, 2013 1:32 pm

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

Postby zdenuch » Fri Jul 05, 2013 2:55 pm

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.
zdenuch
 
Posts: 3
Joined: Fri Jun 28, 2013 5:02 pm

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

Postby Parchir » Fri Jul 05, 2013 3:08 pm

I had this problem when my friend was logged in on forum with this same account that i was logged ;P
Parchir
 
Posts: 177
Joined: Fri Dec 10, 2010 10:35 pm

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

Postby leny-m5 » Sat Jul 06, 2013 8:49 am

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 :-/
leny-m5
 
Posts: 1
Joined: Sat Jul 06, 2013 8:48 am


Return to Bugs

Who is online

Users browsing this forum: Claude [Bot] and 0 guests