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

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

with contents of

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');