Akeeba Backup for Joomla!

Tuesday, 08 November 2011 08:18 CST

wbaccus

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the forum before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 1.5.24
PHP version: 5.2.13
MySQL version: 5.0.77-log
Host: Rackspace
Akeeba Backup version: 3.3.6

EXTREMELY IMPORTANT: Please attach your Akeeba Backup log file in order for us to help you with any backup or restoration issue.

Description of my issue:
Having a lot of trouble getting my site to automatically back up each night with my new hosting provider, Rackspace.

When I look at the logs for this, it looks like it completed the backup. It says it finished post-processing all files, but the interface is telling me that the backup failed.

I am post-processing all of the files to CloudFiles for long-term storage.

Tuesday, 08 November 2011 08:26 CST

nicholas

Can you please ZIP and attach the log file? Without it I have no idea what is going on :(

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!

Tuesday, 08 November 2011 10:26 CST

wbaccus

Whoops, meant to do that originally.. Here it is.

Tuesday, 08 November 2011 11:39 CST

nicholas

OK, it seems that it can not send an email after the backup completion. In this case, just go to Akeeba Backup, Component Configuration and disable the option to send an email on backup completion. That 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!

Thursday, 10 November 2011 08:39 CST

wbaccus

OK. I did turn that off, but I'm still getting a failed notice in the interface. When I look at the logs, it seems to be getting through the post-processing of the files.

Anything else I could try?

Attaching a new log file.

Thursday, 10 November 2011 08:44 CST

nicholas

Huh?! According to the log, the backup has finished successfully - up to the very end of the process. If you take a back-end backup, does it show up as OK or as Failed?

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!

Thursday, 10 November 2011 13:34 CST

wbaccus

Took about 2 hours, it came up with the ol' Invalid AJAX Data.

Attaching a log from backend backup.

Thursday, 10 November 2011 15:04 CST

nicholas

I know what the problem is. During the upgrade, the database schema wasn't updated, causing a problem when the backup statistics are being saved. Can you please do a "SHOW CREATE TABLE jos_ak_stats" in phpMyAdmin and paste the result here?

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!

Thursday, 10 November 2011 15:15 CST

wbaccus

I'm using Sequel Pro to manage my databases

When I ran "SHOW CREATE TABLE jos_ak_stats"

I got "No errors; 1 row affected"

CREATE TABLE `jos_ak_stats` (

Thursday, 10 November 2011 15:17 CST

nicholas

Hm, what I am actually missing is the entire response from MySQL :) Is there any icon indicating that you can click on it to read the rest of the MySQL 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!

Thursday, 10 November 2011 15:21 CST

wbaccus

Had a feeling that wasn't what you were looking for. :-)

CREATE TABLE `jos_ak_stats` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`description` varchar(255) NOT NULL,
`comment` longtext,
`backupstart` timestamp NOT NULL default '0000-00-00 00:00:00',
`backupend` timestamp NOT NULL default '0000-00-00 00:00:00',
`status` enum('run','fail','complete') NOT NULL default 'run',
`origin` varchar(30) NOT NULL default 'backend',
`type` varchar(30) NOT NULL default 'full',
`profile_id` bigint(20) NOT NULL default '1',
`archivename` longtext,
`absolute_path` longtext,
`multipart` int(11) NOT NULL default '0',
`tag` varchar(255) default NULL,
`filesexist` tinyint(1) NOT NULL default '0',
`remote_filename` varchar(1000) default NULL,
`total_size` bigint(20) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_fullstatus` (`filesexist`,`status`),
KEY `idx_stale` (`status`,`origin`)
) ENGINE=MyISAM AUTO_INCREMENT=231 DEFAULT CHARSET=utf8;

Friday, 11 November 2011 02:04 CST

nicholas

The good news is that the database schema isn't corrupt. The bad news is that I don't know why it's crashing :s There is a way to find out. You can send me a Personal Message (I'm user "nicholas") with the following information:
- URL to the site's administrator page
- Super Administrator username and password
- FTP connection information
- A link back to this thread so that I can remember what it's all about
I will then log in to your site, create a new backup profile, backing up just a handful of files for testing, allowing me to find out what's going on.

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!

Tuesday, 22 November 2011 11:33 CST

wbaccus

My backup procedure worked for a few days, but for the last week, it's failing every time. I'm going to PM you a login to check it out.

Also, here's a log file from last night's failed backup.

Refresher: It was reporting failed backup, but it was successfully copying everything to Cloud Files and completing. Now it's not doing that at all, but I did notice my temporary backup directory is full of backups.

Tuesday, 22 November 2011 12:31 CST

nicholas

Hello Winston,

Thanks for the PM, but I can see in your log file that all parts are being uploaded correctly and the backup process completes successfully. Moreover, they seem to be removed from your local server. Can you confirm that there is no file named site-(your domain name)-20111122-020704.* in your backup output directory? Thanks!

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!

Tuesday, 22 November 2011 13:45 CST

wbaccus

Looks like they are in the backup directory, but they're not getting uploaded to CloudFiles.

Tuesday, 22 November 2011 14:47 CST

nicholas

Hm, that's odd, the log file says otherwise. It actually says that it has been uploaded and deleted. Try doing this. Remove all backup archives from your backup output directory. Take a new backup with the backup profile which uploads to CloudFiles. Now, take a look at your backup output directory. There should be no backup files. Take a look at CloudFiles. The files should be there. Is this correct?

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, 25 November 2011 04:37 CST

user8590

Hi There,
I use Cloudsites and Cloudfiles and I have this working.

Take a screenshot of your Akeeba config for me with the JPA Config open and the Cloudfiles config open so I can see what you have.

Make sure anything that is sensitive is blacked out (ie: I don't need to know you're API key) or other login details...

Also note, because I use both services, I don't have to split the archive because it's on the "internal" network between the two and is super fast. It takes a couple of seconds to upload 40mb backups. No timeouts :)

Where do you host your website?

Thanks,
Joint Plan
www.jointplan.co.uk
0800 08 07 017

Support