Support

Admin Tools

#20992 file scanner via crontab

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 tonnick on Monday, 27 October 2014 07:13 CDT

Sunday, 21 September 2014 18:58 CDT

tonnick
Hello

 I implemented the crontab for the php file scanner on 4 joomla websites, but randomly, it seems that it produces some errors.

here are the logs from web which did not work :

PHP Fatal error: Uncaught exception 'JDatabaseException' with message 'Unknown column 'sourcePath' in 'field list' SQL=INSERT INTO `ad1z8_admintools_filescache` (`path`,`filedate`,`filesize`,`data`,`checksum`,`sourcePath`) VALUES ('plugins/installer/admintools/admintools.php','1410652105','1888','','68b98f6eb526a763e4b76f8d1a34c0d3','mypath/plugins/installer/admintools/admintools.php')' in mypath/libraries/joomla/database/database/mysqli.php:403
Stack trace:
#0 mypath/libraries/joomla/database/database.php(867): JDatabaseMySQLi->execute()
#1 mypath/administrator/components/com_admintools/akeeba/platform/jfscan/engines/archiver/jfscan.php(172): JDatabase->insertObject('#__admintools_f...', Object(stdClass))
#2 mypath/administrator/components/com_admintools/akeeba/abstract/archiver.php(230): AEArchiverJfscan->_addFile(false, '/var/www/vhosts...', 'plugins/install...')
#3 /var in mypath/libraries/joomla/database/database/mysqli.php on line 403

I cleared the cache before starting the file scanner. It worked on 3/4 joomla websites. but it changes, it is not always on same web... :/

I noticed scan result is shown on admin backend even if it has not been sent. And it show 13822 files. it is impossible. Checking on server with same extention, I have 4257.

do you have any idea about this issue ?

thx !
Edited by tonnick on 2014-09-21 19:14 CDT

Monday, 22 September 2014 02:15 CDT

nicholas
I think that the file cache wasn't cleared or updated.

First go to your Global Configuration and turn off caching.

Now go to Components, Admin Tools. Reload the page. This will fix any database layout issues with Admin Tools tables, if any are found.

Go to PHP File Change Scanner and click on the Purge File Cache button.

Now you can re-enabe caching in Global Configuration, if it was enabled in the first step.

If the above doesn't work you can try emptying the contents of the abc_admintools_filescache table (but not deleting the table itself!), where abc_ is the common prefix of your site's tables.

If you are not sure how to do this or if this didn't work you can alternatively export your Admin Tools settings, uninstall Admin Tools, re-install it and import your settings. This is the equivalent of a master reset of all internal Admin Tools caches and a complete rebuild of its database tables.

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!

Sunday, 28 September 2014 13:41 CDT

tonnick
ok I disabled cache / cleared it / purge php scanner file cache / re enable on the web where I had cache enable.

my crontab will run tonight, I'll provide you feedback soon. thx

one more thing, my cron run with root, and result is that I have fof directioy in my cache folder for web which are using cache system. so I have to clear cache from my server and not from joomla backend. Can't you use temp instead of cache directory maybe ?
Edited by tonnick on 2014-09-28 13:45 CDT

Monday, 29 September 2014 00:25 CDT

nicholas
We will release a new version on Tuesday which addresses this issue

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!

Monday, 29 September 2014 02:02 CDT

tonnick
crontab ran, and unfortunatly, it did not work on 4/5 webs.

and the web which works detected all files as new instead of only the real new ones and / or modified ones :/ I guess it was due to cache clear.

Monday, 29 September 2014 05:48 CDT

nicholas
As I said: we are aware. We will release a new version on Tuesday which addresses this issue. Just wait approximately 20 hours since receiving this reply :)

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!

Monday, 29 September 2014 07:19 CDT

tonnick
hehe ok ! ;) thx !

Thursday, 09 October 2014 09:13 CDT

tonnick
Did you release a new version ?

Thursday, 09 October 2014 10:48 CDT

nicholas
We rolled back version 3.2 due to quality assurance issues. We are now working on proper automated testing. The next version (3.3) will be thoroughly tested before release. The downside is that we need time to write all the tests, so we do not expect to publish a new version before the end of the month.

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, 10 October 2014 03:13 CDT

tonnick
ok so what are we supposed to do with version 3.1.1 pro ? do I just desactivate crontabs untill next release ?

Friday, 10 October 2014 06:01 CDT

nicholas
Yes, please.

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!

Sunday, 26 October 2014 16:05 CDT

tonnick
hello ! did you have any progress on the resolution ? thx for your help !

Sunday, 26 October 2014 16:23 CDT

nicholas
As far as we can tell version 3.3.1 has resolved this issue. Please upgrade to Admin Tools 3.3.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!

Monday, 27 October 2014 07:13 CDT

tonnick
ok thx I'll try and will provide you feedback.

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!