WPIntell

Source evidence

Prefix cause cleanup to fail

Optimize Database after Deleting Revisions · support · 2024-07-11T07:40:00+00:00

mixedsentiment
mediumseverity
0.85relevance
4replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

4 / 31 rows with source links

12.9% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

27 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
antoinek95 resolved
Hi, The plugin wants to optimize table that starts with wp_, though my database has ap_ as prefix, is there a way to modify the prefix to be target by the plugin ? Best Regards, AK Hi @antoinek95 , The plugin should work fine with a prefix other than wp_ , as long as it’s correctly defined in the WordPress settings (in wp-config.php ). Are your ap_ tables additional, custom tables, that are separate from the regular WordPress tables? Or is your entire WordPress installation using the ap_ prefix? If you go to Tools > Site Health, then click on “Info” at the top, and then expand the “Database” Section, what is the “Table prefix” shown? Thanks, Andrew Hi Andrew, my entire DB is using the ap_ prefix and this is confirmed when I go to the database section of Status Health Info on the website. Cheers, AK Hi AK, Sorry for taking a bit to respond. We’ve tested the plugin extensively with different prefixes, so we’re not sure why there’s an issue in this case. Can you please share a screenshot of your settings page? In particular, we’d like to see the section below the first “Save Settings” button that lists all the individual database tables by name. Also, could you please share the details in Site Health > Info> Database? If you’d prefer to share that confidentially, you can email it to us as support @ nerdpress . net. Thanks, Andrew Hi AK, Since we haven’t heard back in a couple of weeks, and we can’t reproduce this issue on our end, I’m going to mark this as “Resolved” for now. If you want to dig in again, though, please send the above info and we’ll be happy to take another look! Thanks, Andrew

Comments

4 shown
NerdPress 2024-07-11T14:39:00+00:00

Hi @antoinek95 , The plugin should work fine with a prefix other than wp_ , as long as it’s correctly defined in the WordPress settings (in wp-config.php ). Are your ap_ tables additional, custom tables, that are separate from the regular WordPress tables? Or is your entire WordPress installation using the ap_ prefix? If you go to Tools > Site Health, then click on “Info” at the top, and then expand the “Database” Section, what is the “Table prefix” shown? Thanks, Andrew

antoinek95 2024-07-16T07:47:00+00:00

Hi Andrew, my entire DB is using the ap_ prefix and this is confirmed when I go to the database section of Status Health Info on the website. Cheers, AK

Andrew Wilder 2024-07-22T21:16:00+00:00

Hi AK, Sorry for taking a bit to respond. We’ve tested the plugin extensively with different prefixes, so we’re not sure why there’s an issue in this case. Can you please share a screenshot of your settings page? In particular, we’d like to see the section below the first “Save Settings” button that lists all the individual database tables by name. Also, could you please share the details in Site Health > Info> Database? If you’d prefer to share that confidentially, you can email it to us as support @ nerdpress . net. Thanks, Andrew

NerdPress 2024-08-07T00:39:00+00:00

Hi AK, Since we haven’t heard back in a couple of weeks, and we can’t reproduce this issue on our end, I’m going to mark this as “Resolved” for now. If you want to dig in again, though, please send the above info and we’ll be happy to take another look! Thanks, Andrew