send message to friend buggy

[argh2xxx]

Pure install, message friend didn't work, well the form with overlay javascript/lightbox/thickbox did popup, and I can enter text, but when hit send, the thing then loaded up the whole freaking profile page with search users shown... and bunch of mess up layout looks... but no close button to finish up the sending process.

Then when I check the inbox of test accounts, no message was in sight. So the whole send a message to friend thing is so buggy and not working.

This is pligg 9.8 pure install...

BLOGMYWAY News beta 9 / Published News

[chuckroast]

Hi argh2xxx

Pure install huh?
I went to your site. I see your running Pligg 9.8 with a template not made for 9.8- I also see you've modified the code to include advertising.

Either one of those things could easily be causing the problem.

[argh2xxx]

How do you explain about the message is not receiving when sent?

On firefox... message can't send due to error number 6... the overlay javascript effect said.

On ie7... just pop up a page got frame by the effect, and the page was the profile page filled with things not relate to send message.

[AshDigg]

Check to make sure you have a 'messages' MySQL table. Thats usually the reason for Error Number 6.

[argh2xxx]

I don't have the messages MySQL table, so how do I create one? Can you give me the mysql querry for this one? thanks...

[AshDigg]

Originally Posted by argh2xxx

I don't have the messages MySQL table, so how do I create one? Can you give me the mysql querry for this one? thanks...

PHP Code:

CREATE TABLE `YOURPREFIX_MESSAGES` (
  `idMsg` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  `sender` int(11) NOT NULL default '0',
  `receiver` int(11) NOT NULL default '0',
  `senderLevel` int(11) NOT NULL default '0',
  `readed` int(11) NOT NULL default '0',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idMsg`)
) TYPE = MyISAM; 


Replace YOURPREFIX_MESSAGES with your table prefix and then _MESSAGES. In phpMyAdmin there is an SQL tab that will allow you to paste in the code. You'll probably get an error (since the installer couldn't run this code) so just give us the error message you get so we can troubleshoot.

[argh2xxx]

this is for 'config' table, how about 'message' table? I have 'config' table in my db...

[AshDigg]

Originally Posted by argh2xxx

this is for 'config' table, how about 'message' table? I have 'config' table in my db...

Whoops! Sorry about that. I updated the post to show the right table.

[argh2xxx]

As you expected the querry you gave phpmyadmin is currently has trouble to make it work, and so here is the error...

MySQL said: Documentation
#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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY

---- please help me troubleshoot, thank you... -----

[argh2xxx]

bump... bump...