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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

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

Users browsing this forum: paola_84, Semrush [Bot] and 62 guests