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

Problem while installing Sales Analytics
(1 viewing) (1) Guest
SALES ANALYTICS Installation & Configuration.
  • Page:
  • 1

TOPIC: Problem while installing Sales Analytics

Problem while installing Sales Analytics 2 years, 3 months ago #1

  • sazzabi
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hello,
I have purchased and installed Sales Analytics on Joomla 1.5.26 / Virtuemart 1.1.5 stable and I got a lot of errors on installation page but it says "Sales Analytics v3.1.1 Installed Successfully!"

Unable to load the order segmentation table
Table 'atelierm_db.mer18_virtuemart_orders' doesn't exist SQL=INSERT INTO `mer18_sa_order_segmentation` (virtuemart_order_id, cdate, cdate_t, cdate_u, cweek_n, cweek_y, cweek_t, cweek, cmonth_n, cmonth_t, cmonth, cyear, source) SELECT a.virtuemart_order_id AS virtuemart_order_id, a.modified_on AS cdate, a.modified_on AS cdate_t, UNIX_TIMESTAMP(a.modified_on) AS cdate_u, DATE_FORMAT(a.modified_on, '%v') AS cweek_n, DATE_FORMAT(a.modified_on, '%x') AS cweek_y, DATE_FORMAT(a.modified_on, '%x-%v') AS cweek_t, DATE_FORMAT(a.modified_on, '%v/%x') AS cweek, DATE_FORMAT(a.modified_on, '%m') AS cmonth_n, DATE_FORMAT(a.modified_on, '%Y-%m') AS cmonth_t, DATE_FORMAT(a.modified_on, '%M/%Y') AS cmonth, DATE_FORMAT(a.modified_on, '%Y') AS cyear, "V" FROM `mer18_virtuemart_orders` AS a WHERE a.modified_on IS NOT NULL ORDER BY a.virtuemart_order_id;Unable to load the order_cr segmentation table
Table 'atelierm_db.mer18_virtuemart_orders' doesn't exist SQL=INSERT INTO `mer18_sa_order_cr_segmentation` (virtuemart_order_id, cdate, cdate_t, cdate_u, cweek_n, cweek_y, cweek_t, cweek, cmonth_n, cmonth_t, cmonth, cyear, source) SELECT a.virtuemart_order_id AS virtuemart_order_id, a.created_on AS cdate, a.created_on AS cdate_t, UNIX_TIMESTAMP(a.created_on) AS cdate_u, DATE_FORMAT(a.created_on, '%v') AS cweek_n, DATE_FORMAT(a.created_on, '%x') AS cweek_y, DATE_FORMAT(a.created_on, '%x-%v') AS cweek_t, DATE_FORMAT(a.created_on, '%v/%x') AS cweek, DATE_FORMAT(a.created_on, '%m') AS cmonth_n, DATE_FORMAT(a.created_on, '%Y-%m') AS cmonth_t, DATE_FORMAT(a.created_on, '%M/%Y') AS cmonth, DATE_FORMAT(a.created_on, '%Y') AS cyear, "V" FROM `mer18_virtuemart_orders` AS a WHERE a.created_on IS NOT NULL ORDER BY a.virtuemart_order_id;
  • Page:
  • 1
Time to create page: 0.14 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.