Thank you simplistik.
I will try and look into that this week. I will keep you posted.
Hi simplistik.
The plugin has been updated with your changes.
Good job man, thanks for the timely response 🙂
If we have been using this plugin for a while is there a way to clean the DB of these extras?
Fortunately anything that calls from the options table isn’t dependent on the id, so you can actually “dump” your options table and recreate it. I put together this relatively easy workflow for my company to fix the inflated increment.
1. Save your DB. Personally, you can just save the wp_options (or whatever you’ve prefixed it with).
2. Completely Optional: I recommend just removing any transient data from the DB, since it’s all temporary and won’t affect your site, you can do that by running this MySQL query:
DELETE FROM wp_options WHERE option_name LIKE '%transient%';
3. Run this MySQL query which will re-increment your table:
SET @count = 0;
UPDATE wp_options SET option_id = @count:= @count + 1;
4. Reset the options increment, run this MySQL query:
ALTER TABLE wp_options AUTO_INCREMENT = 1;
Note: wp_options might (should) change depending on what you’ve prefixed your tables with.
In what page I have to remove?
