install.php?step=2 Install Problem

[GeordiSi]

Hi all. A quick look shows many people with the same problem but no satisfactory solution.

After entering the SQL database details and clicking continue I get an incomplete screen which shows only the oscommerce logo and the phrases "new installation" and "Database Import". I haven't a clue about PHP but using logic I found a problem in the install_2.php file. Deleting the line begining with

$db['DB_SERVER'] = trim(stripslashes($HTTP

produces the message "A test connection made to the database was NOT successful"

The subsequent lines of PHP code seem to cause no problem despite being similar to that deleted.

 

Does anyone have any idea what could cause this problem or give me any help to find the source of the problem?

 

Regards.

[♥Vger]

The most common cause for installation getting stuck in step 2

is that most recent PHP installations have register_long_arrays = OFF

This needs to be turned to ON in the php.ini file (you will need to

stop and restart your server to get this change to take effect.)

 

Vger

[GeordiSi]

The most common cause for installation getting stuck in step 2

is that most recent PHP installations have register_long_arrays = OFF

This needs to be turned to ON in the php.ini file (you will need to

stop and restart your server to get this change to take effect.)

 

Vger

 

Thanks Vger. Tried to find register_long_arrays in the PHP.ini file but wasn't there. I presume this is because I have an older version of PHP (4.2.2-17). I even inserted the line into the PHP.ini file but this didn't work. I've been wondering whether this because of my PHP setup. I had to use the Register Globals Patch contribution to get the installation to get to this stage and was wondering whether these problems suggest a setup problem?

Is there any way to get PHP to display information about the content of the variables or find exactly where the script stalls?

Simon.

[angshuonline]

Thanks Vger. Tried to find register_long_arrays in the PHP.ini file but wasn't there. I presume this is because I have an older version of PHP (4.2.2-17). I even inserted the line into the PHP.ini file but this didn't work. I've been wondering whether this because of my PHP setup. I had to use the Register Globals Patch contribution to get the installation to get to this stage and was wondering whether these problems suggest a setup problem?

Is there any way to get PHP to display information about the content of the variables or find exactly where the script stalls?

Simon.

 

Hi I am trying to use OSCommerce 2.2ms2 with Php5.2 with Apache2.2 and mySql 5.0.18 on WinXP Pro, SP2. I have the same problem as stated above by GeordiSi on step 2 of installation. Having faced that I created and loaded the schema using MySQL and now I face the same problem in step 7 (after skipping database import on step 1).

 

I have edited the php.ini file for

extension=php_mysql.dll (uncommented)

register_long_arrays = On

extension_dir = "D:\PHP\ext"

 

I have updated the httpd.conf file for setting:

PHPIniDir "D:/ PHP/"

LoadModule php5_module "D:/ PHP/php5apache2_2.dll"

AddType application/x-httpd-php .php

 

I have traced and found that the problem occurs (in both install_2.php and install_7.php) while encountering line: osc_db_connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD']);

 

I then tried to catch the error by inserting a try/catch block in the install_7.php file:

 

try {

osc_db_connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD']);

} catch (Exception $e) {

echo $e->getMessage();

throw $e;

}

 

But I don?t get any error. The control does not seem to come to the catch block or I am doing some stupid mistake. Any help or clue?

regs

~angshu

P.S: Newbie. I do not know PHP or OSCommerce.

[angshuonline]

Btw, I had to apply the register globals patch files to get it to working this stage. Also I changed the port of apache to 7070 instead of std 80 or 8080 ports. (if they matter anyway)

[GeordiSi]

Thanks Vger. Tried to find register_long_arrays in the PHP.ini file but wasn't there. I presume this is because I have an older version of PHP (4.2.2-17). I even inserted the line into the PHP.ini file but this didn't work. I've been wondering whether this because of my PHP setup. I had to use the Register Globals Patch contribution to get the installation to get to this stage and was wondering whether these problems suggest a setup problem?

Is there any way to get PHP to display information about the content of the variables or find exactly where the script stalls?

Simon.

 

In answer to my own question - I have solved it! I can't see any similar posts so I thought I'd reply. The problem stems from function libraries not being loaded due to compiling php5 with mysqli extensions. The functions in osCommerce are only compatible with mysql. Maybe not using the correct terminology but compiling php5 with mysql extensions solves the problems.

 

Hope this stops people wasting many hours like I have.