image
SALES ANALYTICS VirtueMart Reports: Sales, Products, Orders, Customers, Locations, Manufacturers, Inventory, Taxes, Shipping Costs, ... everything under control on your online shop!! Read the Full Story
image
SALES ANALYTICS for MAGENTO Magento Reports: On-site reports for Sales, Products, Categories, Orders, Customers, Locations, Taxes, Shipping,... deep insight into your Magento online shop!! Read the Full Story
image
SOCIAL ANALYTICS JomSocial Reports: Now you can know about your user social activities in detail. Friends, groups, photos, videos, ... reports on all your user participations. Read the Full Story
image
WEB ANALYTICS Joomla! Reports: You can check how your website is evolving using all the relevant information at hand, and make it grow accordingly!! Read the Full Story
* * * *
image image image image
Welcome, Guest
Username Password: Remember me

Reports by Product Categories not working.
(1 viewing) (1) Guest
SALES ANALYTICS for MAGENTO Installation & Configuration.
  • Page:
  • 1

TOPIC: Reports by Product Categories not working.

Reports by Product Categories not working. 3 years, 4 months ago #1

Hi I have installed your extension and checked that Product categories are not working it throws an error.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'couchgui_magento.catalog_category_flat_store_Array' doesn't exist

#0 /chroot/home/couchgui/couchguitarstraps.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /chroot/home/couchgui/couchguitarstraps.com/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /chroot/home/couchgui/couchguitarstraps.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT IF(c.nam...', Array)
#4 /chroot/home/couchgui/couchguitarstraps.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT IF(c.nam...', Array)
#5 /chroot/home/couchgui/couchguitarstraps.com/html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT IF(c.nam...', Array)
#6 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/community/Latitudweb/Salesanalytics/Model/Report.php(156): Zend_Db_Adapter_Abstract->fetchAll('SELECT IF(c.nam...')
#7 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/community/Latitudweb/Salesanalytics/Model/Report.php(71): Latitudweb_Salesanalytics_Model_Report->_fetchData()
#8 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/community/Latitudweb/Salesanalytics/Model/Report.php(55): Latitudweb_Salesanalytics_Model_Report->createReport()
#9 /chroot/home/couchgui/couchguitarstraps.com/html/lib/Varien/Object.php(112): Latitudweb_Salesanalytics_Model_Report->_construct()
#10 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/core/Mage/Core/Model/Config.php(1348): Varien_Object->__construct(Array)
#11 /chroot/home/couchgui/couchguitarstraps.com/html/app/Mage.php(462): Mage_Core_Model_Config->getModelInstance('salesanalytics/...', Array)
#12 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/community/Latitudweb/Salesanalytics/controllers/Adminhtml/ReportController.php(63): Mage::getModel('salesanalytics/...')
#13 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/community/Latitudweb/Salesanalytics/controllers/Adminhtml/ReportController.php(49): Latitudweb_Salesanalytics_Adminhtml_ReportController->_displayReport()
#14 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Latitudweb_Salesanalytics_Adminhtml_ReportController->displayReportAction()
#15 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('displayReport')
#16 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /chroot/home/couchgui/couchguitarstraps.com/html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 /chroot/home/couchgui/couchguitarstraps.com/html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#19 /chroot/home/couchgui/couchguitarstraps.com/html/index.php(87): Mage::run('', 'store')
#20 {main}

I have checked your sql installer file and there was no such create table command which will generate this table and i have checked in other system db also and by default we don't have this table "atalog_category_flat_store_Array" we have atalog_category_flat_store_1 etc.


Please suggest whats the issue?

Need to get back to client with successful instalation.

Waiting for your reply

Regards,
Jyoti

Re: Reports by Product Categories not working. 3 years, 3 months ago #2

Any update please?

Re: Reports by Product Categories not working. 3 years, 3 months ago #3

  • gqueipo
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Hi Jyoti,

It is the same problem I have, also manufacturers reports are not displayed, dont know if you have also that problem.

I sent a support ticket one month ago, and havent received support at all,it is a shame because it could be the best reports system for Magento, but the support with these guys is beyond terrible.

I suggest you tell your client that categories wont work and keep using other reports, or uninstall it and request a refund. I really dont think they will give you a solution nor service at all.

Re: Reports by Product Categories not working. 3 years, 3 months ago #4

  • latitudweb
  • OFFLINE
  • Administrator
  • Posts: 182
  • Karma: 1
Hello guys,

Sorry for the delay, we've been really busy this last week.

A new release was planned last week to improve the Product Categories and Manufacturers reports, and also include some new Inventory reports (a new report area), but it has been delayed to this week. Probably it would be released this same week in a couple of days. We will notify this new release via our usual channels: website, newsletters, RSS feeds, and marketplaces.

Please, once it's released, update your Sales Analytics installations using this release and check whether the isuues have been worked out.

Kind regards, and sorry again for the delay.

Re: Reports by Product Categories not working. 3 years, 3 months ago #5

Is the new release out?

Re: Reports by Product Categories not working. 3 years, 3 months ago #6

  • gqueipo
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
What happened with the new version. It supposed to be live one month a go....

Re: Reports by Product Categories not working. 3 years, 3 months ago #7

  • vaporboost
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
same problem here

Re: Reports by Product Categories not working. 3 years, 2 months ago #8

  • latitudweb
  • OFFLINE
  • Administrator
  • Posts: 182
  • Karma: 1
Please check this new FAQ article that explains how to enable the Product Categories reports: analytictools.latitudweb.com/forum/27-FA...ventory-reports.html

We also remind you that there is a new Sales Analytics release, version 1.1.1, that includes Inventory reports and some bug fixes. It can be downloaded here: analytictools.latitudweb.com/downloads/d...to/categories/6.html

KInd regards.
  • Page:
  • 1
Time to create page: 0.21 seconds

About Us

Latitud WEB is a trademark from Business Excellence through Information Technologies S.L. (BEIT). BEIT is an Information Technology company based in Valencia (Spain). Our aim is to put the IT advantages at the service of companies and organizations of any size.