SQL syntax

  • [Thu May 06 15:51:30.528843 2021] [proxy_fcgi:error] [pid 1446:tid 140280158164736] [client 52.2.74.251:0] AH01071: Got error ‘PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘defer onload=” AND redirect IS NOT NULL LIMIT 0,1’ at line 1 for query SELECT redirect, options FROM can_404_to_301 WHERE url = ‘/sellers.json’ defer onload=” AND redirect IS NOT NULL LIMIT 0,1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, JJ4T3_404_Actions->handle_404, JJ4T3_404_Actions->set_options’, referer: https://futbolme.com/sellers.json

    Any idea what this error is all about?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Joel James

    (@joelcj91)

    Hey @nosaint,

    Can you try uninstalling the plugin and install again? Seems like your DB table for the plugin is broken.

    • This reply was modified 3 years, 10 months ago by Joel James.
    Thread Starter nosaint

    (@nosaint)

    On installation, it throws

    [Thu May 06 23:02:58.476346 2021] [proxy_fcgi:error] [pid 2442:tid 140280275662592] [client IP:0] AH01071: Got error 'PHP message: PHP Warning: set_time_limit() has been disabled for security reasons in /home/public/wp-admin/includes/class-wp-upgrader.php on line 471PHP message: PHP Warning: set_time_limit() has been disabled for security reasons in /home/public/wp-admin/includes/class-wp-upgrader.php on line 471', referer: https://domain/wp-admin/plugin-install.php?s=404%20to%20301&tab=search&type=term

    On activation, it throws

    [Thu May 06 23:03:10.233085 2021] [proxy_fcgi:error] [pid 2442:tid 140278891521792] [client IP:0] AH01071: Got error ‘PHP message: activated’, referer: https://domain/wp-admin/plugin-install.php?s=404%20to%20301&tab=search&type=term

    On accessing domain/sellers.json it throws
    [Thu May 06 23:03:42.967693 2021] [proxy_fcgi:error] [pid 2442:tid 140280099481344] [client IP:0] AH01071: Got error 'PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'defer onload='' AND redirect IS NOT NULL LIMIT 0,1' at line 1 for query SELECT redirect, options FROM can_404_to_301 WHERE url = '/sellers.json' defer onload='' AND redirect IS NOT NULL LIMIT 0,1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, JJ4T3_404_Actions->handle_404, JJ4T3_404_Actions->set_options'

    Plugin Author Joel James

    (@joelcj91)

    Hey @nosaint,

    It seems like some required PHP extensions are disabled on your server. Could you please share the above message with your hosting team and ask them to check if it can be enabled?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL syntax’ is closed to new replies.