mySQL error 1064
hi,
ich möchte in "SugarCRM" ein Modul namens "CalendarNotes" einbauen. Bei der installation entsteht allerdings folgender Fehler: Code:
Error creating table: CalendarNotes: Query Failed:CREATE TABLE CalendarNotes (id char(36) NOT NULL ,date_entered datetime NOT NULL ,date_modified datetime NOT NULL ,assigned_user_id char(36) NULL ,created_by char(36) NULL ,modified_user_id char(36) NOT NULL ,deleted bool DEFAULT 0 NOT NULL ,type varchar(25) NULL ,date_start date NOT NULL ,date_end date NOT NULL ,name varchar(150) NULL ,date_selection varchar(10) NULL ,duration int DEFAULT '1' NULL ,repeat varchar(5) DEFAULT 'none' NULL ,repeat_times int DEFAULT '1' NULL ,repeat_weekday varchar(4) DEFAULT 'non' NULL ,repeat_monthday int DEFAULT '1' NULL ,repeat_month int DEFAULT '1' NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL 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 'repeat varchar(5) DEFAULT 'none' NULL ,repeat_times int DEFAULT '1' NULL ,repe' at line 1 Grüße, Flash613 |
AW: mySQL error 1064
Versuch es mal so:
Code:
CREATE TABLE CalendarNotes ( |
Alle Zeitangaben in WEZ +2. Es ist jetzt 09:05:58 Uhr. |
Powered by vBulletin® Version 3.8.3 (Deutsch)
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.