Snitz Forums 2000 - New member registration problem

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

New member registration problem

New Topic

Topic Locked

Printer Friendly

Author

Topic

pardus
Starting Member

South Africa
7 Posts

Posted - 09 February 2004 : 15:59:44

A few prospective members have been getting the following error when trying to register:

Microsoft JET Database Engine- Error '80040e57'

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

C:\Program Files\Abyss Web Server\htdocs\register.asp, line 7106

my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

How can I increase the field length, or is there something else I've missed?

Edited by - ruirib on 10 February 2004 08:15:57

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 09 February 2004 : 16:02:17

have you installed any mods? can you post a link to a text version of register.asp?

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

pardus
Starting Member

South Africa
7 Posts

Posted - 09 February 2004 : 16:09:34

link to register.asp.txt here> http://www.websamba.com/saeff/register.asp.txt

I added a few mods > "active users 40_17" , "Avatar" & "counter"

website link > http://www.websamba.com/saeff

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 09 February 2004 : 16:11:52

there is no line 7106 in that file. try uploading a fresh copy. also check the modifications you made to taht file.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 09 February 2004 : 16:15:55

but just a quick look, the sql statement before line 185 appears to be all out of order. same with the one before lines 193 and 594. Looks like your field names for active users and avatar mods are in one order, but then the values are the opposite order.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

pardus
Starting Member

South Africa
7 Posts

Posted - 09 February 2004 : 16:17:23

Thanks for your reply's.
I've checked the file already but I'm not that clued up with asp so may easily not spot the problem. I'll go back through it again though.

pardus
Starting Member

South Africa
7 Posts

Posted - 10 February 2004 : 00:29:49

Ok, I've double checked my mod additions to register.asp and they are exactly as laid out in the instructions for the mods. The only potential problem I can see is that the 2 mods "avatar" and "active users" modify lines very close in location to each other and that may have upset the order of things.

I don't have enough experience with asp to see where I might have gone wrong and I would like to keep the mods if I can. If anyone can help it will be greatly appreciated!

ruirib
Snitz Forums Admin