i imported this code to myphpadmin
CREATE TABLE `messages` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 255 ) NULL
`message` TEXT NOT NULL ,
`from` INT( 11 ) NOT NULL ,
`to` INT( 11 ) NOT NULL ,
`from_viewed` BOOL NOT NULL DEFAULT '0',
`to_viewed` BOOL NOT NULL DEFAULT '0',
`from_deleted` BOOL NOT NULL DEFAULT '0',
`to_deleted` BOOL NOT NULL DEFAULT '0',
`from_vdate` DATETIME NULL ,
`to_vdate` DATETIME NULL ,
`from_ddate` DATETIME NULL ,
`to_ddate` DATETIME NULL ,
`created` DATETIME NOT NULL
) ENGINE = MYISAM ;
but i get this error message
Error
SQL query:
CREATE TABLE `messages` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 255 ) NULL `message` TEXT NOT NULL ,
`from` INT( 11 ) NOT NULL ,
`to` INT( 11 ) NOT NULL ,
`from_viewed` BOOL NOT NULL DEFAULT '0',
`to_viewed` BOOL NOT NULL DEFAULT '0',
`from_deleted` BOOL NOT NULL DEFAULT '0',
`to_deleted` BOOL NOT NULL DEFAULT '0',
`from_vdate` DATETIME NULL ,
`to_vdate` DATETIME NULL ,
`from_ddate` DATETIME NULL ,
`to_ddate` DATETIME NULL ,
`created` DATETIME NOT NULL ) ENGINE = MYISAM
MySQL said:
#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 '`message` TEXT NOT NULL ,
`from` INT( 11 ) NOT NULL ,
`to` INT( 11 ) NOT NULL ' at line 4
any help would be great
Simple Private Messaging System
Started by
Paul
, Jul 30 2008 07:08 AM
8 replies to this topic
#1
Posted 30 July 2008 - 07:08 AM
#2
Posted 30 July 2008 - 08:17 AM
You need a comma!
Insert a comma in between these two fields:
`title` VARCHAR( 255 ) NULL,
`message` TEXT NOT NULL ,
Insert a comma in between these two fields:
`title` VARCHAR( 255 ) NULL,
`message` TEXT NOT NULL ,
#3
Posted 30 July 2008 - 09:25 AM
thanks so much
#4
Posted 30 July 2008 - 10:35 AM
No problem pal!
#5
Posted 30 July 2008 - 11:46 AM
im stuck on the second part and third part as it dosent let us know what to name the files or anything
can someone please help
http://www.pixel2lif...g_system/page2/
can someone please help
http://www.pixel2lif...g_system/page2/
#6
Posted 30 July 2008 - 01:14 PM
It looks to me (at first glance) that the code on the first page at the bottom is config.php, the second page is being referred to as pm.php and the third page can be named whatever you'd like...
#7
Posted 31 July 2008 - 05:32 AM
thanks
#8
Posted 28 October 2008 - 02:30 AM
Where abouts do you put the comma? and where do you put the SQL? with a new database or with the same database you made for the login ?
Nick
Nick
#9
Posted 12 November 2011 - 11:33 AM
hello...
do any one now hove to make the script works...
i have install the script on my server,,
i have make the tabel message and user
CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`message` text NOT NULL,
`from` int(11) NOT NULL,
`to` int(11) NOT NULL,
`from_viewed` tinyint(1) NOT NULL DEFAULT '0',
`to_viewed` tinyint(1) NOT NULL DEFAULT '0',
`from_deleted` tinyint(1) NOT NULL DEFAULT '0',
`to_deleted` tinyint(1) NOT NULL DEFAULT '0',
`from_vdate` datetime DEFAULT NULL,
`to_vdate` datetime DEFAULT NULL,
`from_ddate` datetime DEFAULT NULL,
`to_ddate` datetime DEFAULT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `user` (
`userid` int(11) NOT NULL,
`username` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
but all i get is...
Error, couldn't send PM. Maybe wrong user.
please help me......
do any one now hove to make the script works...
i have install the script on my server,,
i have make the tabel message and user
CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`message` text NOT NULL,
`from` int(11) NOT NULL,
`to` int(11) NOT NULL,
`from_viewed` tinyint(1) NOT NULL DEFAULT '0',
`to_viewed` tinyint(1) NOT NULL DEFAULT '0',
`from_deleted` tinyint(1) NOT NULL DEFAULT '0',
`to_deleted` tinyint(1) NOT NULL DEFAULT '0',
`from_vdate` datetime DEFAULT NULL,
`to_vdate` datetime DEFAULT NULL,
`from_ddate` datetime DEFAULT NULL,
`to_ddate` datetime DEFAULT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `user` (
`userid` int(11) NOT NULL,
`username` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
but all i get is...
Error, couldn't send PM. Maybe wrong user.
please help me......
Edited by Niklas, 12 November 2011 - 11:33 AM.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users