[Piwik-hackers] likely PDO Error encountered after fresh install - any ideas?

[Matthieu Aubry]

Brandon,
can you try to update your php version, eg in 5.2 and tell us if it
works better?

On 2/23/08, Brandon Rodak <brodak at gmail.com> wrote:
> Julien,
>
> Thanks for your response.  I do know of another individual who also received
> the error on install (he emailed me).  I did not change any configs on the
> server or the Piwik install (other than dropping the DB and removing it -
> then reinstalling with no success).  Here is the backtrace of the error:
>
> Uncaught exception: 'SQLSTATE[42S02]: Base table or view not found: 1146
> Table 'impact_Stats.Object' doesn't exist'
> In /var/www/stats/libs/Zend/Db/Statement/Pdo.php on line
> 227
>  Backtrace:
> #0 /var/www/stats/libs/Zend/Db/Statement.php(298):
> Zend_Db_Statement_Pdo->_execute(Array)
> #1 /var/www/stats/libs/Zend/Db/Adapter/Abstract.php(262):
> Zend_Db_Statement->execute(Array)
>
> #2
> /var/www/stats/libs/Zend/Db/Adapter/Pdo/Abstract.php(206):
> Zend_Db_Adapter_Abstract->query('?SELECT idarchi...',
> Array)
> #3 /var/www/stats/libs/Zend/Db/Adapter/Abstract.php(469):
> Zend_Db_Adapter_Pdo_Abstract->query('?SELECT idarchi...',
> Array)
>
> #4 /var/www/stats/modules/ArchiveProcessing.php(429):
> Zend_Db_Adapter_Abstract->fetchAll('?SELECT idarchi...',
> Array)
> #5 /var/www/stats/modules/ArchiveProcessing.php(227):
> Piwik_ArchiveProcessing->isArchived()
>
> #6 /var/www/stats/modules/Archive/Single.php(80):
> Piwik_ArchiveProcessing->loadArchive()
> #7 /var/www/stats/modules/Archive/Single.php(117):
> Piwik_Archive_Single->prepareArchive()
> #8 /var/www/stats/modules/Archive/Single.php(272):
> Piwik_Archive_Single->get('max_actions', 'numeric')
>
> #9 /var/www/stats/modules/Archive/Single.php(291):
> Piwik_Archive_Single->getNumeric('max_actions')
> #10 /var/www/stats/plugins/VisitsSummary/API.php(47):
> Piwik_Archive_Single->getDataTableFromNumeric(Array)
>
> #11 [internal function]: Piwik_VisitsSummary_API->get('1',
> 'day', '2008-02-22', '')
> #12 /var/www/stats/modules/API/Proxy.php(462):
> call_user_func_array(Array, Array)
> #13 [internal function]: Piwik_API_Proxy->__call('get', Array)
>
> #14 [internal function]: Piwik_API_Proxy->get('1', 'day', '2008-02-22', '')
> #15 /var/www/stats/modules/API/Request.php(140):
> call_user_func_array(Array, Array)
> #16
> /var/www/stats/plugins/VisitsSummary/VisitsSummary.php(86):
> Piwik_API_Request->process()
>
> #17 /var/www/stats/plugins/Actions/Controller.php(107):
> Piwik_VisitsSummary_Controller::getVisitsSummary()
> #18 /var/www/stats/plugins/Actions/Controller.php(30):
> Piwik_Actions_Controller->getActionsView('Actions',
> 'getActions', 'Actions.getActi...', 'getActionsSubDa...')
>
> #19 [internal function]:
> Piwik_Actions_Controller->getActions()
> #20 /var/www/stats/modules/FrontController.php(120):
> call_user_func_array(Array, Array)
> #21 /var/www/stats/index.php(61):
> Piwik_FrontController->dispatch()
>
> #22 {main}
> PHP version:  5.1.6
> Apache version: 2.2.3
> MySQL: 5.0.22
> PDO Driver for MySQL, client library version: 5.0.22
>
> Is there anything else you would need to help troubleshoot?  Thanks for your
> time / efforts,
>
> Brandon
> WWT
>
>
> On Sat, Feb 23, 2008 at 7:58 AM, Julien Rouviere <julien.rouviere at gmail.com>
> wrote:
> > Hi Brandon,
> >
> > Sorry for the inconvenience, Matthieu should be able to answer you, but
> unfortunately he is in holidays, and I don't think he has a web access right
> now.
> >
> > As far as I know, you're the first one to signal this issue, could you
> please give us further information (configuration/log) ? did you change any
> configuration of your webserver after the installation ?
> >
> > Thanks,
> > Julien
> >
> >
> > 2008/2/22, Brandon Rodak <brodak at gmail.com>:
> > >
> > >
> > >
> > > Hello all,
> > >
> > > I received the following error in all of my widgets in the Dashboard and
> beyond:
> > >
> > > 'SQLSTATE[42S02]: Base table or view not found: 1146 Table
> 'wwt_Stats.Object' doesn't exist'
> > >
> > > It was a fresh install of the latest Piwik source on an Apache 2.2
> server running PHP 5.1.6 and MySQL 5.0.22.
> > >
> > > Do you need any of the PDO information to troubleshoot further or has
> anybody been able to resolve this issue?
> > >
> > > Thanks for any and all advice and help!
> > >
> > > Brandon R.
> > >
> > > --
> > > Brandon Rodak
> > > WhiteWater Technologies - cutting-edge network security
> > > www.whitewatertech.com
> > > _______________________________________________
> > > Piwik-hackers mailing list
> > > Piwik-hackers at piwik.org
> > >
> http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
> > >
> > >
> >
> >
> > _______________________________________________
> > Piwik-hackers mailing list
> > Piwik-hackers at piwik.org
> >
> http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
> >
> >
>
>
>
> --
> Brandon Rodak
> WhiteWater Technologies - cutting-edge network security
> www.whitewatertech.com
> _______________________________________________
>  Piwik-hackers mailing list
>  Piwik-hackers at piwik.org
> http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
>
>