Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

To All PHP Upgrades


Guest

Recommended Posts

To all of you that servers been upgraded, save yourself some time by saving all info: in your sql in doc. not backup db. do a clean install and replace info: manually. I found out the hard way. you cannot uses your old db tables. Their is a bright side. I learn all about db,sql and tables.

Link to comment
Share on other sites

really, the oscommerce is working correctly if the PHP language was correctly installed on server. Personally I have tested the oscommerce on linux with the following specs:

PHP 4.x & MySQL 3.x

PHP 4.x & MySQL 4.x

PHP 5.0.0 - contains 1500+ bugs any normal application will be incorrectly working under sort of version of php.

PHP 5.1.x & MySQL 4.x

PHP 5.1.x & MySQL 5.x

PHP 5.2.x & MySQL 4.x

PHP 5.2.x & MySQL 5.x

PHP 5.2.x & MySQL 6.x (beta)

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

There's no reason to do this if the only change is that php has been updated.

 

Jack

 

Well it didn't work for me I had upgrad to oscommerce-2.2rc2a everthing was working except I could not add new customers I would get the error object_info.php linr 17 & 18 when I went to review customers info: I tried empty the table that didn't work I tried everything and it just didn't work so I ended up saving all info and did a clean install. If you could tell me what I did or didn't do would be great..I had look all over the forum and found a lot of others was having the same problem but I didn't see any resolution...

Thanks for the feedback

Link to comment
Share on other sites

Well it didn't work for me I had upgrad to oscommerce-2.2rc2a everthing was working except I could not add new customers I would get the error object_info.php linr 17 & 18 when I went to review customers info: I tried empty the table that didn't work I tried everything and it just didn't work so I ended up saving all info and did a clean install. If you could tell me what I did or didn't do would be great..I had look all over the forum and found a lot of others was having the same problem but I didn't see any resolution...

Thanks for the feedback

It's difficult to say but in your first post you mentioned the server being updated while here you say the shop was updated. Those are two completely differetn things, as I'm sure you are aware. If you didn't update or replace your database when you upgraded the shop, that might have been the reason for the problem.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

It's difficult to say but in your first post you mentioned the server being updated while here you say the shop was updated. Those are two completely differetn things, as I'm sure you are aware. If you didn't update or replace your database when you upgraded the shop, that might have been the reason for the problem.

 

Jack

 

Hello Jack

Thanks for the reply, yes I did leave out something ,I realize it after I replayed. Ibeen working on this for 3 days. what I ment to say, my server PHP was upgraded and I upgraded my osCommerce to oscommerce-2.2rc2a from oscommerce-2.2 thats when I had the problem with the customers.php error [reset] object_info.php line 17 and 18. the tables is not the same I guess. I save all files in my sql as doc files and reinstall oscommerce.sql and replace all files manual it is a lot of work. what do you think?

Link to comment
Share on other sites

The customers table fails in a new install if the server is running MySQL5 in strict mode e.g. STRICT_ALL_TABLES or STRICT_TRANS_TABLES.

 

DROP TABLE IF EXISTS customers;

CREATE TABLE customers (

customers_id int NOT NULL auto_increment,

customers_gender char(1) NOT NULL,

customers_firstname varchar(32) NOT NULL,

customers_lastname varchar(32) NOT NULL,

customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,

customers_email_address varchar(96) NOT NULL,

customers_default_address_id int,

customers_telephone varchar(32) NOT NULL,

customers_fax varchar(32),

customers_password varchar(40) NOT NULL,

customers_newsletter char(1),

PRIMARY KEY (customers_id),

KEY idx_customers_email_address (customers_email_address)

);

 

The bold line is the problem, if you change the code to the following in the catalog/install oscommerce.sql it will work.

 

 

DROP TABLE IF EXISTS customers;
CREATE TABLE customers (
  customers_id int NOT NULL auto_increment,
  customers_gender char(1) NOT NULL,
  customers_firstname varchar(32) NOT NULL,
  customers_lastname varchar(32) NOT NULL,
  customers_dob datetime DEFAULT NOT NULL,
  customers_email_address varchar(96) NOT NULL,
  customers_default_address_id int,
  customers_telephone varchar(32) NOT NULL,
  customers_fax varchar(32),
  customers_password varchar(40) NOT NULL,
  customers_newsletter char(1),
  PRIMARY KEY (customers_id),
  KEY idx_customers_email_address (customers_email_address)
);

Link to comment
Share on other sites

If trying to upload an old DB to a strict MySQL server try the following: -

 

Open the SQL file

 

Click at the very top of the file then ..

 

Find . .

 

 default '0000-00-00 00:00:00'

 

Replace with nothing (literal meaning of nothing)

 

Click back at the very top of the file then ..

 

Find ..

 

'0000-00-00 00:00:00'

 

Replace with ..

 

NULL

 

Save the SQL as a totally different name e.g. sql_converted.sql or something.

 

This has worked for me with a number of customers.

Link to comment
Share on other sites

Hello Jack

Thanks for the reply, yes I did leave out something ,I realize it after I replayed. Ibeen working on this for 3 days. what I ment to say, my server PHP was upgraded and I upgraded my osCommerce to oscommerce-2.2rc2a from oscommerce-2.2 thats when I had the problem with the customers.php error [reset] object_info.php line 17 and 18. the tables is not the same I guess. I save all files in my sql as doc files and reinstall oscommerce.sql and replace all files manual it is a lot of work. what do you think?

If you look at the update file for RC2, it explains how to update the database. That method should be used.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

If you look at the update file for RC2, it explains how to update the database. That method should be used.

 

Jack

 

Ok, Thanks Everyone

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...