Support

Admin Tools

#20971 File scanner not working since 3.1.0

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Sunday, 26 October 2014 18:20 CDT

Wednesday, 17 September 2014 06:27 CDT

hkymre
I'm seeing the following error when my cron runs

Error displaying the error page: Application Instantiation Error: Unknown column 'sourcePath' in 'field list' SQL=INSERT INTO `xxxx_admintools_filescache`
(`path`,`filedate`,`filesize`,`data`,`checksum`,`sourcePath`) VALUES
('cli/admintools-filescanner.php','1410951722','11156','','fffd62b83a6eea21f0137c29cca7f0d5','/xxx/public_html/cli/admintools-filescanner.php') 

I seen ticket #20969 which might be similar, but I've re-installed 3.1.1 twice & still have the issue

Wednesday, 17 September 2014 07:21 CDT

nicholas
I cannot reproduce this issue. I want you to check something. Please open the file administrator/components/com_admintools/akeeba/platform/jfscan/engines/archiver/jfscan.php with a text editor. Take a look at likes 242 to 245. Do they read exactly:
			// Add a new file record
			unset($filedata->sourcePath);
			$db->insertObject('#__admintools_filescache', $filedata);
			unset($filedata);

or is there any of these lines missing?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 17 September 2014 07:44 CDT

hkymre
Checked & the lines are there, exactly as you posted.

But it works now.

Only things I did differently - deleted cli/admintools-filescanner.php & then re-installed and also hit the Purge File Cache button before running the cron

I've got another couple of sites that are having the problem so I'll try & see which fixed it.

Wednesday, 17 September 2014 07:52 CDT

nicholas
That makes perfect sense. Try using the Purge Files Cache button on the sites where the backup fails. If I am correct in my understanding of the issue it should fix it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 17 September 2014 07:55 CDT

hkymre
Yep, that's done the trick. Purged file cache and scan works fine on all sites.

Wednesday, 17 September 2014 08:10 CDT

nicholas
Cool! This is consistent with my test upgrading from 3.0.x to 3.1.1. You just need to purge the files cache once due to changes in the scanner engine from 3.0.x (and earlier versions) to 3.1.1.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Friday, 26 September 2014 06:10 CDT

hkymre
Spoke too soon.
The scanner had been working fine reporting 0 files changed/modified.

Yesterday, I upgraded to J3.3.4 & no email from Admin Tools.
Checked the output from the cron and it's got

Error displaying the error page: Application Instantiation Error: Unknown column 'sourcePath' in 'field list' SQL=INSERT INTO `xxxx_admintools_filescache`
(`path`,`filedate`,`filesize`,`data`,`checksum`,`sourcePath`) VALUES
('index.php','1411652502','1013','','7397f4ad99a402006262384a5f48157e','sitename etc/index.php')

So it appears as soon as there were changes to report it hits the problem.

Friday, 26 September 2014 09:00 CDT

tampe125
Hello Mark,

thank you very much for reporting this issue.
We have just fixed it and you'll find it in the new version that we'll release on Tuesday.

Thank you very much again!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Sunday, 26 October 2014 18:20 CDT

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
Edited by on 2014-10-26 18:20 CDT

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!