English Need Help

Installation porblem

Sent by Anatoly

Hi, I can not pass 'please, create tables' step. Setups proceeds normally up to that point; when I click on 'create tables in the database', it tries to do so but can setup the database because of '1067: invalid default id' (see output, below). if I click 'next step', it returns me to the loop, to 'create tables in the database'. How to correct this problem? I am on a shared hosting running an Apache (at globat.com). BTW, another thing - I had to delete httpaccess file because otherwise server produces an error and does not allow the setup at all. Thank you in advance.

SETUP OUTPUT::

Setup the database Creation of the table 'users': CREATE TABLE `YACS`.`YACS_users` ( id SMALLINT UNSIGNED DEFAULT '1' NOT NULL AUTO_INCREMENT, nick_name VARCHAR(255) DEFAULT '' NOT NULL, handle VARCHAR(128) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, password VARCHAR(255) DEFAULT '' NOT NULL, full_name VARCHAR(255) DEFAULT '' NOT NULL, yahoo_address VARCHAR(255) DEFAULT '' NOT NULL, jabber_address VARCHAR(255) DEFAULT '' NOT NULL, aim_address VARCHAR(255) DEFAULT '' NOT NULL, msn_address VARCHAR(255) DEFAULT '' NOT NULL, icq_address VARCHAR(255) DEFAULT '' NOT NULL, web_address VARCHAR(255) DEFAULT '' NOT NULL, capability ENUM('A','M','S','?') DEFAULT '?' NOT NULL, introduction TEXT DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, avatar_url VARCHAR(255) DEFAULT '' NOT NULL, options VARCHAR(255) DEFAULT '' NOT NULL, active ENUM('Y','R','N') DEFAULT 'Y' NOT NULL, with_newsletters ENUM('Y','N') DEFAULT 'N' NOT NULL, posts INT UNSIGNED DEFAULT '' NOT NULL, create_name VARCHAR(128) DEFAULT '' NOT NULL, create_id SMALLINT UNSIGNED DEFAULT '1' NOT NULL, create_address VARCHAR(128) DEFAULT '' NOT NULL, create_date DATETIME, edit_name VARCHAR(128) DEFAULT '' NOT NULL, edit_id SMALLINT UNSIGNED DEFAULT '1' NOT NULL, edit_address VARCHAR(128) DEFAULT '' NOT NULL, edit_action VARCHAR(128) DEFAULT '' NOT NULL, edit_date DATETIME, login_date DATETIME, PRIMARY KEY (id), INDEX nick_name (nick_name), INDEX handle (handle), INDEX email (email), INDEX full_name (full_name), INDEX with_newsletters (with_newsletters), INDEX posts (posts), 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), INDEX login_date (login_date), FULLTEXT INDEX full_text(nick_name, full_name, introduction, description) ) 1067: Invalid default value for 'id'

(...)

Verification of the table 'cache': ok

Creation of the table 'phpdoc': CREATE TABLE `YACS`.`YACS_phpdoc` ( name VARCHAR(255) DEFAULT '' NOT NULL, anchor VARCHAR(255) DEFAULT '' NOT NULL, label VARCHAR(255) DEFAULT '' NOT NULL, content TEXT DEFAULT '' NOT NULL, hits INT UNSIGNED DEFAULT '0' NOT NULL, edit_date DATETIME, PRIMARY KEY (name), INDEX anchor (anchor), INDEX hits (hits), INDEX edit_date (edit_date), FULLTEXT INDEX full_text(name, content) ) 1214: The used table type doesn't support FULLTEXT indexes

(...)