History Community ~ All Empires Homepage


This is the Archive on WORLD Historia, the old original forum.

 You cannot post here - you can only read.

 

Here is the link to the new forum:

  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedSql errors when trying to change profile info.

 Post Reply Post Reply
Author
Xirian View Drop Down
Immortal Guard
Immortal Guard
Avatar

Joined: 06-Oct-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Xirian Quote  Post ReplyReply Direct Link To This Post Topic: Sql errors when trying to change profile info.
    Posted: 01-Dec-2008 at 02:49
When I try to make changes to anything in my profile, I get an SQL error like the following:

Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_update_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
Query-based update failed because the row to update could not be found.

Can someone assist me with changing my profile information please?
"There is no delight in owning anything unshared." ~Seneca~
~Xirian~
Back to Top
Northman View Drop Down
Administrator
Administrator
Avatar
~ Scylding ~

Joined: 30-Aug-2004
Location: Denmark
Status: Offline
Points: 4433
Post Options Post Options   Thanks (0) Thanks(0)   Quote Northman Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 03:31
Unfortunately, a few profiles suffer from this error which cannot be corrected directly.
It is due to more transition of the database during the last couple of years, most notably a conversion from MS Access to mySQL.
 
However, we can arrange that I delete your account at a specific time, and then create a new account with the same username and details as the current account. This is the only way to bypass this problem.
 
Let me know through PM when it suits you.
 
~ Northman
 
 
Back to Top
Xirian View Drop Down
Immortal Guard
Immortal Guard
Avatar

Joined: 06-Oct-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Xirian Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 12:40
Thanks for letting me know what's up.

You can delete my account today sometime (12-1-08) and I will re-register later today or early tomorrow.  
"There is no delight in owning anything unshared." ~Seneca~
~Xirian~
Back to Top
Xirian View Drop Down
Immortal Guard
Immortal Guard
Avatar

Joined: 06-Oct-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Xirian Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 14:06
Oh, also, I'm going to be changing my user name to Dara (or something similar). 
"There is no delight in owning anything unshared." ~Seneca~
~Xirian~
Back to Top
Dara View Drop Down
Immortal Guard
Immortal Guard
Avatar

Joined: 01-Dec-2008
Location: Iowa
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dara Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 14:10
I have re-registered as Dara.  Please feel free to delete Xirian account whenever it's convenient for you.
~Dara~

"There is no delight in owning anything unshared."
~Seneca~
Back to Top
Northman View Drop Down
Administrator
Administrator
Avatar
~ Scylding ~

Joined: 30-Aug-2004
Location: Denmark
Status: Offline
Points: 4433
Post Options Post Options   Thanks (0) Thanks(0)   Quote Northman Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 19:10
You solved the problem yourself Smile - and I'll take care of Xirian next time I'm in the database.
 
Back to Top
Dara View Drop Down
Immortal Guard
Immortal Guard
Avatar

Joined: 01-Dec-2008
Location: Iowa
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dara Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 20:39
Cheers and Thanks!!
~Dara~

"There is no delight in owning anything unshared."
~Seneca~
Back to Top
cahaya View Drop Down
Chieftain
Chieftain
Avatar
The Auror

Joined: 05-Oct-2005
Location: Malaysia
Status: Offline
Points: 1264
Post Options Post Options   Thanks (0) Thanks(0)   Quote cahaya Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 10:09
SQL ERROR.. not during chg of my profiles but whenever the time i wish to post a reply.. Many many times happened already.. and.. it starts to irritate me actually.
Uncle North? Seko? Anyone? Help...
Back to Top
Knights View Drop Down
Webmaster
Webmaster
Avatar
AE Magazine Coordinator

Joined: 23-Oct-2006
Location: Australia
Status: Offline
Points: 3294
Post Options Post Options   Thanks (0) Thanks(0)   Quote Knights Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 11:16
Same happens for me actually - mainly when posting in the modern culture subforum. The post still goes through, but an error page appears.

Back to Top
King Kang of Mu View Drop Down
Chieftain
Chieftain
Avatar
(Foot)Balling DJ from da Eastside

Joined: 23-Mar-2006
Location: United States
Status: Offline
Points: 1022
Post Options Post Options   Thanks (0) Thanks(0)   Quote King Kang of Mu Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 11:41
me too.  is it me?  because I posted so many upYourgoogleTube links on that sub forum? 
 
But like Knights said, the post still goes through though. 
I believe I am a reflection, like the moon on water. When you see me, and I try to be a good man, you see yourself.
- from 'Kundun'

www.ted.com
Back to Top
Seko View Drop Down
Administrator
Administrator
Avatar
Superfluous Enabler of Sekostan

Joined: 01-Sep-2004
Location: United States
Status: Offline
Points: 8682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Seko Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 15:15

The error tends to crop up when posting at certain forums. Seems to be one of those weeks where it is most evident. Hang in there.

Copyright 2004 Seko
Back to Top
Northman View Drop Down
Administrator
Administrator
Avatar
~ Scylding ~

Joined: 30-Aug-2004
Location: Denmark
Status: Offline
Points: 4433
Post Options Post Options   Thanks (0) Thanks(0)   Quote Northman Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 15:26
I'm currently working on upgrading the forum software to a new version that probably will take care of this glitch in the software.
However, please remember it's an old and huge database - it has lived through more conversions and we must expect to see a few bugs now and then.
The alternative would be to start from scratch with an empty forum, but that would be the last route we should walk I think.
  
Back to Top
cahaya View Drop Down
Chieftain
Chieftain
Avatar
The Auror

Joined: 05-Oct-2005
Location: Malaysia
Status: Offline
Points: 1264
Post Options Post Options   Thanks (0) Thanks(0)   Quote cahaya Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 15:51
well .. we wont take tht option then... it's ok.. as Seko said.. i'll hang in here.. till.. whenever it takes..
Back to Top
King Kang of Mu View Drop Down
Chieftain
Chieftain
Avatar
(Foot)Balling DJ from da Eastside

Joined: 23-Mar-2006
Location: United States
Status: Offline
Points: 1022
Post Options Post Options   Thanks (0) Thanks(0)   Quote King Kang of Mu Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 17:21

Yeah, it's not really that bad, North.  Now please slowly step away from that red button.  I know you were just trying to scare the kids, but no more of that crazy talk.  I still remember that 'Can' thread, we lost.  I saved the picture of Ulrich you posted.

 
 
This time I was lucky, but I don't ever wanna lose anything as valuable to my life as much as this picture. 


Edited by King Kang of Mu - 18-Dec-2008 at 17:22
I believe I am a reflection, like the moon on water. When you see me, and I try to be a good man, you see yourself.
- from 'Kundun'

www.ted.com
Back to Top
Northman View Drop Down
Administrator
Administrator
Avatar
~ Scylding ~

Joined: 30-Aug-2004
Location: Denmark
Status: Offline
Points: 4433
Post Options Post Options   Thanks (0) Thanks(0)   Quote Northman Quote  Post ReplyReply Direct Link To This Post Posted: 18-Dec-2008 at 21:36
Yes King - Ulrich is a Jack of many cans - but there is a limit to everything. Looks like 12 for him Big smile
 
The New Version...
I just made the last few adjustments to the new version of software. (ver. 9.54)
You wont feel or see much change though - its all behind the lines in the scripts but should take care of some bugs.
 
 
Correction: 13 cans  - had to get my socks off....Embarrassed


Edited by Northman - 18-Dec-2008 at 21:37
Back to Top
es_bih View Drop Down
Immortal Guard
Immortal Guard
Avatar
Beglerbeg

Joined: 20-Dec-2006
Location: United States
Status: Offline
Points: 3426
Post Options Post Options   Thanks (0) Thanks(0)   Quote es_bih Quote  Post ReplyReply Direct Link To This Post Posted: 19-Dec-2008 at 01:15
Originally posted by Northman Northman wrote:

Yes King - Ulrich is a Jack of many cans - but there is a limit to everything. Looks like 12 for him Big smile
 
The New Version...
I just made the last few adjustments to the new version of software. (ver. 9.54)
You wont feel or see much change though - its all behind the lines in the scripts but should take care of some bugs.
 
 
Correction: 13 cans  - had to get my socks off....Embarrassed


Do you know why some mobile browsers won't accept the java scripts for the text boxes ( in particular Opera Mini 4.1 and up, and Pocket Internet Explorer, while some other forums are rendering fine? Is it more software related and then of course which scripts that browser can handle?

Back on topic:


We can handle a few glitches here and there. It is better than starting from scratch and losing valuable content.



Back to Top
Northman View Drop Down
Administrator
Administrator
Avatar
~ Scylding ~

Joined: 30-Aug-2004
Location: Denmark
Status: Offline
Points: 4433
Post Options Post Options   Thanks (0) Thanks(0)   Quote Northman Quote  Post ReplyReply Direct Link To This Post Posted: 19-Dec-2008 at 01:34
Originally posted by es_bih es_bih wrote:


Do you know why some mobile browsers won't accept the java scripts for the text boxes ( in particular Opera Mini 4.1 and up, and Pocket Internet Explorer, while some other forums are rendering fine? Is it more software related and then of course which scripts that browser can handle?

 
No, I can't say I know for sure - but it probably has to do with the java interpreter installed on the mobile compared to the java applets on the websites.
 
Some computers are using the SUN standard interpreter and some the MS Virtual Machine.
Sun and Microsoft never could agree on one standard and some older javascripts (sun standard) cannot run on MSVM and Sun won't allow MS to copy the code... - lawsuits and so on.... - its a mess - in particular for the users. Ouch
 
 
 
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.

This page was generated in 0.063 seconds.