WordPress.org

Forums

[resolved] Problem with Sitemap + Popularity contest 1.2 (11 posts)

  1. tedfox
    Member
    Posted 8 years ago #

    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 ')' at line 3 on line: 1321

    I get that error when I try to save/publish a post.

    I realise the problem only exists when I activate both google sitemap v 3 beta 4, and alex king's popularity contest 1.2

  2. muelheim
    Member
    Posted 8 years ago #

    Is that all you got?

    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 ')' at line 3 on line: 1321

    No file-name?

  3. tedfox
    Member
    Posted 8 years ago #

    Yeah... that's all I got. A white screen otherwise.

    The post gets saved/published properly it seems though

  4. muelheim
    Member
    Posted 8 years ago #

    So it looks like one of your plugins performes a wrong sql-query.

    Did you change the plugin-code?

    Is it the right version for your WP and MySQL?

    Did you try to de- and reinstall them?

  5. tedfox
    Member
    Posted 8 years ago #

    Tried all those,

    weirdly, the plugins work individually, but not together.

  6. Alex King
    Member
    Posted 8 years ago #

    Does this happen with Popularity Contest 1.2.1 as well? I have both plugins enabled and they work fine here.

  7. tedfox
    Member
    Posted 8 years ago #

    Weird, I installed both plugins on another blog and it worked out.

    (yeah, i was using 1.2.1, my mistake)

    yet it somehow does not work on my original blog. And yet both work individually.

    heh. I have no idea how to work this out either. ah wellz.

  8. tedfox
    Member
    Posted 8 years ago #

    ok. this time i disable every darn plugin except for popularity 1.2.1 and sitemaps 3 beta 4.

    I get this

    Warning: Invalid argument supplied for foreach() in /home/tedfox/public_html/anime/wp-content/plugins/popularity-contest.php on line 1313
    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 ')' at line 3 on line: 1321

    Any clue as to how I should try and fix this?

    or any hint as to what's causing the conflict

  9. Alex King
    Member
    Posted 8 years ago #

    There's a tweak checked in to the SVN repository (link on my plugins page) for PC that likely fixes this, however I believe the root cause is likely in the Sitemaps code.

  10. tedfox
    Member
    Posted 8 years ago #

    Yup. That fixes it. Although I still don't really know what's the problem. I already notified the sitemap author too.

    Thanks alot!

  11. Arne Brachhold
    Member
    Posted 8 years ago #

    Hmm, the plugins are using different variables for storing the post data. The sitemaps plugin uses $post_cache because the WP get_post() function looks there for post data and generating permalinks, the PopContest plugin uses $posts which is used in "the loop".

    I've modified the sitemaps plugin so it stores the content of $post_cache also in $posts if $posts is empty. That should fix the problem. You can get it from the SVN:

    http://dev.wp-plugins.org/browser/google-sitemap-generator/trunk/sitemap.php

    Best regards,

    Arne

Topic Closed

This topic has been closed to new replies.

About this Topic