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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 JET error '80004005' Line 92/admin_config_colors
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  01:40:20  Show Profile
Hi,

I use "Snitz_Forums_2000_V3_1_SR4".

Everything else works.

I tried a couple of things, such as reloading the offending file (admin_config_colors.asp), but that did not make the least bit of a difference.


My error (Line 92/admin_config_colors.asp):

Microsoft JET Database Engine error '80004005'
Field 'FORUM_CONFIG.C_STRLINKTEXTDECORATION' cannot be a zero-length string.
/forum/admin_config_colors.asp, line 92



I did as Davio recommended in another user's post with a fairly similar problem and added the string right before line 92 (line numbers added for this message):
92: Response.Write(strSql)
93: my_Conn.Execute (strSql)
94: Application(strCookieURL & "ConfigLoaded") = ""


After I did that, I received the following read-out (I added the carriage returns to make it more readable):

UPDATE FORUM_CONFIG SET
C_STRDEFAULTFONTFACE = 'Verdana, Arial, Helvetica',
C_STRDEFAULTFONTSIZE = '"2">2',
C_STRHEADERFONTSIZE = '"4">4',
C_STRFOOTERFONTSIZE = '"1">1',
C_STRPAGEBGCOLOR = 'white',
C_STRDEFAULTFONTCOLOR = 'midnightblue',
C_STRLINKCOLOR = 'darkblue',
C_STRLINKTEXTDECORATION = '',
C_STRVISITEDLINKCOLOR = 'blue',
C_STRVISITEDTEXTDECORATION = '',
C_STRACTIVELINKCOLOR = 'red',
C_STRHOVERFONTCOLOR = 'red',
C_STRHOVERTEXTDECORATION = '',
C_STRHEADCELLCOLOR = 'midnightblue',
C_STRHEADFONTCOLOR = 'mintcream',
C_STRCATEGORYCELLCOLOR = 'slateblue',
C_STRCATEGORYFONTCOLOR = 'mintcream',
C_STRFORUMFIRSTCELLCOLOR = 'whitesmoke',
C_STRFORUMCELLCOLOR = 'whitesmoke',
C_STRALTFORUMCELLCOLOR = 'gainsboro',
C_STRFORUMFONTCOLOR = 'midnightblue',
C_STRFORUMLINKCOLOR = 'darkblue',
C_STRTABLEBORDERCOLOR = 'black',
C_STRPOPUPTABLECOLOR = 'navyblue',
C_STRPOPUPBORDERCOLOR = 'black',
C_STRNEWFONTCOLOR = 'blue',
C_STRTOPICWIDTHLEFT = '100',
C_STRTOPICNOWRAPLEFT = 1,
C_STRTOPICWIDTHRIGHT = '100%',
C_STRTOPICNOWRAPRIGHT = 0 WHERE CONFIG_ID = 1

Microsoft JET Database Engine error '80004005'

Field 'FORUM_CONFIG.C_STRLINKTEXTDECORATION' cannot be a zero-length string.

/forum/admin_config_colors.asp, line 93


The error now pops up in line 93 after I added the extra line to dump out the code.


Any help greatly appreciated!

Andreas.



AR
Starting Member

17 Posts

Posted - 30 April 2001 :  01:49:06  Show Profile
I had this post originally added at this location:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=7175&FORUM_ID=34&CAT_ID=10&Topic_Title=Microsoft JET Database Engine error %2780040e14%27&Forum_Title=Help%3A General

There's also part of the discussion now (my post is no longer there).
Sorry for the cross-over.

Andreas.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 30 April 2001 :  01:51:18  Show Profile
can you e-mail your admin_config_colors.asp file to:

richard_kinser@yahoo.com

I looked at the source of the output of admin_config_colors.asp and there are:

" where there should be "

> where there should be >
Go to Top of Page

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  02:02:59  Show Profile
File sent!

Thanks.

Andreas.

Go to Top of Page

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  02:11:00  Show Profile
Interesting....

I just did a search for " & g t ; " and " & q u o t ; " (without extra blanks, of course) from within InterDev on this file... didn't come up with either one...

Weird.

Andreas.



Edited by - AR on 30 April 2001 02:12:53
Go to Top of Page

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  02:24:10  Show Profile
Yep, now I saw those too... (using the browser's "View-Source" option).

Andreas.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 30 April 2001 :  02:55:39  Show Profile
I didn't find anything in either config.asp or your database that would cause this.

Did you download the admin_config_colors.asp, that you sent me, from your server?
Go to Top of Page

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  09:57:44  Show Profile
Yes, I retrieved the latest version and then emailed to you "as is"... I too couldn't find anything that looked wrong.

Andreas.

Go to Top of Page

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  10:11:42  Show Profile
I just sent you those files again. This time I used ftp to retrieve them. Last time I used Microsoft InterDev ("Get latest version"). Anyway, maybe that makes a difference?

Later,

Andreas.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 30 April 2001 :  17:17:46  Show Profile
I replied to your e-mail. Seems InterDev might be messing with the code in that file. I would suggest you get a fresh copy of admin_config_colors.asp from the .zip file you downloaded from here and just FTP to upload it instead of InterDev.
Go to Top of Page

AR
Starting Member

17 Posts

Posted - 30 April 2001 :  18:05:12  Show Profile
Thank you that solved the problem!

(I ftp'ed the orig. file to my server directory and all went fine after that. When opening the file under InterDev ALL APPEARED fine... it must have messed it up at the moment of closing&releasing...)

Andreas.



Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 30 April 2001 :  19:27:45  Show Profile
You're welcome

Glad it's all fixed now.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07