I'm running into a wall trying to use install-slashsite on a machine which had
mysql3 running, and now has mysql4.
Here's what happens when I run install-slashsite:
Plugins selected: Admin Blob Email Hof Journal MenuEdit Messages Page
PollBooth Print PubKey Search Sections Stats Submit Zoo bookiejoint calleria
DBD::mysql::db do failed: Can't create table './devbj/backup_blocks.frm'
(errno: 150) at /usr/local/slash/bin/install-slashsite line 387.
The CREATE TABLE command below failed. This almost certainly means
the rest of the slashsite installation will fail, so we're aborting.
This is probably because your SQL user associated with your
DBIx::Password user 'devbj' lacks CREATE and/or DROP permissions.
Fix this, or whatever the problem is, and rerun install-slashsite.
Failed command: CREATE TABLE backup_blocks ( bid varchar(30) DEFAULT '' NOT
NULL, block text, FOREIGN KEY (bid) REFERENCES blocks(bid),
PRIMARY KEY (bid)) TYPE=InnoDB
Now, the odd thing here is that if I use the mysql cli interface, and login to
it as the user which I'm using in DBIx::Password's Password.pm, I can. And I
have full permisisons - I can add tables, drop, you name it, etc:
create table foo (id int auto_increment,unique key (id));
Query OK, 0 rows affected (0.00 sec)
works when I enter mysql with mysql devbj -u devbj -h localhost
(I specified the host to demonstrate that's not the problem).
Now, I googled on error 150. It seems that Innodb's fairly picky about indexes
and what not when a table is type InnoDB:
<URL: http://www.mysql.com/doc/en/Cannot_create.html >
So, I'm wondering if this isn't a slash bug in the schema with mysql4 when the
install runs and imports the theme's schema file.
Have any of you who are running mysql 4 done an install-slashsite lately?
mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)