WordPress.org

Ready to get started?Download WordPress

Forums

Network Latest Posts
[resolved] database error (4 posts)

  1. Maple_Shadow
    Member
    Posted 1 year ago #

    I am not sure if I did it wrongly, but when I add the widget, following error appears:

    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 'WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' at line 1]
    SELECT blog_id FROM WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY last_updated DESC

    Hope to get your help!

    http://wordpress.org/extend/plugins/network-latest-posts/

  2. Jose Luis SAYAGO
    Member
    Plugin Author

    Posted 1 year ago #

    Hello,

    I have seen that error when using this plugin in single install versions of WordPress. It is because it can't find the wp_blogs database table.

    Make sure you are running a WordPress multi-sites and check if your config file reflects the changes, misconfigured multi-sites throws this error too.

    Please let me know if you solved your issue to close this topic.

    Cheers.

  3. Maple_Shadow
    Member
    Posted 1 year ago #

    Thank you Jose! after I set up the network and add another site, it works!

  4. Jose Luis SAYAGO
    Member
    Plugin Author

    Posted 1 year ago #

    Great, thanks for your feedback!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.