[Fix] Duplicate UIDs on Import - v1.8x

[vtm]

Dean

I upgraded to v1.82 on one host - appeared to be fine.

Repeated on a 2nd host and got 'Could not select database
MySQL Error: Access denied for user: 'XXX@localhost' to database 'YYY'

Any thoughts? The first host has only a handful of lists, the faulty one probably 50 lists. Unfortunately, this dbase was created before they switched to a new system and it's no longer visible in my control panel - though it has been working fine for 6 months.

thanks
Laurie

[BGSWebDesign]

Hi DW,

I have verified that this is a v1.8x-specific bug.

Whew... that's a strange one, well, I guess I can finally count on an upgrade now to 1.8x, is everyone certain this bug is fixed, GLUNTZ, has it solved your problem?

Congrats on the fix DW, that was fast, and encouraging!

Keep up the great work on LMP!

[DW]

Wouldn't you know I made a small mistake and you should re-download v1.82 as per my 2nd email...  :x  :oops:

Basically, after I made the fix I un-did it so I could test the upgrade process - I then released the files before re-doing the fix...  I have (again) implemented and verified the change that prevents duplicates on import and updated the v1.82 distribution file.

Regards

[DW]

Laurie,

On the "faulty" installation do you have any problems using the program?  I don't see why you would receive that error message if the program works as usual - the MySQL database access is exactly the same...

Regards

[chris6]

I have done the upgrade and still have duplicate UID's

I downloaded my whole database so I could check for duplicated in Excel and had 247 duplicate UID's I did the upgrade and downloaded my database again and I now have 112 duplicates. It seems to have only done half.
No I did not interrupt the program.
What now?
Gail Cardell

[vtm]

Dean

That message appears when I try to log on. I can't actually get into the program. Although I have since received the dailymail cron report, so perhaps it is still working.

Laurie

[DW]

Laurie / Gail,

Please submit your server information so I can investigate.

Regards

[DW]

Gail/All,

I ran a stress test for the v1.82 upgrade process and couldn't find any problems.

1. I re-instated the old, failing, UID creation routine.  In just 17,000 users imported I had generated at least 100 duplicate IDs with between 2 and 25 copies each.(!)  I stopped it here, though I know some of you will have 100,000+ users...
2. I changed the DB version (lm_config -> cver) to "1.8" and re-logged in to initiate the upgrade.  It took awhile, about 8 minutes and there were no longer any duplicate UIDs.

Gail, did your login/upgrade page show "Done!" and then present the login box?  I suppose it did because if it hadn't you would receive the upgrade message again on the login page (since it updates the DB version last..)

I can't find evidence that this will be a widespread issue..  Did you, perhaps, do an import AFTER upgrading to the first revision of v1.82?  As mentioned in a 2nd email, this could cause further duplicate ID's that need to be fixed by running the upgrade again (by modifying the version to 1.8...)  As per my email, I'm offering hands-on assistance for those affected by the oversight as I expect it will be just a few users.

Man.. these little oversights can sure become time consuming, can't they.  I won't give up - I'll be working on the next update, with more features and improvements (and bugs! ), as soon as I get this issue squared away.  One day, heaven help me, I'll make a release without making a mistake.

Onward...

[chris6]

I have upgrade to 1.82 and can no longer edit any email addresses.

[DW]

:shock: I wonder if your lm_users table became corrupted because of all of the access in the upgrade script.  Maybe the MySQL service was restarted part-way through the upgrade.  Don't panic - you should be able to run some PhpMyAdmin SQL commands to resolve this type of issue:

ANALYZE TABLE lm_users

REPAIR TABLE lm_users

You can set the "cver" field in the lm_users table to "1.8" and re-login to run the upgrade / de-duper script again.

Please submit your info for this installation if you want me to take a look.

PS. I'm having trouble sending email to your AOL address right now.

Regards

[chris6]

I need this resolving,
I can't do the MYSQL bit's your quoting to me?
What do I need to do now that this fix has unfixed my data?

[chris6]

Do you want the MYSQL log in details too?
you can also email me at gail@<edit>

[DW]

Thanks for your updated email address - I'm working on it.  I will update this post again (for everyone else reading) when your issues are resolved.  PS. Did you get my latest reply to your new email?  I'm awaiting a response.

Regards

[chris6]

I've sent two responses now.
Please go ahead and run the UID fix now.

[DW]

I rebooted my server but it was only down for a few minutes - I'm not sure why you can't get email through to me.  I'm going to re-run the upgrade script in an attempt to de-dupe your UIDs.  Since you didn't mention it, are you able to save your users now?  My testing, where I modified some of your users, didn't come up with any errors.

Regards