p51b.mustang wrote:

> Hi Lester,
> Piwik.fbk (desc: Firebird Piwik backup for Lester) has been uploaded to this group.
> I hope this is not too problematic (or tedious) for you:-)

I created the problem ... so I'm in the best place to fix it....

Only thing I can see database wise is a missing field ... but I don't think that
is your problem ... I suspect that the DVCS is not providing a 'clean' copy of
the version I'm running especially if it';s still checking for version!

CREATE TABLE PIWIK_USER_DASHBOARD
(
LOGIN Varchar(100) NOT NULL,
IDDASHBOARD Integer NOT NULL,
NAME Varchar(100),
LAYOUT Blob sub_type 1,
PRIMARY KEY (LOGIN,IDDASHBOARD)
);

Note the extra NAME field ...

Everything else looks fine, but I've got some work I need to finish outside so
running it up will have to wait until later :( That and I've spotted a couple of
blobs that are still VARCHAR on my own database so I'd like to correct that and
check it doesn't break anything as well.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php