Apr 4th, 2009, 2:58 PM
(Apr 4th, 2009, 2:12 PM)Ben Wrote:Code:ALTER TABLE {$g_table_prefix}hooks ADD hook_type ENUM('code', 'template') NOT NULL DEFAULT 'code' AFTER hook_id
ALTER TABLE {$g_table_prefix}hooks CHANGE action_location action_location VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
ALTER TABLE {$g_table_prefix}account_settings CHANGE setting_value setting_value MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
You'll need to replace {$g_table_prefix} with whatever database table prefix you chose.
Sorry about this. There's a bug in the installation script. I'll release a new version shortly.
- Ben
Thanks Ben but I get a Syntax Error when I try to run the SQL statements. I replaced {$g_table_prefix} with ft_ such that the statement reads:
Code:
ALTER TABLE ft_hooks ADD hook_type ENUM('code', 'template') NOT NULL DEFAULT 'code' AFTER hook_id
My host is running phpMyAdmin 2.4.0 if that makes a difference. I tried to alter the tables manually but it didn't work.