http://sourceforge.net/tracker/index.php?func=detail&aid=1700327&group_id=169037&atid=848821

[ 1700327 ] Creloaded6.2 onward solution
       (?)  
Submitted By: 
Jan Verlaan - jverlaan  Date Submitted: 
2007-04-13 22:35  
     Last Updated By: 
calimeross - Comment added  Date Last Updated: 
2007-04-14 15:16  
Number of Comments: 
2  Number of Attachments: 
0  
Data Type: (?) 
 Bugs Feature Requests Patches    
Category: (?) 
 None Access Control Accounts Batch Entry Budgets Calendar Contacts Documents Global Processes Help Files Import / Export Installation Networking Open Link Item Other Plugin Aanmaningen Plugin DrillDown Plugin Dutch OBaangifte Plugin HandyTools Plugin OSCommerce Plugin Other Plugin SQL Browser Plugin XML-Auditfile Point of Sale Reconsiliation Repeating Entries Repeating Invoices Reports Setup Preferences Setup System Parameters Stock Update Ledger (admin)  Group: (?) 
 None 01. Received 02. Previewed 03. In Design 04. In Process 05. Review 06. Deliver 07. Solved 08. Waiting (admin)  
Assigned To: (?) 
 None alextexel cdgo delphidreamer jverlaan kenlyle (admin)  Priority: (?) 
1 - Lowest2345 - Medium6789 - Highest  
Status: (?) 
 Open Closed Deleted Pending  Resolution: (?) 
 Accepted Duplicate Fixed Invalid Later None Out of Date Postponed Rejected Remind Wont Fix Works For Me  
Summary: (?) 
  Private: (?) 
  
SITUATION IDENTIFIED IN: 1.0.2.13 Plugin osCommerce

REPRODUCTION ENVIRONMENT: WindowsXP and Creloaded 6.2

PROBLEM DESCRIPTION:
From Creloaded 6.2 version onwards some tables and fields are changed due
to added functionality in the product options area. e.g.
products_options_text table is added.
Tables and fields are added and fields are shifted between tables.
Due to this the query in ZQOptions.txt needs to be changed for Creloaded
6.2 and upwards versions.

Replace
Code:
SELECT products_options_id,
products_options_name
FROM <@PREFIX>products_options where language_id =%s

with
Code:
SELECT a.products_options_id, b.products_options_name
FROM <@PREFIX>products_options a, <@PREFIX>products_options_text b
WHERE b.products_options_text_id = a.products_options_id
AND b.language_id = %s

and the plugin will work now.

SPECIFIC PARAMETER SETUP:none

STEPS TO BE FOLLOWED:

OBSERVED RESULT: error of unknown field products_options_name

EXPECTED RESULT: working link with Creloaded6.2

ADDITIONAL COMMENTS:
I am not requesting a change of the query as this will influence the other
osCommerce shops. But it would be great if a note in the query directory
would be made with this querychange for Creloaded 
