Support » Plugin: WP Job Manager » Millions of Listings and its trying to load the whole thing

Viewing 13 replies - 1 through 13 (of 13 total)
  • Thread Starter dbhollenbeck

    (@dbhollenbeck)

    Just adding Im using

    ListifyVersion: 1.0.4

    Listify – Child ThemeVersion: 1.0.0

    Running the following addons

    No security addons

    when active I get this error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator at webmaster@keepitlocalusa.com to inform them of the time this error occurred, and the actions you performed just before this error.

    More information about this error may be available in the server error log.

    Apache/2.4.12 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at keepitlocalusa.com Port 80

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    What are you loading, frontend or backend? You will likely need to increase the WP memory limit.

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    Loaded 16 million buisness back end. and Member been increased to 512. I turned evyerthing but your plugin and what is required to run site and it freezes in loop

    Any other suggestions to fix your plugin?

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    Also dont know if this helps but if I just run like 3 million listings it works. a hair slow but works no loop.

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    The backend listing and custom post type is actually all powered by WordPress itself. I’ve personally come across this problem in the past (not with job manager though) when setting too many listings to be displayed in the ‘screen options’.

    Does that sound like something you maybe did?

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘job_listing’

    that line of code is killing me im told how do we fix

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    sorry don’t think its something you can control it the search listing feature on the front that’s pulling every record every time. Think we have to do a recode a bit ill check with listify.

    Thanks

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    SQL_CALC_FOUND_ROWS is something WordPress uses to calculate the maximum number of results. What version of mysql is your server running? Upgrading that could improve performance on this query.

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    SQL_CALC_FOUND_ROWS is something WordPress uses to calculate the maximum number of results. What version of mysql is your server running? Upgrading that could improve performance on this query.

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    i use 5.6 version latest stable

    Thread Starter dbhollenbeck

    (@dbhollenbeck)

    From what I understand you wrote this program. Is there a fee I can pay for you to look at the issue? I am not above paying someone for there time.

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    I can take a look, but I’m not sure if I can workaround it since SQL_CALC_FOUND_ROWS is ran by WP backend. It’s not a custom query. Send details to https://wpjobmanager.com/contact/

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Millions of Listings and its trying to load the whole thing’ is closed to new replies.