21 replies to this topic

[Marked]

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.rmxpunlim...?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.

[Jesse66126]

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?

[Marked]

Jesse66126, on May 31 2009, 07:33 PM, said:

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...

[Jesse66126]

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.

[Polraudio]

Jesse66126, on May 31 2009, 08:03 AM, said:

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.

[Kiriashi]

Yeah that sounds helpful but not for this forum. It just couldn't work.

[Joey]

Actually on my end the page loading seems fine now...i think its still there but its not that bad...

[Kiriashi]

What are you talking about Joey?

Quote

i think its still there but its not that bad

What's "it"?

[Joey]

The page loading lag thing.

[Kiriashi]

Page loading lag?

Oh yeah. I have that too it sucks.

[Kiriashi]

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.

[Kiriashi]

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.

[Joey]

....I can see that...lol.

....I can see that...lol.

....I can see that...lol.

[Kiriashi]

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..

[Kiriashi]

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..

[Kiriashi]

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.

[Joey]

lol...

lol...

lol...

(woohoo you get three lols from me. XD)

[Kiriashi]

Hey man now you are spamming. Say something about databases or something.

[Joey]

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.

[Kiriashi]

Joey, on Jun 1 2009, 01:04 PM, said:

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?

[Joey]

Nope, just a blank white page, it doesn't happen often but it happens at random.

[Kiriashi]

This probably has to do with the "Database Cleanup".