The My Location duplicates bug that was submitted and has occured with several users as well as two of my sites that use Dragonfly were marked as bogus.

The has been verified by several users that it's a bug with the installer, as it creates two My Location fields in MySQL. It causes two My Location fields to appear in the user's profile and both have to have the same data to update as well. That being the case, why was this bug marked Bogus?

the installer checks user_from field (my location) and since there can't be 2 fields with the same name in a table the installer should fail.

The only problem that could occure is that there are 2 records in the cms_user_fields table with the same data.
Since nobody said how they upgraded (like 9.0.3 to 9.0.4) and that the bug only occured by a few people and we couldn't reproduce it, it is marked bogus.

If someone could exactly say after what kind upgrade and which MySQL version they use it would be more clear to debug.
The debug system does ask for several things like reproduce code/instructions, if people forget to fill in those fields we can't help.

DJMaze wrote:

the installer checks user_from field (my location) and since there can't be 2 fields with the same name in a table the installer should fail. The only problem that could occure is that there are 2 records in the cms_user_fields table with the same data. Since nobody said how they upgraded (like 9.0.3 to 9.0.4) and that the bug only occured by a few people and we couldn't reproduce it, it is marked bogus. If someone could exactly say after what kind upgrade and which MySQL version they use it would be more clear to debug. The debug system does ask for several things like reproduce code/instructions, if people forget to fill in those fields we can't help.

Server OS: Linux
Apache: Apache 1.3.33(UNIX)
My SQL: MySQL 4.1.11-standard
PHP: PHP 4.3.11
CPGNuke: CPGNuke 9.0.4.0 CVS

The issue occurs with an upgrade and even the CVS installs. I just installed the latest CVS and had to go into MySQL and remove the extra My Location field and fix the number order.

Does that help?

could you post all records from your cms_users_fields table here.
I think there's something wrong in there.

I think the two locations displayed in the profile were due to some upgrade problem, I think the other post reffered to just removing one from the DB. If I am off topic just kick me in the head and roll me in the ditch. Dont forget to stick a fork in me..

Later..

Screenshot.

Last time I installed I manually went in and deleted the duplicate, then fix the number order.

Just what i thought, someone has renumbered your table.
On entry 8 it says user_from but the installer never creates a fid with 8.
so entry 8 to 25 should have the numbers 9 to 26.

Hack even the installer fixes this by renumbering all entries. So whoever said to you to manualy renumber the entries is wrong. This does again conclude it's not a installer bug.

But when you install it has entries EIGHT AND NINE as My Location entries.

if you remove user_from fid 8 then you don't see double

xfsunoles wrote:

if you remove user_from fid 8 then you don't see double

I don't get why two are being created though.

I just manually went in and renumbered each from 8 - xx so they'd be in the right order (so I thought).

fid 8 is depreased so it removed in system. When Installer, it check field and skip fid 8 since it not exist anymore.

Why weren't the fields simply renumbered accordingly then?

because it will be used in 9.1

Fair enough. So for now just delete field 8?

yes