search

pods-framework / pods

The Pods Framework is a Content Development Framework for WordPress - It lets you create and extend content types that can be used for any project. Add fields of various types we've built in, or add your own with custom inputs, you have total control.
https://pods.io/
GNU General Public License v2.0
1.07k stars 264 forks source link

Upgrade from 2.7.3 to 2.8.13 make the field value missing for table storage mode #6492

Open mwawan77 opened 2 years ago

mwawan77 commented 2 years ago

Description

I upgraded the version of pods from 2.7.3 to 2.8.13 and I got the issue with my taxonomy field that used table storage mode

Version

2.8.13

Testing Instructions

I did upgrade via plugins page like as usual

Screenshots / Screencast

Version 2.7.3

Edit-Pods-‹-Training-co-nz-—-WordPress

Edit-Pods-‹-Training-co-nz-—-WordPress (1)

Edit-Provider-‹-Training-co-nz-—-WordPress

Online-Courses-NZ-Training-co-nz

After Upgrade to 2.8.13

Edit-Provider-‹-Training-co-nz-—-WordPress (1)

Desktop-screenshot - 2022-04-12T102131 017

Possible Workaround

It's like a problem on table storage mode because I have another taxonomy with the same field but it used meta storage, it's fine

Site Health Information

`
### wp-core ###

version: 5.8
site_language: en_NZ
user_language: en_NZ
timezone: Pacific/Auckland
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: closed
environment_type: local
user_count: 73
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /Users/wawan/Local Sites/devtrainingconz/app/public/wp
wordpress_size: 50.38 MB (52824319 bytes)
uploads_path: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/uploads
uploads_size: 0.00 B (0 bytes)
themes_path: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/themes
themes_size: 5.65 MB (5927553 bytes)
plugins_path: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/plugins
plugins_size: 112.40 MB (117859579 bytes)
database_size: 299.50 MB (314048512 bytes)
total_size: 467.93 MB (490659963 bytes)

### wp-active-theme ###

name: Training Genesis (training-genesis)
version: undefined
author: Dev Team
author_website: http://www.training.com.au/
parent_theme: Genesis (genesis)
theme_features: core-block-patterns, menus, post-thumbnails, title-tag, automatic-feed-links, body-open, genesis-inpost-layouts, genesis-archive-layouts, genesis-admin-menu, genesis-import-export-menu, genesis-readme-menu, genesis-customizer-theme-settings, genesis-customizer-seo-settings, genesis-auto-updates, genesis-breadcrumbs, widgets, html5, genesis-responsive-viewport, widgets-block-editor
theme_path: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/themes/training-genesis
auto_update: Auto-updates are not available for this theme.
genesis_recommendations: This theme uses theme supports that are no longer required in Genesis: "genesis-responsive-viewport" theme support can be removed

### wp-parent-theme ###

name: Genesis (genesis)
version: 3.3.3 (latest version: 3.3.5)
author: StudioPress
author_website: https://www.studiopress.com/
theme_path: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/themes/genesis
auto_update: Enable update checks at Appearance → Customize → Theme Settings → Updates.

### wp-plugins-active (20) ###

ACF to REST API: version: 3.3.2, author: Aires Gonçalves (latest version: 3.3.3), Auto-updates disabled
Advanced Custom Fields PRO: version: 5.9.5, author: Elliot Condon (latest version: 5.12.2), Auto-updates disabled
Application Passwords: version: 0.1.3, author: George Stephanis, Auto-updates disabled
Asset CleanUp Pro: Page Speed Booster: version: 1.1.7.6, author: Gabriel Livan, Auto-updates disabled
Black Studio TinyMCE Widget: version: 2.6.9, author: Black Studio (latest version: 2.7.0), Auto-updates disabled
Classic Editor: version: 1.6.2, author: WordPress Contributors, Auto-updates disabled
Cornerstone: version: 3.5.5, author: Themeco, Auto-updates disabled
FacetWP: version: 3.4.7, author: FacetWP, LLC (latest version: 3.9.6), Auto-updates disabled
FacetWP - Cache: version: 1.5.0, author: FacetWP, LLC, Auto-updates disabled
Fastly: author: (undefined), version: 1.2.18 (latest version: 1.2.20), Auto-updates disabled
Geolocation IP Detection: version: 4.2.3, author: Yellow Tree (Benjamin Pick) (latest version: 5.0.0), Auto-updates disabled
Gravity Forms: version: 2.4.22, author: Gravity Forms (latest version: 2.6.1), Auto-updates disabled
Gravity Forms Zapier Add-on: version: 3.3, author: Gravity Forms (latest version: 4.2), Auto-updates disabled
PHP Browser Detection: version: 3.1.8, author: Mindshare Studios, Inc., Auto-updates disabled
PHP Browser Detection - Mobile Add-On: version: 1.0, author: Dev Team, Auto-updates disabled
Pods - Custom Content Types and Fields: version: 2.8.13, author: Pods Framework Team, Auto-updates disabled
SEO Images Optimizer Pro: version: 5.2, author: Weblizar, Auto-updates disabled
WP Disable Sitemap: version: 1.0.2, author: Jewel Theme (latest version: 1.0.4), Auto-updates disabled
WP GraphQL: version: 1.6.2, author: WPGraphQL (latest version: 1.8.0), Auto-updates disabled
Yoast SEO Premium: version: 11.8, author: Team Yoast, Auto-updates disabled

### wp-plugins-inactive (6) ###

Add WPGraphQL SEO: version: 4.15.0, author: Ash Hitchcock (latest version: 4.17.0), Auto-updates disabled
Admin Columns Pro: version: 5.5.3, author: AdminColumns.com, Auto-updates disabled
Admin Columns Pro - Advanced Custom Fields (ACF): version: 2.6.4, author: AdminColumns.com, Auto-updates disabled
Google Apps Login Premium: version: 3.4.1, author: Lever Technology LLC, Auto-updates disabled
Pods - Custom Content Types and Fields: version: 2.7.30, author: Pods Framework Team (latest version: 2.8.13), Auto-updates disabled
WPGraphQL for Advanced Custom Fields: version: 0.5.3, author: WPGraphQL, Jason Bahl, Auto-updates disabled

### wp-media ###

image_editor: WP_Image_Editor_GD
imagick_module_version: Not available
imagemagick_version: Not available
imagick_version: Not available
file_uploads: File uploads is turned off
post_max_size: 1000M
upload_max_filesize: 300M
max_effective_size: 300 MB
max_file_uploads: 20
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, BMP
ghostscript_version: not available

### wp-server ###

server_architecture: Darwin 20.6.0 x86_64
httpd_software: Apache/2.4.43 (Unix)
php_version: 7.4.1 64bit
php_sapi: fpm-fcgi
max_input_variables: 4000
time_limit: 1200
memory_limit: 256M
max_input_time: 600
upload_max_filesize: 300M
php_post_max_size: 1000M
curl_version: 7.54.0 LibreSSL/2.6.5
suhosin: false
imagick_availability: false
pretty_permalinks: true
htaccess_extra_rules: false

### wp-database ###

extension: mysqli
server_version: 5.7.28
client_version: mysqlnd 7.4.1

### wp-constants ###

WP_HOME: http://dev.training.co.nz
WP_SITEURL: http://dev.training.co.nz/
WP_CONTENT_DIR: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content
WP_PLUGIN_DIR: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/plugins
WP_MEMORY_LIMIT: 40M
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_LOCAL_DEV: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable

### genesis ###

theme_version: 3.3.3
db_version: 3301
first_version: 2.0.2
update: 1
site_layout: full-width-content
blog_title: text
comments_posts: 1
trackbacks_posts: 1
content_archive: full
image_size: thumbnail
image_alignment: alignleft
posts_nav: numeric
header_scripts: <meta name="ahrefs-site-verification" content="8e008b19a6bd5d2cddc2a75605f35a47c38dc06e113249753a78cc468e4b90b3">
upgrade: 1
footer_text: [footer_copyright before="Copyright "] · [footer_childtheme_link before="" after=" on"] [footer_genesis_link url="https://www.studiopress.com/" before=""] · [footer_wordpress_link] · [footer_loginout]
entry_meta_before_content: [post_date] by [post_author_posts_link] [post_comments] [post_edit]
entry_meta_after_content: [post_categories] [post_tags]

### pods ###

pods-server-software: Apache/2.4.43 (Unix)
pods-user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36
pods-session-save-path: undefined
pods-session-save-path-exists: No
pods-session-save-path-writable: No
pods-session-max-lifetime: 1440
pods-opcode-cache-apc: No
pods-opcode-cache-memcached: No
pods-opcode-cache-opcache: No
pods-opcode-cache-redis: No
pods-object-cache-apc: No
pods-object-cache-apcu: No
pods-object-cache-memcache: No
pods-object-cache-memcached: No
pods-object-cache-redis: No
pods-memory-current-usage: 80.067M
pods-memory-current-usage-real: 15.000M
pods-network-wide: No
pods-install-location: /Users/wawan/Local Sites/devtrainingconz/app/public/wp-content/plugins/pods/
pods-developer: No
pods-tableless-mode: No
pods-relationship-table-enabled: Yes
pods-light-mode: No
pods-strict: No
pods-allow-deprecated: Yes
pods-api-cache: Yes
pods-shortcode-allow-evaluate-tags: No
pods-sessions: Disable sessions
pods-can-use-sessions: No
pods-relationship-table-status: 90

Pods Package

{
    "meta": {
        "version": "2.8.13",
        "build": 1649734527
    },
    "pods": [
        {
            "name": "pa_0500_provider",
            "id": 1483,
            "label": "Providers",
            "description": "",a
            "label_singular": "Provider",
            "public": "0",
            "show_ui": "1",
            "type": "taxonomy",
            "storage": "table",
            "hierarchical": "1",
            "rewrite": "1",
            "rewrite_custom_slug": "provider",
            "rewrite_with_front": "1",
            "rewrite_hierarchical": "1",
            "query_var": "0",
            "sort": "0",
            "built_in_post_types_page": "1",
            "built_in_post_types_post": "1",
            "built_in_post_types_product": "1",
            "built_in_post_types_attachment": "0",
            "menu_location": "default",
            "show_in_nav_menus": "1",
            "show_tagcloud": "1",
            "show_admin_column": "0",
            "built_in_post_types_page_copy": "0",
            "built_in_post_types_related_search": "0",
            "capability_type": "default",
            "capability_type_custom": "pa_0500_provider",
            "built_in_post_types_acf-field": "0",
            "built_in_post_types_acf-field-group": "0",
            "built_in_post_types_custom_css": "0",
            "built_in_post_types_customize_changeset": "0",
            "show_in_menu": "1",
            "rest_enable": "0",
            "rest_base": "pa_0500_provider",
            "read_all": "0",
            "write_all": "0",
            "built_in_post_types_lvl_loc_provider": "1",
            "built_in_post_types_lvl_provider": "1",
            "built_in_post_types_loc_provider": "1",
            "built_in_post_types_subject_and_location": "0",
            "built_in_post_types_subject_lvl_provider": "1",
            "built_in_post_types_subject_loc_provider": "1",
            "built_in_post_types_subject_provider": "1",
            "built_in_post_types_cs_global_block": "0",
            "built_in_post_types_cs_template": "0",
            "built_in_post_types_cs_user_templates": "0",
            "built_in_post_types_oembed_cache": "0",
            "built_in_post_types_user_request": "0",
            "built_in_post_types_wp_block": "0",
            "show_tagcloud_in_edit": "1",
            "show_in_quick_edit": "1",
            "menu_position": "0",
            "_migrated_28": "1",
            "groups": [
                {
                    "name": "more_fields",
                    "id": 4738,
                    "label": "More Fields",
                    "description": "",
                    "weight": 0,
                    "fields": [
                        {
                            "name": "logo",
                            "id": 1488,
                            "label": "Logo",
                            "description": "",
                            "weight": 0,
                            "type": "file",
                            "required": "0",
                            "unique": "0",
                            "file_format_type": "single",
                            "file_uploader": "attachment",
                            "file_attachment_tab": "upload",
                            "file_edit_title": "1",
                            "file_linked": "0",
                            "file_limit": "0",
                            "file_restrict_filesize": "10MB",
                            "file_type": "images",
                            "file_add_button": "Add File",
                            "file_modal_title": "Attach a file",
                            "file_modal_add_button": "Add File",
                            "admin_only": "0",
                            "restrict_role": "0",
                            "restrict_capability": "0",
                            "hidden": "0",
                            "read_only": "0",
                            "roles_allowed": [
                                "administrator"
                            ]
                        }
                    ]
                }
            ]
        }
    ]
}
mwawan77 commented 2 years ago

Hi, After I investigated this issue again, the real problem is when I upgraded the version from 2.7.3 to 2.8.13 the field Id has changed.

Version 2.7.3 Edit-Pods-‹-Training-co-nz-—-WordPress (2)

After upgraded Version 2.8.13 Edit-Pod-‹-Training-co-nz-—-WordPress

So the short solution is I changed them directly via SQL command Select-wp_podsrel-Adminer

Then I tried to upgrade from 2.8.13 to 2.8.15, it's fine