mirror of
https://github.com/SuiteCRM/SuiteCRM.git
synced 2026-03-02 19:16:58 -05:00
AOR: Custom fields can only be used when "normal" fields used before #941
Labels
No labels
Area: API
Area: Campaigns
Area: Cases
Area: Clean Up
Area: Clean Up: Performance
Area: Dashlets
Area: Databases
Area: Developer Tools
Area: Elasticsearch
Area: Elasticsearch
Area: Emails
Area: Emails:Campaigns
Area: Emails:Cases
Area: Emails:Compose
Area: Emails:Config
Area: Emails:Templates
Area: Environment
Area: Installation
Area: Language
Area: Mobile
Area: Module
Area: PDFs
Area: PHP8
Area: Reports
Area: Studio
Area: Styling
Area: Upgrading
Area: Workflow
Area:Activity Stream
Area:Calls
Area:Import
Area:Projects
Area:Search
Area:Surveys
Area:Themes
Area:Users
Branch:Hotfix
Good First Issue
Hacktoberfest
Help Wanted
PR:Community Contribution
PR:Type:Enhancement
Priority:Critical
Priority:Important
Priority:Moderate
Severity: Major
Severity: Minor
Severity: Moderate
Status: Requires Code Review
Status: Requires Updates
Status: Stale
Status: Team Investigating
Status:Assessed
Status:Fix Proposed
Status:Needs Assessed
Status:Requires Automated Tests
Type: Bug
Type:Deprecated
Type:Discussion
Type:Duplicate
Type:Invalid
Type:Question
Type:Suggestion
Type:Suggestion
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/SuiteCRM-SuiteCRM#941
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @gunnicom on GitHub (Jun 21, 2016).
If you create a report and want to display a custom field from a module thats related, you can only report this field if another "normal" field from the module is used before the custom field.
If the sequence is different ("normal" field after custom field ) you get an error in the suitecrm.log like:
Tue Jun 21 11:47:06 2016 [70849][1][FATAL] Query Failed: SELECT SUM(
opportunities_cstm.leistung_c) AS 'Leistung_[kW]0',opportunities:assigned_user_link_cstm.team_c AS 'team1',opportunities:assigned_user_link.sugar_login AS 'Is_SuiteCRM_User2',opportunities:assigned_user_link_cstm.team_c AS 'team3' FROMopportunitiesLEFT JOINopportunities_cstmopportunities_cstmONopportunities.id =opportunities_cstm.id_c LEFT JOIN usersopportunities:assigned_user_linkONopportunities.assigned_user_id=opportunities:assigned_user_link.id ANDopportunities:assigned_user_link.deleted=0LEFT JOIN
assigned_user_link_cstmopportunities:assigned_user_link_cstmONopportunities:assigned_user_link.id =opportunities:assigned_user_link_cstm.id_c WHERE (opportunities.sales_stage = 'Closed Won' ANDopportunities.opportunity_type != 'Existing Business' ANDopportunities.date_closed BETWEEN "2016-06-01 00:00:00" AND "2016-07-01 00:00:00" ANDopportunities_cstm.leistung_c > '0' ) AND opportunities.deleted = 0 GROUP BYopportunities:assigned_user_link_cstm.team_c,opportunities:assigned_user_link_cstm.team_c,opportunities:assigned_user_link.sugar_login LIMIT 0,20: MySQL error 1146: Table 'suitecrm_de.assigned_user_link_cstm' doesn't exist@shogunpol commented on GitHub (Aug 19, 2016):
@gunnicom I am unable to replicate this in the latest version of SuiteCRM(7.7.1), can you confirm is that issue is solved in your instance.
@gunnicom commented on GitHub (Aug 30, 2016):
Bug still exists in Suite 7.7.3
@gunnicom commented on GitHub (Aug 30, 2016):
To replicate:
Custom fields added via Studio:
team in Users, label "Team"
leistung in Opportunities, label "Leistung [kW]"
Report: Field leistung as SUM, field team group_by over assigned_user
Error in log:
Tue Aug 30 11:48:07 2016 [124854][1][FATAL] Query Failed: SELECT count(*) c FROM (SELECT SUM(
opportunities_cstm.leistung_c) AS 'Leistung_[kW]0',opportunities:assigned_user_link_cstm.team_c AS 'team1',opportunities.id AS opportunities_id FROMopportunitiesLEFT JOINopportunities_cstmopportunities_cstmONopportunities.id =opportunities_cstm.id_c LEFT JOIN usersopportunities:assigned_user_linkONopportunities.assigned_user_id=opportunities:assigned_user_link.id ANDopportunities:assigned_user_link.deleted=0LEFT JOIN
assigned_user_link_cstmopportunities:assigned_user_link_cstmONopportunities:assigned_user_link.id =opportunities:assigned_user_link_cstm.id_c WHERE opportunities.deleted = 0 GROUP BYopportunities:assigned_user_link_cstm.team_c) as n: MySQL error 1146: Table 'suitecrm_de.assigned_user_link_cstm' doesn't existWhen i now add the username from the assigned_user before the team_c field it shows a list.
If this field is after the team_c field the error occurs again.
@shogunpol commented on GitHub (Aug 30, 2016):
The issue has been tested on recent version of SuiteCRM(7.7.3), and it appear, i assign the bug label.
@gunnicom , thanks for raise this issue.
@jbrveen commented on GitHub (Jan 3, 2020):
Please reopen. In 7.11.10 this bug reappears.
@pgorod commented on GitHub (Jan 6, 2020):
Which one(s) from #1635, #8334, #8404 is it better to keep open? Probably not all of them are needed.