To my fellow users of Kunena with Community Builder.

I'm trying to get a better understanding of the integration between CB 1.2.1 and Kunena 1.0.10. I have a message posted here at the joomlapolis site and some folks there have been helpful but since I don't have all the answers yet there and this has to do with Kunena too I wanted to query members here as well.

I'm a bit confused despite having good integration between CB and K, something I have waited for to happen for a long time now, and am grateful for the efforts, I still have an issue with old signatures not being available.

I updated a copy of my live site from CB 1.1 to 1.2.1 and Fireboard 1.04 directly to Kunena 1.0.10 and all WORKS correctly now

Except, the signature files that were once in CB are no longer available to me. They seem to be stored NOW (post upgrade) in KUNENA's jos_fb_users table where before I had them stored in jos_comprofiler's table.

I can add a signature via the new profile forum tab, and it shows up in the forum, but the old signatures from before did not make their way over via upgrade.

IS THIS BY DESIGN? ARE SIGNATURES SUPPOSED TO BE IN KUNENA'S DATABASE NOW AND NOT IN CB'S DATABASE?

If so, is there some way, maybe through SQL script through my phpmyadmin I can make everyone's signature info get copied over to where it is supposed to be now?

Thanks for reading.

Hmmm, it appears I may have myself an isolated situation. I guess I should make plans to inform my users before the upgrade takes place to take note of what their signatures are so they can re-enter them when the new upgraded site is launched.

Would have liked this migration to bring the sig data over but at least after this one snafu everything will work nicely.

Something like this:

UPDATE jos_fb_users AS u, jos_comprofiler as c SET u.signature=c.[SIGNATURE_FIELD] WHERE u.id = c.userid;

Thank you, I have tried this. When I enter the code you entered above I get:

#1064 - 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 '[SIGNATURE_FIELD] WHERE u.id = c.userid' at line 1

I then tried:

UPDATE jos_fb_users AS u, jos_comprofiler as c SET u.signature=c.fbsignature WHERE u.id = c.userid;

I thought maybe I should change [SIGNATURE_FIELD] to fbsignature but when I did that I got:

#1054 - Unknown column 'u.id' in 'where clause'

Is there a typo somewhere in this SQL? Sorry I'm not the sharpest SQL coder.

G'day itgl72

I know that you've struggled patiently with this problem for the past couple of months, but there's light at the end of the tunnel!

First of all, the answer to your question "Where are the signatures now?" The changes in Kunena 1.0.10 and Community Builder 1.2.1 have not changed where Kunena obtains the signature information. The signature information, used in Kunena's forums, has always been obtained from the Kunena user profile.

What has changed is that users can now update the Kunena forum signatures directly from the Community Builder user profile!

However, if you have just installed K 1.0.10 with CB 1.2.1, and you have set Kunena Configuration » Integration » Profile Settings » Profile = Community Builder, you may be wondering why your Community Builder users' signatures are not appearing in your forum! I think this is at the heart of itgl72's problem and what Matias was trying to suggest to overcome the problem.

Installing K 1.0.10 (or integrating it with CB 1.2.1) does not initialise the signature information.

Before K 1.0.10, Community Builder didn't work with Kunena w.r.t. the user's ability to update signature information (among other things). Matias offered a workaround to synch the information between CB's user table and the Kunena user table - see Signature, ordering and viewtype migration script for CB. The problem with this workaround was that the SQL procedure needed to be repeatedly run at regular intervals.

With K 1.0.10 the need for this "synchronisation" has disappeared ... except for the purposes of initialising the Kunena signatures from the CB user profiles. This is the core of your problem.

Therefore, in order to initialise your Kunena data with existing Community Builder information, you will need to run this SQL procedure once:
The above procedure assumes that your Joomla table prefix is "jos_".

The reason that your attempt failed was an error in your WHERE clause.

Code:
UPDATE
jos_fb_users AS a,
jos_comprofiler AS b
SET
a.ordering = b.fbordering,
a.signature = b.fbsignature
WHERE a.userid = b.user_id


THANK YOU! Thats how you lay down some community support. Karma coming your way, this fixed my issue. I can put the hammer back in the toolbox now.

You're very welcome, mate

Helped me out as well - Thanks!

I recommend stickying this or putting this info somewhere as this is going to be helpful to everyone migrating from fb who used the cb plugin.

God bless

WoW! Tks for that! Just solved my problem!

It was killing my mind!

hey folks,

I've tried running the script so I my users can add sigs but I get the following error

#1054 - Unknown column 'b.fbordering' in 'field list'

I'm running CB 1.2.1 and Kunena 1.5.7