Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 1064 please help 1

Status
Not open for further replies.
edie209

edie209

MIS
Sep 18, 2000
106
I am trying to use the following but it gives me an error

#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 '(hdu_id)
) TYPE=MyISAM' at line 32

I will be really honest I haven't got a clue can anyone help me the query is as follows.(its for a website plugin)


CREATE TABLE hdunit (
hdu_id int(10) unsigned NOT NULL auto_increment,
hdu_datestamp int(10) unsigned NOT NULL default '0',
hdu_poster varchar(100) NOT NULL default '',
hdu_posterid int(10) unsigned NOT NULL default '0',
hdu_category int(10) unsigned NOT NULL default '0',
hdu_summary varchar(50) NOT NULL default '',
hdu_description text NOT NULL,
hdu_priority tinyint(3) unsigned NOT NULL default '0',
hdu_resolution int(10) unsigned NOT NULL default '0',
hdu_email varchar(100) NOT NULL default '',
hdu_allocated int(10) unsigned NOT NULL default '0',
hdu_tech int(10) unsigned NOT NULL default '0',
hdu_lastchanged int(10) unsigned NOT NULL default '0',
hdu_closed int(10) unsigned NOT NULL default '0',
hdu_tagno varchar(20) NOT NULL default '',
hdu_return tinyint(3) unsigned NOT NULL default '0',
hdu_lastcomment int(10) unsigned NOT NULL default '0',
hdu_fix int(10) unsigned NOT NULL default '0',
hdu_fixother text,
hdu_fixcost decimal(8,2) NOT NULL default '0.00',
hdu_notifyme tinyint(3) unsigned NOT NULL default '0',
hdu_distance int(10) unsigned NOT NULL default '0',
hdu_drate decimal(8,2) NOT NULL default '0.00',
hdu_dcost decimal(8,2) NOT NULL default '0.00',
hdu_hours decimal(8,2) NOT NULL default '0.00',
hdu_hrate decimal(8,2) NOT NULL default '0.00',
hdu_hcost decimal(8,2) NOT NULL default '0.00',
hdu_callout decimal(8,2) NOT NULL default '0.00',
hdu_eqptcost decimal(8,2) not null default '0.00',
hdu_totalcost decimal(8,2) not null default '0.00'
PRIMARY KEY (hdu_id)
) TYPE=MyISAM;
CREATE TABLE hdu_comments (
hduc_id int(10) unsigned NOT NULL auto_increment,
hduc_ticketid int(10) unsigned NOT NULL default '0',
hduc_poster varchar(100) NOT NULL default '',
hduc_posterid int(10) unsigned NOT NULL default '0',
hduc_date int(10) unsigned NOT NULL default '0',
hduc_status tinyint(1) unsigned NOT NULL default '0',
hduc_comment text
PRIMARY KEY (hduc_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_prefs (
hduprefs_id int(10) unsigned NOT NULL auto_increment,
hduprefs_mailhelpdesk tinyint(3) unsigned NOT NULL default '1',
hduprefs_mailtechnician tinyint(3) unsigned NOT NULL default '1',
hduprefs_mailuser tinyint(3) unsigned NOT NULL default '1',
hduprefs_helpdeskemail varchar(100) default 'helpdesk@yourdomain.com',
hduprefs_usersubject varchar(100) default 'Subject for email to user for a new ticket',
hduprefs_helpdesksubject varchar(100) default 'Subject for email to helpdesk for a new ticket',
hduprefs_techniciansubject varchar(100) default 'Subject for email to technician new assignment',
hduprefs_helpupsubject VARCHAR(100) default 'Helpdesk update subject',
hduprefs_technicianupsubject VARCHAR(100) default 'Technicians update subject',
hduprefs_userupsubject VARCHAR(100) default 'User Updated Subject',
hduprefs_emailfrom varchar(100) default 'helpdesk@yourdomain.com',
hduprefs_sendas tinyint(3) unsigned default '0',
hduprefs_usertext varchar(200) default 'text to user for new ticket',
hduprefs_helpdesktext varchar(200) default 'text to helpdesk for new ticket',
hduprefs_techniciantext varchar(200) default 'text to technician for new assignment',
hduprefs_updateuser varchar(200) default 'text to user for update ticket',
hduprefs_updatetechnician varchar(200) default 'text to technician for update ticket',
hduprefs_updatehelpdesk varchar(200) default 'text to helpdesk for update ticket',
hduprefs_messagetop varchar(200) default 'text at top of list',
hduprefs_messagebottom varchar(200) default 'text at bottom of list',
hduprefs_phone varchar(20) default '',
hduprefs_rows tinyint(3) unsigned NOT NULL default '10',
hduprefs_escalateon tinyint(3) unsigned NOT NULL default '1',
hduprefs_escalatedays tinyint(3) unsigned NOT NULL default '10',
hduprefs_autoclosedays tinyint(3) unsigned NOT NULL default '10',
hduprefs_autocloseres int(10) unsigned NOT NULL default '0',
hduprefs_defaultres int(10) unsigned NOT NULL default '0',
hduprefs_reopen tinyint(3) unsigned NOT NULL default '1',
hduprefs_allread tinyint(3) unsigned NOT NULL default '1',
hduprefs_posteronly tinyint(3) unsigned NOT NULL default '1',
hduprefs_title varchar(25) NOT NULL default 'Helpdesk',
hduprefs_menutitle varchar(25) NOT NULL default 'Helpdesk Menu',
hduprefs_showassettag tinyint(3) unsigned NOT NULL default '1',
hduprefs_showfixes tinyint(3) unsigned NOT NULL default '1',
hduprefs_showfinance tinyint(3) unsigned NOT NULL default '1',
hduprefs_userclass int(10) unsigned NOT NULL default '253',
hduprefs_technicianclass int(10) unsigned NOT NULL default '253',
hduprefs_supervisorclass int(10) unsigned NOT NULL default '253',
hduprefs_hourlyrate decimal(6,2) NOT NULL default '0.00',
hduprefs_distancerate decimal(6,2) NOT NULL default '0.00',
hduprefs_callout decimal(6,2) NOT NULL default '0.00',
hduprefs_showfinusers tinyint(3) unsigned NOT NULL default '1',
hduprefs_force2col tinyint(3) unsigned NOT NULL default '0',
hduprefs_mailpdf tinyint(3) unsigned NOT NULL default '1',
hduprefs_p1col varchar(10) default '#009900',
hduprefs_p2col varchar(10) default '#669933',
hduprefs_p3col varchar(10) default '#CC9933',
hduprefs_p4col varchar(10) default '#990000',
hduprefs_p5col varchar(10) default '#CC3300',
hduprefs_assignto tinyint(3) unsigned NOT NULL default '0'
hduprefs_restech tinyint(3) UNSIGNED NOT NULL default '0',
hduprefs_autoassign tinyint(3) UNSIGNED NOT NULL default '0',
hduprefs_assigned int(10) UNSIGNED NOT NULL default '0',
hduprefs_closestat int(10) UNSIGNED NOT NULL default '0',
PRIMARY KEY (hduprefs_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_categories (
hducat_id int(10) unsigned NOT NULL auto_increment,
hducat_category varchar(30) default NULL,
hducat_order int(10) unsigned NOT NULL default '0',
hducat_helpdesk int(10) unsigned NOT NULL default '0'
PRIMARY KEY (hducat_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_fixes (
hdufix_id int(10) unsigned NOT NULL auto_increment,
hdufix_fix varchar(30) default NULL,
hdufix_fixcost decimal(8,2) NOT NULL default '0.00',
hdufix_order int(10) unsigned NOT NULL default '0'
PRIMARY KEY (hdufix_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_resolve (



hdures_id int(10) unsigned NOT NULL auto_increment,
hdures_resolution varchar(30) default NULL,
hdures_order int(10) unsigned NOT NULL default '0',
hdures_help varchar(100) NOT NULL default '',
hdures_closed tinyint(3) unsigned NOT NULL default '0'
PRIMARY KEY (hdures_id),
KEY hdures_id (hdures_id)
) TYPE=MyISAM;
CREATE TABLE hdu_helpdesk (
hdudesk_id int(10) unsigned NOT NULL auto_increment,
hdudesk_name varchar(30) default NULL,
hdudesk_class int(10) unsigned NOT NULL default '0',
hdudesk_email varchar(100) NOT NULL default '',
hdudesk_order int(10) unsigned NOT NULL default '0',
PRIMARY KEY (hdudesk_id),
KEY hdures_id (hdudesk_id)
) TYPE=MyISAM;
 
Sort by date Sort by votes
Thank for the quick reply I changed the code to this

CREATE TABLE hdunit (
hdu_id int(10) unsigned NOT NULL auto_increment,
hdu_datestamp int(10) unsigned NOT NULL default '0',
hdu_poster varchar(100) NOT NULL default '',
hdu_posterid int(10) unsigned NOT NULL default '0',
hdu_category int(10) unsigned NOT NULL default '0',
hdu_summary varchar(50) NOT NULL default '',
hdu_description text NOT NULL,
hdu_priority tinyint(3) unsigned NOT NULL default '0',
hdu_resolution int(10) unsigned NOT NULL default '0',
hdu_email varchar(100) NOT NULL default '',
hdu_allocated int(10) unsigned NOT NULL default '0',
hdu_tech int(10) unsigned NOT NULL default '0',
hdu_lastchanged int(10) unsigned NOT NULL default '0',
hdu_closed int(10) unsigned NOT NULL default '0',
hdu_tagno varchar(20) NOT NULL default '',
hdu_return tinyint(3) unsigned NOT NULL default '0',
hdu_lastcomment int(10) unsigned NOT NULL default '0',
hdu_fix int(10) unsigned NOT NULL default '0',
hdu_fixother text,
hdu_fixcost decimal(8,2) NOT NULL default '0.00',
hdu_notifyme tinyint(3) unsigned NOT NULL default '0',
hdu_distance int(10) unsigned NOT NULL default '0',
hdu_drate decimal(8,2) NOT NULL default '0.00',
hdu_dcost decimal(8,2) NOT NULL default '0.00',
hdu_hours decimal(8,2) NOT NULL default '0.00',
hdu_hrate decimal(8,2) NOT NULL default '0.00',
hdu_hcost decimal(8,2) NOT NULL default '0.00',
hdu_callout decimal(8,2) NOT NULL default '0.00',
hdu_eqptcost decimal(8,2) not null default '0.00',
hdu_totalcost decimal(8,2) not null default '0.00',
PRIMARY KEY (hdu_id)
) TYPE=MyISAM;
CREATE TABLE hdu_comments (
hduc_id int(10) unsigned NOT NULL auto_increment,
hduc_ticketid int(10) unsigned NOT NULL default '0',
hduc_poster varchar(100) NOT NULL default '',
hduc_posterid int(10) unsigned NOT NULL default '0',
hduc_date int(10) unsigned NOT NULL default '0',
hduc_status tinyint(1) unsigned NOT NULL default '0',
hduc_comment text,
PRIMARY KEY (hduc_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_prefs (
hduprefs_id int(10) unsigned NOT NULL auto_increment,
hduprefs_mailhelpdesk tinyint(3) unsigned NOT NULL default '1',
hduprefs_mailtechnician tinyint(3) unsigned NOT NULL default '1',
hduprefs_mailuser tinyint(3) unsigned NOT NULL default '1',
hduprefs_helpdeskemail varchar(100) default 'helpdesk@yourdomain.com',
hduprefs_usersubject varchar(100) default 'Subject for email to user for a new ticket',
hduprefs_helpdesksubject varchar(100) default 'Subject for email to helpdesk for a new ticket',
hduprefs_techniciansubject varchar(100) default 'Subject for email to technician new assignment',
hduprefs_helpupsubject VARCHAR(100) default 'Helpdesk update subject',
hduprefs_technicianupsubject VARCHAR(100) default 'Technicians update subject',
hduprefs_userupsubject VARCHAR(100) default 'User Updated Subject',
hduprefs_emailfrom varchar(100) default 'helpdesk@yourdomain.com',
hduprefs_sendas tinyint(3) unsigned default '0',
hduprefs_usertext varchar(200) default 'text to user for new ticket',
hduprefs_helpdesktext varchar(200) default 'text to helpdesk for new ticket',
hduprefs_techniciantext varchar(200) default 'text to technician for new assignment',
hduprefs_updateuser varchar(200) default 'text to user for update ticket',
hduprefs_updatetechnician varchar(200) default 'text to technician for update ticket',
hduprefs_updatehelpdesk varchar(200) default 'text to helpdesk for update ticket',
hduprefs_messagetop varchar(200) default 'text at top of list',
hduprefs_messagebottom varchar(200) default 'text at bottom of list',
hduprefs_phone varchar(20) default '',
hduprefs_rows tinyint(3) unsigned NOT NULL default '10',
hduprefs_escalateon tinyint(3) unsigned NOT NULL default '1',
hduprefs_escalatedays tinyint(3) unsigned NOT NULL default '10',
hduprefs_autoclosedays tinyint(3) unsigned NOT NULL default '10',
hduprefs_autocloseres int(10) unsigned NOT NULL default '0',
hduprefs_defaultres int(10) unsigned NOT NULL default '0',
hduprefs_reopen tinyint(3) unsigned NOT NULL default '1',
hduprefs_allread tinyint(3) unsigned NOT NULL default '1',
hduprefs_posteronly tinyint(3) unsigned NOT NULL default '1',
hduprefs_title varchar(25) NOT NULL default 'Helpdesk',
hduprefs_menutitle varchar(25) NOT NULL default 'Helpdesk Menu',
hduprefs_showassettag tinyint(3) unsigned NOT NULL default '1',
hduprefs_showfixes tinyint(3) unsigned NOT NULL default '1',
hduprefs_showfinance tinyint(3) unsigned NOT NULL default '1',
hduprefs_userclass int(10) unsigned NOT NULL default '253',
hduprefs_technicianclass int(10) unsigned NOT NULL default '253',
hduprefs_supervisorclass int(10) unsigned NOT NULL default '253',
hduprefs_hourlyrate decimal(6,2) NOT NULL default '0.00',
hduprefs_distancerate decimal(6,2) NOT NULL default '0.00',
hduprefs_callout decimal(6,2) NOT NULL default '0.00',
hduprefs_showfinusers tinyint(3) unsigned NOT NULL default '1',
hduprefs_force2col tinyint(3) unsigned NOT NULL default '0',
hduprefs_mailpdf tinyint(3) unsigned NOT NULL default '1',
hduprefs_p1col varchar(10) default '#009900',
hduprefs_p2col varchar(10) default '#669933',
hduprefs_p3col varchar(10) default '#CC9933',
hduprefs_p4col varchar(10) default '#990000',
hduprefs_p5col varchar(10) default '#CC3300',
hduprefs_assignto tinyint(3) unsigned NOT NULL default '0'
hduprefs_restech tinyint(3) UNSIGNED NOT NULL default '0',
hduprefs_autoassign tinyint(3) UNSIGNED NOT NULL default '0',
hduprefs_assigned int(10) UNSIGNED NOT NULL default '0',
hduprefs_closestat int(10) UNSIGNED NOT NULL default '0',
PRIMARY KEY (hduprefs_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_categories (
hducat_id int(10) unsigned NOT NULL auto_increment,
hducat_category varchar(30) default NULL,
hducat_order int(10) unsigned NOT NULL default '0',
hducat_helpdesk int(10) unsigned NOT NULL default '0',
PRIMARY KEY (hducat_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_fixes (
hdufix_id int(10) unsigned NOT NULL auto_increment,
hdufix_fix varchar(30) default NULL,
hdufix_fixcost decimal(8,2) NOT NULL default '0.00',
hdufix_order int(10) unsigned NOT NULL default '0',
PRIMARY KEY (hdufix_id)
) TYPE=MyISAM ;
CREATE TABLE hdu_resolve (


And now I get a different error

#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 'hduprefs_restech tinyint(3) UNSIGNED NOT NULL default '0',
hduprefs_autoassig' at line 53

Hope you can help
 
Upvote 0 Downvote
Tony I must be being stupid because I can't see a comma missing before the PRIMARY KEY clause. Please excuse my ignorance but this is my first experience with sql
 
Upvote 0 Downvote
The error message tells you the line number and quotes the text around where the problem is. If you look there you'll see that there's a comma missing.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

David Higgs
  • Locked
  • Question
ERROR lower_case_table_names
Replies
0
Views
189
David Higgs
David Higgs
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
156
madcelt
madcelt
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
137
spamjim
spamjim
Abeer60
  • Locked
  • Question
LAG error
Replies
1
Views
167
feherke
feherke
AM_WG
  • Locked
  • Question
I need some help with SQL
Replies
13
Views
279
AM_WG
AM_WG

Part and Inventory Search

Sponsor

Back
Top