UnderstandingE Forums
Offline
Tried installling this and i think its terminal, anyone using this successfully and can point me in the direction of what to do
exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘littlebl_mage1.mage_googleanalytics’ doesn’t exist’ in /home/littlebl/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/littlebl/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /home/littlebl/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/littlebl/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3 /home/littlebl/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #4 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘DESCRIBE `mage_…’, Array) #5 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘DESCRIBE `mage_…’, Array) #6 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(156): Varien_Db_Adapter_Pdo_Mysql->query(‘DESCRIBE `mage_…’) #7 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1596): Zend_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’, NULL) #8 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Abstract.php(206): Varien_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’) #9 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(586): Mage_Core_Model_Resource_Abstract->_prepareDataForTable(Object(Cinasstore_Googleanalytics_Model_Googleanalytics), ‘mage_googleanal…’) #10 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(449): Mage_Core_Model_Resource_Db_Abstract->_prepareDataForSave(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #11 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #12 /home/littlebl/public_html/app/code/local/Cinasstore/Googleanalytics/Model/Observer.php(10): Mage_Core_Model_Abstract->save() #13 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1338): Cinasstore_Googleanalytics_Model_Observer->saveGoogleanalyticsConfig(Object(Varien_Event_Observer)) #14 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Cinasstore_Googleanalytics_Model_Observer), ‘saveGoogleanaly…’, Object(Varien_Event_Observer)) #15 /home/littlebl/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘admin_system_co…’, Array) #16 /home/littlebl/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(179): Mage::dispatchEvent(‘admin_system_co…’, Array) #17 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_System_ConfigController->saveAction() #18 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘save’) #19 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #20 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #21 /home/littlebl/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #22 /home/littlebl/public_html/index.php(87): Mage::run(”, ‘store’) #23 {main} Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘littlebl_mage1.mage_googleanalytics’ doesn’t exist’ in /home/littlebl/public_html/lib/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /home/littlebl/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/littlebl/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/littlebl/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘DESCRIBE `mage_…’, Array) #4 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘DESCRIBE `mage_…’, Array) #5 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(156): Varien_Db_Adapter_Pdo_Mysql->query(‘DESCRIBE `mage_…’) #6 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1596): Zend_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’, NULL) #7 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Abstract.php(206): Varien_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’) #8 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(586): Mage_Core_Model_Resource_Abstract->_prepareDataForTable(Object(Cinasstore_Googleanalytics_Model_Googleanalytics), ‘mage_googleanal…’) #9 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(449): Mage_Core_Model_Resource_Db_Abstract->_prepareDataForSave(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #10 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #11 /home/littlebl/public_html/app/code/local/Cinasstore/Googleanalytics/Model/Observer.php(10): Mage_Core_Model_Abstract->save() #12 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1338): Cinasstore_Googleanalytics_Model_Observer->saveGoogleanalyticsConfig(Object(Varien_Event_Observer)) #13 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Cinasstore_Googleanalytics_Model_Observer), ‘saveGoogleanaly…’, Object(Varien_Event_Observer)) #14 /home/littlebl/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘admin_system_co…’, Array) #15 /home/littlebl/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(179): Mage::dispatchEvent(‘admin_system_co…’, Array) #16 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_System_ConfigController->saveAction() #17 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘save’) #18 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #19 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #20 /home/littlebl/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #21 /home/littlebl/public_html/index.php(87): Mage::run(”, ‘store’) #22 {main}
Offline
Can I ask why you want google analytics in dashboard, why not simply login into google anayltics?
And which one are you using?
"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln
Offline
reading the 1st line if I am correct it is basically saying you have no database table for it.
Have a look in your php admin for the table labled
littlebl_mage1.mage_googleanalytics
"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln
Offline
Regarding the DB, I saw that but I thought the extension would set everything up, as there are no extensions.
I find GA pretty difficult to navigate/read and thought this extension would simplyfy it a tad
Maybe I have to work out how to uninstall or i will be left with a load of dross in the admin panel
Offline
Steve Froggatt said
Regarding the DB, I saw that but I thought the extension would set everything up, as there are no extensions.
I find GA pretty difficult to navigate/read and thought this extension would simplyfy it a tad
Maybe I have to work out how to uninstall or i will be left with a load of dross in the admin panel
Which extension is it?
I can always try and see if I can get it to install on mine….
Steve
It depends on what you want from GA to achieve for you, if its just a simple case of visitors per day and a few more stats then it should be easy.
If you are going down the route of serious tracking. For example tracking your individual links in each transactional email you send out to see what works and what doesnt. Tracking your shares across social media. Changing your landing pages for promos to see which ones make purchases. Adwords campaigns etc etc then I suggest you login to analytics.
"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln
Offline
Hi Dom
Its this one http://www.magentocommerce.com…..ics-3.html
For now simple stats are more than adequate, I wont be getting full on with GA for a while yet
Steve
Offline
Steve Froggatt said
Hi Dom
Its this one http://www.magentocommerce.com…..ics-3.htmlFor now simple stats are more than adequate, I wont be getting full on with GA for a while yet
Steve
It installed for me, just doesnt show much……..
"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln
Why Should You Join UnderstandingE?
- Access to over 500 step-by-step video tutorials
- +20 video courses available
- Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
- Everything is in 100% Plain English
- Learn how to build your own multi-channel software for eBay & Amazon
- Access to the community forums, meet fellow business owners like yourself
Join Now with 2 Clicks
Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.
Most Users Ever Online: 1012
Currently Online:
21 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Jimbob: 453
Paul Cartwright: 414
Forum Stats:
Groups: 6
Forums: 37
Topics: 5222
Posts: 27488
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606
