Bug 3.2.4 Bloating wp-options table with duplicate rows

  • Resolved The Old Man

    (@graham-smith)


    1 year, 4 months ago

    Hi,

    The plugin v3.2.4 seems to flooding my wp_options table with duplicate rows.

    Duplicate entry 'as3cf_constant_AS3CF_SETTINGS' for key 'PRIMARY'

    SELECT * FROM wp_options WHERE option_name LIKE 'as3cf_constant_AS3CF_SETTINGS';

    ?Showing rows 0 - 24 (67985 total, Query took 0.0004 seconds.)

    Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi @graham-smith!

    WP Offload Media Support Team here. Thanks for reaching out with your query! We would be happy to assist.

    Can you kindly let us know what plugin version was used before upgrading to the latest version?

    Would you be able to send the debugging information from the Support tab on the site you’re having trouble with?

    1. Go to the Support tab of your install

    2. Scroll down to the “Diagnostic Info”

    3. Paste it here in your next reply

    Thread Starter The Old Man

    (@graham-smith)

    Hello! Thanks for the reply.

    Can you kindly let us know what plugin version was used before upgrading to the latest version?


    I’ve ran the plugin for a long while so I’m assuming it would have been v3.2.3.

    Screenshots of the issue:

    https://www.dropbox.com/scl/fi/o6nvj731y857wbqn8crvn/IMG_2228.jpg?rlkey=1hdxlovziqvlqats0jem1uodk&dl=0

    https://www.dropbox.com/scl/fi/cqyed6f9u90pq41cqt5yn/IMG_2227.jpg?rlkey=zzrrxtqns63r8xr0u9zbqwwzt&dl=0

    However, it may not be down to the actual plugin. I’ve come to the realisation it may not be representative of your plugin but more a symptom of the index configuration was probably not preventing duplicate rows by using a unique index. I don’t know what the actual existing index configuration was before without looking at my backups, but removing all the duplicates bar one then applying a unique index to the table has stopped it reoccurring. I assumed previously that the plugin was inserting new rows instead of updating an existing row if it already exists.

    The current index configuration:

    Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment

PRIMARY	BTREE	Yes	No	option_name	741	A	No
option_id	BTREE	Yes	No	option_id	741	A	No
autoload	BTREE	No	No	autoload	4	A	No

    I found the same issue and similar number of duplicate rows with the Smart Crawl plugin, and you can see discussion here:

    https://www.ads-software.com/support/topic/repeating-wds_blog_tabs-rows-bloating-wp_options-table/

    Thank you.

    • This reply was modified 1 year, 4 months ago by The Old Man.
    • This reply was modified 1 year, 4 months ago by The Old Man.
    Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi @graham-smith ,

    Thanks for letting us know how you were able to resolve the issue. I don’t think we have encountered this issue before, but the additional information you provided may help in the future if we encounter something similar.

    Feel free to message us again if you have any other concerns.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Bug 3.2.4 Bloating wp-options table with duplicate rows’ is closed to new replies.