Page 1 of 1

Seo panel report - not displaying the change between dates

PostPosted: Mon Apr 13, 2015 6:40 pm
by seopanel_forum
Please apply following patch for seo panel version <= 3.6.0

1) replace file seopanel/controllers/report.ctrl.php

with contents of

http://seopanel.googlecode.com/svn-history/r478/trunk/seopanel.v.3.7.0.beta/controllers/report.ctrl.php


2) replace file seopanel/themes/classic/views/report/reportsummary.ctp.php

with contents of

http://seopanel.googlecode.com/svn-history/r478/trunk/seopanel.v.3.7.0.beta/themes/classic/views/report/reportsummary.ctp.php


3) Execute following sql in mysql database

Code: Select all
ALTER TABLE `searchresults` ADD `result_date` DATE NULL , ADD INDEX ( `result_date` );
UPDATE `searchresults` SET `result_date` = FROM_UNIXTIME(time, '%Y-%m-%d');