Support

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.

Description of my issue:

the log starts
You are using PHP 5.3.29 (cli)

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

Current memory usage: 2.25 Mb

Unsetting time limit restrictions.

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

Last Tick : 2014-11-05 05:00:13 GMT-0600 (CST)
Domain : init
Step :
Substep :
Memory used : 7.62 Mb
Warnings : no warnings issued (good)

all instances look good when starting but then further down the line
>
>
>
>
Last Tick : 2014-11-05 05:02:32 GMT-0600 (CST)
Domain : Packing
Step : /home/xxxxxx/public_html/administrator/language/en-GB
Substep :
Memory used : 11.11 Mb
Warnings : no warnings issued (good)

Last Tick : 2014-11-05 05:02:33 GMT-0600 (CST)
Domain : Packing
Step : /home/xxxxxxx/public_html/cgi-bin
Substep :
Memory used : 11.11 Mb
Warnings : no warnings issued (good)

Error displaying the error page: Application Instantiation Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''8'' at line 4 SQL=SELECT `u`.`name`,`u`.`email` FROM `r2ngq_users` AS `u` INNER JOIN `r2ngq_user_usergroup_map` AS `m` ON (`m`.`user_id` = `u`.`id`) WHERE `m`.`group_id` IN '8'

+++++++++++++++
I am at a loss I dont have any MySQL knowledge can you advise/direct to where I can get to understand what I need to do

I can back up via admin back but wanted to automate the setup which seems to be working till I get this error

your support /direction is appreciated
KindRegards
JOhn

John,

In addition to the CRON log, there would be a backup log too. That would be helpful in figuring where and when the error is occurring. The backup log gives the error context.

Please zip and post your backup log and we'll see if we can beat it into submission.

thank you Dale

have attached requested log look forward to recieve comments
KindRegards
John

John,

The good news is that the backup completed normally. There are no errors or warnings in the log file.

That leaves us with a mystery of why we're getting the MySQL error in the CRON job output. I will have to seek some help from Davide and Nicholas.

John,

You found a bug. There was a typo in the code involved with sending the completion email to the administrator. The backup itself is fine, you just didn't get the notice email.

The fix will be included in the next release. Thank you for reporting the problem!

John,

Nicholas released a Developer's Release that includes this fix. The dev release is at https://www.akeebabackup.com/download/developer-releases/akeebapro.html, the most recent release is at the top. If you would install this version and test it, we would appreciate your feedback on if the bug is fixed.

One thing to note about dev releases, they always prompt you to "upgrade" to a stable release, even if that stable release is older. You just need to not upgrade until you see a release greater than 4.0.5 (current).

Fantastic
Glad you managed to squash it! :)

Will do the update and advise
thank you for your assistance
KR
John

WORKED close ticket :) with thanks to all for your prompt attention

results from CronDeamon

Last Tick : 2014-11-07 05:02:33 GMT-0600 (CST)
Domain : finale
Step :
Substep :
Memory used : 14.07 Mb
Warnings : no warnings issued (good)

Backup job finished successfully after approximately 2 minutes Peak memory usage: 14.29 Mb
==================================
and completion email recieved

Akeeba Backup has completed backing up your site using the front-end backup feature. You may visit the site's administrator section to download the backup.

The new backup was taken with profile #1. It consists of 1 part(s). The full list of files of this backup set is the following:

site-www.xxxxx.com.au-20141107-220010.jpa

Have a great day

Thank you for the confirmation! You have a nice weekend.