Fehler in der Datenbank behoben

Dear visitor, welcome to Amorphophallus-Forum.de. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Shreck

Administrator

Posts: 979

Location: Klettwitz

Sunday, August 21st 2011, 11:29pm

Fehler in der Datenbank behoben

Hello

certainly one or the other noticed that in searching topics and posts showed up several times and then in some contributions we user as there were unregistered. I have now corrected this error.

The reason is simple. When you import of the database, the software has every topic and every single post! written 5 x in the database.

Unregistrierete users have always the ID 0 in the database table. So I me the tables for the contributions and the topics sorted by the user ID and the server said it is to delete all posts and threads with the user ID 0

By hand, we would have used moderators years

There were over 2000 themes that were copies and over 18,000 posts: shock:, now all gone.

Thus, no double posts are there.

There have already tested and also again looked at the database. There are all copies of the threads and posts out.

Pure working time: 5 minutes

MfG
Stephan

Meine aktuelle Bestandsliste

Go to the top of the page

Mr. Titanum

Administrator

Posts: 3,621

Location: Uetze

Monday, August 22nd 2011, 10:05am

Dank dem Admin !

Hi Stephan,.

Congratulations to the skillful train!
Beautiful, that is the conversion of the Forum forward.

Notice you already what of the integration of facebook (in terms of access to the Forum and new members)?

Happy administration, Bernhard.