Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. mysql issues (Wim)
----------------------------------------------------------------------
Message: 1
Date: Thu, 25 Oct 2012 15:49:09 +0000 (UTC)
From: Wim <[email protected]>
Subject: [Netdot-users] mysql issues
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
Hi,
I'm trying netdot out for the first time.
make installdb seems to work, but some of the tables are not created.
It tries to create UNIQUE INDEXes without specifying the key column.
mysql> CREATE TABLE `audit` (
-> `fields` varchar(255) NULL,
-> `id` bigint NOT NULL auto_increment,
-> `label` varchar(255) NOT NULL,
-> `object_id` bigint NOT NULL,
-> `operation` varchar(255) NOT NULL,
-> `tablename` varchar(255) NOT NULL,
-> `tstamp` timestamp NOT NULL DEFAULT '1970-01-02 00:00:01',
-> `username` varchar(255) NOT NULL,
-> `vals` varchar(255) NULL,
-> UNIQUE INDEX `audit1` (``),
-> INDEX `Audit2` (`tstamp`),
-> INDEX `Audit3` (`username`),
-> INDEX `Audit4` (`tablename`),
-> INDEX `Audit5` (`label`),
-> PRIMARY KEY (`id`)
-> ) ENGINE=InnoDB;
ERROR 1072 (42000): Key column '' doesn't exist in table
I fixed this by adding the same key for unique as for primary_key in netdot.meta
e.g.
primary_key => 'id',
unique => [ ['id' ] ],
Wim
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 47, Issue 9
*******************************************
