Help - Search - Members - Calendar
Full Version: Error Please Help
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
Brandon
When i create this table I get the following

CODE
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: 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 '`message` TEXT NOT NULL ,
`from` INT( 11 ) NOT NULL ,
`to` INT( 11 ) NOT NULL ' at line 4

Can Anyone Help me With This ?

Thanks Allot Crown
Alex
Erm... you've missed a comma after the NULL and before `message` (and you don't need to define NULL at all, it's the default, only NOT NULL is required).
Brandon
QUOTE(webchababe @ Jan 4 2008, 07:52 PM) *
you can chabge ligne 94

Dont Worrie Sorted Now
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.