Support

Admin Tools

#25863 cron Job Error

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 aroundi on Tuesday, 09 August 2016 11:27 CDT

aroundi
 Hello,

I am receiving this error via email:

Subject: Cron <cambridg@s2> /usr/bin/php /home/cambridg/public_html/cli/admintools-filescanner.php
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
X-Powered-By: PHP/5.6.24
Content-type: text/html; charset=UTF-8

Admin Tools PHP File Scanner CLI 4.0.1 (2016-07-28)
Copyright (c) 2010-2016 Akeeba Ltd / Nicholas K. Dionysopoulos
-------------------------------------------------------------------------------
Admin Tools is Free Software, distributed under the terms of the GNU General
Public License version 3 or, at your option, any later version.
This program comes with ABSOLUTELY NO WARRANTY as per sections 15 & 16 of the
license. See http://www.gnu.org/licenses/gpl-3.0.html for details.
-------------------------------------------------------------------------------
You are using PHP 5.6.24 (cgi-fcgi)


Unsetting time limit restrictions.

Site paths determined by this script:
JPATH_BASE : /home/cambridg/public_html
JPATH_ADMINISTRATOR : /home/cambridg/public_html/administrator

Last Tick : 2016-08-09 06:10:01 GMT-0500 (CDT)
Memory used : 4.88 Mb
Warnings : no warnings issued (good)



********** ERROR! **********



Technical information:

Code: 0
File: /home/cambridg/public_html/libraries/joomla/database/driver/mysql.php
Line: 275

Stack Trace:

#0 /home/cambridg/public_html/libraries/joomla/database/driver.php(1728): JDatabaseDriverMysql->execute()
#1 /home/cambridg/public_html/administrator/components/com_admintools/platform/Filescan/Archiver/Jfscan.php(55): JDatabaseDriver->loadResult()
#2 /home/cambridg/public_html/administrator/components/com_admintools/engine/Archiver/Base.php(89): Akeeba\Engine\Archiver\Jfscan->__bootstrap_code()
#3 /home/cambridg/public_html/administrator/components/com_admintools/engine/Factory.php(119): Akeeba\Engine\Archiver\Base->__construct()
#4 /home/cambridg/public_html/administrator/components/com_admintools/engine/Factory.php(594): Akeeba\Engine\Factory::getObjectInstance('\\Akeeba\\Engine\\...')
#5 /home/cambridg/public_html/administrator/components/com_admintools/engine/Core/Domain/Init.php(432): Akeeba\Engine\Factory::getArchiverEngine()
#6 /home/cambridg/public_html/administrator/components/com_admintools/engine/Core/Domain/Init.php(264): Akeeba\Engine\Core\Domain\Init->getArchiveName()
#7 /home/cambridg/public_html/administrator/components/com_admintools/engine/Base/Part.php(255): Akeeba\Engine\Core\Domain\Init->_run()
#8 /home/cambridg/public_html/administrator/components/com_admintools/engine/Core/Kettenrad.php(314): Akeeba\Engine\Base\Part->tick()
#9 /home/cambridg/public_html/administrator/components/com_admintools/engine/Base/Part.php(259): Akeeba\Engine\Core\Kettenrad->_run()
#10 /home/cambridg/public_html/cli/admintools-filescanner.php(236): Akeeba\Engine\Base\Part->tick()
#11 /home/cambridg/public_html/cli/admintools-filescanner.php(322): AdminToolsFAM->execute()
#12 {main}

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I ran a couple of scans from the back end. The first failed mid-way through with an AJAX error (dialog box alert). The second scan was successful.

From the list of files above I'm guessing the path to my PHP files is correct. I'm not sure how to troublrshoot this; can you help?

Thanks,

mark

nicholas
Akeeba Staff
Manager
Please go to your site's administrator backend and click on the System, Global Configuration menu item. Then click on the Server tab. At the top right of the page's main area you'll find the Database Type option. It is currently set to MySQL. Please change it to MySQLi. Then click on the Save & Close button on the toolbar. Now let the CRON job run again. What is the result?

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!

aroundi
Hi Nicholas,

Thanks for the quick reply. I've changed the DB type and edited my cron job to be running now. Giving some thought, I think this problem may coincide with upgrading my PHP version about a month ago. Would this make sense?

Another thought, the hosting server is located in Chicago (I'm in Boston). The cron job is probably scheduled an hour earlier. If I don't receive a report I'll reschedule accounting for the time difference.

mark

aroundi
Hi Nicholas,

After changing the DB type from SQL to SQLi the cron job scan works without errors.

Thank you for your help.

Admin tools Pro is a great product.

Closing ticket.

Rgds,

mark

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!