|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
109 |
[In-Portal CMS] Data Management |
bug report |
always |
2009-07-08 05:06 |
2009-10-03 07:56 |
|
|
Reporter:
|
alex |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
critical |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
4.3.9 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.0.0 |
|
|
Reference:
|
|
|
Change Log Message:
|
|
|
Estimate Points:
|
0 |
|
|
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. |
|
Steps To Reproduce:
|
|
|
Additional Information:
|
|
| Relationships | |
|
Attached Files:
|
|
|
|
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 |
|