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

[Brandon Rodak]

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.2server 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.piwik.org/pipermail/piwik-hackers/attachments/20080223/ebfe62c6/attachment.htm