Support

Akeeba Backup for Joomla!

#13706 Akeeba Backup manually creates a MySQL dump and Akeeba Backup using cron doesn't create a MySQL dump

Posted in ‘Akeeba Backup 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
Akeeba Backup version
n/a

Latest post by nicholas on Monday, 01 October 2012 11:34 CDT

user67643
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: (unknown) 2.5.6
PHP version: (unknown) 5.3.3.7
MySQL version: (unknown) ) 5.1.63
Host: (optional, but it helps us help you)
Akeeba Backup version: (unknown) 3.6.6.rc pro

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

When manually backing up using akeeba web interface we successfully get a mysql dump file in the backup JPA file. When using a cron to automatically backup the joomla site the mysql dump file is empty at 0KB. Any ideas, what this maybe? Thanks

This is the error we get:

-------------------------------------------------------------------------------
You are using PHP 5.3.3-7+squeeze14 (cli)

Starting a new backup with the following parameters:
Profile ID 1
Description "Command-line backup"

Current memory usage: 1.4 Mb

Unsetting time limit restrictions.

Site paths determined by this script:
JPATH_BASE : /var/www/cli/../
JPATH_ADMINISTRATOR : /var/www/cli/..//administrator

Last Tick : 2012-10-01 11:38:05 GMT+0100 (BST)
Domain : init
Step :
Substep :
Memory used : 5.07 Mb
Warnings : no warnings issued (good)

Last Tick : 2012-10-01 11:38:05 GMT+0100 (BST)
Domain : installer
Step :
Substep :
Memory used : 5.11 Mb
Warnings : no warnings issued (good)

Last Tick : 2012-10-01 11:38:05 GMT+0100 (BST)
Domain : PackDB
Step :
Substep :
Memory used : 6.57 Mb
Warnings : no warnings issued (good)

Last Tick : 2012-10-01 11:38:06 GMT+0100 (BST)
Domain : Packing
Step : /var/www/cli/../administrator/language/en-GB
Substep :
Memory used : 6.78 Mb
Warnings : no warnings issued (good)

Last Tick : 2012-10-01 11:38:15 GMT+0100 (BST)
Domain : Packing
Step : -
Substep :
Memory used : 6.78 Mb
Warnings : no warnings issued (good)

PHP Fatal error: Uncaught exception 'JDatabaseException' with message ' SQL=SELECT `u`.`name`,`u`.`email`
FROM `rul4a_users` AS `u`
INNER JOIN `rul4a_user_usergroup_map` AS `m` ON (`m`.`user_id` = `u`.`id`)
WHERE `m`.`group_id` = ''' in /var/www/libraries/joomla/database/database/mysqli.php:403
Stack trace:
#0 /var/www/libraries/joomla/database/database.php(923): JDatabaseMySQLi->execute()
#1 /var/www/administrator/components/com_akeeba/akeeba/platform/joomla25/platform.php(479): JDatabase->loadAssocList()
#2 /var/www/administrator/components/com_akeeba/akeeba/platform/platform.php(148): AEPlatformJoomla25->get_administrator_emails()
#3 /var/www/administrator/components/com_akeeba/akeeba/core/domain/finalization.php(191): AEPlatform->__call('get_administrat...', Array)
#4 /var/www/administrator/components/com_akeeba/akeeba/core/domain/finalization.php(191): AEPlatform->get_administrator_emails()
#5 /var/www/administrator/components/com_akeeba/akeeba/core/domain/finalization.php(125): AECoreDomainFinalization->mail_administrat in /var/www/libraries/joomla/database/database/mysqli.php on line 403

nicholas
Akeeba Staff
Manager
Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it. Without a log file I can't possibly know what is going on. Make sure that you include the log file from the "Command-line" origin, not the one from the "Back-end" origin. Thank you!

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!

user67643
attached is the log

thanks

nicholas
Akeeba Staff
Manager
Hm, that's odd, Akeeba Backup believes it's doing a Restore Point backup :s Can you please first try to upgrade to Akeeba Backup 3.6.5 or 3.6.6.rc1?

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!

user67643
I have uninstalled completely akeeba and installed a new version and it works.
thanks

nicholas
Akeeba Staff
Manager
You're welcome!

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!

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!