RT-Themes | Support Center

Viewing 10 results - 1 through 10 (of 22 total)

1 2 3 →

Author

Search Results

June 5, 2023 at 12:48 pm #119238

In reply to: Contact Form and Product Clone

neo

Staff

You can use a plugin to clone products. Please consult the wordpress plugins repository for more info on that

https://wordpress.org/plugins/duplicate-post/
https://wordpress.org/plugins/duplicate-wp-page-post/

April 9, 2019 at 3:48 pm #104069

In reply to: Allowed memory size exhausted when opening portfolio

neo

Staff

Normally meta data is gathered after you know the post id. So i do not understand how the portfolio shortcode causes the exhaust. Because you gather the items by a category. Once you know the items you walk through a loop and gather the meta data you need. This is done post by post and not by a bulk call.

Did you report this to the duplicate posts plugin builder?

There are more plugins to duplicate. Maybe its a plugin issue

https://wordpress.org/plugins/duplicate-wp-page-post/

https://wordpress.org/plugins/duplicate-post/

Pls Let us know your findings.

Best regards,
Neo
Theme support

April 9, 2019 at 3:34 am #104063

In reply to: Allowed memory size exhausted when opening portfolio

iprastha

Member

Ok, so I narrowed it down to the root cause of this. Basically adding new portfolio Item we use the Post Duplicate Post plugin (plugin documentation link), since there is a an elementor page inside each portfolio item, it makes sense we simply duplicate rather than designing it from scratch.
The issue is that the meta posts (postmeta table), gets duplicated exponentially.
So every time we duplicate a portfolio item, the postmeta is duplicated from 1 to 2 , 2 to 4 , 4 to 16 , and so on. this resulted even duplicating the “_elementor_data” meta key which holds the entire content and killing the database.

Solution, first backup both posts and postmeta table, the I use the following query to check which meta key is duplicated, and simply delete the ones with a lower meta_id.

select post_id, meta_key, min(meta_id) as min_meta_id, max(meta_id) as max_meta_id, count(1) as rowcount
from wp_postmeta
group by meta_key , post_id
having count(1) > 1
order by post_id, meta_key, rowcount desc

select post_id, meta_key, min(meta_id) as min_meta_id, max(meta_id) as max_meta_id, count(1) as rowcount

from wp_postmeta

group by meta_key , post_id

having count(1) > 1

order by post_id, meta_key, rowcount desc

This will show all those duplicated and how many rows the duplicates are, then I simply use spreadsheet to make delete queries like follow:

delete from 1288921 where meta_key = 'rttheme_key_details'
and meta_id < 1288921 and post_id = 7040;

1 2	delete from 1288921 where meta_key = 'rttheme_key_details' and meta_id < 1288921 and post_id = 7040;

1288921 is the max_meta_id (so its not deleted), and it only deletes the previous meta_id.

Please note i'm assuming the following points:
1. each post id and meta key should be unique (can anyone confirm this?)
2. if a single post id and meta key has more than 1 row, I assume the meta content (values) are the same (I did a sample check and it is, but I cannot confirm this is true for all cases)

After deleting, the page now works fine.

Cheers

February 1, 2019 at 12:43 pm #102724