p51b.mustang wrote:

> Hi,
> The consolations went into the weekend so I haven't had a lot of time
> looking at this. I did load up your copy and used the initial setup, I
> know you haven't completed the install but it was the easiest way to
> get going.
> I did encountered:
>
> * zend\db\adapter\firebird.php missing final } at end

Curious
Which set are you using?
http://lsces.co.uk/hg/piwik/ has the latest build
http://lsces.co.uk/hg/piwik/archive/tip.tar.gz will give you a complete dump.

> * File integrity check could not be performed due to missing
> manifest.inc.php which I guess needs to be amended for FB. The manifest
> required more than my cursory glance so I thought I would wait until I
> got Piwik going on FB before looking at it.

I have no idea how that was built so I ignored it ;)

> * There was an error when adding the website: - Firebird prepare
> error: invalid request BLR at offset 77 generator GEN_PIWIK_SITE_ID is
> not defined Thiswas because I couldn't find where you set up the
> triggers and GENs.

Correct ... I need to add that it, but it was easier just to run an extra script
at that point ;) Thought I had mentioned that, but it was on another message :(
Having built the initial database with some manual intervention, I've attached a
full ddl for the finished database. Start clean, run to 'tables loaded' then
swap database for this one and continue with installer. I'll drop ... OK it is
in the core/Db/Schema directory as well. Just tidied it up so that it runs clean
;) I'd just grabbed the generators and triggers out of it last time I did a
clean install ...

I have all of this sort of thing working nicely in ADOdb ... across all database
that supports so it may be worth pulling that into the equation even if only for
the 'datadict' but that also provides database agnostic update scripts as well,
which is another todo area ;)

> So far, I would say point 1 is the only serious item. But I may have
> done something wrong as it is so obvious and it would have appeared on
> your machine as well. Anyway this may help.

It's possible that it crept in while I was working on the 1.6 to 1.7 merge, but
the Firebird file should not be touched by piwik code changes :(

--
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


[Non-text portions of this message have been removed]