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
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.
Posted 3 years ago #
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
Posted 3 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.
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
This topic has been closed to new replies.
