Web Wiz Support and Community Forums : 8 character file name limit??? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 01:21:23 +0000 Tue, 20 Mar 2007 13:35:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22922 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[8 character file name limit??? : ANSWER FOUND -boRg- was kind...]]> https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121377.html#121377 Author: simkissrdns
Subject: 22922
Posted: 20 March 2007 at 1:35pm

ANSWER FOUND

-boRg- was kind enough to help me find the answer to this issue, and it turns out that the database does in fact limit the number of characters that can be used for the topic icon filenames to 8.3 format (i.e. 12345678.123).  -boRg- explained that this is done in to increase the efficiency of processing and storage.
 
Therefore, if you run into this error, all you need to do is limit your topic icon filenames to 8.3 format and they will work fine.
]]> Tue, 20 Mar 2007 13:35:00 +0000 https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121377.html#121377 <![CDATA[8 character file name limit??? : more info... getting closer! How...]]> https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121367.html#121367 Author: simkissrdns
Subject: 22922
Posted: 20 March 2007 at 12:03am

more info...
getting closer! 
How can I resolve the error 80040e21?

Answer:

Error 80040e21 is an OLE DB error. The error 80040e21 indicates that the field is too small to accept the amount of data you attempted to add. For example, the error 80040e21 may be caused by trying to insert 12 characters into a SQL Server field that is formatted to accept only 10 characters. In this case, you should insert less data.
 
Somehow, that field in the database for the Topic Icons is limited to 12 characters.  So if I make the image's filename 1234568.gif, it works ok, but when I use 1234567890.gif, it gives the database error.
 
Can anyone hunt this down or replicate this problem?
(all the default smileys are 8.3 filename length so most of you probably haven't run into this problem unless you tried to rename your smileys.)
 


Edited by simkissrdns - 20 March 2007 at 12:06am]]> Tue, 20 Mar 2007 00:03:39 +0000 https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121367.html#121367 <![CDATA[8 character file name limit??? : anyone have a clue on this? i&#039;m...]]> https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121337.html#121337 Author: simkissrdns
Subject: 22922
Posted: 18 March 2007 at 2:39pm

anyone have a clue on this?  i'm stumped.Confused]]> Sun, 18 Mar 2007 14:39:56 +0000 https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121337.html#121337 <![CDATA[8 character file name limit??? : I modified the topic_icon_inc.asp...]]> https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121328.html#121328 Author: simkissrdns
Subject: 22922
Posted: 18 March 2007 at 4:20am

I modified the topic_icon_inc.asp file to include the icons that I want to use.  I did this like this exerpt...
 
saryTopicIcon(4,1) = "debate"
saryTopicIcon(4,2) = "smileys/7debate.gif"
saryTopicIcon(5,1) = "disagree"
saryTopicIcon(5,2) = "smileys/7disagree.gif"
saryTopicIcon(6,1) = "exclamation"
saryTopicIcon(6,2) = "smileys/7exclamation.gif"
However, I noticed that when I update a post if any of the filenames are longer than 8 characters, I get an error.  If it's 8 or fewer, it works fine.  What's the story here?
 
This is this error I get for icon filenames longer than 8 characters... (I did not modify the edit_post.asp file referenced in the error below by the way.)
 
SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Show_signature, tblThread.IP_addr, tblThread.Hide, tblThread.File_uploads FROM tblThread WITH (ROWLOCK) WHERE tblThread.Thread_ID=8;

Microsoft OLE DB Provider for SQL Server error '80040e21'

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

/forum/edit_post.asp, line 700

 
 
 
 
 
 


Edited by simkissrdns - 18 March 2007 at 4:25am]]> Sun, 18 Mar 2007 04:20:44 +0000 https://forums.webwiz.net/8-character-file-name-limit_topic22922_post121328.html#121328