Hey there,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue?

To add your access, simply edit your first post above or head on to http://stackideas.com/dashboard/site to insert your site access once only.

Added site access in dashboard

Hey Alexandra,

I am really sorry for the delay of this reply as it is a weekend for us here. Thanks! I am able to login to the back end now. However, there is no FTP access Can you please advise?

Hi.

Sorry for the delay.
There is no FTP account. But you can use ProFiles from the components menu.
Then you should be able to access files.

Hello Alexandra,

I've tried to access your site but failed: http://screencast.com/t/l02S6q8ZUgR

Hi Nick. From which country your are trying to access the site ?
I am using a geo IP blocker because I had too much people trying to attack the site

Hey Alexandra,

I am really sorry for the delay of this reply as it is a weekend for us here. We are connecting from Malaysia.

Hi,

Malaysia shouldn't blocked any more.
Please try again.

Sorry for delayed answers, I'm on vacation in chile right now..
So no worries if you can answer delayed as well

Hey Alexandra,

I am really sorry for the delay of this reply as it is a weekend for us here. Can you download the attached file and upload it into /administrator/components/com_easyblog/includes/comment/ and see if the problems still persists?

Hi Mark,

I replaced the file and getting a Server error 500.
Both files are in the same directory.
The new one is called _new.

So you can renale it again.
I am using the old file again so i can use the blog again.

FTP access works sich the component profiles...

Thanks
Alex

This is the error generated and it is probably due to file permissions. I cannot seem to change the file permissions with Profiles, http://screencast.com/t/nr9FraHU9kCU

<br />
<b>Warning</b>: require_once(/var/www/vhosts/mychaosland.net/mychaosland_new/administrator/components/com_easyblog/includes/comment/comment.php): failed to open stream: Permission denied in <b>/var/www/vhosts/mychaosland.net/mychaosland_new/administrator/components/com_easyblog/includes/easyblog.php</b> on line <b>529</b><br />
<br />
<b>Fatal error</b>: require_once(): Failed opening required '/var/www/vhosts/mychaosland.net/mychaosland_new/administrator/components/com_easyblog/includes/comment/comment.php' (include_path='.:/opt/plesk/php/5.6/share/pear') in <b>/var/www/vhosts/mychaosland.net/mychaosland_new/administrator/components/com_easyblog/includes/easyblog.php</b> on line <b>529</b><br />

Hi Mark,

Changed the permissions to 755
No getting follw

Error
1054
Home Page
Unknown column 'p.state' in 'where clause' SQL=select SQL_CALC_FOUND_ROWS a.*, count(pcat.`id`) as `cnt` from `u5s1x_easyblog_category` as a inner join `u5s1x_easyblog_category` as c on a.`lft` <= c.`lft` and a.`rgt` >= c.`rgt` left join `u5s1x_easyblog_post_category` as `pcat` on c.`id` = pcat.`category_id` and exists (select p.`id` from `u5s1x_easyblog_post` as p where pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0') WHERE a.`published`='1' and a.`parent_id` = 0 and p.`state` = '0' and (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `u5s1x_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (9)) > 0)) ) GROUP BY a.`id` having (count(pcat.`id`) > 0) ORDER BY a.`lft` ASC



I will try to give you a proper FTP account tomorrow. Will make things easier.

Cheers
Alexandra

Hey Alexandra,

Yes, a proper ftp account will make our job much easier. Hope to hear from you soon!

FTP account Details added dashboard user site details. Ftp is with encryption. (Ftp es)

Thanks !

Hi Alexandra,

I am really sorry for the delay of this reply.

It seems like the file that Mark provided above are related with the other fix that we have made with the categories count issue previously. I've applied the fix inside your /administrator/components/com_easyblog/models/category.php and the sql error is no longer shown. I've also checked the comment count on your easyblog and it seems to show correctly now. Please have a look.

Same error. With the file comment.php (from Mark), that's ok. Thanks.

Hi Ezrul,

Everything working fine now. Thanks

Hey Jan,

Try download my attached files and replace into

JoomlaFolder\administrator\components\com_easyblog\models\category.php
JoomlaFolder\administrator\components\com_easyblog\includes\comment\comment.php

And see how it goes.

By the way, Thanks Alexandra getting back to us everything is working fine.