[zaerl]

The problem here is that bbPress insert a FORCE INDEX (PRIMARY, post_parent) but WPML uses a JOIN in its tables. You can’t do that when you have a JOIN cause the correct syntax in that particular case is FORCE INDEX FOR JOIN. Try to replace the function “function _bbp_has_replies_where( $where, $query )” in wp-content/plugins/bbpress/bbp-includes/bbp-replay-functions.php” with this: https://gist.github.com/3930162

Keep in mind that it’s not tested, I haven’t a WPML license. I do not know either if my reasoning makes sense at all.

[tamarazuk]

Hi Villagora,

Thank you so much for your reply! You are absolutely right, WPML is causing the problem. I have spent the whole day investigating hoping that I could write something meaningful here, however, that is not the case. I will contact WPML for further support and post back here if I hear anything that could be of use to other people.

Thanks again!

[villagora]

hi tamarazuk,

Indeed, that seems to be the same error [ticket #1938][1]. But in our case, we have modified bbp_has_replies args for to add our own meta queries…
In your case, it seems that the plugin WPML add a join clause to the bbppress query :

> JOIN wp_icl_translations t ON wp_posts.ID = t.element_id

That’s why the SQL query crash… I suggest you to backup your db & disable WPML for confirm my diagnostic ! 😉

Some ideas for fix it :

• wait the bbpress update
• if you have programing skills, you can try to hook the posts_join or posts_where probably used by WPML for fix manualy the querry.

Good luck !

[tamarazuk]

Hi,

I am unable to view the topic or reply content. With debug on I receive the following error

WordPress database 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 ‘FORCE INDEX (PRIMARY, post\_parent) WHERE 1=1 AND (wp\_posts.ID = 647 OR wp\_posts.’ at line 2] SELECT SQL\_CALC\_FOUND\_ROWS wp\_posts.* FROM wp\_posts JOIN wp\_icl\_translations t ON wp\_posts.ID = t.element\_id AND t.element\_type IN (‘post\_topic’) JOIN wp\_icl\_languages l ON t.language\_code=l.code AND l.active=1 FORCE INDEX (PRIMARY, post\_parent) WHERE 1=1 AND (wp\_posts.ID = 647 OR wp\_posts.post\_parent = 647) AND wp\_posts.post\_type IN (‘topic’, ‘reply’) AND (wp\_posts.post\_status = ‘publish’ OR wp\_posts.post\_status = ‘closed’) AND t.language\_code=’en’ ORDER BY wp\_posts.post\_date ASC LIMIT 0, 15

I have had this error since I installed this plugin over a month ago and have not been able to fix it. At that time I found this ticket1 which lead me to this 2 line change2. I decided to add these two lines but that did not help either.

I have switched themes to Twenty Ten bbPress, Twenty Eleven, and the standard Twenty Eleven. I have also disabled almost all plugins (not WPML because I’ve had bad experiences with disabling and re-enabling it). None of this troubleshooting actions have helped. I then sat around waiting for an update, but unfortunately one has not come yet.

Since we are reaching the launch date I would like any help from anyone who has encountered this issue and successfully fixed it.

Thank you so much! Tamara

• This topic was modified 12 years, 1 month ago by tamarazuk.

[kuching]

This is a question between Buddypress and WordPress, however I decided to post it also here, because I’m not too sure whether I should use BBPress or Buddypress in my setup and maybe someone could give me some advice here.

I’m working at a wordpress project that is structured as follows in a multisite configuration:

1) main site, single language, heavily customized with post types, loads of content, no forum, one webshop

2) secondary site, simpler setup, relatively little content, no forum, no webshop, multilanguage (WPML)

3) third site hosting a forum only and no other content; forum interface will be multilanguage (like site #2)

4) fourth site, reserved to admins only, single language, possibly a forum, to manage content and carry on project management tasks and discussions, etc.

– all sites would be in the same domain (ie http://www.domain.com/ = 1, http://www.domain.com/2, http://www.domain.com/3 etc)

– sites #1, #2, #3 would be seamlessly integrated in the frontend. However content displayed changes, since #1 has very different contents meant for users in the main language, while #3 is just a forum. Site #2 is intended to provide information and basic contents to international users, while the forum would provide a common space for discussion, being the interface translated.

I want a multisite setup so users can keep their logins, cookies, across the sites, yet at the same time make some order to admin the different areas.

Now… it is clear to me that WPML I can take care of the translation part. However, what I’m really clueless about is how to seamlessly integrate the forum part. Since mine is a community-type website, I want to have community features… Buddypress seems to offer a more complete solution for this than bare bbpress. I don’t want users to create their blogs or groups. But it would be nice to have better profile pages, private messaging, set their own display pic, and so on. Features that bbpress lacks or are not natively integrated (I come from a bbpress 1.0 experience and while I love it for the theming possibilities, plugin wise was badly supported).

So what I would really like to know… Does it make sense to run BuddyPress on site #3, activate only modules for member profiles, forums and activity streams?

Will the activity streams report activity of these users on sites #1 and #2? (would that include creation of new articles, posts and content by admins and authors? or just comments?)

Will the users be able to login from site #1 or #2 or #3 and kept logged in without any weirdness happening when navigating through the sites and performing actions?

Can authors from #1 and #2 link their profiles to profiles found in #3 Buddypress rather than using author.php? Same for registered users that post a comment on #1 or #2, can they have a link directing to their Buddypress member profile page/activity stream?

Being site #1 only in one language for both content and interface, what if user jumps from #2 or #3 to #1 and then back to #2 or #3, would his languages preference being persistent?

Thank you!

[@ommunist]

Has the same issue. I created “my-languages” folder, but bbPress does not pick up mo and po from it. I also look to find the way to make it compatible with qTranslate.

[Elias_Lapp]

I have a WordPress with WPML plugin and it works ok in all the pages, menus, widgets and plugins.

Now I added the bbpress 2.0 plugin, and there is no way that WPML can read the language .mo files of bbpress.

I tried with CodeStyling Localization (another translate plugin) but the bbpress language files are not available. Localization section of WP shows this:

Textdomain: bbpress

Versión: 2.0

Estado: active

Descripción: bbPress is forum software with a twist from the creators of WordPress.

Compatibility: Loading Issue: Author is using load_textdomain instead of load_plugin_textdomain function. This may break behavior of WordPress, because some filters and actions won’t be executed anymore. Please contact the Author about that.

How can I make bbpress 2.0 will be multilingual as the entire content?

Thanks!

[OC2PS]

I use phpBB at the moment. It used to be pretty bad but version 3 is acceptable.

The 3 things I hate about phpBB are:

1) Lack of SEO URLs/ pretty URLs/ custom permalinks structures

2) There are no plugins. There are MODs – meaning installation is a pain in the back and code is changed. Forget about updations completely – it is excruciating. Contrasts with the rather pleasant one-click installs and upgrades that WordPress has made me accustomed to.

3) Lack of multilingual capability. WordPress has WPML…though I am getting increasingly disillusioned with it (critical features missing, basic things like Canadian flag, Slovak language etc missing, not using international conventions in naming, arrogant and unhelpful support etc). I run a multilingual site and need multilingual forums. If that’s not possible, then to begin with I need a Google Translate gadget so that people can read in multiple languages at least.

It’s not just the lack of these features that cheeses me off…it’s the unwillingness of the developer community to consider these for 3.1/3.2

And there is a major rewrite underway v4. I believe v4 will be the wipeout of phpBB…they are writing from the ground up, which is never a great idea (http://www.joelonsoftware.com/articles/fog0000000069.html)

So excellent opportunity for bbPress.

I would switch as soon as I see the aforementioned 3 in bbPress…

[Ricardo]

i downloaded the last free WPML version and i was able to create a po file with all the english strings (158 entries), we can start translating…

@JJJ

can we use the mo files with the latest bbpress?

[Ricardo]

i downloaded the last free WPML version and i was able to create a po file with all the english strings (158 entries), we can start translating…

@JJJ

can we use the mo files with the latest bbpress?

[appliantologist]

Hello,

wpml-translation-management has the ability to extract all the strings from your plugin and give you a .po file to translate.

[appliantologist]

Hello,

wpml-translation-management has the ability to extract all the strings from your plugin and give you a .po file to translate.

[Lightheaded]

I have resolved the problem. All I did was specify the MO file name in WPML settings. Didn’t know they were related..

-edit- Nope, not resolved afterall. It appears that the localization file is grabbed from [wp-dir]/wp-content/languages, not the bbpress loc. file. And some strings remain untranslated, like posts count, RSS feed links and freshness times..

[Lightheaded]

I have resolved the problem. All I did was specify the MO file name in WPML settings. Didn’t know they were related..

-edit- Nope, not resolved afterall. It appears that the localization file is grabbed from [wp-dir]/wp-content/languages, not the bbpress loc. file. And some strings remain untranslated, like posts count, RSS feed links and freshness times..