WPIntell

Source evidence

Huge postmeta DB table

Longer Permalinks · support · 2020-02-07T13:09:00+00:00

mixedsentiment
highseverity
0.94relevance
15replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

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

1 / 15 rows with source links

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

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

14 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
Yannis Develekos resolved
Hey Giannis, Thank you for the great plugin! I have two issues and I need your advice. 1) I found a database with table postmeta full of rows with meta_key value “longer-permalinks-post-name-longer”. It’s 6,5GB!!! Is it OK if I go on and delete these rows? 2) Amongst them I see meta_value with values like “2577-revision-v1” which actually replaced somehow the original URL and I have to go to the back-end and revert the URL manually. Is it a known issue? Is there a workaround? Thank you in advance, Yannis Develekos Hello Yiannis! Can you please check which plugin version was running when this happened? Was this on 1.17? Thank you. I have same problem using v 1.2 on wordpress 5.3.2 . All Mysql disk used and there are thousands of longer-permalinks-post-name-longer values in the Table. Hi @alihoseiny , were you using an older plugin version before version 1.20? Or was this a fresh install of the plugin? For a quick fix: You can safely delete all those records with that value from wp_postmeta table (value “longer-permalinks-post-name-longer”) without a problem. We cannot reproduce this problem but we are investigating the issue and will have news the soonest possible. Thank you. Thanks for you response. I’ve updated from the previous version. Thank you. Dear @alihoseiny let me ask you: Are you on a network WordPress installation or on a single WordPress website installation? Thank you. There is a new release today (version 1.21) handling related functionality. Could you please give try the updated version? Thank you. Dear @develekos @alihoseiny , the last update (v1.21) should successfully handle the problem you reported and also automatically remove any redundant postmeta records. Please do not hesitate to contact us for anything you might need. I confirm that our problem has been solved with the last update. Thank you for the immediate response @antithesisgr Thank for your response. But my problem did not solve. I still got those rows in my database. Dear @alihoseiny , so you did the update to the latest version right? About how many posts does your website have? And how many rows do you have in postmeta table with value “longer-permalinks-post-name-longer”? Thank you. Sorry for the late answer. I am using the latest version. I only have 34 posts and there are 586 rows with that value. Hi @alihoseiny , please try to go to version 1.20 and then to do the upgrade to 1.21. The upgrade to 1.21 is deleting all those values in postmeta table and generates them again, so it is possible this is normal. If you still have the problem you can follow the plugin author’s link to contact us in order to investigate specifically your case and follow up here at the end. Thank you. when i deactivated the plugin, all site links broken!! help please k i want to un install the plugin This reply was modified 6 years, 2 months ago by elmaazon . Hi @elmaazon thank you for using the support forum. If you have created longer links that than WordPress default allowance by using the plugin, after you deactivated/uninstalled the plugin all your long URLs is expected to stop working. All links that have less characters that the default WordPress limitation should be working. The long URLs will not. This is normal. Please open a new thread for more, since this thread here is not related to that. Thank you. i opend new one please help 🙁

Comments

15 shown
antithesisgr 2020-02-07T16:15:00+00:00

Hello Yiannis! Can you please check which plugin version was running when this happened? Was this on 1.17? Thank you.

Mohammadreza Alihoseiny 2020-02-13T18:16:00+00:00

I have same problem using v 1.2 on wordpress 5.3.2 . All Mysql disk used and there are thousands of longer-permalinks-post-name-longer values in the Table.

antithesisgr 2020-02-13T18:52:00+00:00

Hi @alihoseiny , were you using an older plugin version before version 1.20? Or was this a fresh install of the plugin? For a quick fix: You can safely delete all those records with that value from wp_postmeta table (value “longer-permalinks-post-name-longer”) without a problem. We cannot reproduce this problem but we are investigating the issue and will have news the soonest possible. Thank you.

Mohammadreza Alihoseiny 2020-02-13T18:57:00+00:00

Thanks for you response. I’ve updated from the previous version. Thank you.

antithesisgr 2020-02-13T19:35:00+00:00

Dear @alihoseiny let me ask you: Are you on a network WordPress installation or on a single WordPress website installation? Thank you.

antithesisgr 2020-02-13T20:50:00+00:00

There is a new release today (version 1.21) handling related functionality. Could you please give try the updated version? Thank you.

antithesisgr 2020-02-18T09:37:00+00:00

Dear @develekos @alihoseiny , the last update (v1.21) should successfully handle the problem you reported and also automatically remove any redundant postmeta records. Please do not hesitate to contact us for anything you might need.

Yannis Develekos 2020-02-18T10:01:00+00:00

I confirm that our problem has been solved with the last update. Thank you for the immediate response @antithesisgr

Mohammadreza Alihoseiny 2020-02-27T15:21:00+00:00

Thank for your response. But my problem did not solve. I still got those rows in my database.

antithesisgr 2020-02-28T13:49:00+00:00

Dear @alihoseiny , so you did the update to the latest version right? About how many posts does your website have? And how many rows do you have in postmeta table with value “longer-permalinks-post-name-longer”? Thank you.

Mohammadreza Alihoseiny 2020-03-06T08:58:00+00:00

Sorry for the late answer. I am using the latest version. I only have 34 posts and there are 586 rows with that value.

antithesisgr 2020-03-06T12:59:00+00:00

Hi @alihoseiny , please try to go to version 1.20 and then to do the upgrade to 1.21. The upgrade to 1.21 is deleting all those values in postmeta table and generates them again, so it is possible this is normal. If you still have the problem you can follow the plugin author’s link to contact us in order to investigate specifically your case and follow up here at the end. Thank you.

elmaazon 2020-03-26T21:25:00+00:00

when i deactivated the plugin, all site links broken!! help please k i want to un install the plugin This reply was modified 6 years, 2 months ago by elmaazon .

antithesisgr 2020-03-27T08:21:00+00:00

Hi @elmaazon thank you for using the support forum. If you have created longer links that than WordPress default allowance by using the plugin, after you deactivated/uninstalled the plugin all your long URLs is expected to stop working. All links that have less characters that the default WordPress limitation should be working. The long URLs will not. This is normal. Please open a new thread for more, since this thread here is not related to that. Thank you.

elmaazon 2020-03-27T10:55:00+00:00

i opend new one please help 🙁