[code:1]SQL errorDB function failed with error number 1054
Unknown column 'time' in 'field list' SQL=INSERT INTO jos_pms (username,whofrom,date,time,readstate,subject,message) VALUES('ccstudios','shuai',CURDATE(),CURTIME(),0,'You have a pending connection from shuai!','
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\nshuai is requesting to connect with you and requires your approval. Please accept or deny the connection request accordingly. shuai included the following personal message:\n
\n
yo\n

Manage Connections\n');
SQL =

INSERT INTO jos_pms (username,whofrom,date,time,readstate,subject,message) VALUES('ccstudios','shuai',CURDATE(),CURTIME(),0,'You have a pending connection from shuai!','
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\nshuai is requesting to connect with you and requires your approval. Please accept or deny the connection request accordingly. shuai included the following personal message:\n
\n
yo\n

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

That is the error I get... please help!




EDIT> also when I accept one, it says:
[code:1]SQL errorDB function failed with error number 1054
Unknown column 'time' in 'field list' SQL=INSERT INTO jos_pms (username,whofrom,date,time,readstate,subject,message) VALUES('foo','shuai',CURDATE(),CURTIME(),0,'Connection Request Accepted!','
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\nYour request to connect with shuai was accepted!\n

Manage Connections\n');
SQL =

INSERT INTO jos_pms (username,whofrom,date,time,readstate,subject,message) VALUES('foo','shuai',CURDATE(),CURTIME(),0,'Connection Request Accepted!','
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\nYour request to connect with shuai was accepted!\n

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

Post edited by: shuai, at: 2005/12/26 02:01

this is related to the private messaging system.

select the right connection notifcation method in the backend.

iow: if you want pm notifcations, make sure mypms is actually installed

I see, thanks. I think it's because I'm using MyPMS 2.5 Alpha.