| Author |
 Topic  |
|
GauravBhabu
Advanced Member
4288 Posts |
 Posted - 04 December 2002 : 02:16:47
|
SELECT FIELDNAME FROM TABLENAME WHERE ((FIELDNAME) Is Null); |
 |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 04 December 2002 : 05:41:20
|
I ran the update, Davio, and it said "successful."
Running the archive function again, however, produced the same results:
quote:
No Replies were Archived: none found
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/messageboard/admin_forums.asp, line 581
I am using Table Editor beta 0.81 to look at my Access 2000 database. I could download the db & look locally with Microsoft Access 2000.
I just opened it again to look at the FORUM_A_TOPICS table. Now, I see some blank fields next to some properly archived posts under the T_ISPOLL column. ???? Some, have "0" ... |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 04 December 2002 : 12:52:10
|
Oh yeah ... I keep re-commenting. Here you go: [I'll leave them uncommented till this gets resolved!]
quote:
No Replies were Archived: none found
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
INSERT INTO FORUM_A_TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG, T_EVENT_DATE, T_ISEVENT) VALUES (4, 15, 91, 0, 'Congrats & Thanks!', 'Caitlin, Jeff, & Dominique .... Just wanted to congratulate & wish you all well with the little one! When is the expected arrival???? Ayesha - Haven''t had time to call you yet but .... THANK YOU! Ayesha & Colin just returned from a trip to Turkey!!!! Having determined beforehand that she really wanted to visit Ephesus, that great apostolic city, Ayesha''s determination paid off & I am the most fortunate recipient of beautiful photos & gorgeous, very special gifts!!!!! Ayesha, I hope to reach you by phone soon but want to thank you & invite you to post those pictures here!!!!! Incredibly beautiful ... Many, many thanks ... you are such a wonderfully sweet person! Lainey ', 19, 0, 0, 51, '20020624111208', '20020621175405', 0, '65.217.41.224', 11, 547, '', NULL, 0, , 0, 0 , '', 0 )
|
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 December 2002 : 13:03:15
|
This red part is where your problem is:
INSERT INTO FORUM_A_TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE,
T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG, T_EVENT_DATE, T_ISEVENT) VALUES
(4, 15, 91, 0, 'Congrats & Thanks!', 'Caitlin, Jeff, & Dominique .... ', 19, 0, 0, 51, '20020624111208', '20020621175405', 0, '65.217.41.224', 11, 547, '', NULL, 0, Something should be here, 0, 0 , '', 0 )
Once more, it's the T_ISPOLL field. Make sure all your topics records have the expected value for this field. Maybe executing that DBS code that Davio posted will fix it. Better do it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 04 December 2002 13:04:43 |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 04 December 2002 : 18:32:47
|
Ruirib, I did run Davio's update, with no noticeable positive effect.
Let me ask, what is the expected value supposed to be? Zero?
Also - are you saying I need to go through my database & put a "0" in every topic's T_ISPOLL field? In just the FORUM_A_TOPICS? Or, EVERY topic? 'm not clear on this stuff. Please walk me through what it is I should be doing?
This seems very strange - because there are no polls in this forum that I just tried to archive. In addition, I have been able to previously archive other forums with no problems at all. I don't understand what is going on here!
I appreciate all the time and effort you guys put into all the problems folks like me throw your way! I really do! |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 December 2002 : 18:59:35
|
I don't know what value should be there, since I don't know the Poll mod. I think you need to run that update on the TOPICS table:
[UPDATE]
TOPICS
T_ISPOLL#0#T_ISPOLL = NULL
[END]
Try it and let me know. Of course, I don't know where the value for T_ISPOLL is coming from. Don't know if it should come from the table or assigned directly by a statement if the value in the table is NULL, since I don't know the Poll mod, as I wrote.
Anyway, try that and then try to archive the topics again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 04 December 2002 : 20:16:55
|
Ran the code ... "values updated successfully." 
Tried to archive that forum for the umpteenth time. Result:
quote:
No Replies were Archived: none found
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
INSERT INTO FORUM_A_TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG, T_EVENT_DATE, T_ISEVENT) VALUES (4, 15, 91, 0, 'Congrats & Thanks!', 'Caitlin, Jeff, & Dominique .... Just wanted to congratulate & wish you all well with the little one! When is the expected arrival???? Ayesha - Haven''t had time to call you yet but .... THANK YOU! Ayesha & Colin just returned from a trip to Turkey!!!! Having determined beforehand that she really wanted to visit Ephesus, that great apostolic city, Ayesha''s determination paid off & I am the most fortunate recipient of beautiful photos & gorgeous, very special gifts!!!!! Ayesha, I hope to reach you by phone soon but want to thank you & invite you to post those pictures here!!!!! Incredibly beautiful ... Many, many thanks ... you are such a wonderfully sweet person! Lainey ', 19, 0, 0, 51, '20020624111208', '20020621175405', 0, '65.217.41.224', 11, 547, '', NULL, 0, , 0, 0 , '', 0 )
  |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 December 2002 : 23:15:33
|
When archiving the topics, the admin_forums.asp file selects the values of the fields from the topics table to move them over to the archive table. I included the poll mod fields in that select statement. It then should update|insert that value into the archive table.
The default value of the T_ISPOLL field should be 0.
Richfed, do you have the table editor online? That I could by some chance take a look at the database myself? But only allow me access if you trust me. Otherwise we would have to continue looking to see what the problem is.
- Did you have some problems when you installed the poll mod? Maybe you made some tests posts to get the poll mod working but it wasn't.
- Is your poll mod working ok? No problems?
- Do you know any difference between the topics that have the default value of 0 for the T_ISPOLL field and the ones that are empty? (if you dont't understand this, don't have to answer)
- Are there more empty T_ISPOLL fields than the field filled in with 0, or are there more T_ISPOLL fields filled in with 0 than empty fields? |
Support Snitz Forums
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 December 2002 : 23:22:42
|
| FYI: There is only one place the T_ISPOLL field is updated and that is when you create a new poll. It is updated with the value of 1 (1 meaning the topic is a poll, 0 meaning the topic is not a poll). Otherwise the value should be 0. Everywhere else the field is selected. |
Support Snitz Forums
|
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 05 December 2002 : 05:10:45
|
Hi Davio ...
The poll MOD installed & updated with no errors [I had the previous version for 3.3xx, thus the update - I DID NOT DO STEP 3!].
As far as I know, the poll is functioning correctly. We have quite a few polls going, and I've noticed nothing wrong. A few folks claimed they couldn't vote, but I believe that was all related to peeking first.
Of course I trust you!!! I will e-mail you with the info you need to access my database. Thank you - VERY MUCH!
E-mail sent at 5:15 AM EST - Let me know if you don't receive it. |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
Edited by - richfed on 05 December 2002 05:19:25 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 December 2002 : 12:51:15
|
I got it. Looked at your topics table and found only 5 topics that had the T_ISPOLL field blank. I sucessfully updated 3 out of the 5 with the value of 0. The last 2 said I couldn't update the record, and blah blah blah.
We can get around this by placing a check in admin_forums.asp to check if T_ISPOLL is empty. If it is empty we can just replace it with the value 0.
I can't give you exact code or lines to do this now as I am at work. When I get home I'll give you the rest of the info. |
Support Snitz Forums
|
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 06 December 2002 : 05:12:39
|
| OK, Davio ... thanks for the effort! Look forward to getting this resolved! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 December 2002 : 21:53:52
|
Here you go, afterline 564 in the admin_forums.asp file, add the code in red:if isnull(drs("T_UREPLIES")) then
intT_UREPLIES = "NULL"
intT_UREPLIEScnt = 0
else
intT_UREPLIES = drs("T_UREPLIES")
intT_UREPLIEScnt = drs("T_UREPLIES")
end if
if isnull(drs("T_ISPOLL")) then
intISPOLL = 0
else
intISPOLL = drs("T_ISPOLL")
end ifThen change line 579 from this:strsqlvalues = strsqlvalues & "', " & intT_LAST_EDITBY & ", " & drs("T_STICKY") & ", " & drs("T_ISPOLL") & " , " & 0 & ", " & drs("T_SIG") & " "to this:strsqlvalues = strsqlvalues & "', " & intT_LAST_EDITBY & ", " & drs("T_STICKY") & ", " & intISPOLL & " , " & 0 & ", " & drs("T_SIG") & " "That should catch the empty fields. Let me know how it goes. |
Support Snitz Forums
|
|
|
|
Topic |
|
|
|
Topic Locked
