Web Wiz Forums - Registering problem

Print Page | Close Window

Registering problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=429
Printed Date: 29 March 2026 at 7:45pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Registering problem

Posted By: damage
Subject: Registering problem
Date Posted: 22 February 2003 at 1:46pm

Hi guys, 1st thing, Fantastic forum, works a treat.

I have a problem on mine with new users registering, but only certain user names.. Its the 7 beta 3 version.
If i try to register as JCS=TESF=1066AD i get this error

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/forum/register.asp, line 744

I get no alert in the registration page saying that there is anything wrong with the username?

If i register as =1066= it works fine, so i dont think the = sign is the problem, any ideas??

Thanks

Replies:

Posted By: damage
Date Posted: 22 February 2003 at 1:55pm

I just tryed it on this one, with the same name as above and it worked ok, dont know if this helps

Posted By: Bunce
Date Posted: 22 February 2003 at 4:42pm

http://www.adopenstatic.com/faq/80040e21.asp - http://www.adopenstatic.com/faq/80040e21.asp

Might help..

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: damage
Date Posted: 23 February 2003 at 5:17am

Thanks for the reply Andrew,

I looked at that, and this seems to be my problem

This error is caused when you try to insert too much data into a specified field. For example if you enter a string that is 20 characters long into a field that is defined as varChar(10), or if you try to insert a value greater than 2¹⁵ (approx 2.1 billion) into an Integer field.This error is caused when you try to insert too much data into a specified field. For example if you enter a string that is 20 characters long into a field that is defined as varChar(10), or if you try to insert a value greater than 2¹⁵ (approx 2.1 billion) into an Integer field.

The thing is, the field that u type the username into when u register is restricted to 15 characters, it wont let you type any more than that. If i enter 111111111111111, it works, but if i try the name i stated above, i get the error. But if i type less charcters with an = sign, it works??

Any othe r ideas?

Posted By: TYSON
Date Posted: 23 February 2003 at 5:26am

Could it be that with borg's security function of converting certain characters to the ascii equivilent that this would increase the number of chars once converted?

-------------
http://www.fuo-motorsports.com/ - http://www.fuo-motorsports.com/

Posted By: damage
Date Posted: 23 February 2003 at 5:32am

I think you are right,

If i enter damage=tesf=

It fails to register, i get the error

But if i enter, dama=tesf= , it works ok

also works ok with 15 normal charcters

Is there anyway i can change this?

Thanks

Posted By: damage
Date Posted: 23 February 2003 at 6:02am

Its ok, i fixed it, just increased the filed size in the DB for passwords, username, username code and salt (whatever that is, lol)

Might be worth changing that in the dowload files?

Thanks anyways guys, great forum