“Not valid JSON” and “unknown column post_title.meta_value”

  • Resolved TheDani

    (@thedani)


    3 years, 3 months ago

    I have problem with “The response is not a valid JSON response” and “WordPress database error: [Unknown column ‘post_title.meta_value’ in ‘field list’]“. There is fine with the Custom Post Type (record, song, etc), except group.
    You will see e.g. /wp-admin/edit.php?post_type=group (All Groups / Add New)

    Backend: /wp-admin/post.php?post=20&action=edit (group)
    …(standard input first)…
    More Fields
    – Records
    – Songs: WordPress database error: [Unknown column ‘post_title.meta_value’ in ‘field list’] SELECT etc … (error 1)

    I have looked on Edit Pod: group (wp-admin/admin.php?page=pods&action=edit&id=15)
    – Records – Relationship [type=pick] >> Records (record) [object=post_type-record]
    – Songs – Relationship [type=pick] >> Songs (song) [object=post_type-song]

    Save Pod: The response is not a valid JSON response. (error 2)
    Also the normal and any of the Custom Post Type on Pods is also with JSON error.

    I have also disabled theme single-group.php and template-parts/content-group.php. But they are in another theme. Now I have temporary standard theme.

    In short: Disabled plugins except Pods, classic editor and switch theme. Temporary Twenty Twenty-One theme, I have php 7.4 (soon 8), WP_DEBUG, WP_DEBUG_LOG and WP_DEBUG_DISPLAY is true, WP_HOME and WP_SITEURL is https://example.com, .htaccess 644 and Site Health: “The REST API did not process the context query parameter correctly.“. (error 3)

    Can you help me?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    What is your setting for “Display Field in Selection List” for the problematic relationship fields?

    If you see {@post_title} there, try removing that and saving again.

    There’s some sort of bug there that we’re tracking down and that may be what you’ve encountered.

    Thread Starter TheDani

    (@thedani)

    I wanted to try remove {@post_title}, but there is unfortunately error 2:

    Groups > More Fields > Songs > Edit Field
    Display Field in Selection List = (try blank now, remove)
    Save Field
    The response is not a valid JSON response.

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    Do you see anything in your Network panel of your Browser Dev Tools?

    Thread Starter TheDani

    (@thedani)

    Is this on debug on Chrome js? See picture: https://ibb.co/0qBSkRS
    Names and Statuses is 200 – that is normal.

    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @thedani

    The link isn’t working here.
    I can reproduce your first error, and it’s correct. {@post_title.meta_value} will produce an error since it isn’t a meta value but a core field. {@t.post_title} should work.

    However, I cannot reproduce your second error. After I removed {@post_title.meta_value} I can save the Pod without issues. Anything else you did here?

    Cheers, Jory

    Thread Starter TheDani

    (@thedani)

    Hey,

    Worked earlier, but not now. Try this instead: https://postimg.cc/1fpbnjRZ

    Empty on “Display Field”, “Save Field”, and then it gives error JSON.

    • This reply was modified 3 years, 3 months ago by TheDani.
    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @thedani

    If you open your network tab and then hit Save you’ll see the XHR call being made.
    Please check the Response tab for the actual error.

    Cheers, Jory

    Thread Starter TheDani

    (@thedani)

    Solved.
    I have temporary disabled index.php: define( ‘WP_USE_THEMES’, false ); on front page.

    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @thedani

    Glad to hear you solved it. The solution implies a theme conflict so you might want to look at that to make sure this doesn’t happen again!

    Cheers, Jory

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘“Not valid JSON” and “unknown column post_title.meta_value”’ is closed to new replies.