By Helen Nunley on Wednesday, 09 December 2015
Posted in Technical Issues
Likes 0
Views 530
Votes 0
Hi,

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

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

I have en-US as my default language. I checked the database and I don't have a column 'ispending' in #_easyblog_post table.

I don’t know how to fix this.

Thanks,
Helen
Hey Helen,

May i know what is your Easyblog current version?

What I suspect it might one of the plugin trigger this, perhaps you can provide us with your Joomla backend and FTP access so we can help you check on this?

By the way, in the future you can just include your site's access once at http://stackideas.com/dashboard/site rather than needing to keep adding them in your replies
·
Wednesday, 09 December 2015 22:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

EB 5.0.30.

I have set up access for you. I will need to whitelist your IP so you don't get locked out.

Also, I will need the details so I can apply the fix to my development localhost.

(And, I am testing JA Multilingual. If you can suggest any other automated solution, I am open suggestions.)

Thanks,
Helen
·
Wednesday, 09 December 2015 23:35
·
0 Likes
·
0 Votes
·
0 Comments
·
This is my current IP address : 175.145.128.248

I've tried to connect with your FTP server, but it seems like you provided that login credentials is not working.

Response:	530 Login authentication failed
Error: Critical error
Error: Could not connect to server
·
Thursday, 10 December 2015 00:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Typo. See corrected username.
·
Thursday, 10 December 2015 00:13
·
0 Likes
·
0 Votes
·
0 Comments
·
It seems like still the same, perhaps you can create another new FTP user account for us?
·
Thursday, 10 December 2015 00:35
·
0 Likes
·
0 Votes
·
0 Comments
·
I just logged in as you to ftp. So I re-pasted the password. See if that does it.
·
Thursday, 10 December 2015 00:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Helen,

I am sorry for the delay of this reply because last my reply already 12.30am yesterday night,

I've tried connect again but it seems like I still hitting the same issue.

Is it possible to create another new FTP account for us?

By the way, may i know how to replicate this error? Perhaps you can show me step by step how to replicate this issue so I can take a look ? Because I never use this JA multilingual before.
·
Thursday, 10 December 2015 10:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

I had the same issue with this account's ftp just yesterday so I will need to get server support (again) to fix the ftp issue. This won't be until about 12 hrs. as it is late here for me. -.-

I will let you know when to try again.

Thanks,
Helen
·
Thursday, 10 December 2015 10:53
·
0 Likes
·
0 Votes
·
0 Comments
·
It okay helen, take your time

But remember guide me how to replicate this issue.

Looking forward of your response.
·
Thursday, 10 December 2015 15:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

I just pasted the password into the Additional details and saved. When I looked at it again, it seems your form is dropping anything including and after a special character "<". So this in fact would be the wrong password so I reset it. Also put it in Additional details to check it and it looks right. Please try it again.

Here is the tutorial to run JA Multiligual: https://www.youtube.com/watch?v=gSi9JqF6jb8

Basically, You go to Components>JA Multilingual then "Translate All". It cooks and shows progress then stops with the error.

Thanks,
Helen
·
Friday, 11 December 2015 04:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Not out of the woods yet. Use "FTP over TLS if available" but not "SFTP - SSH". Another issue that needs to be resolved, I'm afraid.
·
Friday, 11 December 2015 04:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Helen,

I am really sorry for the delay of this reply as it is a public holiday for us here.

I can connected with your FTP server, it seems like that was not our issue, perhaps you can pass to them to check again and see is there a proper fix for this, because in 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');


I have help you click on `Translate all ` button, it run smoothly now.
·
Friday, 11 December 2015 13:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Just to follow up, JA Multilingual does not work with EasyBlog 5.0.+ after all.

Thank you for all your time trying to fix this.

I am enjoying learning to use EasyBlog!
·
Sunday, 03 January 2016 01:27
·
0 Likes
·
0 Votes
·
0 Comments
·
No problem Helen I will try to get in touch with the guys from Joomlart and see if they can update their extension to support EasyBlog 5

By the way, why don't you stick with the multi lingual setup that ships with Joomla by default?
·
Sunday, 03 January 2016 13:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

I was trying to find a solution for my client where the site could "auto-translate" content. I thought JA Multilingual was it, but it is not really that automated. The core Joomla multilingual setup does no translating that I could see, unless I just missed that day in school. Please let me know if I am wrong.
·
Tuesday, 05 January 2016 05:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Helen,

There is really no real way to "auto translate" contents even with Joomla's multi lingual setup. Moreover, the result of "auto translations" are often pretty crappy

By the way, take a look at this slide if you want to setup multi lingual support with Joomla, http://www.slideshare.net/erictiggeler/creating-a-multilingual-site-in-joomla-joomla-3-beginners-guide-eric-tiggeler
·
Tuesday, 05 January 2016 12:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

I agree that the "auto translations" aren't that great. My client has since decided that they won't go in that direction.

Thanks for the link to the guide. I had only found about half of that in my own quest for knowledge.
·
Tuesday, 05 January 2016 23:10
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Helen

By the way, please remember to assign your domain to your license to obtain for support in the future. You can do so by accessing your license area at http://stackideas.com/dashboard
·
Wednesday, 06 January 2016 00:53
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post