new message database error

Hello.
Uddeim is working fine on my joomla 1.5.
Only problem is when i click on new message link. I have following error:

No valid database connection Table 'xxx_xxxxx.jos_comprofiler_members' doesn't exist SQL=SELECT m.referenceid,m.memberid,u.username as displayname, u.id FROM jos_comprofiler_members AS m, jos_users AS u WHERE u.block=0 AND m.memberid=u.id AND m.referenceid=68 ORDER BY u.username

Message is sent even with that error.

Its like all its working, except for that error only when i click to write a new message. Replying messages is working fine too.

I have read the FAQ and the Readme and search here, i didnt find anything to help me.


Any tip would be helpful.

Thanks

W4llet - Brazil.

The might be two issues:

- You are not using CB but you have enabled CB integration (should not possible since uddeIM checks if CB is installed)
- You are using the new CBE (uses jos_cbe tables) and have enabled CB integration (which uses jos_comprofiler tables).

Under some circumstances the following code may show this warning:

includes.php (line 1077+):

[code:1]function uddeIMdoShowConnections($myself, $my_gid, $config) {
...
$rows = uddeIMselectCBbuddies($myself, $config);
$somanyfriends = count($rows);
[/code:1]

Change this to

[code:1]function uddeIMdoShowConnections($myself, $my_gid, $config) {
...
$somanyfriends = 0;
if (uddeIMcheckCB()) {
$rows = uddeIMselectCBbuddies($myself, $config);
$somanyfriends = count($rows);
}
[/code:1]

Is this working for you?

slabbi wrote:

Under some circumstances the following code may show this warning:

includes.php (line 1077+):

[code:1]function uddeIMdoShowConnections($myself, $my_gid, $config) {
...
$rows = uddeIMselectCBbuddies($myself, $config);
$somanyfriends = count($rows);
[/code:1]

Change this to

[code:1]function uddeIMdoShowConnections($myself, $my_gid, $config) {
...
$somanyfriends = 0;
if (uddeIMcheckCB()) {
$rows = uddeIMselectCBbuddies($myself, $config);
$somanyfriends = count($rows);
}
[/code:1]

Is this working for you?

Dear developer.

After I read your first reply about the CB plugin i went to check there because i dont havy any CB intalled on joomla.

I read your documentation again in your zip file and found i had installed the right component and modules. Nothing related to cb plugins or modules was installed.

So I checked again and i didnt have any CB integration turned on. All CB related options are disable and i cant switch that off like u said in that reply. Only one i can switch to on or "yes" is the CB unblock connection wich is off either.

So, in a desperate act i had all modules and component uninstalled to try to install it again.

Problem now is modules is installed correctly, but the component dont want to install again. For some unknown reason, when i upload and install file on joomla adm panel, my server is terminating connection.

So, I had manually erased all UUI tables related, didnt work too, wishing that was the source of the problem.

I am still investigating why i am having that trouble, because any other component or modules are being installed properly.

As soon i can put your nice message feature back i will change the code as suggested and will give a feed back.

Thanks so much to answering my question in no time.

Best regards,

w4llet - Brazil.

slabbi wrote:

Under some circumstances the following code may show this warning:

[code:1]function uddeIMdoShowConnections($myself, $my_gid, $config) {
...
$somanyfriends = 0;
if (uddeIMcheckCB()) {
$rows = uddeIMselectCBbuddies($myself, $config);
$somanyfriends = count($rows);
}
[/code:1]

Is this working for you?

WOW :woohoo:

Your new code fixed the problem.

Your are a genius.

Thanks so much.

Btw. Problem about reinstall the component was a apache and php server error, nothing related to your component.

I am so happy now. Working 100%

Thanks.

I have released "hotfix1" today which also fixes this bug.