Hallo,
folgendes Problem habe ich wenn ich aus dem /calendar/SQL die "mysql.sql" Datei per phpmyadmin in meine Roundcube Datenbank importieren möchte:
Fehler
SQL-Befehl:
CREATE TABLE `events` ( `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uid` text, `recurrence_id` text, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `start` int(10) unsigned NOT NULL DEFAULT '0', `end` int(10) unsigned NOT NULL DEFAULT '0', `expires` int(10) unsigned NOT NULL DEFAULT '0', `rr` varchar(1) default NULL, `recurring` text NOT NULL, `occurrences` int(11) DEFAULT '0', `byday` text, `bymonth` text, `bymonthday` text, `summary` varchar(255) NOT NULL, `description` text NOT NULL, `location` varchar(255) NOT NULL DEFAULT '', `categories` varchar(255) NOT NULL DEFAULT '', `all_day` tinyint(1) NOT NULL DEFAULT '0', `group` text, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `del` int(1) NOT NULL DEFAULT '0', `notified` int(1) NOT NULL default '0', `client` text, PRIMARY KEY (`event_id`), CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASC[...]
MySQL meldet: Dokumentation
#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 'CREATE TABLE `events_cache` (
`event_id` int(11) unsigned NOT NULL AUTO_INCRE' at line 30
Ich nutze Roundcube 0.5, MySQL 5.0.51a-24+lenny5
Danke, Markus