I Broke The Forum

[Gteuk]

Hey all, while I was trying to sort out the spamming issue my browser done a dive during the deleting known spammers as I restarted the browser it gave me the option to open last session which I thought was a good idea until it told me it deleted 14,000 users (including me) from the database :(

 

I am trying my hardest to incorporate the backup into the system but it is proving more difficult as it keeps crashing the database I will try to resolve ASAP but at the moment I have been on it for near 20 hours and it will not allow merging of the backup with the existing Database :(

 

Sorry for the inconvenience, on the good side spam should reduce :(

[kfk]

Well Done.........when you have finished restoring the forum maybe you reset my password for the control panel :-)

[kfk]

......................ignore that, its working and let me in.

[Gteuk]

over 24 hours of trying the database will not allow the import of new members and it will show all posts before today as guest posts, the reason for this is as it deleted the users it deleted the AuthorID from the posts, the forum will now work, I will not resync the post counts as this will show as zero, Really sorry for the problems,

 

Some users may have to reregister on the site as I was only able to import members upto december or their abouts after that a corrupt record would not let be go any further and It will not allow fix or deletion of the record without trashing the member database :(

 

I have set it to backup more regularly now, the backups take a lot of space so were not as frequent, I have now set to backup more frequently and delete old backups.

 

SPAMMING ISSUE

 

I have found a trend in the spamming and have used that trend to reduce the spamming, this is not to say that I have stopped it as some of the spammers are actual humans on the site but for the BOT version I may have reduced it considerably until they change their programs that is.

 

Thank you for your years of support, this forum has had its fair share of troubles and I hope this is the last of them.

[Gteuk]

Update

 

I am at present running some scripts to re index the the member IDs in topic and posts along with the topic starter ID and Last post ID, the scripts are resource hungry mainly due to the size of the database, so it is causing access problems to this site at the moment. due to this I am stopping and starting the script to allow access and to free up resources,as well as trying to tweak the script to work faster.

 

Sorry for the problems.

[Gteuk]

For those unable to log in I am sorry it is not possible to reinstate your account from the database, Please reregister using the same username and I will try to reinstate your post and topic links, I can only do this if you use the same name though.

[Gteuk]

Because this is taking so long I am going to leave the scripts until night time now so between the hours of 00:00 and 8:00 there will be disruption to service till I get this all fixed.

[kfk]

What a way to spend your weekend!

[Gteuk]

Well since I broke it I suppose I should try to fix it, a number of new members will have to re register but I am confident that I can get it sort of back upto date, it does make you realise how much data there is though as so far it has only fixed the old posts upto 2008, I might see if I can make the script work backwards.

[Gteuk]

test