[The Realist]

Thanks M8, did the below but I received this error:

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE vbookie_items (
item_id MEDIUMINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_id SMALLINT UNSIGNED,
threadid INT(10) UNSIGNED DEFAULT '0',
item_title VARCHAR(255) NOT NULL,
item_min_bet BIGINT UNSIGNED DEFAULT '0',
item_max_bet BIGINT UNSIGNED DEFAULT '0',
item_timezoneoffset VARCHAR(6) DEFAULT '0',
item_created INT(13) NOT NULL,
item_open_until INT(13) NOT NULL,
item_pay_after INT(13) NOT NULL,
item_status ENUM('OPEN', 'CLOSED', 'SETTLED', 'ABANDONED') DEFAULT 'OPEN',
item_allow_multiple_bets ENUM('Y', 'N') DEFAULT 'Y',
item_n_bets_placed MEDIUMINT UNSIGNED DEFAULT '0',
item_amount_staked BIGINT UNSIGNED DEFAULT '0',
item_amount_won BIGINT UNSIGNED DEFAULT '0'
) TYPE=MyISAM

mysql error: Invalid default value for 'item_id'

mysql error number: 1067

Originally Posted by MarcoH64

in your vbookie_install.php script, find:

PHP Code:

            group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY, 


and replace by:

PHP Code:

            group_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,