Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 Forum describtion too long		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rsiera
Starting Member

4 Posts
Posted - 07 May 2001 :  17:16:56  Show Profile
You get this error if your Message in which you describe a new forum is too long.

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

/forum/post_info.asp, line 696
------------------------------

ldgjr
Starting Member

USA
6 Posts
Posted - 10 May 2001 :  10:39:01  Show Profile
To add future information with the same root cause. When running against SQL Server 6.5, it causes an SQL Server error but with a much more obscure message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 


[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from datatype 'text' to datatype 'varchar' 
Table: 'ATForum.f_atweb.FORUM2_FORUM', Column: 'F_DESCRIPTION' Use the CONVERT function to run this query. 


/RMforum/inc_footer.asp, line 7


The error checking should be done in the code somewhere before it hits the database and provide a more reasonalble message.



Edited by - ldgjr on 10 May 2001 16:04:45
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20593 Posts
Posted - 10 May 2001 :  11:48:18  Show Profile  Visit HuwR's Homepage
This is because you are trying to add more than 255 characters to the database, either add fewer characters, or change the size of the description field to a memo
Go to Top of Page

ldgjr
Starting Member

USA
6 Posts
Posted - 10 May 2001 :  16:03:48  Show Profile
HuwR,

I think we both understand the root cause of the error. My point (and I think rsiera) was that I consider having the DB drivers detect the data entry error to be neither graceful nor good programming practice.

To me, the software should do an error check and put up the appropriate message -- or just truncate the Message to 255 characters and proceed to avoid the error in the DB driver.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 09 March 2002 :  01:53:18  Show Profile
This has been fixed by changing the F_DESCRIPTION field to a TEXT (or MEMO in Access) field.

fixed in v3.4
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07