| Author |
 Topic  |
|
|
mtn_roadie
Starting Member
USA
18 Posts |
 Posted - 15 August 2002 : 03:18:19
|
I'm receiving the following error when I try to add a new forum category:
Microsoft JET Database Engine error '80004005'
Field 'FORUM_FORUM.F_L_ARCHIVE' cannot be a zero-length string.
/clients/forum/post_info.asp, line 896
I'm not sure why I'm receiving this now.... here's what I've done.
v3.3.03 - kept up with the updates that have been released over the past several months and added the fixes as they were posted.
-I moved the forum to a new site; backed up copies of everything.
-Uploaded the database and all files to the new site.
-Ran some tests to make sure everything was OK; added forums / topics / members, etc... All went well for the most part.
-Then used the new v3.3.05 setup.asp file to upgrade the forum (per many posts I've read here).
-Everything seemed to go OK, however, now when I add a new forum category, I receive the above error.
Looking at the Insert statement for the error, it appears that it is actually not inserting anything at all (no requests, just ''). And the database (the copy I saved), has this field set to Not Allow Zero Lengths.
Is there something supposed to be inserted into the 'FORUM_FORUM.F_L_ARCHIVE' field when a new category is created?
Or am I safe to assume I should just change this field to allow zero lengths?
|
::kindler chase::
Roubaix Interactive
http://www.roubaixinteractive.com |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 August 2002 : 03:20:56
|
| You can just change it to allow zero length string |
 |
|
|
mtn_roadie
Starting Member
USA
18 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 August 2002 : 03:38:16
|
| holds a date string indicating the last time a particular forum was archived. |
|
|
|
mtn_roadie
Starting Member
USA
18 Posts |
|
|
mtn_roadie
Starting Member
USA
18 Posts |
Posted - 15 August 2002 : 03:55:35
|
As an FYI: the FORUM_FORUM.F_L_DELETE has the same error and needs to have the field changed to allow zero length as well.
Did the setup.asp file modify these database fields? or have they always been set to not allow zero length? |
::kindler chase::
Roubaix Interactive
http://www.roubaixinteractive.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 August 2002 : 04:01:23
|
| did you open your database in Access and save it from within Access? |
|
|
|
mtn_roadie
Starting Member
USA
18 Posts |
Posted - 15 August 2002 : 04:13:54
|
| Yes, I opened/saved from within Access (Access 2k). Both before running setup.asp (when no errors were occurring) and after running setup.asp to change the 2 fields in question to correct the errors. |
::kindler chase::
Roubaix Interactive
http://www.roubaixinteractive.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 August 2002 : 04:19:49
|
| for some reason it affects some people and not others. The fix is just what you did, to change the attribute. |
|
|
|
mtn_roadie
Starting Member
USA
18 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 August 2002 : 04:32:47
|
| you're welcome. |
|
|
| |
Topic |
|
Topic Locked
