Question [Topic archived by moderator] Recent Discussions/My Discussions show multiple copies of same post.

Okay, just uploaded the default_ex template back up to server via FTP from the latest build package of Kunena... No change.

Thanks

When/how this started? Did you do something just before recent discussions broke up?

It looks like our query fails to group threads together. I just cannot understand why And you do not have this issue in the category view?

I noticed this just shortly after upgrading to .11 but I don't know if it's related to that. It IS happening in the category view as well.

If I go into a topic there is just one copy of the record as there should be.

The only thing I've done recently to the forums is that I moved a topic from one forum to another but that was before the upgrade and it appeared to have worked.

Thanks for your time.

I found that the fb_users table is the problem, I just don't know what the cause is. The table has multiple records for each user. It appears that something is adding users to this table and I'm not sure what. It does look like each time the program has been upgraded 1.5.9 -> 1.5.11 -> 1.5.11 -> uninstalled and then re-installed to 1.5.11 it has added two more copies of each user to the fb_user table.

Looking at the upgrade.xml file included with Kunena, I believe that the "add_key" function didn't work on my upgrades. I believe because the tables are in the wrong collation. Should they be UTF8_General_ci for Kunena? Everything on my site is, except the FB tables.

Thanks for any help. Hope I'm making some sense.

There are a few possible reasons for this kind of bugs:

1) Do you have custom code in Kunena?
2) Does your fb_users table have primary key on userid?

Collation does not matter (except it breaks UTF-8 characters), but it tells that you have used FB or K1.0 before. Did you also have J1.0? I ask this because migration scripts from J1.0 to J1.5 tend to break jos_fb tables.

PS: in our wiki is an article how to fix collation.

1) Do you have custom code in Kunena?

No custom code...

2) Does your fb_users table have primary key on userid?

It did not have a primary key on userid. It appears that the update file attempts to create that custom key. It did not on my table I tried to create the key manually with the sql statement used in the upgrade script and it errored indicating that there was already a column with that name. (also because I have duplicate userids right now.) The question I've got now is how to clean that user table up...

Could I empty it, add the primary key to user id and re-sync users in Kunena?

Yes, this site was originally on 1.0 and migrated to 1.5.

Thanks!