| Author |
 Topic  |
|
richfed
Average Member
United States
999 Posts |
 Posted - 02 December 2002 : 04:37:43
|
Sure. See: Admin Forums Text File
quote:
Originally posted by ruirib
What is the DB problem? Better start a new topic for that one, but if it's MOD related, better post in this forum again.
I just need to match up the topics, with 0 replies, that weren't archived, to their missing replies, that apparently were ... that is the topics that were over 4 months old, that I tried to archive, stayed behind, yet all their replies appear missing [I assume in the archive table]. |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
 |
|
|
red1
Junior Member
355 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 02 December 2002 : 06:45:47
|
| Are you certain your FORUM_A_TOPICS and FORUM_A_REPLY tables have the new columns that the Event Mod added ? |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 02 December 2002 : 06:54:15
|
quote:
Originally posted by red1
can you try replacing line 598 with this one:
", T_EVENT_DATE = '" & drs("T_EVENT_DATE") & "'" & _
Made the change, here's the latest error message:
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 believe the message "topic exists," refers to this situation. For some reason, the two oldest threads were archived in their entirety, as normal. Yet, they also show up in with the non-archived topics [minus their replies - as is the same with all the other supposedly archived topics - topics still there; replies gone. Ony those two threads made it over to the archives.]
So, Gremlin, it would appear that the changes must have been made to the tables you refer to. I also ran the dbs file again last night, and it said that the tables already existed.
I have to go to work, but I'll look at the database at lunchtime & see if they are surely there. |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
red1
Junior Member
355 Posts |
Posted - 02 December 2002 : 07:09:53
|
| Uncomment lines 579-580, the ones that say 'Response.Write strSql & 'Response.End then look at the sql string in the output |
My Mods:
New Events Calendar
New Non-database Active Users |
Edited by - red1 on 02 December 2002 07:12:10 |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 02 December 2002 : 12:40:47
|
Here's the results, Red1:
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 )
Will report back with what I find in my database shortly ... |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 02 December 2002 : 12:51:31
|
Columns in FORUM_A_TOPICS Table:
quote:
CAT_ID FORUM_ID TOPIC_ID T_STATUS T_MAIL T_SUBJECT T_MESSAGE T_AUTHOR T_REPLIES T_VIEW_COUNT T_LAST_POST T_DATE T_LAST_POSTER T_IP T_LAST_POST_AUTHOR ANSWER1 COUNT1 ANSWER2 COUNT2 ANSWER3 COUNT3 ANSWER4 COUNT4 ANSWER5 COUNT5 ANSWER6 COUNT6 ANSWER7 COUNT7 ANSWER8 COUNT8 T_LAST_VOTE T_ISPOLL T_STICKY T_TOPSTICKY T_MSGICON T_LAST_EDIT T_LAST_EDITBY T_SIG T_LAST_POST_REPLY_ID T_UREPLIES T_EVENT_DATE T_ISEVENT T_POLLSTATUS T_NOTELET_STATUS T_NOTELET_LAST_DATE T_NOTELET_EDITBY T_NOTELET_MESSAGE
Columns in FORUM_A_REPLY Table:
quote:
CAT_ID FORUM_ID TOPIC_ID REPLY_ID R_STATUS R_MAIL R_AUTHOR R_MESSAGE R_DATE R_IP R_MSGICON R_LAST_EDIT R_LAST_EDITBY R_SIG
Let me know what's next! |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
red1
Junior Member
355 Posts |
Posted - 02 December 2002 : 20:19:08
|
Your columns look ok. Can you try replacing line 574 with this:
strsqlvalues = strsqlvalues & "', " & intT_LAST_EDITBY & ", " & drs("T_STICKY") & ", '" & drs("T_ISPOLL") & "' , " & 0 & ", " & drs("T_SIG") & " " |
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 03 December 2002 : 05:28:35
|
No, Red1, that didn't work either. Archiving that forum again gave the same result:
quote:
All replies to Topics older than 8/3/2002 5:16:22 AM were archived
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/messageboard/admin_forums.asp, line 581
Uncommenting lines 579 & 580 gave this:
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 )
 ????
I updated my Admin_Forums Text File
Browsing topics in this forum, I just discovered a similar thread at : http://forum.snitz.com/forum/topic.asp?TOPIC_ID=38676 Could the Poll Mod be the culprit here? |
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 03 December 2002 06:14:47 |
|
|
|
red1
Junior Member
355 Posts |
Posted - 03 December 2002 : 12:07:35
|
| Yes its the value of T_ISPOLL that isn't set correctly. Can you open your database and put a zero value for T_ISPOLL for this topic that you want to archive?? |
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 03 December 2002 : 12:41:42
|
| I'm unclear as to want you are asking me to do ... assign a zero value to a topic [there are a couple of dozen topics that didn't archive properly - no polls] or to the T_ISPOLL field itself? If the latter, the value is already set to zero, according to the table. |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 03 December 2002 : 12:59:12
|
This doesn't make any sense at all to me ... there are no polls in the entire forum in question. There are events, though none are due to be archived.
As I've said, the two earliest threads in this forum archived normally, though they still also show in the forum itself - minus the replies! All the other threads that were supposed to be archived are now reduced to topics only - replies are gone, presumably archived [with no topic!].
I have successfully archived other forums in the past, though they are devoid of both polls AND events. Not sure if any of this is relevant, just want to be sure you can understand my situation. |
|
|
|
red1
Junior Member
355 Posts |
Posted - 03 December 2002 : 19:41:05
|
ok, you can restore line 574 to this one:
strsqlvalues = strsqlvalues & "', " & intT_LAST_EDITBY & ", " & drs("T_STICKY") & ", " & drs("T_ISPOLL") & " , " & 0 & ", " & drs("T_SIG") & " "
since that didn't work.
The problem is that it's returning a blank value for T_ISPOLL that's why sql string is causing an error. I don't know exactly what's causing it; maybe you can wait for Davio to help you as he's better at this than I am
|
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 03 December 2002 : 19:41:27
|
quote:
Originally posted by red1
Yes its the value of T_ISPOLL that isn't set correctly. Can you open your database and put a zero value for T_ISPOLL for this topic that you want to archive??
I just re-read this and it suddenly made sense ... sorry! Yes, the T_ISPOLL value seems already to be set at 0 for all topics in the table. |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 December 2002 : 01:51:31
|
Hmm, I have a few ideas as to why the T_ISPOLL field would be blank. It could be that when then poll mod was installed, the database didn't populate the new T_ISPOLL field with the default value of 0 in the A_TOPICS table. But you already said it has 0 for all the values. If it does have 0 for each row of data in the table, then why isn't it being selected?
What database are using again? (If you posted it previously, forgive me. I missed it, and I don't want to stop typing right now.  )
And what program do you use to look at the database data?
You could try this little bit of code using your "Alternate MOD Setup" file in the admin options:[UPDATE]
A_TOPICS
T_ISPOLL#0#T_ISPOLL = NULL
[END] I'm not sure how to search for an empty integer field. I know searching for an empty string field you would use '' but you can't do that with interger type fields. I'm a bit rusty on my sql queries, hopefully one of the guys who are more greased than I am with sql queries will correct me if I am wrong.
Let me know if that code update does anything. It not, we can try something else. |
Support Snitz Forums
|
|
|
|
Topic |
|
|
|
Topic Locked
