Error 500 on 2.2 page

  • Nurbis
    Participant
    # 7 months, 2 weeks ago

    Hello,

    I just installed the plugin and noticed one problem. When I want to visit “Define Your Search” – “Data” (2.2. page), the page is loading a while and then I get error 500.

    Could it be because I’ve got too many posts on my wordpress (150 000) ? Or is there something else ?

    wpsolr
    Keymaster
    # 7 months, 2 weeks ago

    Hello,

    It should not be the number of posts. We have clients with millions of posts/products/topics.

    Do you get errors in WP debug.log?

    wpsolr
    Keymaster
    # 7 months, 2 weeks ago

    What are your versions of WP, and PHP?

    Nurbis
    Participant
    # 7 months, 2 weeks ago

    Hi,

    WP: 5.0.3
    PHP: 7.0.28

    wpsolr
    Keymaster
    # 7 months, 2 weeks ago

    I suspect a lot of data is in your metas table.

    Please try to execute the SQL on your WP:

    SELECT distinct meta_key
    FROM wp_posts as POSTS
    INNER JOIN wp_postmeta AS POSTMETAS ON POSTS.ID = POSTMETAS.post_id
    WHERE POSTS.post_type = 'post'

    You can also install https://wordpress.org/plugins/query-monitor/ and check the longest queries.

    • This reply was modified 7 months, 2 weeks ago by  wpsolr.
    Nurbis
    Participant
    # 7 months, 2 weeks ago

    Hi, I run the query:
    (399249 rows total, Query took 2.7871 seconds.)

    So yeah, a lot 🙂

    wpsolr
    Keymaster
    # 7 months, 2 weeks ago

    This query returned 399249 rows?

    This would mean your posts have 399249 custom field definitions (not content, definition).
    This is not possible.

    Nurbis
    Participant
    # 7 months, 2 weeks ago

    Well I did clean the meta keys (via WP-sweep plugin) and can now access the 2.2 page 🙂
    So thanks for the tip.

    wpsolr
    Keymaster
    # 7 months, 2 weeks ago

    WP-Sweep

    Amazing. I added the plugin’s link for other readers.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.