[Adaman]

Hi Guys,

I am getting the error 6 code with private messaging.

it is covered in this thread but the code supplied dosent seem to work with MySQL 5.

http://forums.pligg.com/general-help...umber-6-a.html

CREATE TABLE `pligg_messages` (
`idMsg` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 250 ) NOT NULL ,
`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'
) TYPE = MYISAM ;

Thanks for any help

Adam

[Adaman]

Solved it with the code below for MYSQL 5 database's.

CREATE TABLE `pligg_messages` (
  `idMsg` int(11) NOT NULL auto_increment,
  `title` varchar(250) 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(14) NOT NULL,
  PRIMARY KEY  (`idMsg`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Adam