UPDATES EasySocial 4.0.15 Released! Joomla 5.x and PHP 8.x compatible now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is online
Our support specialists is available now. We will attend to you as soon as we can.
  Support is online

EasyBlog - 1064 Error

John Coonen · ·
8:17 AM Monday, 02 November 2015
Normal
Hi StackIdeas,

My site is offline now, because it throws this 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.`lft` < and a.`published` = '1' AND (( ( a.`private` = 0) OR ( a.`private' at line 1 SQL=select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `xxxxxx_easyblog_category` as a WHERE a.`lft` > AND a.`lft` < and a.`published` = '1' AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `xxxxxx_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (2,3,8,11)) > 0))) ORDER BY a.`lft` ASC

I used "xxxxxx" instead of my actual prefix for this public post. You should already have my site / ftp access info.
The replies under this section are restricted to logged in users or users with an active subscription with us