[geeklog-users] Upgrade problem

[Vincent Furia]

I seem to remember this problem cropping up.  Some of the old versions
of the static page plugin (before it was incorpated into core geeklog
distribution) used '<prefix>staticpages' instead of
'<prefix>staticpage' which is the current default.

You can fix this a couple ways.  The first is to rename your
<prefix>staticpages table <prefix>staticpage.  The second is to edit
system/lib-database.php and change this line:
$_TABLES['staticpage']          = $_DB_table_prefix . 'staticpage';
to:
$_TABLES['staticpage']          = $_DB_table_prefix . 'staticpages';

of course you'll have to do that every time you upgrade or reinstall Geeklog.

-Vinny

P.S.  <prefix> is the value of $_DB_table_prefix from config.php,
which defaults to "gl_".

On Thu, 8 Jul 2004 20:06:06 -0700, Norman Cohen <nacohen at mac.com> wrote:
> Hi,
> 
> I've tried to update from geeklog 1.3.7sr2 to 1.3.9. While running the
> /path/to/geeklog/admin/install/install.php script, I keep getting an
> error that table staticpages doesn't exist. I have chosen an upgrade
> install with 1.3.7 as the active database. I deleted the database and
> restored from by backup and still get the error. My database never had
> a staticpage table. Any ideas on what I can do to get this update done?
> 
> Thanks in advance,
> 
> Norman Cohen
> nacohen at mac.com
> 
> "People seem to enjoy things more when they know a lot of other people
> have been left out of the pleasure."
> Russell Baker
> 
> _______________________________________________
> geeklog-users mailing list
> geeklog-users at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-users
>