Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Plugin – Private Messages

Ok…I fixed the other errors (still waiting for Ardenfrost to see if they will work or if there is a better way), but I can’t get rid of the following error when I post or reply:

bbPress 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 '19:54:11' at line 1]

SELECT * FROM bb_privatemessages WHERE id_sender = 14 AND created_on = 2006-12-09 19:54:11

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/forum/bb-includes/db.php:147) in /var/www/html/forum/bb-includes/pluggable.php on line 160

The error is generated from the following code in the plugin itself:

function pm_new_message( $id_receiver, $id_sender, $pmtitle, $message ){

global $bbdb, $bb_table_prefix;

$created_on = bb_current_time('mysql');

$bbdb->query("INSERT INTO ".$bb_table_prefix."privatemessages

(id_sender, id_receiver, pmtitle, message, created_on)

VALUES

('$id_sender', '$id_receiver', '$pmtitle', '$message','$created_on')");

$rmess = $bbdb->get_row("SELECT * FROM ".$bb_table_prefix."privatemessages WHERE id_sender = $id_sender AND created_on = $created_on");

return $rmess->pm_id;

}

I would ask anyone that might have an idea for me here to let me know. It doesn’t have a problem with the bb_current_time for posting normally, so I can’t understand why it doesn’t like the timestamp on this one. I have mySQL 4.1.21.

Anyone?

Skip to toolbar