Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Report not working when Date parameter is included

Report not working when Date parameter is included 2 months 1 week ago #76267

  • arnold.m@sothebysrealtynh.co.za
  • arnold.m@sothebysrealtynh.co.za's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
We are using version 7.10.11 which was updated about 6 weeks ago. We have created some reports for data in the Leads module, which included Date parameters, and until a few days ago these reports worked well.

We we doing some changes to the Accounts module, and imported some data into it. We then deleted the data, and selected 'Restore' for the Accounts module in order to return it to its default state. after the 'Restore', the map address fields for the Accounts module were missing. We then also discovered that the reports which contained date parameters no longer worked. If we edit the report, remove the parameter selections for Date, and then enter dates for the report query and save the report, the results for the report appear correctly, but as soon as we select the 'parameter' check box under the conditions tab for the report, the report yields no results.

Our default date format (under the user settings) is 2010-12-23. The default date setting that appears under Admin - System Settings is '%c' as shown in the attached screen dump.

Our log indicates a high volume of the following types of errors:

Thu Jan 10 12:41:45 2019 [429299][1ab15a12-6207-3878-d9cb-5bbf0e10fed3][ERROR] fromUser: Conversion of from user format Y-m-d h:ia failed
Thu Jan 10 12:41:45 2019 [429299][1ab15a12-6207-3878-d9cb-5bbf0e10fed3][ERROR] fromUser: Conversion of 2019-01-10 12:40:16 from user format Y-m-d h:ia failed
Thu Jan 10 12:41:45 2019 [429299][1ab15a12-6207-3878-d9cb-5bbf0e10fed3][ERROR] fromUser: Conversion of from user format Y-m-d h:ia failed
Thu Jan 10 12:41:45 2019 [429299][1ab15a12-6207-3878-d9cb-5bbf0e10fed3][ERROR] fromUser: Conversion of 2019-01-10 12:40:16 from user format Y-m-d h:ia failed

Any assistance or guidance regarding the above would be greatly appreciated.
Attachments:
The administrator has disabled public write access.

Report not working when Date parameter is included 2 months 1 week ago #76304

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 9303
  • Thank you received: 1403
  • Karma: 337
Have you checked GitHub for any Issues related to this? I can't look right now, but I'm pretty sure I saw some that looked just like this. There might be fixes there.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.099 seconds
Powered by Kunena Forum