Sean
Error below. I also tried to add Gallery as you will see with similar results.
Regards
Gerry
FATAL ERROR: DATABASE ERROR: Couldn't run query: ALTER TABLE `SiteTree` CHANGE `ClassName` `ClassName` enum('SiteTree','Page','GhostPage','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree' | ALTER command denied to user 'gerryk'@'ge1' for table 'sitetree'
At line 431 in /home/gerryk/public_html/sapphire/core/model/Database.php
user_error(DATABASE ERROR: Couldn't run query: ALTER TABLE `SiteTree` CHANGE `ClassName` `ClassName` enum('SiteTree','Page','GhostPage','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree' | ALTER command denied to user 'gerryk'@'ge1' for table 'sitetree',256)
line 431 of Database.php
Database->databaseError(Couldn't run query: ALTER TABLE `SiteTree` CHANGE `ClassName` `ClassName` enum('SiteTree','Page','GhostPage','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree' | ALTER command denied to user 'gerryk'@'ge1' for table 'sitetree',256)
line 108 of MySQLDatabase.php
MySQLDatabase->query(ALTER TABLE `SiteTree` CHANGE `ClassName` `ClassName` enum('SiteTree','Page','GhostPage','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree')
line 210 of MySQLDatabase.php
MySQLDatabase->alterTable(SiteTree,Array,Array,Array,Array)
line 160 of Database.php
Database->endSchemaUpdate()
line 178 of DatabaseAdmin.php
DatabaseAdmin->doBuild()
line 90 of DatabaseAdmin.php
DatabaseAdmin->build(Array)
line 261 of Controller.php
Controller->run(Array)
line 104 of Director.php
Director::direct(db/build)
line 158 of main.php
Context
Debug (Debug::showError() in line 180 of Debug.php)
* msg =
Couldn't run query: ALTER TABLE `SiteTree` CHANGE `ClassName` `ClassName` enum('SiteTree','Page','GhostPage','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree' | ALTER command denied to user 'gerryk'@'ge1' for table 'sitetree'
* errorLevel =
256