Member Matrix results in DB Error: no such field
Just posting here to see if people are having success with the Member Matrix report. On CiviCRM 5.35.2 multisite and WP 5.7. Report Plus 2.4.4. Here is the error log.
There was a CiviCRM error at Libertarian Party.
Date: 2021-08-10T20:10:51-04:00
***ERROR***
message: DB Error: no such field
code:
exception: PEAR_Exception Object
(
[cause:protected] => DB_Error Object
(
[error_message_prefix] =>
[mode] => 16
[level] => 1024
[code] => -19
[message] => DB Error: no such field
[userinfo] => SELECT SQL_CALC_FOUND_ROWS COUNT(*) as 'value', DATE_FORMAT(membership_civireport.membership_start_date, '%Y-%u') as 'col', membership_civireport.status_id as 'row'
FROM civicrm_contact contact_civireport
INNER JOIN civicrm_membership membership_civireport
ON contact_civireport.id = membership_civireport.contact_id
WHERE ( contact_civireport.is_deceased = 0 ) AND ( contact_civireport.is_deleted = 0 ) AND ( membership_civireport.membership_type_id IN (49, 78, 50, 51, 52, 53, 54, 64, 65, 67) ) AND ( membership_civireport.status_id IN (1, 2, 4) ) GROUP BY col, row ORDER BY row, col LIMIT 0, 999999 [nativecode=1054 ** Unknown column 'membership_civireport.membership_start_date' in 'field list']
[backtrace] => Array
(
[0] => Array
(
[file] => /var/www/example/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php
[line] => 997
[function] => __construct
[class] => PEAR_Error
[type] => ->
[args] => Array
(
[0] => DB Error: no such field
[1] => -19
[2] => 16
[3] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[4] =>...
***LAST ERROR***
Array
(
[type] => 2
[message] => fopen(api/v3/OptionValue/Getoptions.php): failed to open stream: No such file or directory
[file] => /var/www/example/wp-content/plugins/civicrm/civicrm/CRM/Utils/File.php
[line] => 417
)
***SESSION***
CiviCRM: Array
(
[ufID] => 1114
[userID] => 20
[CRM_Utils_Recent] => Array
(
[0] => Array
(
[title] => Andy Burns
[url] => /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview&reset=1&cid=20
[id] => 300
[type] => Individual
[contact_id] => 300
[contactName] => Andy Burns
[subtype] => LeaderLeaderLeader
[isDeleted] =>
[image_url] =>
[edit_url] => /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fadd&reset=1&action=update&cid=20
[delete_url] =>
)
[1] => Array
(
[title] => Test Contact
[url] => /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview&reset=1&cid=444715
[id] => 444715
[type] => Individual
[contact_id] => 444715
[contactName] => Test Contact
[subtype] =>
[isDeleted] =>
[image_url] => https://example.org/civicrm_icons/individual.png
[edit_url] => /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fadd&reset=1&action=update&cid=444715
[delete_url] => /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview%2Fdelete&reset=1&delete=1&cid=444715
)
[2] => Array
(
[title] => Test Contact (Attendee - 2020 State Convention)
[url] => /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview%2Fparticipant&action=view&reset=1&id=12026&cid=444715&context=home
[id] => 12026
[type] => ...
_CRM_Activity_Form_ActivityLinks__container:Array
(
[defaults] => Array
(
)
[constants] => Array
(
)
[values] => Array
(
[ActivityLinks] => Array
(
)
)
[valid] => Array
(
[ActivityLinks] =>
)
)
_CRM_Activity_Form_ActivityFilter__container:Array
(
[defaults] => Array
(
)
[constants] => Array
(
)
[values] => Array
(
[ActivityFilter] => Array
(
)
)
[valid] => Array
(
[ActivityFilter] =>
)
)
_CRM_Contribute_Form_Search__container:Array
(
[defaults] => Array
(
)
[constants] => Array
(
)
[values] => Array
(
[Search] => Array
(
)
)
[valid] => Array
(
[Search] =>
)
)
_CRM_Reportplus_Form_Member_Matrix_CRMReportplusFormMemberMatrix1cc0sh56jy9wgsoscgkwkc4wswoo8sk4kswckcgc44004g80w8_9142_container:Array
(
[defaults] => Array
(
)
[constants] => Array
(
)
[values] => Array
(
[Matrix] => Array
(
[charts] =>
[qfKey] => CRMReportplusFormMemberMatrix1cc0sh56jy9wgsoscgkwkc4wswoo8sk4kswckcgc44004g80w8_9142
[entryURL] => https://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Freport%2Fmember%2Fmatrix&page=CiviCRM&reset=1
[fields] => Array
(
[count] => 1
)
[sort_name_op] => has
[sort_name_value] =>
[source_op] => has
[source_value] =>
[id_min] =>
[id_max] =>
[id_op] => lte
[id_value] =>
[gender_id_op] => in
[gender_id_value] => Array
(
)
[birth_date_relative] =>
[birth_date_from] =>
[birth_date_to] =>
[contact_type_op] => in
[contact_type_value] => Array
(
)
[contact_sub_type_op] => in
[contact_sub_type_value] => Array
(
)
[modified_date_relative] =>
[modified_date_from] =>
[modified_date_to] =>
[is_deceased_op] => eq
[is_deceased_value] => 0
[do_not_email_op] => eq
[do_not_email_value] =>
[do_not_phone_op] => eq
[do_not_phone_value] =>
[do_not_mail_op] => eq
[do_not_mail_value] =>
[do_not...