Public Forums 71,145 posts

[helenbn Friend helenbnJoin date: December 2015Posts: 14Downloads:3Uploads:2]

#770470

Hi,

I get the following error when trying to translate EasyBlog posts:

Unknown column ‘ispending’ in ‘where clause’ SQL=SELECT _FROM #_easyblogpost WHERE ispending = 0 AND (language=’en-US’ OR language=’‘ OR language=”)

I have en-us as my default language.

I don’t know how to fix this.

Thanks, Helen

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#778506

Hi the error seems to be from the Database of easyblog of your site , kindly check go to extension manager –> database –> fix and hit fix
Also did consult the issue with the extension support team .

[helenbn Friend helenbnJoin date: December 2015Posts: 14Downloads:3Uploads:2]

#785222

Will do. Thank you.

[helenbn Friend helenbnJoin date: December 2015Posts: 14Downloads:3Uploads:2]

#804693

Hi,

Here is the temporary fix from Stack Ideas:

**Easyblog 5 no longer using ‘ispending’ columns, I believe they haven’t update this yet.

JoomlaFolder/administrator/components/com_jalang/helpers/content/adapters/easyblog_post.php

//LINE 48
$this->translate_filters = array(‘ispending = 0’);

//I temporary change this to use ‘state’, but I am not really sure this translate_filters task
$this->translate_filters = array(‘state = 0’);
**

This seems to be working with this edit. Do you agree with the fix?
Helen

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#808122

Hi its issue from the extension ,
as they provided code for it and it work fine , you can use it :).

[helenbn Friend helenbnJoin date: December 2015Posts: 14Downloads:3Uploads:2]

#808737

Will this be included in the next update? Or must I remember to hack this?

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#809740

Hi
I will forward it to team fro review on it , But you need to backup the custom changes in future upgrades as its not sure at this time about the updates can contain this fix.

[Author]

Posts