To All PHP Upgrades

[Guest]

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.

[web-project]

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)

[Jack_mcs]

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

 

Jack

[Guest]

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

[Jack_mcs]

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

[Guest]

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?

[♥FWR Media]

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)
);

[♥FWR Media]

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.

[Jack_mcs]

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

[Guest]

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