| Author |
 Topic  |
|
Andy Humm
Average Member
United Kingdom
908 Posts |
 Posted - 06 May 2009 : 09:27:21
|
I have experienced an error message when trying to create an additional forum under the category heading. On submitting the new forum heading and details I get the following error:
Microsoft JET Database Engine error '80004005'
Field 'FORUM_FORUM.F_LAST_POST' cannot be a zero-length string.
/forum/post_info.asp, line 1584
Is it something to do with database settings or coding within post_info.asp (text file here)
I have version 06 and using access db
I notice the db settings for L_POST are set required to 'no'
Any help would be appreciated |
Edited by - Andy Humm on 06 May 2009 09:34:07 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 06 May 2009 : 10:05:56
|
Yes but get the following:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/forum/search.asp, line 349
?????
I did search as much as poss... |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 06 May 2009 : 13:52:16
|
ok, tried access alone : No Matches Found hence asking in Help: General / Current Version (v3.4.xx)
Any previous forum headings can be edited but it is only we try to add a new forum heading.
line 1584:
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 06 May 2009 : 14:48:31
|
Okay thank you -
Looking at my access database the T_LAST_POST properties, the allow zero length field is set to NO.
Rather than downloading the whole db file and changing the property, is there some quick code to use in the admin features of Alternative MOD Setup
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 06 May 2009 : 16:15:22
|
Is this what you was referring to?
2eNetWorX TableEditoR v0.81 Beta
quote:
Originally posted by ruirib
There was an Access database management script that allowed Db changes online, but I can't remember the name.
Not recommended by me to be put on to a production website, maybe an intranet. |
Cheers,
David Greening |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 06 May 2009 : 17:02:48
|
| thank I think it might be easier if I take the forum down for a few minutes while I make the adjustments.. |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 06 May 2009 : 19:13:38
|
| All sorted there were so many db fields with the allow zero length field is set to NO Changed to yes and hey presto . Thank you ruirib |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 May 2009 : 06:27:28
|
| Careful... some of them you don't want to allow zero length fields... |
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 07 May 2009 : 08:10:19
|
What modifications have you made to your code, there is no mention of F_LAST_POST anywher near line 1584, and you should not have to make any changes to the default access database, certainly not to the allow zero length property anyway.
|
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 07 May 2009 : 16:16:05
|
| Thats right Huwr, line 1584 has my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords but I think it might be associated with the split topic mod??? Not sure. I file compared this file and the spilt topic code is there along with <!--#INCLUDE FILE="cal_post_info1.asp" --> ConfusedDotCom!!!! |
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 07 May 2009 : 17:10:01
|
| The main reason I ask about modifications etc is that the database that comes with snitz already has F_LAST_POST set to allow zero length strings, so am intrigued as to why your database would be different |
|
|
|
Topic |
|
Topic Locked
