Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - 8 character file name limit???
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

8 character file name limit???

 Post Reply Post Reply
Author
simkissrdns View Drop Down
Newbie
Newbie


Joined: 18 March 2007
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote simkissrdns Quote  Post ReplyReply Direct Link To This Post Topic: 8 character file name limit???
    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
Back to Top
simkissrdns View Drop Down
Newbie
Newbie


Joined: 18 March 2007
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote simkissrdns Quote  Post ReplyReply Direct Link To This Post Posted: 18 March 2007 at 2:39pm
anyone have a clue on this?  i'm stumped.Confused
Back to Top
simkissrdns View Drop Down
Newbie
Newbie


Joined: 18 March 2007
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote simkissrdns Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
simkissrdns View Drop Down
Newbie
Newbie


Joined: 18 March 2007
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote simkissrdns Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.