MySQL 5

[Guest]

This is mostly intended as an FYI.

 

So far, OSCommerce has been working great for us (www.dhraonline.com). We don't use it for much, but it certainly saved me from having to write a store myself. And the integration with PayPal has saved us from having to process credit cards ourselves.

 

Recently, we move the site to a new server that uses PHP5 and MySQL 5. There were a few troubles that popped up. First, OSC requires register_globals to be active. I enabled this var for the catalog directory, which solved that problem.

 

The admin section had its own problems. First, in catalog/admin/includes/classes/upload.php, there is a statement, "$this = null", which doesn't work. Changing this to "unset($this)" solved this problem. It may exist in other places. Also, it seems that MySQL5 is less forgiving of certain syntax things. Specifically, it needs parens around FROM elements that contain JOINS, expecially LEFT or RIGHT JOINS. Putting in those parens solved *that* problem. So, in the little testing that I've done thus far (our web programmer found the problems and fixed them), OSC now seems to work OK with PHP5 and MySQL5.

 

Neal

[Guest]

(Message edit failed (you don't have permission...), so here's the pertinent server/version info:

Server OS: Linux 2.6.9

Database: MySQL 5.0.27

HTTP Server: Apache/2.2.3 (Unix)

OSC Version: osCommerce 2.2-MS2

 

Neal

[Frank Heinen]

Did you update your version of osC to the latest edition (osC V2.2 ms2 060817)? In this version these problems should be solved.

[Guest]

Did you update your version of osC to the latest edition (osC V2.2 ms2 060817)? In this version these problems should be solved.

 

Yer on top o' this, too! Cool!