Problem with SQL syntax (probably simple)
Posted
by Bryan Folds
on Stack Overflow
See other posts from Stack Overflow
or by Bryan Folds
Published on 2010-04-17T17:11:36Z
Indexed on
2010/04/17
17:23 UTC
Read the original article
Hit count: 304
I'm doing some custom database work for a module for Drupal and I get the following SQL error when trying to create my table:
user warning: 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 'DEFAULT NULL,
rooms
INT DEFAULT NULL,adults
INT DEFAULT NULL,children
' at line 14 query: CREATE TABLE dr_enquiry (eId
INT unsigned NOT NULL auto_increment,eKey
VARCHAR(16) NOT NULL,dateSent
INT NOT NULL DEFAULT 0,status
VARCHAR(30) NOT NULL DEFAULT 'Unanswered',custName
VARCHAR(50) NOT NULL,custEmail
VARCHAR(200) NOT NULL,custPhone
VARCHAR(25) NOT NULL,custCountry
VARCHAR(40) NOT NULL,custIP
VARCHAR(11) DEFAULT NULL,offerName
VARCHAR(100) NOT NULL,offerURL
VARCHAR(200) NOT NULL,arrival
DATETIME DEFAULT NULL,departure
DEFAULT NULL,rooms
INT DEFAULT NULL,adults
INT DEFAULT NULL,children
INT DEFAULT NULL,childAges
VARCHAR(32) DEFAULT NULL,toddlers
INT DEFAULT NULL,toddlerAges
VARCHAR(32) DEFAULT NULL,catering
VARCHAR(255) DEFAULT NULL,comments
VARCHAR(255) DEFAULT NULL,agent
VARCHAR(100) DEFAULT NULL,voucher
VARCHAR(100) DEFAULT NULL, PRIMARY KEY (eId) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/travelco/public_html/includes/database.inc on line 550.
© Stack Overflow or respective owner