Post by gjburg » Mon May 13, 2019 9:48 pm

Hi, I want to try to enable recent activity logging but what I do try it's not logged. I've searched the forum and tried to enable all required settings and probably I'm missing something but can't find what and where.

Followed also another topic about it but didn't fix it
viewtopic.php?f=199&t=200422&p=707266

1) Have enabled the Activity report extension
2) Have enabled it in the shop settings
3) Storage folder is outside my httpdocs and 777 writable
4) to be sure cleared my xxx_customer_activity table

However nothing is logged but the "customers online" function is working fine.

Newbie

Posts

Joined
Wed Jan 21, 2015 5:02 am

Post by straightlight » Tue May 14, 2019 12:37 am

No OC version posted. Forum rules.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by gjburg » Tue May 14, 2019 12:46 am

Sorry forgot to post it's the latest 3.0.3.2

I've recreated the activity table and have overwritten the admin directory and now it seems to be working
New orders and logins are logged.

Code: Select all

DROP TABLE IF EXISTS `oc_customer_activity`;
CREATE TABLE `oc_customer_activity` (
  `customer_activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `key` varchar(64) NOT NULL,
  `data` text NOT NULL,
  `ip` varchar(40) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`customer_activity_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Newbie

Posts

Joined
Wed Jan 21, 2015 5:02 am

Post by Moel » Sat Aug 31, 2019 9:46 pm

Could you give me tutorial about this? where I should write those script? thanks

Newbie

Posts

Joined
Sat Feb 16, 2019 5:48 am

Post by straightlight » Sun Sep 01, 2019 5:59 am

Moel wrote:
Sat Aug 31, 2019 9:46 pm
Could you give me tutorial about this? where I should write those script? thanks
In your PHPMyAdmin - > Opencart Database - > SQL tab. You simply need to copy and paste that code and ensure the database table prefix name matches in the pasted code before you execute it. Most importantly, to make a backup of your database before applying any SQL codes.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: pprmkr and 22 guests