1 Topic by Rich Pedley (edited by Rich Pedley 2007-05-08 09:53)

  • Registered: 2006-07-31
  • Posts: 254

Topic: manual PunBB 1.2.15 upgrade problem

I've just completed a manual upgrade from 1.2.14 to 1.2.15 and seem to be unable to get out of maintenance mode!
[edit - sorted, amended the cache_config.php file]




Secondly, I tried to do a manual sql change to alter the database to add this :

ALTER TABLE online ADD UNIQUE INDEX online_user_id_ident_idx(user_id,ident)

Which I translated from the substitution required in the install.php :

$queries[] = 'ALTER TABLE '.$db_prefix.'online ADD UNIQUE INDEX '.$db_prefix.'online_user_id_ident_idx(user_id,ident)';

But the syntax appears to be incorrect - according to SQLite Manager

I am using sqlite, which may or may not make a difference.

any ideas on how to do this would be appreciated.

my mind is on a permanent tangent
byUsers forum
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: manual PunBB 1.2.15 upgrade problem

SQLite doesn't need that index, MySQL does wink

  • Registered: 2006-07-31
  • Posts: 254

Re: manual PunBB 1.2.15 upgrade problem

doh!

Thanks for pointing that out -  I should have checked what section it was in!

my mind is on a permanent tangent
byUsers forum