Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

PHP 5 and osCommerce

Akira71

By Akira71
in General Support

Recommended Posts

Akira71

Akira71

Posted
Posted

A few days ago I ran into a problem with osCommerce and the version of MySQL being used. A few suggestions were put in place to alleviate the problem with changing the password format to OLD_PASSWORD(). Well that never actually worked in MySQL even with the documentation specified.

 

A second suggestion was to convert osCommerce to run in MySQL 5 and I started that process. I been searching online and there are lots and lots of little pieces. I have not found a comprehensive list of items to work on. I was hoping someone here might be able to point me in the right direction. To this day I have not seen osCommerce work and it is beginning to get frustrating. However I am willing to stick with it since the support does seem to be exceptional. Thank you!

 

Notice the first error I am getting is the register_globals needs to be set to on in php.ini. I get this error no matter what I do with osCommerce. Note that I do have it set form off to on in php.ini and have saved and restarted Apache just to make sure... The php.ini file resides in the Windows root directory, but I have also copied a version of it to c:\php\ and it is also changed.

 

Any ideas are appreciated.

 

Thank you,

 

Akira

Vger

♥Vger

Posted
Posted

All that is required to make osCommerce work in PHP 5 was to rem out $this on line 31 of upload.php. Your heading refers to php5, but then you go on to talk about MySQL5. If you are trying to use both PHP5 and MySQL 5, then the simple answer is to downgrade.

 

Vger

Akira71

Akira71

Posted
  • Author
Posted
All that is required to make osCommerce work in PHP 5 was to rem out $this on line 31 of upload.php.  Your heading refers to php5, but then you go on to talk about MySQL5.  If you are trying to use both PHP5 and MySQL 5, then the simple answer is to downgrade.

 

Vger

 

 

Ack! That was a mistake. I am not using MySQL 5, but rather 4.1.7 nt-max. I am using PHP5 though and I did make that change in the ADMIN module, upload.php. I finally got the PHP.INI to take with the new information. Not sure why the service restarts and the two reboots did not do the trick before.

 

I am now through the install piece to a certain point. After setting up the database information, it connects to the database and a form half pops up on the screen saying

INSTALL DATABASE and then a sub item then the HTML is cut off. Nothing. I am doing this in FireFox as my browser so I am not sure if that makes a difference.

 

However it does seem to have some error in the install process and then just hangs.

 

Again, thank you all for the support.

Akira71

Akira71

Posted
  • Author
Posted
Ack! That was a mistake. I am not using MySQL 5, but rather 4.1.7 nt-max. I am using PHP5 though and I did make that change in the ADMIN module, upload.php.  I finally got the PHP.INI to take with the new information. Not sure why the service restarts and the two reboots did not do the trick before.

 

I am now through the install piece to a certain point. After setting up the database information, it connects to the database and a form half pops up on the screen saying

INSTALL DATABASE and then a sub item then the HTML is cut off. Nothing. I am doing this in FireFox as my browser so I am not sure if that makes a difference.

 

However it does seem to have some error in the install process and then just hangs.

 

Again, thank you all for the support.

 

 

Wish I could edit my post instead of a new post here.. but I thought I would include the HTTP source to see what I was referring to above. It might help, it might not..

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>

<title>osCommerce :// Open Source E-Commerce Solutions</title>

<meta name="ROBOTS" content="NOFOLLOW">

<link rel="stylesheet" type="text/css" href="templates/main_page/stylesheet.css">

<script language="javascript" src="templates/main_page/javascript.js"></script>

</head>

<body text="#000000" bgcolor="#ffffff" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0">

<!-- header //-->

<p> </p>

<table width="75%" cellpadding="0" cellspacing="0" border="0" align="center">
 <tr>
   <td><table width="100%" cellpadding="0" cellspacing="0" border="0">
     <tr>
       <td width="1%"><img src="images/layout/topleft.gif" width="15" height="15" border="0"></td>
       <td width="98%" background="images/layout/topmid.gif"><img src="images/pixel_trans.gif" width="15" height="15" border="0"></td>

       <td width="1%"><img src="images/layout/topright.gif" width="15" height="15" border="0"></td>
     </tr>
     <tr>
       <td width="1%" background="images/layout/midleft.gif"><img src="images/pixel_trans.gif" width="15" height="15" border="0"></td>
       <td width="98%" bgcolor="ffffff"><table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
         <tr>
           <td><img src="images/layout/left_header_curve.gif"></td>
           <td width="100%" background="images/layout/middle_header_filler.gif"> </td>
           <td align="right" valign="top"><img src="images/oscommerce.gif" border="0" alt="osCommerce"></td>

         </tr>
       </table>
<!-- header_eof //-->

<table cellspacing="0" cellpadding="0" width="100%" border="0" align="center">
 <tr>
   <td width="5%" class="leftColumn" valign="top" background="images/layout/left_column_background.gif"><img src="images/layout/left_column_top.gif"></td>
   <td width="85%" valign="top">
<p class="pageTitle">New Installation</p>

<p><b>osCommerce Configuration</b></p>

Akira71

Akira71

Posted
  • Author
Posted
Did you set up a blank database via phpMyAdmin?

 

Vger

 

 

Actually I went ahead and manually created the oscommerce dagtabase in MySQL and ran the SQL script.

 

I found out the place it is dieing is in install_7.php at this function

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

 

Basically the connection to the datbase is failed and I do not see an error anywhere. Not in any log I can get too. I am a bit perplexed by this as the database and permissions are good. I am doing this in Windows, PHP5 and MySQL 4.1.7 nt-max. Not sure if that helps nail it more. MySQL Admin and MySQL Query apps work fine as well as the CLI interface to MySQL.

 

I am not really aware of PHPMyADMIN. I am an old school C++ programmer and essentially this is my first PHP project to get up and running.

 

Thanks for the help :-)

Akira71

Akira71

Posted
  • Author
Posted
Actually I went ahead and manually created the oscommerce dagtabase in MySQL and ran the SQL script.

 

I found out the place it is dieing is in install_7.php at this function

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

 

Basically the connection to the datbase is failed and I do not see an error anywhere. Not in any log I can get too. I am a bit perplexed by this as the database and permissions are good. I am doing this in Windows, PHP5 and MySQL 4.1.7 nt-max. Not sure if that helps nail it more. MySQL Admin and MySQL Query apps work fine as well as the CLI interface to MySQL.

 

I am not really aware of PHPMyADMIN. I am an old school C++ programmer and essentially this is my first PHP project to get up and running.

 

Thanks for the help :-)

 

 

Another note, if this helps, is that I am using PHP5 so I did make sure that php_mysqli.dll was enabled in Apache. I was reading elsewhere on the forum that this might be an issue. It is definately having a problem connecting to MySQL though. I did check to make sure that I can connect to MySQL through other means at the DB seems fine. I am still trying to find help with this if anyone can lead me further down the right path.

 

Thank you very much.

 

Akira

evilnside

evilnside

Posted
Posted
Another note, if this helps, is that I am using PHP5 so I did make sure that php_mysqli.dll was enabled in Apache. I was reading elsewhere on the forum that this might be an issue. It is definately having a problem connecting to MySQL though. I did check to make sure that I can connect to MySQL through other means at the DB  seems fine. I am still trying to find help with this if anyone can lead me further down the right path.

 

Thank you  very much.

 

Akira

 

I might be wrong. But I don't believe I am. Having mysqli enabled is your problem. mysqli is a whole different interface to accessing mySQL then the normal way. As far as I know (and from my own testing) having mysqli enabled disables the ability to use the old way.

 

I suggest you comment out php_mysqli.dll, and restart the server, I believe this will fix your problem.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...