[ACT] Unable to create Pod with Advance Content Type

You will need to enable the Advanced Content Types or Table Storage components in Pods Admin > Components to gain access to those advanced features. They are off by default.

Got it, Thanks!

Can I update existing pod to use table storage or I need to create a new pod from scratch?

There is a WP-CLI command available through this plugin: https://github.com/pods-framework/pods-convert

It will allow you to convert a pod type or pod storage.

Hi, Thanks for this info.

Facing the below error. Can you please share elaborated documentation if there is any?

# wp pods-convert migrate  --pod=legal_cases --new_storage=table
Found pod legal_cases (#847 - post_type) to migrate.tml/*****]#
Error: Error: Database Error; SQL: SELECT

                DISTINCT
                t.*, d.*
                FROM WJa_posts AS t
                LEFT JOIN WJa_pods_legal_cases AS d ON d.id = t.ID
                WHERE ( ( t.post_status IN ( 'publish' ) ) AND ( t.post_type = 'legal_cases' ) )


                ORDER BY t.menu_order, t.post_title, t.post_date
                LIMIT 0, 100; Response: Table '****MY DB***.WJa_pods_legal_cases' doesn't exist

Thanks,

Post running the script, our single post (Custom Post Type) is also failing with below error:

Database Error; SQL: SELECT DISTINCT t.* FROM WJa_posts AS t LEFT JOIN WJa_pods_legal_cases AS d ON d.id = t.ID WHERE ( ( t.post_status IN ( 'publish' ) ) AND ( t.post_type = 'legal_cases' ) ) ORDER BY t.menu_order, t.post_title, t.post_date LIMIT 0, 15; Response: Table '****<MY DB>***.WJa_pods_legal_cases' doesn't exist

Also I was not able to find “Pods Converter” on WordPress Marketplace as mentioned in Readme. Note: I downloaded the zip file and then uploaded the plugin. Ref: https://github.com/pods-framework/pods-convert/blob/master/readme.txt#L44

Thanks,

Hi @sc0ttkclark , Any update?