- This topic has 18 replies, 2 voices, and was last updated 7 years, 9 months ago by Jim Gaiko.
June 3, 2015 at 2:36 pm #10346
Hi, I have a license for “WPFront User Role Editor Personal Pro – Up to 5 Sites” and on one of the sites I activated it on, the plugin lost the licsense and I had to re-enter the license to get it to be fully functional again. The plugin was never uninstalled, de-activated, it just suddenly lost the license key. Unfortunately, this gave access to capabilities that a user role I had set up wasn’t supposed to have. Any ideas how this might have happened?
I currently have version 2.9.3 of the plugin installed. Would upgrading to version 2.10 fix this issue?June 3, 2015 at 8:25 pm #10361
There are only three reasons why it would deactivate.
1. Deactivated from Go Pro page.
2. Deactivated from wpfront.com purchase history.
3. Site home URL changed.
Is there any chance that one of these would have happened? How many times did this happen? Did you check your purchase history before activating again to see whether that site exists within the list?
I understand that how this will be an issue from a security stand point. I’ll add email notification with grace period and audit trails in next version so that you will be notified on accidental deactivation with enough time to reactivate. Nothing changed in v2.10 on licensing functions, so I doubt it.
SyamJune 4, 2015 at 9:05 am #10417
Strange, I didn’t do any of those 3 items, and yet it deactivated. It’s happened at least once, maybe twice. I did not check the purchase history before activating it again, but will do that if it happens again.
I’ll keep a close eye on it in the coming days/weeks, and will let you know if it happens again.
And some sort of grace period and email notification would be very helpful rather than it lapsing silently and making capabilities available to people who should have very limited access. Thanks!June 4, 2015 at 9:47 am #10420
Thanks Jim, next version will have the notification and grace period.June 5, 2015 at 5:05 pm #10604
The license deactivated on its own again. When it was deactivated, the license page on your site still said the license was being used by my website, but it was deactivated on my website.June 5, 2015 at 5:34 pm #10605
Sorry about that. Is it possible for you to give me access to your site? Here are the details I’ll need. An Administrator account on your site and FTP access, so that I can replace files.
ThanksJune 5, 2015 at 6:29 pm #10606This reply has been marked as private.June 5, 2015 at 9:45 pm #10634
Can you also give me access to mysql admin? I want to check the values stored in the database.
It looks like the basic cause of this issue is, updating the license status field in DB, deletes the license key from DB. I have no idea why that would happen.
SyamJune 6, 2015 at 8:58 am #10649This reply has been marked as private.June 6, 2015 at 10:04 am #10653
I understand if you don’t want me to have mysql access. But backup/restore method will take considerably long time rather than mysql admin.
I think I found the basic cause. The ‘id’ column from ‘wpfront_ure_options’ table always returns zero, which makes the values overwrite each other. That column is supposed to be an ‘auto_increment’ so it should never be zero. Can you check the values of that column? And also make sure it is set as auto_increment. Do a test insert into that table and check the ‘id’ value. You also mentioned you have a development site. Do the same checks there too.
SyamJune 6, 2015 at 12:22 pm #10655
I checked the live site and the development site.
On the live site, the ‘id’ column is not set to auto-increment, but on the development site it is. The problem of the license deactivating hasn’t happened on the development site, so I think you are correct in your diagnosis of this issue.
However, when I try to change the ‘id’ column to auto-increment on the live site, I get this error: “#1075 – Incorrect table definition; there can be only one auto column and it must be defined as a key”. What do you suggest?June 6, 2015 at 5:11 pm #10659
Try making that as a primary key. Can you think of a reason, why the auto increment got removed?June 7, 2015 at 5:52 am #10661
I tried making it the primary key, but doesn’t like that there are multiple rows with 0. Does it matter what values I give for the “id” for these?
I have no idea how this happened, I’ve not modified the database structure, just copied it directly from my development environment when I set up the live server. It’s set up properly on the development environment.June 7, 2015 at 8:25 am #10665
The value doesn’t matter. It just needs to be unique.June 7, 2015 at 9:08 am #10666
Thanks, I made the fixes to the db, and now the table is set to auto-increment. I’ll keep an eye on this in the coming days and will let you know if the problem returns. Thanks for your assistance.
- The topic ‘License deactivating mysteriously’ is closed to new replies.