| Anonymous | Login | Signup for a new account | 2023-05-31 05:58 CDT | |
| Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
| 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 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. |
||||||
| Additional Information | |||||||
| Tags | No tags attached. | ||||||
| Reference | |||||||
| Change Log Message | |||||||
| Estimate Points | 0 | ||||||
| Attached Files | |||||||
|
|
|||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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. |
|
Notes |
| 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 ] | ||
| Related Changesets |
|
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 | |
|
Issue History |
| Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic
In-Portal Open Source CMS |
Copyright © 2000 - 2009 MantisBT Group
 |