Menu

#550 error during fresh install: Failed to create table

2.1
open
nobody
Installer (23)
5
2009-09-25
2009-09-25
laetzer
No

Fresh install of Bitweaver 2.6, MySQL, MyISAM, after selecting all packages to be installed:

Screenshot: http://www.iimmgg.com/image/e89ff6ca83b367bd7b7e6485bee3564a

The following database operations failed

Failed to create table mail_queue:
CREATE TABLE mail_queue ( mail_queue_id BIGINT NOT NULL, content_id INTEGER NOT NULL, email VARCHAR(160) NOT NULL, nl_content_id INTEGER NOT NULL, user_id INTEGER, url_code VARCHAR(32), queue_date BIGINT NOT NULL, begin_date BIGINT, sent_date BIGINT, last_read_date BIGINT, last_read_ip VARCHAR(39), reads SMALLINT NOT NULL DEFAULT 0, mail_error TEXT , CONSTRAINT mailq_content_ref FOREIGN KEY (nl_content_id) REFERENCES liberty_content( content_id ) , CONSTRAINT mailq_user_ref FOREIGN KEY (user_id) REFERENCES users_users( user_id ), PRIMARY KEY (mail_queue_id) )ENGINE=MYISAM

Failed to create index mailq_email_idx on mail_queue:
ALTER TABLE mail_queue ADD INDEX mailq_email_idx (email)

Failed to create index mailq_user_idx on mail_queue:
ALTER TABLE mail_queue ADD INDEX mailq_user_idx (user_id)

Failed to create index mailq_content_idx on mail_queue:
ALTER TABLE mail_queue ADD INDEX mailq_content_idx (content_id)

Failed to create index mailq_user_content_idx on mail_queue:
ALTER TABLE mail_queue ADD UNIQUE INDEX mailq_user_content_idx (content_id, user_id)

Failed to create index mailq_sent_idx on mail_queue:
ALTER TABLE mail_queue ADD INDEX mailq_sent_idx (sent_date)
Some errors occured. Your site may not be ready to run. You can revisit the previous page to rerun the installation.

Discussion


Log in to post a comment.