Marked 197 Report post Posted May 31, 2009 Hello everyone, I've had to come back because of some sort of abnormality in the database. Kiriashi made a topic about it: http://www.rmxpunlimited.net/forums/index.php?showtopic=2734 The member didn't register 27 times, that account actually has replicated itself 1,117 times. While testing on my offline test-boards, I discovered that this member was causing an error, but there was only one account. After deleting that account to solve the problem, it duplicated itself and has continued to do so for about 24 hours. So I decided to do the job I had originally set out to do in the last announcement topic I made. The database has been cleansed of all components and mods, and all other unoriginal database information. I had tested this before and it worked fine, but on the live board it wasn't so simple. I'm unsure if I was successful in stopping the account from duplicating, but the forum is currently operating so it could be worse. Okay so what this means is that the forum no longer has any custom components(except gallery, downloads & blogs). I'm sure this will annoy a few people, but I think this was necessary to do to try and stop that error in the database. What I need from all of you guys is if you find any errors, please report them. Either post them in this topic, or email me. I'm still away studying but if anything major comes up that I need to fix then I will come to fix it. I think there will be errors around the forum, and im saddened to say that the lag is somehow still here. Share this post Link to post Share on other sites
Jesse66126 4 Report post Posted May 31, 2009 Wow,an account that duplicates itself infinitly? Is that why we had such a high member count? Yet less than like 200 are ever on ever? Share this post Link to post Share on other sites
Marked 197 Report post Posted May 31, 2009 Wow,an account that duplicates itself infinitly? Is that why we had such a high member count? Yet less than like 200 are ever on ever? No. The replicating account does not increase the member count, it just adds entries into the database. I think the member count you see in the forum statistics increases everytime a registration is completed. For example, we have 5000 members but the last member's ID is 9101. The reason for the high member count and low activity is probably because of the downloads manager or other resources you can get. Thats why I'm seriously considering removing all of those things. As I've said before, we just attract leeches. But that is my fault. Unfortunately the member is still replicating so I inserted him back into the database(the original) using an old backup. Deleting that is what set it off, so hopefully this will stop it. The links in the drop-down menus that are no longer working are now in red. I think its possible that the lag is caused by files. I'm not sure, but if that is the case then I do a fresh upload and get rid of it once and for all. It may take some time, but I'm confident I will get rid of it. EDIT: Since the quick fix for the duplicating member, there have been no more duplications made. After some testing, the files are not relating to the forum lag. If you see any spambots around, please report them. There were a lot of spam topics made, bur since I have deleted them and reinstalled our security system. Sorry this has been so disastrous... Share this post Link to post Share on other sites
Jesse66126 4 Report post Posted May 31, 2009 BloodQueen was saying something about there being a setting that disables a member from doing anything else until they've made 5 posts that were approved by a staff member. That's how it is on WoWBeeZ,a WoW Private Server Forum. That forum is also powered by InvisionFree. Also there's a setting that you have to have your account approved by an administrator to even get registered. That's a lot of stress to put on the staff though. Share this post Link to post Share on other sites
Polraudio 122 Report post Posted May 31, 2009 BloodQueen was saying something about there being a setting that disables a member from doing anything else until they've made 5 posts that were approved by a staff member.That's how it is on WoWBeeZ,a WoW Private Server Forum. That forum is also powered by InvisionFree. Also there's a setting that you have to have your account approved by an administrator to even get registered. That's a lot of stress to put on the staff though. Yea you can but like you said it would be a pain. We wouldn't want to do this cause our forum don't have enough activity and it will drive members away. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Yeah that sounds helpful but not for this forum. It just couldn't work. Share this post Link to post Share on other sites
Joey 9 Report post Posted June 1, 2009 Actually on my end the page loading seems fine now...i think its still there but its not that bad... Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 What are you talking about Joey? i think its still there but its not that bad What's "it"? Share this post Link to post Share on other sites
Joey 9 Report post Posted June 1, 2009 The page loading lag thing. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Page loading lag? Oh yeah. I have that too it sucks. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Page loading lag? Oh yeah. I have that too it sucks. LOL. I clicked Add Reply to post: "Page loading lag? Oh yeah. I have that too it sucks.", but it gave me this error and I had to hit the back button. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Page loading lag? Oh yeah. I have that too it sucks. LOL. I clicked Add Reply to post: "Page loading lag? Oh yeah. I have that too it sucks.", but it gave me this error and I had to hit the back button. Share this post Link to post Share on other sites
Joey 9 Report post Posted June 1, 2009 ....I can see that...lol. ....I can see that...lol. ....I can see that...lol. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Oh, wow. Triple post. Sorry. xD Thats ironic how that happened right after I mentioned lag. xD WAIT WHAT!? NO MORE ARCADE?! That sucks I liked the arcade.. :( Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Oh, wow. Triple post. Sorry. xD Thats ironic how that happened right after I mentioned lag. xD WAIT WHAT!? NO MORE ARCADE?! That sucks I liked the arcade.. :( Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Oh, wow. Triple post. Sorry. xD Thats ironic how that happened right after I mentioned lag. xD WAIT WHAT!? NO MORE ARCADE?! That sucks I liked the arcade.. :( EDIT: DAMN I did it again. I guess I am clicking reply more than once. I didn't know it would do this. Sorry guys this will stop.. I hope. Share this post Link to post Share on other sites
Joey 9 Report post Posted June 1, 2009 lol... lol... lol... (woohoo you get three lols from me. XD) Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Hey man now you are spamming. Say something about databases or something. Share this post Link to post Share on other sites
Joey 9 Report post Posted June 1, 2009 Yeah I know...I'm used to posting in your threads. >_> Sorry guys, lol. EDIT: I see that the "blank page" thing still exists here, lol...just got it randomly. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 Yeah I know...I'm used to posting in your threads. >_>Sorry guys, lol. EDIT: I see that the "blank page" thing still exists here, lol...just got it randomly. What do you mean by blank page? Are you getting an error? Share this post Link to post Share on other sites
Joey 9 Report post Posted June 1, 2009 Nope, just a blank white page, it doesn't happen often but it happens at random. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted June 1, 2009 This probably has to do with the "Database Cleanup". Share this post Link to post Share on other sites