[EventCalendar] Ultimate Tag Warrior and EventCalendar Clash...
alex at firetree.net
Sun Nov 20 23:13:35 UTC 2005
It's the bit that says "p.ID=" that's causing the problem. There should be a number after the '='.
The code that generates this SQL doesn't check for a null post ID. It should. Or you could force the post ID to an integer, that would probably make it '0', instead of just nothing.
The code you linked doesn't seem to generate this SQL (at least nowhere round line 824), so that's not much help.
On Sun, 20 Nov 2005 11:40:27 -0800 (PST)
amory <amory_tarr at yahoo.com> wrote:
> I have no expectation that this will be answered due to the fact that both the UTW and EventCalendar plugins for WordPress have been heavily modified for a project I'm working on for anyone organizing events/concerts/bands etc.. Thought I would give it a shot though to see if you could shed any light on my findings. The following error comes only when viewing the "concerts" page which is a function starting around line 824 of <a href="http://paste.uni.cc/8091">EventCalendar</a> (link to pastebin file). Something is conflicting between the two scripts.
> 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 'ORDER BY t.tag ASC' at line 1]
> SELECT DISTINCT t.tag FROM eventpress_tags t INNER JOIN eventpress_post2tag p2t ON p2t.tag_id = t.tag_id INNER JOIN eventpress_posts p ON p2t.post_id = p.ID AND p.ID= ORDER BY t.tag ASC
> Thanks for any and all help,
> Yahoo! FareChase - Search multiple travel sites in one click.
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net +44-7901-552763
More information about the EventCalendar