Snitz Forums 2000 - Profile with long country name generates SQL error

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Bug Reports (Closed)

Profile with long country name generates SQL error

Forum Locked

Topic Locked

Printer Friendly

Author

Topic

tobycerqua
Starting Member

USA
15 Posts

Posted - 21 January 2002 : 15:14:25

if a particularly long country name -- for instance, "Virgin Islands (United Kingdom)" is chosen in a profile, the following error is generated:

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

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

/forum/pop_profile.asp, line 959

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 21 January 2002 : 15:28:59

Have you tried setting the length for the country field in the members table to 60 instead of the default value?

Roland

- here to help when possible -

http://www.frutzle.com
Also for logo requests!

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 21 January 2002 : 15:30:06

this is already addressed in the next version (v3.4).

We increased the size of the FORUM_MEMBERS.M_COUNTRY field from 20 characters to 50 characters.

Topic

Forum Locked

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.09 seconds.