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

Tue Feb 26 17:55:31 CET 2008

Matthieu,

Actually, an upgrade to version 5.2 would not be possible as the machine is
a production server for several other Virtual Domains.  I may try it on
another server we have in-house.

Thanks for your help,

Brandon R.

On Mon, Feb 25, 2008 at 4:20 AM, Matthieu Aubry <matthieu.aubry at gmail.com>
wrote:

> 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
> >
> >
> _______________________________________________
> 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/20080226/9142eab6/attachment.htm 