OSCommerce Product Manager

OSCommerce Product Manager for Windows

FS#295 - MySQL 5 compatibility

Attached to Project: OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 13 November 2005, 03:39 GMT-5
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 23 January 2006, 07:38 GMT-5
Task Type Bug Report
Category Backend / Core
Status Closed
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Low
Priority Normal
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No


In the forums, an user reported:

"Due to changes in MySQL 5 the syntax of the SQL statements (probably the initial selects in main.pas) need to be adjusted."

"Please see the changes in catalog/index.php and the changelog of the latest osC release (from yesterday) for details and for hints about fixing the problem. There was also another change in catalog/advanced_search_result.php because of MySQL 5 incompatibilities."

"In the current state it is not possible to fetch the products data with oscpm."

Pending to verify, check causes, test fixes, and deploy.

Severity is Major. Priority is medium-low.
This task depends upon

Closed by  Mario A. Valdez-Ramirez (mvaldez)
Monday, 23 January 2006, 07:38 GMT-5
Reason for closing:  
Comment by Mario A. Valdez-Ramirez (mvaldez) - Saturday, 19 November 2005, 16:47 GMT-5
Pending to install testing server.
Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 23 January 2006, 07:38 GMT-5

The issue was with LEFT JOIN clauses in some SELECTs. Since 5.0.1x-something when LEFT JOINing the not all tables in the FROM clause will be joined with the table specified in the LEFT JOIN, but only the closer one. To join them all, they must be grouped in parenthesis.

Se that's what we did. Seems to work ok.


This bug is not related with the change in the authentication protocol since 4.1, even though it applies also to MySQL 5. That is Bug #144.