Web Wiz Forums - 8 character file name limit???

8 character file name limit???

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=22922
Printed Date: 07 April 2026 at 11:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: 8 character file name limit???

Posted By: simkissrdns
Subject: 8 character file name limit???
Date 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

Replies:

Posted By: simkissrdns
Date Posted: 18 March 2007 at 2:39pm

anyone have a clue on this? i'm stumped.

Posted By: simkissrdns
Date 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.)

Posted By: simkissrdns
Date 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.