--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:

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

I thought I was using latest build, but I could have made a mistake as I downloaded on Friday while juggling other things. I will use your full dump above and start over doing download and setup at same time so I am sue. :-)

>
> > * File integrity ......
> I have no idea how that was built so I ignored it ;)

Yes it does require a bit of looking into; I'll do like wise.

>
> > * 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 :(

Don't scold yourself. I am sure you did mention it. I Just could find the script files. Thanks for letting me know where they are.

> ..............
> 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 ;)
>

Yes, I am sure I have read one of your posts (totally unrelated to this exercise) advocating ADO which, at the time, I played with following your lead. However, with my Zend based application it didn't fit in well so I used ZendX interface to FB.

> > ..........
> 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 :(

Looks like that maybe it as the version core is 1.7 in the PIWIK Options table.

Hence, I'll redownload and set up again. One final point is the FB database (file) must exists before setup can run. I think that maybe the database setup page could accept full drive,path, and file name to create the database if not already there.

Regards
David