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

MYSQL Error for Bi-Directional Field Relationship. #5502

Open davyirl321 opened 5 years ago

davyirl321 commented 5 years ago

Issue Overview

Used pods to create two custom post types, 'upcoming auctions' and buttons. This was working recently but I'm not sure if an update broke it or if its down to user messing with the settings.

Expected Behavior

Under the 'upcoming auctions' post type I was able to add custom button post types but now I'm getting a SQL error. image

Current Behavior

image. This is what is happening now.

Steps to Reproduce (for bugs)

  1. Unknown

Possible Solution

Unsure.

WordPress Environment

WordPress Version: 5.2.4

PHP Version: 7.2.23

MySQL Version: 5.5.5

Server Software: Apache

Your User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:69.0) Gecko/20100101 Firefox/69.0

Session Save Path: /var/lib/php/session

Session Save Path Exists: No

Session Save Path Writeable: No

Session Max Lifetime: 1440

Opcode Cache:

Apc: No
Memcached: No
OPcache: No
Redis: No

Object Cache:

APC: No
APCu: No
Memcache: No
Memcached: No
Redis: Yes

WPDB Prefix: 2mO0aE11_

WP Multisite Mode: No

WP Memory Limit: 40M

Current Memory Usage: 38.894M

Current Memory Usage (real): 26.000M

Pods Network-Wide Activated: No

Pods Install Location: /var/www/vhosts/ashgrovegroup.ie/seaneacrettantiques.ie/wp-content/plugins/pods/

Pods Tableless Mode Activated: No

Pods Light Mode Activated: No

Currently Active Theme: Sean Eacrett Auctioneers

Currently Active Plugins:

Astra Premium Sites: 1.3.20
Astra Pro: 2.1.1
Classic Editor: 1.5
Contact Form 7: 5.1.4
Convert Pro: 1.4.0
Convert Pro - Addon: 1.3.0
Elementor: 2.7.4
Elementor Pro: 2.7.1
GDPR Cookie Consent: 1.8.1
Google Analytics Dashboard for WP (GADWP): 5.3.9
Google Maps Pro: 2.9.4
Health Check & Troubleshooting: 1.4.2
MailChimp Forms by MailMunch: 3.1.3
Pods - Custom Content Types and Fields: 2.7.15
Product Input Fields for WooCommerce: 1.2.5
Product Open Pricing (Name Your Price) for WooCommerce: 1.4.0
Schema Pro: 1.4.0
Smart Slider 3: 3.3.22
Ultimate Addons for Elementor: 1.18.0
WooCommerce: 3.7.1
WooCommerce Admin: 0.20.0
WooCommerce Global Payments HPP: 2.2.0
WooCommerce Product Enquiry: 2.3.0
WP phpMyAdmin: 2.91
WP Portfolio: 1.8.0
</details>

## Pods Package Export (helpful!)
<!-- Please include the Pods Package Export as it will be helpful in reproducing your issues. -->
<!-- To access: Pods Admin, Components, Migrate: Packages, Enable. -->
<!-- Then Pods Admin, Migrate: Packages, Export and Copy and Paste the JSON here OR -->
<!-- Save to a text file and upload to this bug report -->

Couldn't find export.



## Workaround or Alternate Solution Until Bug is Addressed
none

## Related Issues and/or PRs
none
issue-label-bot[bot] commented 5 years ago

Issue-Label Bot is automatically applying the label Type: Bug to this issue, with a confidence of 0.87. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

JoryHogeveen commented 5 years ago

Hello @davyirl321 Could you share how to reproduce this error?

multisme commented 5 years ago

Hi, i have the same problem. Basically, when mysql do the request to a pod through a pod using the bidrectional api, i think a character get mess up. I thing this bug should be prioritized since you need to basically had downgrade all the installs to make the ui works. Could look into it when i have time. Edit: i think you have a kind of fix here https://github.com/pods-framework/pods/pull/5505