Anonymous | Login | Signup for a new account | 2024-04-19 06:30 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Viewing Issue Advanced Details [ Jump to Notes ] [ Wiki ] | [ View Simple ] [ 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 | Platform | |||
Status | closed | OS | |||||
OS Version | |||||||
ETA | none | Fixed in Version | 5.0.0 | Product Version | 4.3.9 | ||
Target Version | 5.0.0 | Product Build | |||||
Time Estimate | No 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. |
||||||
Steps To Reproduce | |||||||
Additional Information | |||||||
Tags | No tags attached. | ||||||
Reference | |||||||
Change Log Message | |||||||
Estimate Points | 0 | ||||||
Attached Files | |||||||
|
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(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 |
(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 |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |