Thanks for your help. I'll amend the correct the field and fiddle around and see what I come up with. You may be correct about the DVCS as I did have to fix the sql.php as an additional } was closing off the class early.
Obviously, you have more important work and priorities than this and I do appreciate your help.
Regards
David

--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> 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
>