[Réglé] install sous windows: tables non créées
je tente l'installation en local sous xampp et windows : des tables ne se créent pas
Bonjour
je n'arrive pas à obtenir une installation complète - le processus se poursuit malgré les messages ci-dessous - le site semble bon mais n'enregistre pas les articles cra apparemment les tables manquent
l'erreur mysql retournée est tjs la même 1067: Invalid default value for 'edit_id'
voir ci dessous
avez vous une solution ?
sinon c'est beau
[folder] Erreur avec la table 'images' CREATE TABLE `yacs`.`yacs_images` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, image_name VARCHAR(255) DEFAULT '' NOT NULL, image_size INTEGER DEFAULT '0' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, source VARCHAR(255) DEFAULT '' NOT NULL, thumbnail_name VARCHAR(255) DEFAULT '' NOT NULL, link_url VARCHAR(255) DEFAULT '' NOT NULL, use_thumbnail ENUM('A', 'Y','N') DEFAULT 'Y' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX title (title), INDEX image_size (image_size), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, source, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'tables' CREATE TABLE `yacs`.`yacs_tables` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, nick_name VARCHAR(255) DEFAULT '' NOT NULL, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, source VARCHAR(255) DEFAULT '' NOT NULL, query TEXT DEFAULT '' NOT NULL, with_number ENUM('Y','N') DEFAULT 'Y' NOT NULL, with_zoom ENUM('Y','N') DEFAULT 'Y' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX nick_name (nick_name), INDEX anchor (anchor), INDEX title (title), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, source, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'files' CREATE TABLE `yacs`.`yacs_files` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, file_name VARCHAR(255) DEFAULT '' NOT NULL, file_href VARCHAR(255) DEFAULT '' NOT NULL, alternate_href VARCHAR(255) DEFAULT '' NOT NULL, file_size INTEGER DEFAULT '0' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, keywords TEXT DEFAULT '' NOT NULL, source VARCHAR(255) DEFAULT '' NOT NULL, active ENUM('Y','R','N', 'X') DEFAULT 'Y' NOT NULL, hits INT UNSIGNED DEFAULT '0' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id MEDIUMINT DEFAULT '' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX title (title), INDEX active (active), INDEX hits (hits), INDEX file_size (file_size), INDEX create_name (create_name), INDEX create_id (create_id), INDEX create_date (create_date), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, source, description, keywords) ) TYPE=MyISAM 1067: Invalid default value for 'create_id'
Erreur avec la table 'links' CREATE TABLE `yacs`.`yacs_links` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, link_url VARCHAR(255) DEFAULT '' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, keywords VARCHAR(255) DEFAULT '', hits INT UNSIGNED DEFAULT '0' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX link_url (link_url), INDEX title (title), INDEX keywords (keywords), INDEX hits (hits), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, link_url, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'locations' CREATE TABLE `yacs`.`yacs_locations` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'article:1' NOT NULL, geo_place_name VARCHAR(128) DEFAULT '' NOT NULL, geo_position VARCHAR(128) DEFAULT '' NOT NULL, longitude VARCHAR(128) DEFAULT '' NOT NULL, latitude VARCHAR(128) DEFAULT '' NOT NULL, geo_country VARCHAR(128) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX geo_place_name (geo_place_name), INDEX longitude (longitude), INDEX latitude (latitude), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(geo_place_name, geo_country, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'comments' CREATE TABLE `yacs`.`yacs_comments` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, previous_id MEDIUMINT UNSIGNED DEFAULT '' , type VARCHAR(64) DEFAULT 'default' NOT NULL, description TEXT DEFAULT '' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id MEDIUMINT DEFAULT '' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX previous_id (previous_id), INDEX type (type), INDEX create_name (create_name), INDEX create_id (create_id), INDEX create_date (create_date), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(description) ) TYPE=MyISAM 1067: Invalid default value for 'previous_id'
La table 'categories' a été vérifiée et analysée et optimisée.
La table 'members' a été vérifiée et analysée et optimisée.
Erreur avec la table 'actions' CREATE TABLE `yacs`.`yacs_actions` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'article:1' NOT NULL, title VARCHAR(128) DEFAULT '' NOT NULL, target_url VARCHAR(128) DEFAULT '' NOT NULL, status ENUM('O','C','R') DEFAULT 'O' NOT NULL, status_date DATETIME, description TEXT DEFAULT '' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id MEDIUMINT UNSIGNED DEFAULT '1' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX title (title), INDEX status (status), INDEX create_date (create_date), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'servers' CREATE TABLE `yacs`.`yacs_servers` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(128) DEFAULT '' NOT NULL, host_name VARCHAR(128) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, main_url VARCHAR(128) DEFAULT '' NOT NULL, submit_feed ENUM('Y','N') DEFAULT 'N' NOT NULL, feed_url VARCHAR(128) DEFAULT '' NOT NULL, anchor VARCHAR(64) DEFAULT 'category:1' NOT NULL, submit_ping ENUM('Y','N') DEFAULT 'N' NOT NULL, ping_url VARCHAR(128) DEFAULT '' NOT NULL, process_ping ENUM('Y','N') DEFAULT 'Y' NOT NULL, submit_monitor ENUM('Y','N') DEFAULT 'N' NOT NULL, monitor_url VARCHAR(128) DEFAULT '' NOT NULL, process_monitor ENUM('Y','N') DEFAULT 'Y' NOT NULL, submit_search ENUM('Y','N') DEFAULT 'N' NOT NULL, search_url VARCHAR(128) DEFAULT '' NOT NULL, process_search ENUM('Y','N') DEFAULT 'Y' NOT NULL, active ENUM('Y','R','N') DEFAULT 'Y' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX title (title), INDEX host_name (host_name), INDEX main_url (main_url), INDEX submit_monitor (submit_monitor), INDEX submit_ping (submit_ping), INDEX submit_search (submit_search), INDEX active (active), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'versions' CREATE TABLE `yacs`.`yacs_versions` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) NOT NULL, content MEDIUMTEXT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, PRIMARY KEY (id), INDEX anchor (anchor), INDEX edit_date (edit_date) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'[/folder]
je n'arrive pas à obtenir une installation complète - le processus se poursuit malgré les messages ci-dessous - le site semble bon mais n'enregistre pas les articles cra apparemment les tables manquent
l'erreur mysql retournée est tjs la même 1067: Invalid default value for 'edit_id'
voir ci dessous
avez vous une solution ?
sinon c'est beau
[folder] Erreur avec la table 'images' CREATE TABLE `yacs`.`yacs_images` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, image_name VARCHAR(255) DEFAULT '' NOT NULL, image_size INTEGER DEFAULT '0' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, source VARCHAR(255) DEFAULT '' NOT NULL, thumbnail_name VARCHAR(255) DEFAULT '' NOT NULL, link_url VARCHAR(255) DEFAULT '' NOT NULL, use_thumbnail ENUM('A', 'Y','N') DEFAULT 'Y' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX title (title), INDEX image_size (image_size), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, source, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'tables' CREATE TABLE `yacs`.`yacs_tables` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, nick_name VARCHAR(255) DEFAULT '' NOT NULL, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, source VARCHAR(255) DEFAULT '' NOT NULL, query TEXT DEFAULT '' NOT NULL, with_number ENUM('Y','N') DEFAULT 'Y' NOT NULL, with_zoom ENUM('Y','N') DEFAULT 'Y' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX nick_name (nick_name), INDEX anchor (anchor), INDEX title (title), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, source, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'files' CREATE TABLE `yacs`.`yacs_files` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, file_name VARCHAR(255) DEFAULT '' NOT NULL, file_href VARCHAR(255) DEFAULT '' NOT NULL, alternate_href VARCHAR(255) DEFAULT '' NOT NULL, file_size INTEGER DEFAULT '0' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, keywords TEXT DEFAULT '' NOT NULL, source VARCHAR(255) DEFAULT '' NOT NULL, active ENUM('Y','R','N', 'X') DEFAULT 'Y' NOT NULL, hits INT UNSIGNED DEFAULT '0' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id MEDIUMINT DEFAULT '' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX title (title), INDEX active (active), INDEX hits (hits), INDEX file_size (file_size), INDEX create_name (create_name), INDEX create_id (create_id), INDEX create_date (create_date), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, source, description, keywords) ) TYPE=MyISAM 1067: Invalid default value for 'create_id'
Erreur avec la table 'links' CREATE TABLE `yacs`.`yacs_links` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, link_url VARCHAR(255) DEFAULT '' NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, keywords VARCHAR(255) DEFAULT '', hits INT UNSIGNED DEFAULT '0' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX link_url (link_url), INDEX title (title), INDEX keywords (keywords), INDEX hits (hits), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, link_url, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'locations' CREATE TABLE `yacs`.`yacs_locations` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'article:1' NOT NULL, geo_place_name VARCHAR(128) DEFAULT '' NOT NULL, geo_position VARCHAR(128) DEFAULT '' NOT NULL, longitude VARCHAR(128) DEFAULT '' NOT NULL, latitude VARCHAR(128) DEFAULT '' NOT NULL, geo_country VARCHAR(128) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX geo_place_name (geo_place_name), INDEX longitude (longitude), INDEX latitude (latitude), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(geo_place_name, geo_country, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'comments' CREATE TABLE `yacs`.`yacs_comments` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'section:1' NOT NULL, previous_id MEDIUMINT UNSIGNED DEFAULT '' , type VARCHAR(64) DEFAULT 'default' NOT NULL, description TEXT DEFAULT '' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id MEDIUMINT DEFAULT '' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX previous_id (previous_id), INDEX type (type), INDEX create_name (create_name), INDEX create_id (create_id), INDEX create_date (create_date), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(description) ) TYPE=MyISAM 1067: Invalid default value for 'previous_id'
La table 'categories' a été vérifiée et analysée et optimisée.
La table 'members' a été vérifiée et analysée et optimisée.
Erreur avec la table 'actions' CREATE TABLE `yacs`.`yacs_actions` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) DEFAULT 'article:1' NOT NULL, title VARCHAR(128) DEFAULT '' NOT NULL, target_url VARCHAR(128) DEFAULT '' NOT NULL, status ENUM('O','C','R') DEFAULT 'O' NOT NULL, status_date DATETIME, description TEXT DEFAULT '' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id MEDIUMINT UNSIGNED DEFAULT '1' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX anchor (anchor), INDEX title (title), INDEX status (status), INDEX create_date (create_date), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'servers' CREATE TABLE `yacs`.`yacs_servers` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(128) DEFAULT '' NOT NULL, host_name VARCHAR(128) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, main_url VARCHAR(128) DEFAULT '' NOT NULL, submit_feed ENUM('Y','N') DEFAULT 'N' NOT NULL, feed_url VARCHAR(128) DEFAULT '' NOT NULL, anchor VARCHAR(64) DEFAULT 'category:1' NOT NULL, submit_ping ENUM('Y','N') DEFAULT 'N' NOT NULL, ping_url VARCHAR(128) DEFAULT '' NOT NULL, process_ping ENUM('Y','N') DEFAULT 'Y' NOT NULL, submit_monitor ENUM('Y','N') DEFAULT 'N' NOT NULL, monitor_url VARCHAR(128) DEFAULT '' NOT NULL, process_monitor ENUM('Y','N') DEFAULT 'Y' NOT NULL, submit_search ENUM('Y','N') DEFAULT 'N' NOT NULL, search_url VARCHAR(128) DEFAULT '' NOT NULL, process_search ENUM('Y','N') DEFAULT 'Y' NOT NULL, active ENUM('Y','R','N') DEFAULT 'Y' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, PRIMARY KEY (id), INDEX title (title), INDEX host_name (host_name), INDEX main_url (main_url), INDEX submit_monitor (submit_monitor), INDEX submit_ping (submit_ping), INDEX submit_search (submit_search), INDEX active (active), INDEX edit_name (edit_name), INDEX edit_id (edit_id), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(title, description) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'
Erreur avec la table 'versions' CREATE TABLE `yacs`.`yacs_versions` ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, anchor VARCHAR(64) NOT NULL, content MEDIUMTEXT DEFAULT '' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, edit_id MEDIUMINT DEFAULT '' NOT NULL, edit_name VARCHAR(128) DEFAULT '' NOT NULL, PRIMARY KEY (id), INDEX anchor (anchor), INDEX edit_date (edit_date) ) TYPE=MyISAM 1067: Invalid default value for 'edit_id'[/folder]