In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details Jump to Notes ] Wiki ] View Advanced ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000109 [In-Portal CMS] Data Management bug report always 2009-07-08 05:06 2009-10-03 07:56
Reporter alex View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority critical Resolution fixed Fixed in Version 5.0.0
Status closed Product Version 4.3.9 Target Version 5.0.0
Time EstimateNo estimate
Summary 0000109: Error in database query syntax, when table aliases are used in "option_key_field" or "option_title_field" field options
Description In some case we need to use JOIN in database queries, that are used in "options_sql" option for field. In many cases there is a possibility, that fields, selected in "option_key_field"/"option_title_field" options will be present in more, then one table, used in JOIN. This will result in database query error.

I propose to strip table alias (if any) when building field options list.
Additional Information
Tags No tags attached.
Reference
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0000120)
alex (manager)
2009-07-08 05:09

Fix committed to RC branch. Commit Message:

Fixes 0000109: Error in database query syntax, when table aliases are used in "option_key_field" or "option_title_field" field options
User avatar (0000603)
administrator (administrator)
2009-10-03 07:56

Closing issues from 5.0.0 version, because version was already released.

- Related Changesets
In-Portal CMS: RC r11894
Timestamp: 2009-07-08 05:09:51
Author: alex
Details ] Diff ]
Fixes 0000109: Error in database query syntax, when table aliases are used in "option_key_field" or "option_title_field" field options
mod - /in-portal/branches/RC/core/kernel/kbase.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2009-10-03 07:56 administrator Note Added: 0000603
2009-10-03 07:56 administrator Status resolved => closed
2009-10-03 07:44 administrator Priority normal => critical
2009-07-08 05:10 alex Fixed in Version => 5.0.0
2009-07-08 05:10 alex Target Version => 5.0.0
2009-07-08 05:09 alex Note Added: 0000120
2009-07-08 05:09 alex Status active => resolved
2009-07-08 05:09 alex Resolution open => fixed
2009-07-08 05:09 alex Assigned To => alex
2009-07-08 05:09 alex Changeset attached RC r11894
2009-07-08 05:06 alex New Issue



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker