Authored by:Dirk on Thursday, August 29 2002 @ 03:41 PM EDT
Prior to this release, the static pages plugin did not use the prefix for its table name. Now the install script tries to rename the \"staticpage\" table to \"gl_staticpage\" (or whatever your prefix is). Obviously, this will fail when you don\'t use a prefix at all ...
Solution: Open /path/to/geeklog/sql/updates/mysql_1.3.5_to_1.3.6.php and remove the line that reads
$_SQL[] = \"RENAME TABLE staticpage TO ($_TABLES[\'staticpage\'])\";
Then run the install script again - it should work now.
Need to think of a better solution for the final release ...
The following comments are owned by whomever posted them. This site is not responsible for what they say.
Just tried to upgrade my development site and got the following error after selecting upgrade from 1.3.5 database:
1050: Table \'./geeklogdevdb/staticpage.frm\' already exists
(bear in mind I don\'t use the gl_ prefix since my Geeklog install has its own database, and have appropriately defined this in config.php).
Any ideas? I\'m hoping it\'s me doing something stupid but can\'t think what it could be on this occassion :)
--
Alan @ goddammit.co.uk
Solution: Open /path/to/geeklog/sql/updates/mysql_1.3.5_to_1.3.6.php and remove the line that reads
$_SQL[] = \"RENAME TABLE staticpage TO ($_TABLES[\'staticpage\'])\";
Then run the install script again - it should work now.
Need to think of a better solution for the final release ...
bye, Dirk
I\'m glad it wasn\'t me being foolish (well, not _too_ foolish ;) ).
Fun fun fun!