By Henning Sass on Monday, 12 October 2015
Posted in General Issues
Replies 8
Likes 0
Views 478
Votes 0
Hi,

after update to 5.0.28 i have a SQL 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.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.' at line 1 SQL=select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `ew28b_easyblog_category` as a WHERE a.`lft` > AND a.`lft` < AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `ew28b_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (1,8,13)) > 0))) ORDER BY a.`lft` ASC
Hey Henning,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue?
·
Monday, 12 October 2015 23:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

here the backend info.
·
Tuesday, 13 October 2015 14:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

You work on it?
·
Wednesday, 14 October 2015 14:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Henning,

Sorry for the late reply. I've checked your site and I can't see the error. Did you change anything? Please advise.
·
Thursday, 15 October 2015 13:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

Show on Blog
·
Thursday, 15 October 2015 14:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Henning,

I've checked your site and found out that one of your module didn't configured correctly. I've re-configured it and it is working now. Please verify this.
·
Thursday, 15 October 2015 17:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

it works.
Which module it was?

Thanks
·
Thursday, 15 October 2015 17:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

It was the showcase module.
·
Thursday, 15 October 2015 18:08
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post