Notice: This is the official website of the All Empires History Community (Reg. 10 Feb 2002)

  FAQ FAQ  Forum Search   Register Register  Login Login

Sql errors when trying to change profile info.

 Post Reply Post Reply
Author
Guests View Drop Down
Guest
Guest
  Quote Guests 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?
Back to Top
Northman View Drop Down
Tsar
Tsar

Suspended

Joined: 30-Aug-2004
Online Status: Offline
Posts: 4262
  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
Guests View Drop Down
Guest
Guest
  Quote Guests 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.  
Back to Top
Guests View Drop Down
Guest
Guest
  Quote Guests 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). 
Back to Top
Guests View Drop Down
Guest
Guest
  Quote Guests 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.
Back to Top
Northman View Drop Down
Tsar
Tsar

Suspended

Joined: 30-Aug-2004
Online Status: Offline
Posts: 4262
  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
Guests View Drop Down
Guest
Guest
  Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 01-Dec-2008 at 20:39
Cheers and Thanks!!
Back to Top
Guests View Drop Down
Guest
Guest
  Quote Guests 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
Caliph
Caliph
Avatar
suspended

Joined: 23-Oct-2006
Location: AUSTRALIA
Online Status: Offline
Posts: 3224
  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
Online Status: Offline
Posts: 1023
  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. 
http://www.allempires.net/forum/forums.html
Back to Top
Seko View Drop Down
Emperor
Emperor
Avatar
Spammer

Joined: 01-Sep-2004
Online Status: Offline
Posts: 8595
  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.

Back to Top
Northman View Drop Down
Tsar
Tsar

Suspended

Joined: 30-Aug-2004
Online Status: Offline
Posts: 4262
  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
Guests View Drop Down
Guest
Guest
  Quote Guests 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
Online Status: Offline
Posts: 1023
  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
http://www.allempires.net/forum/forums.html
Back to Top
Northman View Drop Down
Tsar
Tsar

Suspended

Joined: 30-Aug-2004
Online Status: Offline
Posts: 4262
  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
Guests View Drop Down
Guest
Guest
  Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 19-Dec-2008 at 01:15
Originally posted by Northman

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

Suspended

Joined: 30-Aug-2004
Online Status: Offline
Posts: 4262
  Quote Northman Quote  Post ReplyReply Direct Link To This Post Posted: 19-Dec-2008 at 01:34
Originally posted by es_bih


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

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 9.56a [Free Express Edition]
Copyright ©2001-2009 Web Wiz

This page was generated in 0.111 seconds.