Check MySQL for Correct Syntax of MySQL Version

  • Resolved webhosting4u

    (@webhosting4u)


    2 weeks, 4 days ago

    This is the error I am receiving in the monitor – I have not seen this before and have not made any modifications to the code.

    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 ‘FROM wpxp_posts WHERE 1=1 AND ((wpxp_posts.post_type = ‘post’ AND (wpxp_’ at line 2

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Carlos Carmona

    (@cecarmona)

    2 weeks, 3 days ago

    Hi @webhosting4u ,

    Thanks for your patience while we looked into the issue.

    It looks like there’s a bug affecting the SQL syntax!

    A report has been created about this issue to notify our development team about it. I apologize for the inconvenience in the meantime. I can’t currently provide an ETA for when a fix will be released. However, I’m taking note of this thread and I’ll make sure to send you an update when an update that fixes this issue is released.

    Temporary workaround:

    As a temporary solution, you can try modifying the following file:

    Navigate to /wp-content/plugins/nextgen-gallery/src/DataMapper/WPPostDriver.php and alter line 418 to:

    $query = new \WP_Query( [ 'datamapper' => true, 'fields' => '*' ] );

    Please let me know if you have any questions.

    Thanks!

    Plugin Support Carlos Carmona

    (@cecarmona)

    2 weeks, 3 days ago

    Hi, @webhosting4u !

    I just wanted to give you an update on the issue you reported earlier. Good news! Our team has addressed it in the latest release of NextGEN Gallery v3.59.11, so you should be good to go. 

    To make sure everything is working smoothly, could you please update to the latest version of NextGEN and let us know if you’re still encountering any issues? We really appreciate your help in identifying this problem and your patience as we worked to fix it. 

    If you have any questions or need further assistance, don’t hesitate to reach out.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.