Subject | Re: [firebird-php] Re: Zend Framework and piwik ... |
---|---|
Author | Lester Caine |
Post date | 2012-02-22T23:24:26Z |
p51b.mustang wrote:
worked. The result now is that people write for MySQL as you say, and can't
accept any criticism when we ask them to use SQL compliant formats. What is more
annoying is that the Zend library is making better attempts to plug the gap
anyway as long as things like 'limit()' are used rather than hard coding LIMIT
into the SQL. You might notice my port uses 'FIRST x SKIP y' , although that
could now be updated to use ROWS in the library.
I'm down to 10 of the test programs failing, and half of those are because curl
has gone missing on this machine. I'll post those 'fixes' shortly.
I've been posting to the piwik list and they have asked me to package the
'limit()' modes to their tracker so they are a little more open to moving the
main code base forward.
The NEXT problem I have is that some of the settings screens don't work, so I
can't add users and sites from the app, only direct to the database. I'm not
sure how to debug the ajax/rest interface though :(
--
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
>> "Subtle ... Go to 'config/config.inc.php' and changePDO was a major mistake and should never have been allowed out until it ACTUALLY
>> > schema = "Mysami" to schema = "Firebird"
> subtle indeed, I totally missed it. I went in and changed it and the dashboard comes up clean without FB issues. Sorry for wasting your time:-(
> Your process of install that you outlined below is similar what I was doing. Just to get on my soapbox, one issue I see with open PHP stuff is the code is very specific to MySQL& SQLite which integrates the application too much with the DBMS. The whole point of a DBMS, and SQL, was to liberate the data management from the application.
> Anyways, I can more a bit further now so see what I can get from site data.
worked. The result now is that people write for MySQL as you say, and can't
accept any criticism when we ask them to use SQL compliant formats. What is more
annoying is that the Zend library is making better attempts to plug the gap
anyway as long as things like 'limit()' are used rather than hard coding LIMIT
into the SQL. You might notice my port uses 'FIRST x SKIP y' , although that
could now be updated to use ROWS in the library.
I'm down to 10 of the test programs failing, and half of those are because curl
has gone missing on this machine. I'll post those 'fixes' shortly.
I've been posting to the piwik list and they have asked me to package the
'limit()' modes to their tracker so they are a little more open to moving the
main code base forward.
The NEXT problem I have is that some of the settings screens don't work, so I
can't add users and sites from the app, only direct to the database. I'm not
sure how to debug the ajax/rest interface though :(
--
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