Hello Neel,

Sorry for late reply to this,
Thanks for reporting on this, can you provide us with your Joomla backend and FTP access so we can help you check on this? Please advise.

I was finally able to set up the dev server now. How do I sent those access details to you?

Hi Arlex, Never mind my last post. I saw the "Update Site Details" link in the sidebar and added my info there.

Here is a full report on K2-ES related things that are not working:

1) When you go to EasySocial -> My Profile -> and click on "K2" in My Profile Page (ofcourse, after installed the K2 App), it just shows a loading gif and doesnt load anything (similar to the screen dump in my first post above). When I refresh that page, I receive this error:

1054 - Unknown column 'trashed' in 'where clause' SQL=SELECT * FROM `joom_k2_items` WHERE `created_by` = '838' AND `published` = '1' AND `trashed` = '0' ORDER BY `created` DESC LIMIT 0, 5

2) Under filters (in Dashboard), when I click on K2 Articles, it shows "There are no activities here yet", eventhough there are K2 Articles stream updates in timeline.

3) When I click on the K2 button in Album's user Profile page, it shows the SQL error (view the below link as guest when not logged in so you know which K2 button I am referring to). This is probably related to the error above: (link added with site details additional info)

BTW, I have installed Joomla 3.3 with EasySocial 1.3 Beta 5 that I downloaded only today.

Let me know if you need more info. Thank you so much for your assistance and support on this. I really appreciate this.

Cheers,
Neel.

Hi Arlex, this is in continuation to my last post. Another thing to add, I noticed that although I have enabled K2 Plugin, I dont see the K2 related points when creating new K2 articles in my Points History.

Hello Neel,

Which version of K2 are you using? Are you on the latest version? As for the points, you need to run the discovery of the points at the back end of EasySocial to discover new points.

Yeah I am using 2.6.8. I'll check out the discovery option.

Which version of K2 are you using? Are you on the latest version? As for the points, you need to run the discovery of the points at the back end of EasySocial to discover new points.

Perfect the points are discovered now. Thanks for that...

You are most welcome This is what you would want to do when you install a new app

Just a quick heads up. I am just waiting on this when you get a chance to check it:

Hi Arlex, Never mind my last post. I saw the "Update Site Details" link in the sidebar and added my info there.

Here is a full report on K2-ES related things that are not working:

1) When you go to EasySocial -> My Profile -> and click on "K2" in My Profile Page (ofcourse, after installed the K2 App), it just shows a loading gif and doesnt load anything (similar to the screen dump in my first post above). When I refresh that page, I receive this error:

1054 - Unknown column 'trashed' in 'where clause' SQL=SELECT * FROM `joom_k2_items` WHERE `created_by` = '838' AND `published` = '1' AND `trashed` = '0' ORDER BY `created` DESC LIMIT 0, 5

2) Under filters (in Dashboard), when I click on K2 Articles, it shows "There are no activities here yet", eventhough there are K2 Articles stream updates in timeline.

3) When I click on the K2 button in Album's user Profile page, it shows the SQL error (view the below link as guest when not logged in so you know which K2 button I am referring to). This is probably related to the error above: (link added with site details additional info)

BTW, I have installed Joomla 3.3 with EasySocial 1.3 Beta 5 that I downloaded only today.

Let me know if you need more info. Thank you so much for your assistance and support on this. I really appreciate this.

Cheers,
Neel.

Hello Neel,

Sorry for late reply to this,
I have help you fix with the SQL error, can you give it try again and see how it goes?
Regarding with your 3rd question, I have a little bit lost here, can you elaborate more details regarding this? Perhaps provide us some screenshot as well?

3) When I click on the K2 button in Album's user Profile page, it shows the SQL error (view the below link as guest when not logged in so you know which K2 button I am referring to). This is probably related to the error above: (link added with site details additional info)

Hi Arlex, No worries..

Thanks for adding a fix. I will give that a try now.

With the third question, I will come back after I try it out. Its probably related to SQL error too and its most likely fixed when the other ones are fixed. Thanks again for looking at it. I'll be back!

Hi Arlex,

The first one is fixed and its working. When I click on "k2" in my profile, it now lists the articles. This is great.

The second one is not working yet. When I click on "K2 Articles" filter in the left side bar of the dashboard, it is not filtering and listing the articles from stream. It is still showing "There are no activities here yet" although there are article feed in streams. Am I missing some setting or something here?

Hello Neel,

Okay, I have applied the fix in your site. Please have a check.

Hi Arlex, That is perfect! You have fixed all of them - (1) (2) and (3) all works! Thank you so much Arlex.

Last 2 questions:

1) With the fixes you did, is that to the EasySocial Beta 5 package or the Plugin? I am asking this because the site I gave you is just a dummy dev site. If I want to add the same fix to my localhost or my production site in the future, do I need to update anything manually or is this fix gonna be included in your ES package itself?

2) Do you have an updated file with these fixes you can give me now so I can add them to my wamp server too?

You are amazing. I am very glad you resolved these for me by end of today itself!. Thank you heaps...

You are most welcome Neel