Errors after 4.6.1

  • Resolved mattwillms

    (@mattwillms)


    8 years, 5 months ago

    We are using WP Job Manager and WP Job Manager – Applications. All updated.

    After upgrading WordPress to 4.6.1: When doing a submission the interface throws an error to the user that just says “Invalid address: “. This is different than the invalid email error, etc. Notice how there is nothing beyond the colon. The submission does get stored however. My server has this in the error logs:

    [Fri Sep 23 13:35:27.807480 2016] [:error] [pid 3997] [client 45.33.52.226:20141] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 500; /* From [careerscb.staging.wpengine.com/wp-cron.php?doing_wp_cron=147’ at line 6 for query DELETE a, b FROM wp_options a, wp_options b\n\t\t\t\tWHERE a.option_name LIKE ‘\\\\_transient\\\\_jm\\\\_%’\n\t\t\t\tAND a.option_name NOT LIKE ‘\\\\_transient\\\\_timeout\\\\_jm\\\\_%’\n\t\t\t\tAND b.option_name = CONCAT( ‘_transient_timeout_’, SUBSTRING( a.option_name, 12 ) )\n\t\t\t\tAND b.option_value < 1474637727\n\t\t\t\tLIMIT 500; /* From [careerscb.staging.wpengine.com/wp-cron.php?doing_wp_cron=1474637727.5169749259948730468750] in [/nas/content/staging/careerscb/wp-content/plugins/wp-job-manager/includes/class-wp-job-manager-cache-helper.php:108] */ made by do_action_ref_array, call_user_func_array, WP_Job_Manager_Cache_Helper::clear_expired_transients

    [Fri Sep 23 14:18:47.497478 2016] [:error] [pid 23021] [client 45.33.52.226:45500] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 500; /* From [careerscb.staging.wpengine.com/wp-cron.php?doing_wp_cron=147’ at line 6 for query DELETE a, b FROM wp_options a, wp_options b\n\t\t\t\tWHERE a.option_name LIKE ‘\\\\_transient\\\\_jm\\\\_%’\n\t\t\t\tAND a.option_name NOT LIKE ‘\\\\_transient\\\\_timeout\\\\_jm\\\\_%’\n\t\t\t\tAND b.option_name = CONCAT( ‘_transient_timeout_’, SUBSTRING( a.option_name, 12 ) )\n\t\t\t\tAND b.option_value < 1474640327\n\t\t\t\tLIMIT 500; /* From [careerscb.staging.wpengine.com/wp-cron.php?doing_wp_cron=1474640327.2538809776306152343750] in [/nas/content/staging/careerscb/wp-content/plugins/wp-job-manager/includes/class-wp-job-manager-cache-helper.php:108] */ made by do_action_ref_array, call_user_func_array, WP_Job_Manager_Cache_Helper::clear_expired_transients

    [Fri Sep 23 16:12:28.013601 2016] [:error] [pid 15003] [client 73.177.102.214:55056] purge_varnish_cache() failed for: (localhost) #^(careerscb\\.staging\\.wpengine\\.com)$# #(/job/branch-operations-officer(.*))#, referer: https://careerscb.staging.wpengine.com/wp-admin/post.php?post=555&action=edit

    [Fri Sep 23 16:12:28.024114 2016] [:error] [pid 15003] [client 73.177.102.214:55056] purge_varnish_cache() failed for: (localhost) #^(careerscb\\.staging\\.wpengine\\.com)$# #(/job/branch-operations-officer(.*))#, referer: https://careerscb.staging.wpengine.com/wp-admin/post.php?post=555&action=edit

    • This topic was modified 8 years, 5 months ago by mattwillms.
Viewing 5 replies - 1 through 5 (of 5 total)

  • Are you using a cache plugin? If so, i would recommend clearing the cache on that and in the web browser you are using. Also, check MySQL version and PHP to make sure you are using versions compatible with your version of WordPress.

    Also, are you talking about the frontend posting via a page with the Job dashboard shortcode? If so, try using the WP Admin area to post a job and see if that has the same issue. I am currently using the WP Job Manager plugin on a wordpress multisite network running wordpress 4.6.1 and all my plugins are up to date.

    Thread Starter mattwillms

    (@mattwillms)

    The only plugins I’m using are ACF, WP Job Manager, and WP Job Manager – Applications. Everything is up to date.

    WPEngine has a drop-in plugin called advanced-cache.php but I’ve tried with that plugin removed and have the same result.

    If you go here (the site is in STAGE) and apply for a job you can see the error. You can use fake data:

    https://careerscb.staging.wpengine.com/job/mortgage-loan-assistant/

    “Invalid address: “

    Thanks for your info. I definitely see the issue you are encountering. However, since you are using a paid plugin “WP Job Manager – Applications”, I suggest you seek their support staff and/or documentation.

    https://wpjobmanager.com/document/applications/

    Thread Starter mattwillms

    (@mattwillms)

    Thanks. I’ll do that.

    Thread Starter mattwillms

    (@mattwillms)

    Just FYI to anyone. It seems our license had recently expired so we were not receiving updates. Once I renewed and downloaded the latest version of WP Job Manager – Applications everything cleared up nicely.

    Thanks for the help @mathewemoore.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Errors after 4.6.1’ is closed to new replies.