Akeeba Backup for Joomla!

Thursday, 09 May 2013 12:21 CDT

netandpaper

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: 3.0.1
PHP version: 5.3.23
MySQL version: 5.5.23-55
Host: Hostgator
Akeeba Backup version: 3.7.6

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:

cannot fill the database. akeeba runs through the extraction process. i can see the extracted files via ftp. but when i press next after putting in the database data (which are checked and correct) i get the following error:

An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.

HTTP Request Error
HTTP Status: 404 (Not Found)
Internal status: error
XHR ReadyState: 4
Raw server response: 404 page not found

i´m not sure which file you need and since i can only upload one i don´t upload the .jpa file but the log file as you request above.

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 01:55 CDT

nicholas

What is the URL of the site you are trying to restore to?

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 May 2013 02:19 CDT

netandpaper

hi nicholas!
the IP is 50.87.144.104
the domain is reach-up.com, which is hosted by godaddy and pointing with the nameservers to HG.
kr sandra

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 02:40 CDT

nicholas

I need a clarification. Are you accessing the restoration URL as
http://reach-up.com/installation/index.php
or as something which looks like
http://1.2.3.4/~something/installation/index.php

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 May 2013 02:52 CDT

netandpaper

normally i would restore from reach-up.com/kickstart.php
but the pointing of the nameservers didn´t work yet so i restored from
http://50.87.144.104/~reach13/kickstart.php
you see that on http://50.87.144.104/~reach13/ is an error displayed now.
i ran through the restoration process till i had to put in the database data and got a database error first. i tried it a couple of times and get now this error 404 or whatever on http://50.87.144.104/~reach13/
in the ftp i can see that the joomla installation has been extracted but it cannot fill the database obviously. the database data is correct though.
kr sandra

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 02:53 CDT

nicholas

URLs in the form of 1.2.3.4/~something are called temporary URLs and cause great problems to Apache (it can't report the URL of the site being accessed and it cannot parse SEF URLs). As a result restoration will not work on such URLs, as noted in our documentation. Unless you assign a domain name you will not be able to proceed with the restoration.

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 May 2013 02:53 CDT

netandpaper

and i had an index.html file with test content before i ran through the restoration process and could reach the content with reach-up.com without any problem. so it cannot be the pointing of the nameserver that causes the problem, i guess.

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 02:55 CDT

netandpaper

but if i point the nameservers to HG and see the test index.html it should be able to restore, or not?

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 03:09 CDT

netandpaper

it try to restore to my working server and get the following error:

Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 0
Database server error reply:

SQL=CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `bxle3_jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`bxle3_languages` `l` left join `bxle3_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`
Raw query text:

CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `bxle3_jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`bxle3_languages` `l` left join `bxle3_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 03:15 CDT

nicholas

Can you ask your host if your database user has the CREATE VIEW privilege? You will need it in order to restore MySQL VIEWs like the one you are pasting 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!

Friday, 10 May 2013 03:19 CDT

netandpaper

i set up my databases myself and they have all priviliges.

the funny thing is that the restoration process works on my working server. see: test1005.netandpaper.org although i got this wired database error.

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 03:34 CDT

nicholas

There is only one other thing that comes to mind: the tables referenced by this VIEW are not present in the restored database. This can happen due to many reasons:

The extension which created it (it's either JoomFish or Falang – stupidly Falang uses the same table names) was uninstalled, the tables removed but the VIEW wasn't. In this case exclude the view with the database tables exclusion feature of Akeeba Backup
The tables referenced by the view are not backed up because they are excluded with the database tables exclusion feature of Akeeba Backup
You have turned off the database table dependency tracking which is a bad idea what you have views in your database.

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 May 2013 03:48 CDT

netandpaper

that i don´t quite get at all, but let me see:

1. i don´t use JoomFish and also don´t know what Falang is

2. so in Akeeba Backup there is a feature which would exclude certain database tables?
where would i find that to check if its the case that i turned it off?

3. where do i find the database table dependency tracking to see if i turned it off?

please keep in mind, that i restored to my working server 20min ago, got this wird long database error but see the page as it should be. but when i restore to the real server (both Hostgator, both databases all privilges) i get another error (404) and don´t see the page (database is empty) ?

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 03:52 CDT

nicholas

1. I am looking at the VIEW's name. It's bxle3_jf_languages and belongs either to JoomFish or Falang. These are multilingual / translation extensions for Joomla!. Someone installed one of them at some point in time on your site. Otherwise where did this view come from? I've seen it many times causing problems and it's on;y created by one of the aforementioned extensions.

2. Akeeba Backup, Database Table Exclusions, find #__jf_languages. If the icon is white, click on it and it will become yellow. Yellow = excluded.

3. Does not apply in your case, you can forget about 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!

Friday, 10 May 2013 04:12 CDT

netandpaper

i looked it up in the plugin-manager and in the extension manager and didn´t find one of those you mention but i had the language filter turned on. do you think, that could cause the problem?

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 04:25 CDT

nicholas

Nope. Just follow the instructions in #2 above and re-take the backup.

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 May 2013 04:34 CDT

netandpaper

the icon beside was red. should it be red?

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 04:38 CDT

nicholas

That's the "Skip contents" icon. It is always red in view as we cannot back up their content. I meant the other icon which instructs Akeeba Backup to skip the table or view entirely from the backup. That's white. Click on it to turn it yellow.

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 May 2013 04:43 CDT

netandpaper

i did that, i just wanted to be sure that its ok that the other one is red.

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Friday, 10 May 2013 04:45 CDT

nicholas

Yep, that's normal

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 May 2013 02:31 CDT

netandpaper

hi nicholas!

are you available? i have the same problem with another site.

i did this already
"
2. Akeeba Backup, Database Table Exclusions, find #__jf_languages. If the icon is white, click on it and it will become yellow. Yellow = excluded.
"
and try it now again but need to go online right now or else i´m in big trouble.

i just want to see if i could reach you in case it doesn´t work again.

kr sandra

Sandra - Net and Paper Austria www.netandpaper.at [email protected]

Monday, 27 May 2013 05:24 CDT

nicholas

Well, yes, if you have an emergency I will be around until Wednesday evening (my time). From Wednesday evening to Tuesday morning I will be travelling to the J and Beyond conference. I'm told that the Internet connectivity is not good, so you may not hear back from me if you try contacting me during those days.

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, 22 July 2013 18:00 CDT

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2013-07-22 18:00 CDT

Support