after a little playing around i got everything installed, e.g slash compiled and put everything in/usr/local/slash but when i try to run/usr/local/slash/bin/install-slash -u foo it asks me all sorts of questions, then dies with these errors:
DBD::mysql::db do failed: Column 'uid' is used with UNIQUE or INDEX but is not defined as NOT NULL at bin/install-slashsite line 341.
Failed on ' CREATE TABLE accesslist ( id mediumint NOT NULL auto_increment, uid mediumint UNSIGNED, ipid char(32), subnetid char(32), formname varchar(20) DEFAULT '' NOT NULL, readonly tinyint UNSIGNED DEFAULT 0 NOT NULL, isbanned tinyint UNSIGNED DEFAULT 0 NOT NULL, ts datetime default '0000-00-00 00:00:00' NOT NULL, reason varchar(120), PRIMARY KEY id (id), key uid (uid), key ipid (ipid), key subnetid (subnetid), key formname (formname), key ts (ts)) TYPE = myisam'
DBD::mysql::db do failed: Column 'op' is used with UNIQUE or INDEX but is not defined as NOT NULL at bin/install-slashsite line 341.
Failed on ' CREATE TABLE accesslog ( id int UNSIGNED NOT NULL auto_increment,host_addr char(32) DEFAULT '' NOT NULL, subnetid char(32) DEFAULT '' NOT NULL, op varchar(254), dat varchar(254), uid mediumint UNSIGNED NOT NULL, ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, query_string varchar(50), user_agent varchar(50), section varchar(30) DEFAULT 'index' NOT NULL, INDEX host_addr_part (host_addr(16)), INDEX op_part (op(12)), INDEX ts (ts), PRIMARY KEY (id)) TYPE = myisam'
install-slashsite dies after asking email address: (Score:1)
DBD::mysql::db do failed: Column 'uid' is used with UNIQUE or INDEX but is not defined as NOT NULL at bin/install-slashsite line 341.
Failed on ' CREATE TABLE accesslist ( id mediumint NOT NULL auto_increment, uid mediumint UNSIGNED, ipid char(32), subnetid char(32), formname varchar(20) DEFAULT '' NOT NULL, readonly tinyint UNSIGNED DEFAULT 0 NOT NULL, isbanned tinyint UNSIGNED DEFAULT 0 NOT NULL, ts datetime default '0000-00-00 00:00:00' NOT NULL, reason varchar(120), PRIMARY KEY id (id), key uid (uid), key ipid (ipid), key subnetid (subnetid), key formname (formname), key ts (ts)) TYPE = myisam'
DBD::mysql::db do failed: Column 'op' is used with UNIQUE or INDEX but is not defined as NOT NULL at bin/install-slashsite line 341.
Failed on ' CREATE TABLE accesslog ( id int UNSIGNED NOT NULL auto_increment,host_addr char(32) DEFAULT '' NOT NULL, subnetid char(32) DEFAULT '' NOT NULL, op varchar(254), dat varchar(254), uid mediumint UNSIGNED NOT NULL, ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, query_string varchar(50), user_agent varchar(50), section varchar(30) DEFAULT 'index' NOT NULL, INDEX host_addr_part (host_addr(16)), INDEX op_part (op(12)), INDEX ts (ts), PRIMARY KEY (id)) TYPE = myisam'
Re:install-slashsite dies after asking email addre (Score:1)
editing schema.sql and adding NOT NULL to the entries which required it fixed the problem.
Re:install-slashsite dies after asking email addre (Score:2)
Parent