solved PMS 2.0.x with updated CB 1.0.2 Problem

SOLVED - (i'm stupid)



Hello World!

CB 1.0.2 and PMS 2.0.x working fine together on a fresh installation:)

Unfortunatly I have still a problem on my joomla with a CB updated to 1.0.2

I had the pms tables complete deleted and pms new installed (now 2.0.3) AND i had included the updated "pms.mypmspro.php" provided by NICK on forge.joomla.org/sf/go/artf6909?nav=1

If I establish or revoke connections within CB i get errors like that:

[code:1]SQL errorDB function failed with error number 1054
Unknown column 'username' in 'field list' SQL=INSERT INTO mg_pms (username,whofrom,date,readstate,subject,message) VALUES('Krystofiak','admin',NOW(),0,'You have a pending connection from Administrator moveGreen!','
NOTE: This is a message generated automatically by the Connections system. It has the connecting user\'s address, so you can conveniently reply if you wish to.
\n\nAdministrator moveGreen is requesting to connect with you and requires your approval. Please accept or deny the connection request accordingly. Administrator moveGreen included the following personal message:\n
\n
w4576w45z\n

Manage Connections\n');
SQL =

INSERT INTO mg_pms (username,whofrom,date,readstate,subject,message) VALUES('Krystofiak','admin',NOW(),0,'You have a pending connection from Administrator moveGreen!','
NOTE: This is a message generated automatically by the Connections system. It has the connecting user\'s address, so you can conveniently reply if you wish to.
\n\nAdministrator moveGreen is requesting to connect with you and requires your approval. Please accept or deny the connection request accordingly. Administrator moveGreen included the following personal message:\n
\n
w4576w45z\n

Manage Connections\n');[/code:1]


So i think the update to CB 1.0.2 was not complete succsessfull in the Database !???

Can anybody can give me a hint where to search? please?
I spend hours but cant find the bug:(

Sunny regards from Hanover, Germany

Bernd

Post edited by: Krystofiak, at: 2006/12/12 11:37

exact same problem addressed before (twice by me).

you have probably selected the wrong pms type in the generic pms plugin available in CB 1.0.2.

You have selected the pms os version instead of the pms enhanced.

Hello Nick,

this would be to easy;)

You can only chose the kind of PMS System in the CB Login Modul.

In fact, here i have choosen the PMS Enhanced 2.x.


The Communiy Builder was uninstalled und reinstalled in the Version 1.0.2 and I have replaced the pms.mypmspro.php with the modificated version.

Do i have missed something`?


BEst Regards

Bernd

Yes you have missed something.

You can search these forums for the other 2 times I addressed this or you can make me address it once again.

What the heck ... you need to tell the CB Plugin that the PMS component you installed is PMS Enhanced. This you do in the CB Plugin Management area. See the MY PMS OS & Pro plugin and look at the first parameter.

OH MY GOD !!! :woohoo:


Thats so embarrassing:blush: :blush: :blush:

Can someone please delete this thread? (its a shame)

Thank you to help the idiot:dry: :blush:

No more comment:whistle:


Sunny regards

BErnd

Post edited by: Krystofiak, at: 2006/12/12 11:35