8 replies to this topic

[Paul]

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

[Tyson D]

You need a comma!

Insert a comma in between these two fields:

`title` VARCHAR( 255 ) NULL,
`message` TEXT NOT NULL ,

[Paul]

thanks so much

[Tyson D]

No problem pal!

[Paul]

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/

[Tyson D]

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...

[Paul]

thanks

[Nick Mok]

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

[Niklas]

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......

Edited by Niklas, 12 November 2011 - 11:33 AM.