By Omar Elofi on Tuesday, 30 June 2015
Posted in Technical Issues
Replies 1
Likes 0
Views 396
Votes 0
easydiscuss when I click on ask a question I get error message below



1064 - 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 '-2' at line 1 SQL=SELECT DATEDIFF('2015-06-29 20:54:53', a.`created`) as `noofdays`, DATEDIFF('2015-06-29 20:54:53', a.`created`) as `daydiff`, TIMEDIFF('2015-06-29 20:54:53', a.`created`) as `timediff`, a.`id`, a.`title`, a.`alias`, a.`created`, a.`modified`, a.`replied`, a.`legacy`, a.`content`, a.`category_id`, a.`published`, a.`ordering`, a.`vote`, a.`hits`, a.`islock`, a.`featured`, a.`isresolve`, a.`isreport`, a.`user_id`, a.`parent_id`, a.`user_type`, a.`poster_name`, a.`poster_email`, a.`num_likes`, a.`num_negvote`, a.`sum_totalvote`,a.`answered`, a.`post_status`, a.`post_type`, pt.`title` AS `post_type_title`,pt.`suffix` AS `post_type_suffix`, count(b.id) as `num_replies`, c.`title` AS `category`, a.`password` FROM `j0u75_discuss_posts` AS a LEFT JOIN `j0u75_discuss_posts` AS b ON a.`id` = b.`parent_id` AND b.`published` = 1 LEFT JOIN `j0u75_discuss_category` AS c ON a.`category_id` = c.`id` LEFT JOIN `j0u75_discuss_post_types` AS pt ON a.`post_type` = pt.`alias` WHERE a.`published` = '1' AND a.`user_id`='684' AND a.`parent_id` = 0 GROUP BY (a.id) ORDER BY a.`created` DESC LIMIT 0,-2


I have easysocial, easyblog, easydiscuss and k2
Hi Omar Elofi,

Sorry for late reply to this,

Can you provide us with your Joomla backend and FTP access so we can help you check on this?
·
Tuesday, 30 June 2015 10:12
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post