Re: [MRBS-general] Upgrade

[Campbell M. <cam...@gm...>]

Sorry, I saw you posted this the other day and I've no idea why this is
happening.    What version of MySQL are you running and on what platform?

 

Campbell

 

 

 

From: Paul Haysom [mailto:Pau...@be...] 
Sent: 30 June 2012 01:05
To: mrb...@li...
Subject: [MRBS-general] Upgrade

 

I have downloaded the latest full version of MRBS and used it to perform an
upgrade from an existing version 1.4.6.

After entering the root username and password I am presented with the
followinf error mesage:


Upgrading to database version: 28
Tried:# $Id: mysql.sql 1862 2011-08-07 <tel:1862%202011-08-07> 17:27:39Z
cimorrison $ CREATE TABLE mrbs_zoneinfo ( id int NOT NULL auto_increment,
timezone varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ''
NOT NULL, outlook_compatible tinyint unsigned NOT NULL DEFAULT 0, vtimezone
text CHARACTER SET utf8 COLLATE utf8_general_ci, last_updated int NOT NULL
DEFAULT 0, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
and got error:
Table 'mrbs.mrbs_zoneinfo' doesn't exist
_____________________________________________

I tried creating the table manually via phpAdmin but came up with the same
error. The only way I can seem to create the table is by shortening the name
of the table to eg mrbs_zone, but then of course it doesn't work with the
rest of the code!

Am I missing something obvious. Hasve been using MRBS for years and this is
my first sticking point.

Thanks


Paul Haysom