Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Confused about versions


Recommended Posts

I'm confused about the different versions of OSC and I can't find anywhere that explains them.

(can someone explain this or point me somewhere — this info shouldn't be this hard to find, imo)


What exactly is the difference between RC1, RC2, MS2? (and what order do they go in?)


I am (apparently) using OSC 2.2 MS2 (060817) on BlueHost.com. (they supply it with an auto-install through their 'cpanel')


The store worked fine. And then I got a template from templatemonster.com and installed it.


Then my admin got an error:


1146 - Table 'DB.administrators' doesn't exist

select id from administrators limit 1



I tracked the error down in the forums and "fixed it" (maybe) by doing the following SQL:


CREATE TABLE administrators (

id int NOT NULL auto_increment,

user_name varchar(32) binary NOT NULL,

user_password varchar(40) NOT NULL,




So now I can log into admin, but I think there are potentially greater issues. (like someone mentioned that the column lengths in the configuration table increased from 64 to 255 — and there could be missing values in that table — I also couldn't find anywhere that listed these, which should also be part of some documentation somewhere, including what was added/changed for each OSC version)


From what people were saying, it sounded like the template is for a different version of OSC than the one I am using.


So I did some checking and my snapshot of the original installation shows this:



Line 32 : define('PROJECT_VERSION', 'osCommerce 2.2-MS2');


and the new template shows this:



Line 37 : define('PROJECT_VERSION', 'osCommerce Online Merchant v2.2 RC1');


So I'm guessing this probably isn't a good thing. Who knows what else is broken.


I could probably install the newer version (IS IT a newer version??? or is my template for an older version??) instead of using the one my server company provides. That would be a pain. (I tried templatemonster.com online chat support and the idiot there wasn't any help; he just told me to enter a support ticket, and then I kind of figured it out for myself, up to this point)


I also looked for some info about what the differences are between the different versions, like the databases (names and structures, etc.), and such, and couldn't find that, either. That should also be provided as standard documentation. (if it isn't, why not? how hard would that be??)


Here is our site info in case it makes a difference:


Apache version: 2.2.6 (Unix)

PHP version: 5.2.5

MySQL version: 5.0.45

Architecture: x86_64

Operating system: Linux


Any help, hints, suggestions, etc., much appreciated.

Link to comment
Share on other sites

In order (only going back to 2.1 - older than that is pointless);


osCommerce 2.1

osCommerce 2.2

osCommerce 2.2 MS1

osCommerce 2.2 MS2

osCommerce 2.2 MS2 060817 (is MS2 with a few bug fixes and other updates)

osCommerce 2.2 RC1 (is 060817 with a whole load of new stuff, including new database entries etc)

osCommerce 2.2 RC2 (is RC1 with a few bug fixes)

osCommerce 2.2 RC2a (is RC2 with a couple of bug fixes).


The RC releases are (hopefully!) eventually building up to a release of osCommerce v3


In the meantime, osCommerce has changed it's name to "osCommerce Online Merchant" rather than just osCommerce - but everyone still knows it as osCommerce.


So your site is 4 iterations old, your template is 3 iterations old. Hence they don't play together nicely.

Link to comment
Share on other sites


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

  • Create New...