By HMED on Friday, 07 November 2014
Posted in General
Likes 0
Views 674
Votes 0
Hello,

i'd installed Xmap and the easydiscuss/blog plugins to generate sitemap, i added as mentionned a menu item to the sitemap page, when i try to rich this page a get 1064 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 'AND ( ( a.`private`= 0 ) OR ( (a.`private` = 10) AND ('945' > 0 ) ) OR ( ( a.`pr' at line 1 SQL=SELECT a.* FROM `dr78k_easyblog_post` AS a LEFT JOIN `dr78k_easyblog_team_post` AS b ON a.`id` = b.`post_id` WHERE a.`published` ='1' AND a.`ispending` ='0' AND AND ( ( a.`private`= 0 ) OR ( (a.`private` = 10) AND ('945' > 0 ) ) OR ( ( a.`private` = 30 ) AND ( 1 = 2 ) ) OR ( (a.`private` = 40) AND ( a.`created_by`=945) ) ) AND a.`issitewide` = '1' ORDER BY a.`created` DESC LIMIT 20


can you help me please to get my easyproducts generating sitemap ?

kind regards
hello jan!,

I am really sorry for the delay of this reply as it is a weekend for us here.

Actually that was known issues, I have help you fix it, please have a check. It should be work fine now.
·
Saturday, 08 November 2014 15:38
·
0 Likes
·
0 Votes
·
0 Comments
·
work perfectly !!! thank you Arlex, what wonderfull support, realy !
·
Saturday, 08 November 2014 19:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello jan! ,

You're welcome. glad to heard your issues resolved.
·
Sunday, 09 November 2014 13:41
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post