osCommerce & MySQL

[bluewolf]

What version of MySql does osCommerce support? Looking over the readme in the windows distro I didn't see this. I have mysql 4.1.3 setup, but when going to install the db /catalog/install it finks out on the second page after I put in the details of the db. ie it doesn't create it.

 

I have created the db's manualy, but after looking at the configure.php as suggestted in the readme I went to /catalog and it return'd a error: Fatal error: Call to undefined function mysql_connect() in d:\serv\www\catalog\includes\functions\database.php on line 19

 

I know in mysql 4.x they changed some of the routines in connectting to a db. So, just wondering which version osCommerance supports?

 

Also, just incase i did the configure.php wrong. Would someone post an example of what I should put in each field. Thanks.

 

bluewolf

[bluewolf]

kf webserver / latest build

MySQL 4.1.3

Php 5.0 build 2195

 

domain : www.renegadebbs.net

server root: d:\serv\www

catalog : d:\serv\www\catalog

 

Everything else in it is default at this time. php has access read/write rights to /includes/configure.php . mysql user has create/read/write rights to the osCommerce mysql tables. Looks as thought I have everything setup correctly.

I have phpbb installed on here also. So, I know it isn't mysql. php:

( www.renegadebbs.net/test.php )

 

 

What version's of those software would you suggest

running in order to get osCommerce to work properly.

I don't want to change the webserver I am using to

anything else. The documents said I wouldn't have

to either. Accually I don't see why I would have to.

 

It really should be this hard to install. I at least should

see something instead of a error when going to

www.renegadebbs.net/catalog/

 

It defentantly has something to do with the MySQL access though. Cause after the configure.php the error is about connectting to it. Also, when tring to make the database for the first time. (I had to do the dos create). It would stall on me and not finish displaing the installtion screen. I can take a snap shot if you would like.

 

here is the configure.php

-==-=-==-

define('HTTP_SERVER', 'http://renegadebbs.net'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'http://renegadebbs.net'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', false); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.renegadebbs.net');

define('HTTPS_COOKIE_DOMAIN', 'www.renegadebbs;.net');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', 'd:/serv/www/catalog/');

define('DIR_WS_HTTPS_CATALOG', 'd:/serv/www/catalog/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'notshown');

define('DB_SERVER_PASSWORD', 'notshown');

define('DB_DATABASE', 'oscommerce');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

?>

[bluewolf]

To answer my own questions.....

 

 

MySQL v4.0.1

PHP v4.3.8

 

No newer.. Can we update please....