Support

Hi,

First of all, I want to thank you for your work and this great component.

I'm trying to move my website to another host using the JoomlaPack Component (latest version) and I experienced the following issue :

I created a backup of the entire site (Site + Database) with Joomlapack.
I downloaded the zipped backup package using Filezilla
I unpacked this package using the JoomlaPack extract Utility
I uploaded the unpacked files to the new host
I successfully connected to the website on the new host and get into the Joomlapack Installer 4.

All of these steps were successful, without any problem, and the first step of the Installer indicate that all prerequisits are O.K. but at the second step (Database Initialisation), I'm unable to connect to the Database, even I typed the correct infos for Mysql, Database Server, Username, Password, and Database name.

Here is the error message :

AJAX error:
parsererror(undefined)
Raw Data:





I verified the parameters with my Hosting provider, and they are correct.

Then I tried to make a fresh install of Joomla!, and the Original Joomla! Installer accepts the parameters that were not recognized by the JoomlaPack! Installer.

What did I wrong ?
Could you help me please ?

Thanks in advance.

The most common error is assuming that JoomlaPack can create the database, but that isn't the problem here. There aren't any known connection problems in any of the three latest versions of JoomlaPack (2.3.3, 2.4.b2 and SVN577M). It bothers me that you're getting an AJAX error instead of a simple "can't connect" message. I will ask Nicholas to take a look at this.

Thanks for your answer.
I already used previous versions on other websites and never had any problems...
I'll wait for your feedback.

Thanks for all.

Maybe could I try to replace JPI4 by JPI3 ?

Is it possible ?

If yes, how to do it ?
I guess it is not just to replace the directory "Installation" of JPI4 by that one of JPI3, but that there are some files to keep ?

I have the same issue. I need to get a resolution as I cannot update several websites.

thanks!

Al...

Thanks for your answer Nicholas.

There were effectively dollar signs in the password, but I already changed it to a password with only standard characters.

However, there is an underscore sign in the database name, which is imposed by the host.

I have access to the database through phpmysql, but cannot delete or rename it.

In the meantime, I'll try to replace the JPI4 by an older version and keep you informed of the result.

Kind regards

The underscore isn't a problem, my host imposes that also.

Could you provide me a link to download JPI3 ?

I wondered where you were going to get the JPI3 code from :lol: Most users aren't comfortable with swapping installers.

The attached zip contains the /installation folder from the backup. It should replace the entire current folder except for the /installation/sql folder. This is the JPI3 installer. installation-20091118.zip

Thanks al lot...

I successfully replaced JPI4 by JPI3, but unfortunately, it neither doesn't work :(

It seems to accept my mysql parameters, but I get the following message :

Unable to determine the filesize of /my_site_folder_path/installation/includes/../sql/

Is the joomla.sql file located at the same place in JPI3 than in JPI4 ?

It seems to be looking for a folder /installation/includes/.../sql/ ???

Yes, the database dump would be in the same place. The /installation folder should be self contained. The JPI3 installer does call Joomla! core files, JPI4 does not.

If it can't find a file, we may have a permission or file ownership problem. If your server supports it, please flag the /installation folder as 777 (all rights for all users). You need to do this recursively, so subfolders and files are also flagged. There is usually a check box on your ftp client to do this when you change properties. Some servers won't allow 777, they will throw a 500 error for anything higher than 755.

Permissions changed as 777 for the /installation folder, recursively to all subfolders and files, but the situation remains the same...

Still the same message "Unable to determine the filesize of /my_site_folder_path/installation/includes/../sql/"

My mysql parameters are well accepted, but it seems to be now another problem than with JPI4...

It becomes very urgent to restore my website...

The /installation/sql directorys exists and it contains the the files joomla.sql and databases.ini...

I'll try again, but I'll do this during the week-end and if it neither doesn't work, I'll take a look on the emergency manual restoration procedure.

The site must be back online for next week.

I keep you informed, and please, keep me aware if you find a solution.

Thanks again for your help.

I finally successfully restored my site using the Manual Restore Procedure and it is back online.

However, I'd like to find a solution to be able to backup/restore my site using your great component...

Now that my site were moved to the new host, I'll try to backup/restore it again,let's hope the problem was only due to the transfer from a host to another, and that it will luck when remaining on the same host...

I too am having the same problem. See my separate post.
No special characters are given.

Hey folks,

had the same problem yesterday. JPI4 couldn't connect to database. (1&1 server)
My databank was a MySQL 4. I deleted it and built a new MySQL 5 databank, and suddenly the Installer could connect. Don't know if this works for you, but it could be the problem.
But still I didn't get my page on the server. After connecting to database, i get a white screen with "invalid task" written on it ? Does anybody know what the problem is?

greetz aendipopaendi

Hello

I just read the previous posts and I have been experiencing all of these issues during various attempts to restore a site using JPI4.

Most recently I have created a JPA backup file and uploaded it to the server along with Kickstart. When I run the installation everything looks ok until the database section. I have failed here on seven occasions after FTP uploads and was advised to use the Kickstart method.

The outcome is the same. At the database restore page I get the following messages:

Warning: parse_ini_file() has been disabled for security reasons in /content/HostingPlus4/s/l/slowfoodireland.com/web/installation/includes/logic/dbsetup.php on line 36

Warning: array_keys() [function.array-keys]: The first argument should be an array in /content/HostingPlus4/s/l/slowfoodireland.com/web/installation/includes/logic/dbsetup.php on line 49

Warning: array_shift() [function.array-shift]: The argument should be an array in /content/HostingPlus4/s/l/slowfoodireland.com/web/installation/includes/logic/dbsetup.php on line 131

Warning: array_pop() [function.array-pop]: The argument should be an array in /content/HostingPlus4/s/l/slowfoodireland.com/web/installation/includes/logic/dbsetup.php on line 132

When I try to connect to the database I get this message:

AJAX error:
parsererror(undefined)

Raw Data:






I have made numerous attempts to circumvent this, including trying a different remote host, and I cannot get past the db restore.

Any help would be most welcome. I am running out of time.

Kind regards

PD

Continuation

After the time it took to complete writing the above I returned to the JPI4 DB restore page and refreshed it. I did not change anything. The four warning messages disappeared and I hit the next button. I got the following message:

"Could not determine the size of the database dump file"

Stuck again.

PD

I think the parse_ini_file error is the root of the problem. It can't read databases.ini and it goes downhill from there.

Nicholas is going to be offline for a few days, the only thing that I can offer you right now is a manual restore. This would bypass the installer scripts. I don't think the JPI3 installer would be any different. The manual restore instructions are here.

Hello,

A quick update.

I tried the manual restore after the above failure. I edited the joomla.sql file and configuration.php file etc. as instructed and got nowhere. Just MySQL syntax errors when I tried to restore the database. I put that in a separate post.

However, since the problem during the manual restore seemed to be with the joomla.sql file, I uploaded the uncompressed joomla.sql file from the original localhost website on my pc. (This was in place of the file in the decompressed back up installation folder.) I edited this file according to the manual restore instructions and it worked. No syntax errors.

I can only conclude that the Joomlapack compression or Kickstart extraction caused some problem with the joomla.sql file.

Don't know if it adds to the general body of knowledge, but there it is for what it is worth.

PD