| Author |
 Topic  |
|
Etymon
Advanced Member
United States
2385 Posts |
 Posted - 21 December 2006 : 15:09:07
|
Lory,
What version of Snitz did you start with?
What version of Snitz are you using now?
Etymon< |
 |
|
|
skellyx
Starting Member
24 Posts |
Posted - 21 December 2006 : 17:00:48
|
Hi Etymon
I have looked for until now :) in the control panel I have found
[Snitz Forums 2000 Version 3.4.03]
excuse for the whole trouble that I give you
Kiss
Lory< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 22 December 2006 : 09:38:02
|
Hi Lory,
I haven't forgotten about you.
I am having to chase down an odd error for the one of the sites I am modifying. The error is unrelated to my fixes since I haven't uploaded anything yet. LOL! So, give me a little bit to get this taken care of, and then I'll get back to the MOD.
Thank you for understanding.
Etymon
< |
|
|
|
skellyx
Starting Member
24 Posts |
Posted - 22 December 2006 : 10:14:40
|
No problem Etymon you already make me a big gift the whole time that serves take ( but it is understood what I write with the translator ah ah :) )
I make you best wishes ...Marry Christmas and happy new year
Hi .Lory *** =^.^=
< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 22 December 2006 : 23:38:44
|
Hi Lory,
I fixed the problem. I can take a look at the MOD now.
I'll try to write in simple English from now on since you are puting my words through a translator.
Etymon
< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
|
|
skellyx
Starting Member
24 Posts |
Posted - 23 December 2006 : 05:16:21
|
Hi Etymon tested error is
Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in table 'FORUM_FORUM'.
cforum/admin_topics.asp, line 1098
if you must work so much only for me it is not important you are very kind but I am sorry it.
Hi and kiss< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
|
|
skellyx
Starting Member
24 Posts |
Posted - 23 December 2006 : 12:55:48
|
Ok I try to eliminate the relationships in the database.
I try on a copy of the forum so I don't make damages :):)
if I succeed I write what I have done.
Thank Etymon
Sincerely ..Lory ***< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 23 December 2006 : 18:56:27
|
Sounds good.
And, if you don't succeed, still post your results.
Etymon
< |
|
|
|
thermal_seeker
Junior Member
United Kingdom
430 Posts |
Posted - 24 February 2007 : 18:31:09
|
everything appears goes well and the topic appears to archive ok but at the last screen I get this error...
All replies to the topic ...
testing
were successfully archived!
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error '80040e14'
The name '0' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
/Forum/admin_topics.asp, line 808
line 808 being:
my_conn.execute(strsql),,adCmdText + adExecuteNoRecords
when I look the replies have gone but the original topic is still there in the forum and shows replies are there but the replies have gone.
trying to un-archive what was archived I do not see what I have archived listed.
any ideas??
EDIT: I have just done a search of the forum and what appears to have happened is that the replies have been deleted!!
I have just tried again on a test topic with 5 replies and the same thing happens.. replies deleted and main topic still in the forum showing that there are 5 replies to the topic when in fact they have been deleted.
EDIT 2: If I try and re archive the topic (the one that the replies were deleted from) I get this error...
No replies were archived: None were found
Microsoft OLE DB Provider for SQL Server error '80040e14'
The name '0' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
/Forum/admin_topics.asp, line 808
so does this mean your MOD only archives replies and not the topic??
Dave
< |
No good at coding, but I can plough a field !! |
Edited by - thermal_seeker on 24 February 2007 19:02:37 |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 24 February 2007 : 22:49:30
|
The way the standard archive process works with a clean install of Snitz is that the reply ids are first copied over to the FORUM_A_REPLY table (the table containing archived reply ids) and then deleted from the FORUM_REPLY table (the table containing non-archived reply ids).
Next, the originating post (the topic id) that is associated with those replies is copied over to the FORUM_A_TOPICS table (the table containing archived topic ids), and then deleted from the FORUM_TOPICS table (the table containing non-archived topic ids).
The topic id is the pivoting factor in determining where the replies are located. This is true for both the topic.asp and the search.asp pages. The topic id is tracked to determine which table it is in. The logic is this: If the topic is in the FORUM_A_TOPICS table, then the replies are also in the FORUM_A_REPLY table, and that is where the replies are retrieved from ... and vice versa ... if the topic is in the FORUM_TOPICS table, then the replies are in the FORUM_REPLY table and retrieved from there.
In the FORUM_TOPICS table, for each topic id, there are fields associated with it, such as category id, forum id, etc. There are also another two fields that record the number of replies associated with that topic id. Those are the counts that you are seeing and the counts are carried with the topic id not the reply ids.
If you are able to download the database and look into the FORUM_A_REPLY table, you should see that the replies are all there. I believe that your replies are intact. However, the reference to them is absent only in that the process to associate the topic id to them was ended due to the content of the topic id. What you probably have is a topic id that is not archived and reply ids that are archived.
I included a SQL check using the variable RevealSQL on line 116. Make sure it is set to equal 1. Can you post the SQL that RevealSQL reveals previous to line 808?
< |
Edited by - Etymon on 24 February 2007 22:53:20 |
|
|
|
thermal_seeker
Junior Member
United Kingdom
430 Posts |
Posted - 25 February 2007 : 05:43:38
|
ahhh now that makes sense..
As I got errors last night I put my backup files back in place as today is a tad busy and I will not have time for the forum stuff, I will however do this at the start of next week.
presumably when I did a search for a word that I know was in the archived topic reply, it didn't find it because the topic wasn't archived??
also I did comment line 116 out so as not to reveal the SQL statements.
Dave< |
No good at coding, but I can plough a field !! |
|
|
|
ReAX222
Starting Member
4 Posts |
Posted - 15 November 2007 : 11:49:06
|
I too am having trouble with table relationships. I was getting
quote:
Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in table 'FORUM_MEMBERS'.
cforum/admin_topics.asp, line 958
I uploaded the file you made for Lory and I downloaded my database and deleted the relationship to forum_members. Do I need to bring it back down and delete all of the relationships?< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 15 November 2007 : 23:29:00
|
What version of Snitz are you running?
What MODs do you have installed?
What database are you using?
I may have to rework the MOD. It's about time for an update on it anyway.
Thank you for the report. I am sure it will help someone else out as well.
Etymon
< |
Edited by - Etymon on 15 November 2007 23:43:26 |
|
|
|
Topic |
|
Archive One Topic MOD 1.0a
