| Subject | Re: Zend Framework and piwik ... |
|---|---|
| Author | p51b.mustang |
| Post date | 2012-02-21T21:47:55Z |
Hi,
I thought I'll let you know where I'm at. I downloaded the complete dump
and have tried the setup in different ways as I still get problems if I
don't change the Piwik code.
There is still the missing '}' in firebird.php in libs\Zend\Db\Adapter
directory. i.e.
Parse error: syntax error, unexpected $end, expecting T_FUNCTION in
E:\Apache2.2\htdocs\piwik-fb\libs\Zend\Db\Adapter\Firebird.php on line
608 Call Stack: 0.0295 353376
1. {main}() E:\Apache2.2\htdocs\piwik-fb\index.php:0 0.4038 1187840
2. Piwik_FrontController->init()
E:\Apache2.2\htdocs\piwik-fb\index.php:52 1.2683 3220392
3. Piwik_PluginsManager->loadPlugins()
E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:269 1.2685 3220392
4. Piwik_PluginsManager->reloadPlugins()
E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:219 2.2882 5398448
5. Piwik_PluginsManager->addPluginObservers()
E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:330 2.2884 5399144
........
and the code:
/**
* Quotes an identifier.
* @param string|array|Zend_Db_Expr $ident The identifier.
* @param boolean $auto If true, heed the AUTO_QUOTE_IDENTIFIERS
config option.
* @return string The quoted identifier.
*/
public function quoteIdentifier($ident, $auto=false)
{
return $ident;
} <=== missing ??
}
This is no big deal as it is a standard correction.
When you progress to specifying the firebird dbs it creates rudimentary
tables which obviously lacks your generators, additional tables,
triggers etc. of your ddl. Next step of super user is ok, but the step
after that of setting the site to track has the error of expecting a
generator. So at this point I drop the tables and then run your ddl
which runs fine and the site specification and rest of setup runs fine.
Once the setup is complete the web transfer to the user's dashboard
that where things go awry. i.e.
When going onto dashboard after the define site page:=>
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): unsuccessful metadata update Table
PIWIK_USER_DASHBOARD already exists in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\Dashboard\Dashboard.php:82]#5
Piwik_Dashboard->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): unsuccessful metadata update STORE
RDB$RELATION_FIELDS failed attempt to store duplicate value (visible to
active transactions) in unique index "RDB$INDEX_15" in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\ExampleFeedburner\ExampleFeedburne\
r.php:39]#5 Piwik_ExampleFeedburner->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): Dynamic SQL Error SQL error code = -104 Token
unknown - line 1, column 66 NULL in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\Provider\Provider.php:80]#5
Piwik_Provider->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): Dynamic SQL Error SQL error code = -104 Token
unknown - line 3, column 18 ( in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\PDFReports\PDFReports.php:170]#5
Piwik_PDFReports->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
I listed them all just to give you an idea of what I mean. Notice that
its all happening in core\Db\Adapter\Firebird.php rather than libs/Zend
(but this is probably not the issue as they do different things). The
offence seems to be
/**
* Returns a list of the tables in the database.
*
* @return array
*/
public function listTables()
{
$data = $this->fetchCol('SELECT RDB$RELATION_NAME FROM
RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0');
foreach($data as &$v)
$v = trim(strtolower($v));
return $data;
}
Which is going through the table, maybe to perform your update?
Muti fiddles resulted in just ignoring these messages and hitting
'enter' jumps to the login page. Then on to the details page where
obviously don't contain any data as yet so have not verify as yet. A
couple of widgets had firebird prepare errors which I'll put in a log on
the SQL statement to see what's happening there.
I don't know if this is what you expected or not, just thought I pass it
on.
Regards
David
I thought I'll let you know where I'm at. I downloaded the complete dump
and have tried the setup in different ways as I still get problems if I
don't change the Piwik code.
There is still the missing '}' in firebird.php in libs\Zend\Db\Adapter
directory. i.e.
Parse error: syntax error, unexpected $end, expecting T_FUNCTION in
E:\Apache2.2\htdocs\piwik-fb\libs\Zend\Db\Adapter\Firebird.php on line
608 Call Stack: 0.0295 353376
1. {main}() E:\Apache2.2\htdocs\piwik-fb\index.php:0 0.4038 1187840
2. Piwik_FrontController->init()
E:\Apache2.2\htdocs\piwik-fb\index.php:52 1.2683 3220392
3. Piwik_PluginsManager->loadPlugins()
E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:269 1.2685 3220392
4. Piwik_PluginsManager->reloadPlugins()
E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:219 2.2882 5398448
5. Piwik_PluginsManager->addPluginObservers()
E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:330 2.2884 5399144
........
and the code:
/**
* Quotes an identifier.
* @param string|array|Zend_Db_Expr $ident The identifier.
* @param boolean $auto If true, heed the AUTO_QUOTE_IDENTIFIERS
config option.
* @return string The quoted identifier.
*/
public function quoteIdentifier($ident, $auto=false)
{
return $ident;
} <=== missing ??
}
This is no big deal as it is a standard correction.
When you progress to specifying the firebird dbs it creates rudimentary
tables which obviously lacks your generators, additional tables,
triggers etc. of your ddl. Next step of super user is ok, but the step
after that of setting the site to track has the error of expecting a
generator. So at this point I drop the tables and then run your ddl
which runs fine and the site specification and rest of setup runs fine.
Once the setup is complete the web transfer to the user's dashboard
that where things go awry. i.e.
When going onto dashboard after the define site page:=>
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): unsuccessful metadata update Table
PIWIK_USER_DASHBOARD already exists in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\Dashboard\Dashboard.php:82]#5
Piwik_Dashboard->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): unsuccessful metadata update STORE
RDB$RELATION_FIELDS failed attempt to store duplicate value (visible to
active transactions) in unique index "RDB$INDEX_15" in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\ExampleFeedburner\ExampleFeedburne\
r.php:39]#5 Piwik_ExampleFeedburner->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): Dynamic SQL Error SQL error code = -104 Token
unknown - line 1, column 66 NULL in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\Provider\Provider.php:80]#5
Piwik_Provider->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
There is an error. Please report the message and full backtrace in the
Piwik forums
<http://192.168.1.9/piwik-fb/index.php?module=Proxy&action=redirect&url=\
http://forum.piwik.org> (please do a Search first as it might have been
reported already!).
Warning: fbird_query(): Dynamic SQL Error SQL error code = -104 Token
unknown - line 3, column 18 ( in
E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php on line 134
Backtrace -->#0 Piwik_ErrorHandler(...) called at [:]#1
fbird_query(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\Db\Adapter\Firebird.php:134]#2
Piwik_Db_Adapter_Firebird->exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:38]#3
Piwik_Sql::exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsFunctions\Sql.php:80]#4
Piwik_Exec(...) called at
[E:\Apache2.2\htdocs\piwik-fb\plugins\PDFReports\PDFReports.php:170]#5
Piwik_PDFReports->install(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:441]#6
Piwik_PluginsManager->installPlugin(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:551]#7
Piwik_PluginsManager->installPluginIfNecessary(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\PluginsManager.php:166]#8
Piwik_PluginsManager->installLoadedPlugins(...) called at
[E:\Apache2.2\htdocs\piwik-fb\core\FrontController.php:293]#9
Piwik_FrontController->init(...) called at
[E:\Apache2.2\htdocs\piwik-fb\index.php:52]
I listed them all just to give you an idea of what I mean. Notice that
its all happening in core\Db\Adapter\Firebird.php rather than libs/Zend
(but this is probably not the issue as they do different things). The
offence seems to be
/**
* Returns a list of the tables in the database.
*
* @return array
*/
public function listTables()
{
$data = $this->fetchCol('SELECT RDB$RELATION_NAME FROM
RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0');
foreach($data as &$v)
$v = trim(strtolower($v));
return $data;
}
Which is going through the table, maybe to perform your update?
Muti fiddles resulted in just ignoring these messages and hitting
'enter' jumps to the login page. Then on to the details page where
obviously don't contain any data as yet so have not verify as yet. A
couple of widgets had firebird prepare errors which I'll put in a log on
the SQL statement to see what's happening there.
I don't know if this is what you expected or not, just thought I pass it
on.
Regards
David
--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> p51b.mustang wrote:
> >> 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.:-)
> >
>
> Curious as I've not done much since mid week ... except for tidy that
ddl file
> this morning.
>
> --
> 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]