[Link14716]

Originally Posted by Wij

Hi,

Invalid SQL: ALTER TABLE language ADD `phrasegroup_shoutbox` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_shoutbox'


I've jsut been taking a look at the usergroup settings and theres a table with 10 options yes/no but no text in this area whatsoever.I'm starting to think I may have made a glaring mistake now(tho I'm pretty sure I havent its fairly straightforward)so any help is appreciated.


Wij

The uninstall queries: in SQL format for version 1.04. Run these queries in phpMyAdmin:

[sql]ALTER TABLE language DROP phrasegroup_shoutbox;

DELETE FROM phrasetype WHERE phrasetypeid=716;

DROP TABLE IF EXISTS shoutbox_posts;

ALTER TABLE usergroup
DROP `shoutboxpermissions`,
DROP `shouthierarchy`,
DROP `shoutmaxdaily`;

ALTER TABLE user
DROP `shouts`,
DROP `shoutbanned`;
[/sql]

Now re-install.