1
naarjtie
Some parts of my website are being repeated - strange phenomenon
  • 2005/12/8 1:17

  • naarjtie

  • Just popping in

  • Posts: 10

  • Since: 2005/12/8


I'm having a really annoying probem with XOOPS at the moment. I've just launched my site last week and it's in a few newspapers on Friday and Saturday so i'm trying pretty hard to get this sorted but i'm pretty stuck.. anyway, on with the problem.

Pretty much, some things on the site are being repeated - listings in my address module (Version 1.5 click XOOPS listing of module) as well as where it says the moderators for each forum.

An example of the forums, click here.

An example of the double listing in the address book, click here.

The problems were noticed after I did a failed upgrade from v.2.0.9.2 to v.2.0.13.1. My other XOOPS website on the same server, messed up pretty badly and it had to be backed up from an earlier copy.

Is there any way I can fix this, or what would you recommend?

Thanks in advance.

2
brash
Re: Some parts of my website are being repeated - strange phenomenon
  • 2005/12/8 2:20

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


I've had a very similar issue with the Mydownloads and Mylinks modules. For the past 2 years in a row when the new year has clicked over, for some strange reason these module decide to duplicate all the content. Have a read of this thread;

Double Post Problem
IT Headquarters
Innovative IT Solutions

3
naarjtie
Re: Some parts of my website are being repeated - strange phenomenon
  • 2005/12/8 20:07

  • naarjtie

  • Just popping in

  • Posts: 10

  • Since: 2005/12/8


Thanks for the reply Brash.

Quote:
Anyway, as the problem involes duplicate records, you cannot use an SQL statement to simply delete the unwanted data. What I did to fix it was export the appropriate database table(s) to an SQL file and then manually deleted each duplicate record. I then removed (dropped) that table(s) from the database and imported my modified SQL file back into the database. Not perfect, but a hell of a lot better than starting again.


I've not been using XOOPS for long, and before this i've only been using HTMl. Where abouts can I find the appropriate database, or is there a guide or anything I could go off?

Thanks

4
highlander
Re: Some parts of my website are being repeated - strange phenomenon
  • 2005/12/8 20:49

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Hi Naarjtie,

You'll need to find the duplicate rows in the database and delete them.
You can do this with a database tool like PhpMyAdmin which you probably have (most hosts istall it as standard)

As its only 32 adresses and a couple of double moderators it should not take long.

If you are unsure I am sure someone here can help if you PM the url to PhpMyAdmin.

greetings Highlander
So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
http://www.AnimalPedigree.com

5
naarjtie
Re: Some parts of my website are being repeated - strange phenomenon
  • 2005/12/8 23:17

  • naarjtie

  • Just popping in

  • Posts: 10

  • Since: 2005/12/8


I've just had a look in the database.. there are no duplicate rows.

Furthermore, if you look at thislink, you will see some links are repeated and some aren't.

The 'Baby Judas' listing at the top was only included today which may be why it wasn't repeated, however the Jusure link at the bottom wasn't repeated either and that was one of the first submitted. Very incosistent, and kinda alarming.. can anyone help? I'm considering having to wipe the whole thing but that would take ages, and if I had to wipe the forums i'd loose all the posts..

Login

Who's Online

250 user(s) are online (148 user(s) are browsing Support Forums)


Members: 0


Guests: 250


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits