2003(huh?), Versions, Bug and Fixes

[thebruce]

Hi,

 

Versions:

 

I downloaded the standard MS2.2 package. This package has not been updated since 2003? Can that be true?

 

I many posts that pertain to known bug fixes. Can it be that none of these bug fixes have been incorporated into the base distribution since 2003?

 

I had a problem inporting the oscommerce.sql file in the base distribution:mostly invalid value in the date field, I don't think mySQL 5 likes "now()" in an imported field.

 

(aside: Am I not suppoed to be using mySQL 5? There does not seem to any baseline software environment stated, that is, PHP version version such and such, mySQL version such and such, that establishes a known environment baseline against which the baseline distribution will work.)

 

I have found sql table defintions (that are supposed to be the standard ones) posted here on the forum that do not correspond to the definition in the oscommerce.sql file. For example:

 

http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=725620

 

describes the order table; this is not the code in the oscommerce.sql file. Where did it come from?

 

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

 

After many hours I have finally got oso up and running (sort of) on Win XP sp2. However, all is not well. There are many errors, such as:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'

 

Now, this is an error that has been reported before. No resolution. (Perhaps a mySQL 5 problem.) btw, running this query in phpMyAdmin posts the same error. ( big surprise, huh?)

 

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

I hear alot about CSV this and that, which is supposed to be the repository for all know bug fixes. (Is that true?) However, it's not on-line( yeah, i read the post.)

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

 

This post is a bit rambling, but, my point is: Where is a current, stable, consistant and relatively bug-free version of this software? - the standard download is certainly not it. I've already spent approx. 25 hours on getting this up and have little to show for it.

 

Thanks for your time,

Bruce Pearson

Bakersfield, CA