| Author |
 Topic  |
|
|
retro
Junior Member
123 Posts |
 Posted - 18 March 2002 : 17:22:47
|
In the last three months, this same thing has happened and it's starting to get really scary.
For some reason, replies are getting reassigned to a single post. To fix this, I have to go in and read every single reply and then try to figure out which post they are going to. The first time this happened, it was when I used the "Update Forum Count" feature. The second time it happened, it was when I archived -- which uses the "Update Forum Count" feature as well. It happened again this weekend and my SQL database spit out a nasty message (which I posted in the SQL help area).
Today, I am finding that it's doing it again. Take a look at this thread:
Look at the date of the original post and then look at the date of all the replies. Each of these replies was to a completely different topic but now is pointing to this topic.
My forum is the stock 3.3.03 with the active users, active chatters, and photo gallery mods installed. I don't think any of these mods is to blame because the problem occurred prior to any of these mods being installed.
I really don't relish the thought of losing my data or having to go through my SQL database on a weekly basis to ensure that replies are pointing to the right place.
CAN ANYONE HELP???!!?? Please say you can....
Sean
Edited by - Retro on 10 May 2002 17:11:01 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 March 2002 : 17:32:02
|
Check your FORUM_REPLY and FORUM_TOPICS Tables for Triggers. If there are triggers set on these tables then delete them.
If you upsized from an access database using the upsizing wizard then this is one way that can occur.
www.daoc-halo.com |
 |
|
|
retro
Junior Member
123 Posts |
Posted - 18 March 2002 : 17:33:29
|
Gremlin,
Thanks for the quick reply. I did upsize from an Access database to SQL. How do I check to see if there are triggers?
Thanks again!
Sean
Edited by - Retro on 10 May 2002 17:11:14 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
retro
Junior Member
123 Posts |
Posted - 18 March 2002 : 19:14:45
|
I see the code that Ken posted. Is it safe to assume that this is the fix for removing the trigger? If so, do I just drop the code into and .asp page and load the page?
Seems to me that everyone in this previous discussion felt that this was a very serious issue, yet the discussion regarding it died last year. Seems that a patch is in order.
Thanks again for your quick responses!
Sean
Edited by - Retro on 10 May 2002 17:11:30 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 March 2002 : 19:19:16
|
Yes drop Ken's code into an ASP page and run it.
The discussion kinda died becuase it was resolved, we've been warning people ever since (where we can) not to use Upsize Wizard.
It's possible that the Devs have also updated the readme.txt file in the latest version to warn against it also, but I can't confirm that.
Perhpas that post should also be placed into the Access and SQL FAQ sections here ?
www.daoc-halo.com |
|
|
|
retro
Junior Member
123 Posts |
Posted - 18 March 2002 : 19:26:55
|
THANKS, THANKS, THANKS!!! I have said it before, and I'll say it again..you guys and gals deserve a raise!
I went ahead and deleted the triggers by hand (found where to do it) so all should be well!
Sean
Edited by - Retro on 10 May 2002 17:11:43 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 March 2002 : 19:45:09
|
Great !!, always nice to see a happy user
www.daoc-halo.com |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 March 2002 : 19:45:55
|
quote:
The method in which those who have this problem created their SQL Database is not one that we support. The only method that we support is by using setup.asp.
Still a warning somewhere may be appropriate to try and prevent people from using an "unsupported method"
www.daoc-halo.com |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 18 March 2002 : 20:24:28
|
what if when you install the forum it puts in the config table what type of database you are using. then if you change the database type in config.asp and it does not match what database type that is stored in the database then it will give an error about upsizing can cause problems "CLICK HERE" if you did not upsize to remove this message, or something like that.
Brad
Web Hosting with SQL Server @ $24.95 per month
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 10 May 2002 : 17:42:36
|
quote:
quote:
The method in which those who have this problem created their SQL Database is not one that we support. The only method that we support is by using setup.asp.
Still a warning somewhere may be appropriate to try and prevent people from using an "unsupported method"
www.daoc-halo.com
Actually, in the pre-dbs days there was a distributed sql script file that copied the Access relationships using triggers for DRI in SQL Server. Older forums may have the same problem without ever being upsized.
This is like from pre-history (2 years ago)
======
Doug G
====== |
|
|
| |
Topic |
|
Topic Locked
