I had the same error on installation. Fixed it by doing the following:
[17:47:23] <BullDog> CREATE TABLE `quotes` (
[17:47:23] <BullDog> `id` int(4) NOT NULL auto_increment,
[17:47:23] <BullDog> `quote` mediumtext NOT NULL,
[17:47:23] <BullDog> `username` varchar(255) NOT NULL,
[17:47:23] <BullDog> `unapproved` TINYINT( 1 ) NOT NULL,
[17:47:23] <BullDog> PRIMARY KEY (`id`)
[17:47:23] <BullDog> )
Then got an error for a duplicate entry so:
[17:50:25] <BullDog> ALTER TABLE `quotes` DROP COLUMN `unapproved`
Works fully now. (Remove the time and BullDog and do the query).
Edit:
Am I the only one not able to see usergroup settings or find settings for this thing anywhere?
|