WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Problem with Sitemap Popularity contest 1.2

[Resolved] Problem with Sitemap Popularity contest 1.2

  • 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

Viewing 10 replies - 1 through 10 (of 10 total)
  • 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?

    Yeah… that’s all I got. A white screen otherwise.

    The post gets saved/published properly it seems though

    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?

    Tried all those,

    weirdly, the plugins work individually, but not together.

    Alex King
    Member

    @alexkingorg

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

    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.

    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

    Alex King
    Member

    @alexkingorg

    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.

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

    Thanks alot!

    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

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘[Resolved] Problem with Sitemap Popularity contest 1.2’ is closed to new replies.