Unable to start installation

[Baetylos]

Hi!

 

Downloaded osCommerce, extracted it and uploaded it via ftp in ASCII to my webserver. Set up a database and user in MySQL and then opened catalog/install/ in the browser. I clicked on Install New Store and on the next page I checked both boxes and clicked continue. Then nothing happens. It just refreshes the same page with the checkboxes and the url catalog/install/install.php?step=2.

Unable to get past the checkboxes and to the page where you are supposed to enter database information.

 

The webserver is Windows Server 2003, PHP5 and IIS6.

 

Anyone experienced the same problem or have som ideas?

 

 

Thanks,

 

Vidar

[♥Vger]

Install gets stuck on page 2

---------------------------

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

[Baetylos]

Install gets stuck on page 2

---------------------------

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 for the advice.

I set register_long_arrays = ON and did a restart, but I still can't get past page 2.

Anyone got other ideas?

 

//Vidar

[Gauravs]

In notepad type line as shown below

<?php phpinfo(); ?>

 

Save file as ServerInfo.php at your server root.

 

Run it in browser using http://www.yoursite.com/ServerInfo.php

 

Check what are the settings for

a. PHP_SELF

b. register_globals

c. regiser_long_arrays.

 

Display the result here in forum for next step.

 

cheers

Gaurav

[Baetylos]

In notepad type line as shown below

<?php phpinfo(); ?>

 

Save file as ServerInfo.php at your server root.

 

Run it in browser using http://www.yoursite.com/ServerInfo.php

 

Check what are the settings for

a. PHP_SELF

b. register_globals

c. regiser_long_arrays.

 

Display the result here in forum for next step.

 

cheers

Gaurav

 

 

Hi!

 

Running phpinfo() on the server yields this result:

 

a. PHP_SELF: /serverinfo.php

b. register_globals: ON both local and master

c. register_long_arrays: OFF (even though I have set it to ON in php.ini. Could this be the problem?)

 

The result of serverinfo.php states that include_path is .;C:\php5\pear, but there is no folder on c: named php5 just php.

 

 

//Vidar

[Gauravs]

c. register_long_arrays: OFF (even though I have set it to ON in php.ini. Could this be the problem?)

 

The result of serverinfo.php states that include_path is .;C:\php5\pear, but there is no folder on c: named php5 just php.

where have you modified php.ini - in your server root / or php installation folder?

Also you would have to correct include_path .. since the path doesn't exist, none of the pear functions would get used.

 

A contribution exists for register_long_arrays.

 

Search for php.ini on your hard-drive - it is much better to change the .ini file in installation folder than to make exclusive setting for your catalog.

 

cheers

GS

[Baetylos]

where have you modified php.ini - in your server root / or php installation folder?

Also you would have to correct include_path .. since the path doesn't exist, none of the pear functions would get used.

 

A contribution exists for register_long_arrays.

 

Search for php.ini on your hard-drive - it is much better to change the .ini file in installation folder than to make exclusive setting for your catalog.

 

cheers

GS

 

php.ini is in php installation folder. I deleted the file and set up a new one and now register_long_arrays are set to on and I can get past page 2 of the installation.

 

Thank you very much for all the help. Much appreciated!!!

[Baetylos]

Hmm I got a little further with the installation. Got to the part where I fill in the information about the MySQL database, but after filling in adress, username, password and database when I click continue it stops at the database import.

 

I have also searched for all include_path referances, but I can't find where it refers to the php5 adress. In php.ini include_path is set to C:/PHP/includes but when I look at the result from serverinfo.php include_path refers to .;C:\php5\pear.

 

It's hard to be a noob hehe ;)

 

 

 

//Vidar

[Baetylos]

Now I have double checked through MySQL Query Browser that I can connect to the database I have set up with the username and password I created, so the problem isn't that.

And i have searched every inch of this forum for any reference to the same problem and I have done all the advices I have found.

 

Register_globals is set to On, register_long_arrays is set to On, mysql extensions are set in php.ini and php is up and running correctly. But I still get nothing after filling in database information for database import when importing. It's just the header showing where it says New installation and database import.

 

If anyone have some good ideas I would be much grateful.

 

 

//Vidar

[Gauravs]

Hi Vidar,

Can you connect to mysql at all ?

Is phpMyAdmin able to connect to database ?

You would have to identify the reason why it is not connecting to database (user credential, ports .. could be anything)

 

Cheers

Gaurav

[Baetylos]

Hi Vidar,

Can you connect to mysql at all ?

Is phpMyAdmin able to connect to database ?

You would have to identify the reason why it is not connecting to database (user credential, ports .. could be anything)

 

Cheers

Gaurav

 

I am not using phpMyAdmin, but MySQL Query Browser and MySQL Administrator.

And with MySQL Query Browser I am able to connect to the blank database I have set up.

The database is on a different webserver and I connect with the IP adress. So there is no problem with connection to the database.

And since I get no error messages when running the install I am lost. Checked event logs but no info there. Don't know what can be the problem.

Been struggling with this for almost a week now. It's probably just a minor detail I have missed hehe

 

 

 

//Vidar

[Gauravs]

Hi Vidar

 

1. Copy following code in notepad.

2. Change values for database server, username and password.

3. Save as testmysql.php and upload it to your server root.

4. run http://www.yourserver.com/testmysql.php

 

<?php
mysql_connect("database server", "username", "password") or die(mysql_error());
echo "Connected to MySQL<br />";
?>

 

What is the result?

If you see Connected to MySQL then problem could be with OSC installation variables, if anything is wrong - you would get a display on the screen that would help us to isolate the issue.

 

Thanks

Gaurav

[Baetylos]

Hi Vidar

 

1. Copy following code in notepad.

2. Change values for database server, username and password.

3. Save as testmysql.php and upload it to your server root.

4. run http://www.yourserver.com/testmysql.php

 

<?php
mysql_connect("database server", "username", "password") or die(mysql_error());
echo "Connected to MySQL<br />";
?>

 

What is the result?

If you see Connected to MySQL then problem could be with OSC installation variables, if anything is wrong - you would get a display on the screen that would help us to isolate the issue.

 

Thanks

Gaurav

 

Thanks!

 

This process yielded the following error:

 

Fatal error: Call to undefined function mysql_connect() in ..\www_root\testmysql.php on line 2

 

So I am able to connect to MySQL through MySQL Query Browser, but not through PHP? What can I do to solve this?

 

 

//Vidar

[Guest]

Thanks!

 

This process yielded the following error:

 

Fatal error: Call to undefined function mysql_connect() in ..\www_root\testmysql.php on line 2

 

So I am able to connect to MySQL through MySQL Query Browser, but not through PHP? What can I do to solve this?

//Vidar

I suppose that it is defined in both of your configure.php files?

[Baetylos]

I suppose that it is defined in both of your configure.php files?

 

I haven't changed anything in the configure.php files. Isn't that what the installation will do and set up the configure.php file?

 

 

//Vidar

[Guest]

I haven't changed anything in the configure.php files. Isn't that what the installation will do and set up the configure.php file?

//Vidar

Supposed to, but it would not hurt to check, but do not post your database info on line.

[Gauravs]

I haven't changed anything in the configure.php files. Isn't that what the installation will do and set up the configure.php file?

//Vidar

Well we are not there yet to test configure.php, PHP doesn't have access to mysql_connect() function (which is strange !!!!).

undefined function mysql_connect()

Even if you don't have OSC installed, inbuilt/default php functions should work.

The webserver is Windows Server 2003, PHP5 and IIS6

Is this setup on a local machine, or a web-server. If on a remote host, could you please check the KB / FAQ to see if you need to enable something on your server end.

 

Link to your site / host server would certainly help me to dig out more information. This appears to be a problem with PHP installed on your server. Run following code on your server as well to gather some insight on what all is installed and configured for PHP on your server. [save as phpinfo.php and run using http://www.yoursite.php/phpinfo.php)

<?php phpinfo(); ?>

 

 

 

Cheers

Gaurav

[♥Vger]

With the exception of the two configure.php files reload all other files via FTP. It looks as though some of the files did not upload correctly.

 

Vger

[Gauravs]

With the exception of the two configure.php files reload all other files via FTP. It looks as though some of the files did not upload correctly.

 

Vger

mysql_connect() should work on any server that has PHP installed, with or without OSC files.

 

It is an inbuilt function just like include or requires ... and thus, the problem is NOT with OSC at this stage.

 

Thanks

Gaurav

[Baetylos]

Well we are not there yet to test configure.php, PHP doesn't have access to mysql_connect() function (which is strange !!!!).

undefined function mysql_connect()

Even if you don't have OSC installed, inbuilt/default php functions should work.

 

Is this setup on a local machine, or a web-server. If on a remote host, could you please check the KB / FAQ to see if you need to enable something on your server end.

 

Link to your site / host server would certainly help me to dig out more information. This appears to be a problem with PHP installed on your server. Run following code on your server as well to gather some insight on what all is installed and configured for PHP on your server. [save as phpinfo.php and run using http://www.yoursite.php/phpinfo.php)

<?php phpinfo(); ?>

Cheers

Gaurav

 

 

This is setup on a webserver. I have looked through setup of PHP on the server and I can't seem to find anything that should be done differently.

This is the php.info: http://pyntshop.twm.no/phpinfo.php

I notice that there is no info concerning MySQL, so there must be something wrong with the installation of PHP on the server. The .dll is enabled in php.ini.

 

 

 

//Vidar

[Gauravs]

Hi Vidar,

You would have to contact your service provider to compile PHP with MySQL. Since MySQL was never compiled, you don't have access to database functions, and I am afraid there is nothing you and I could do at this stage.

 

Just to check what you should see when PHP is compiled correctly - is shown below and available on my Sandbox for a limited time. You can compare the output from your server vs. mine.

mysql
MySQL Support enabled 
Active Persistent Links  0  
Active Links  0  
Client API version  5.0.45  
MYSQL_MODULE_TYPE  external  
MYSQL_SOCKET  /var/run/mysqld/mysqld.sock  
MYSQL_INCLUDE  -I/usr/include/mysql  
MYSQL_LIBS  -L/usr/lib -lmysqlclient

 

Cheers

Gaurav

[Baetylos]

Hi Vidar,

You would have to contact your service provider to compile PHP with MySQL. Since MySQL was never compiled, you don't have access to database functions, and I am afraid there is nothing you and I could do at this stage.

 

Just to check what you should see when PHP is compiled correctly - is shown below and available on my Sandbox for a limited time. You can compare the output from your server vs. mine.

mysql
MySQL Support enabled 
Active Persistent Links  0  
Active Links  0  
Client API version  5.0.45  
MYSQL_MODULE_TYPE  external  
MYSQL_SOCKET  /var/run/mysqld/mysqld.sock  
MYSQL_INCLUDE  -I/usr/include/mysql  
MYSQL_LIBS  -L/usr/lib -lmysqlclient

 

Cheers

Gaurav

 

 

Aha! That would explain it. At least I know whats the problem, so I can deal with it.

Thank you very much for the assistance, all of you!!!!

Much appreciated :D

 

//Vidar

[Baetylos]

Aha! That would explain it. At least I know whats the problem, so I can deal with it.

Thank you very much for the assistance, all of you!!!!

Much appreciated :D

 

//Vidar

 

I installed MySQL, PHP and OSCommerce on a different webserver doing the exact same procedures I used on the previous server. And this time everything went smoothly. I even managed to update OSCommerce with a template without any problems.

So the problems I had was because of the initial server. Guess it is up for a complete format hehe

 

 

 

//Vidar