SQL query in ml_is_notified

  • Resolved Pau Iglesias

    (@pauiglesias)


    10 years, 2 months ago

    Hi, I’m having this entry from PHP error log:

    “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 ”wp_1_mobiloud_notifications’ WHERE post_id = 96847′ at line 1 de la base de datos de WordPress para la consulta SELECT COUNT(*) FROM ‘wp_1_mobiloud_notifications’ WHERE post_id = 96847 realizada por edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action, call_user_func_array, ml_post_published_notification, ml_is_notified”

    it appears to be that the query in function ml_is_notified (file push.php) fails because WP prepare function adds single quotes when replace %s with the table name, and this cause the SQL error.

    Can you confirm this issue is possible?

    Thanks in advance,

    Regards
    Pau

    http://wordpress.org/plugins/mobiloud-mobile-app-plugin/

Viewing 1 replies (of 1 total)
  • Plugin Author pietro

    (@psac50)

    10 years, 1 month ago

    Thanks Pau, we’re looking into the problem, which hasn’t be reported before.

Viewing 1 replies (of 1 total)
  • The topic ‘SQL query in ml_is_notified’ is closed to new replies.