Extensions issueshttps://lab.civicrm.org/groups/extensions/-/issues2023-04-12T11:02:38Zhttps://lab.civicrm.org/extensions/firewall/-/issues/19What does it do?2023-04-12T11:02:38ZStefanWhat does it do?Hey there,
I installed the firewall and it seems to work => doesn't make any trouble.
However, I wonder what it actually does.
I use wordpress and have security plugins installed. So, my wordpress backend and therefore civi should be ...Hey there,
I installed the firewall and it seems to work => doesn't make any trouble.
However, I wonder what it actually does.
I use wordpress and have security plugins installed. So, my wordpress backend and therefore civi should be fine, at least I thought that way.
Is this firewall then about API4 or civi event forms e.x.?
Another line in the description would be nice, at least for me^^https://lab.civicrm.org/extensions/firewall/-/issues/20Blocking Stripe payments in certain circumstances2023-04-12T11:01:59Zdarren.woodsBlocking Stripe payments in certain circumstancesI've seen the old issues here: https://lab.civicrm.org/extensions/firewall/-/issues/3 and: https://lab.civicrm.org/extensions/stripe/-/issues/179
Unfortunately this has been reoccuring with v1.5.1 of Firewall and Stripe 6.7.1 Civi 5.45....I've seen the old issues here: https://lab.civicrm.org/extensions/firewall/-/issues/3 and: https://lab.civicrm.org/extensions/stripe/-/issues/179
Unfortunately this has been reoccuring with v1.5.1 of Firewall and Stripe 6.7.1 Civi 5.45.5
We've had to disable the extension for the users affected to be able to submit payments.
Screenshot of frontend error below (400 in console same as issues above).
![image__4_](/uploads/f21d5f83bf3608fb451de652d7dd56f2/image__4_.png)https://lab.civicrm.org/extensions/firewall/-/issues/21How do I know it's working?2023-04-12T11:01:27ZrobbrandtHow do I know it's working?I installed this on a site experiencing heavy fraud use with Stripe. It comes in waves. Lately there's been minimal activity. But it's only been a week.
Is there a way to see what IP addresses have been blocked? Do they show up in th...I installed this on a site experiencing heavy fraud use with Stripe. It comes in waves. Lately there's been minimal activity. But it's only been a week.
Is there a way to see what IP addresses have been blocked? Do they show up in the configuration page or are they stored elsewhere?https://lab.civicrm.org/extensions/firewall/-/issues/29multiple captcha forms2023-04-12T11:00:13Zjonty17multiple captcha formsHi, I am having a problem with duplicate captcha forms appearing on contribution pages when I enable this in the firewall module. Those forms are not being submitted successfully.
Many thanks
JonHi, I am having a problem with duplicate captcha forms appearing on contribution pages when I enable this in the firewall module. Those forms are not being submitted successfully.
Many thanks
Jonhttps://lab.civicrm.org/extensions/firewall/-/issues/27cv ext:enable firewall is failing2023-04-12T10:58:54Zhescocv ext:enable firewall is failingHow would I resolve this, please?
```
[error_message] => API error: is not of type String on OptionValue.create( entity name crm-search-display-table)
```How would I resolve this, please?
```
[error_message] => API error: is not of type String on OptionValue.create( entity name crm-search-display-table)
```https://lab.civicrm.org/extensions/cronplus/-/issues/7Update dragonmantank/cron-expression dependency2023-04-12T08:26:06ZSandor SemseyUpdate dragonmantank/cron-expression dependencyThe dependency `dragonmantank/cron-expression` version is specified strictly as 3.1.0:
```
"dragonmantank/cron-expression": "3.1.0"
```
Is there any reason why is it locked on that version? I haven't found any info about it in the repo....The dependency `dragonmantank/cron-expression` version is specified strictly as 3.1.0:
```
"dragonmantank/cron-expression": "3.1.0"
```
Is there any reason why is it locked on that version? I haven't found any info about it in the repo.
Would it be possible to use `^3.1`?
It would allow updates.https://lab.civicrm.org/extensions/eventics/-/issues/9Doesn't do anything?2023-04-11T12:21:17ZmikantchapDoesn't do anything?Have cleared caches but no links on admin page.
Tried using civicrm/admin/event/eventics but nothing?Have cleared caches but no links on admin page.
Tried using civicrm/admin/event/eventics but nothing?https://lab.civicrm.org/extensions/fieldconditions/-/issues/1Merge with fieldlookup?2023-04-10T13:32:06ZJonGoldMerge with fieldlookup?Hi Mathieu - I was wondering if it made sense to merge fieldlookup with this? It'd be nice to have one extension for hierarchical field lookups.
The two use cases fieldlookup handles that I'm not sure this does are:
* hierarchical look...Hi Mathieu - I was wondering if it made sense to merge fieldlookup with this? It'd be nice to have one extension for hierarchical field lookups.
The two use cases fieldlookup handles that I'm not sure this does are:
* hierarchical lookups on multi-record custom fields;
* "reverse" lookups - by putting in the more fine-grained option, it picks the coarser-grained one (e.g. when filling in a postcode fills in a state/province and city automatically).https://lab.civicrm.org/extensions/stripe/-/issues/422The resource ID cannot be null or whitespace / Stripe Contact update failed: ...2023-04-09T22:19:43Zben_fairlessThe resource ID cannot be null or whitespace / Stripe Contact update failed: Expected one PaymentProcessor but found 0WordPress 6.1, CiviCRM 5.59.3, PHP 7.4, Stripe 6.8.1, Stripe API version 2022-11-15
After upgrading, I am now seeing these errors when attempting to make a payment using the test page:
> Mar 21 02:13:26 [error] Stripe Payment Error: Th...WordPress 6.1, CiviCRM 5.59.3, PHP 7.4, Stripe 6.8.1, Stripe API version 2022-11-15
After upgrading, I am now seeing these errors when attempting to make a payment using the test page:
> Mar 21 02:13:26 [error] Stripe Payment Error: The resource ID cannot be null or whitespace.
>
> Mar 21 02:13:26 [error] Stripe Contact update failed: Expected one PaymentProcessor but found 0
>
> Mar 21 02:13:28 [debug] StripeNo matching contributions for event evt_XXXXXXXXXXXXXX
Payment is taken from the customer and a Pending (Incomplete) transaction is created in CiviCRM.
The only events being sent over from Stripe to CiviCRM are a charge.succeeded and a charge.captured event. Both events appear in the Payment Processor Webhooks page.
Is there something I'm missing here?https://lab.civicrm.org/extensions/civiexportexcel/-/issues/17Excel export creates date instead of real data2023-04-07T11:27:57ZMariaVExcel export creates date instead of real dataWhen I export a report with a column that includes data like "1-2", "1-3" and so on, the Excel shows a date, i.e. "2022-02-01", "2022-03-01".
Tested with Microsoft Office and LibreOffice Calc
Workaround: Created Report with SearchKit
...When I export a report with a column that includes data like "1-2", "1-3" and so on, the Excel shows a date, i.e. "2022-02-01", "2022-03-01".
Tested with Microsoft Office and LibreOffice Calc
Workaround: Created Report with SearchKit
CiviCRM v. 5.47.4 (it worked on an earlier version)
Export to Excel v. 2.3https://lab.civicrm.org/extensions/action-provider/-/issues/35Event: get by ID does not return the ID of a custom contact reference field2023-04-06T07:52:25Zsimon.hermannEvent: get by ID does not return the ID of a custom contact reference fieldHaving an event, with a custom field, which is a contact reference, I would expect to get back the civicrm ID of the contact, if I use the action 'Event: Get By ID'. Looking at the code of `AbstractGetSingleAction`, from which `GetEvent`...Having an event, with a custom field, which is a contact reference, I would expect to get back the civicrm ID of the contact, if I use the action 'Event: Get By ID'. Looking at the code of `AbstractGetSingleAction`, from which `GetEvent` derives, this seems to be taken care of by the function `normalizeCustomValues`.
However, if I set up a simple Formprocessor, which takes an event id and show me the results of GetEvent, I find that the contact name is returned instead of the id.
I am not sure, which part of `normalizeCustomValues` does not work. If anyone has an idea, I would be happy to provide a merge request myself.
I tested this on CiviCRM 5.58.1 and ActionProvider 1.121https://lab.civicrm.org/extensions/stripe/-/issues/241Incorrect Form Validation for checkboxes on profiles2023-04-04T23:23:10ZkcristianoIncorrect Form Validation for checkboxes on profilesCivi 5.28.3, mjwshared 0.8.1, firewall 1.1, sweetalert 1.3
Event Form, profile in use has 1 required field of type checkbox.
If you check none - validation error- OK, Check All - no validation error.
Check 1 Validation error an...Civi 5.28.3, mjwshared 0.8.1, firewall 1.1, sweetalert 1.3
Event Form, profile in use has 1 required field of type checkbox.
If you check none - validation error- OK, Check All - no validation error.
Check 1 Validation error and stripe highlights all options not check and sweetalert displays a message to complete required fields. Switch to another processor, no issues.
![image](/uploads/f00a71ef4337c3f9e31dfb5d99ea7148/image.png)6.5https://lab.civicrm.org/extensions/dataprocessor/-/issues/99Unknown column 'is_test' in 'on clause'2023-04-01T14:04:39ZedvanleeuwenUnknown column 'is_test' in 'on clause'After updating to 1.40, there is a problem with the is_test test in an inner join clause.
Query in 1.39:
SELECT
DISTINCT `lid_lidmaatschap_Lidmaatschap`.`covs_lid_37` AS `lidmaatschap_covs_lid`,
`lid_lidmaatschap`.`membership_type_i...After updating to 1.40, there is a problem with the is_test test in an inner join clause.
Query in 1.39:
SELECT
DISTINCT `lid_lidmaatschap_Lidmaatschap`.`covs_lid_37` AS `lidmaatschap_covs_lid`,
`lid_lidmaatschap`.`membership_type_id` AS `lidmaatschapstype_id`,
`lid_lidmaatschap`.`join_date` AS `lid_sinds`,
`lid`.`id` AS `nummer_contact_id`,
`lid`.`id` AS `nummer_contact_name`,
`lid`.`last_name` AS `achternaam`,
`lid`.`middle_name` AS `tussenvoegsel`,
`lid`.`nick_name` AS `roepnaam`,
`lid`.`first_name` AS `voornaam`,
`lid`.`gender_id` AS `contactnummer`,
`lid`.`birth_date` AS `geboortedatum`,
`lid_Financi_n`.`rekeningnummer_28` AS `financi_n_rekeningnummer`,
`lid_KNVB_gegevens`.`knvb_nummer_29` AS `knvb_gegevens_knvb_nummer`,
`adres`.`street_address` AS `straat_en_huisnummer`,
`adres`.`postal_code` AS `postcode`,
`adres`.`city` AS `plaats`,
`e_mail`.`email` AS `e_mail`,
`telefoon`.`phone` AS `telefoon`,
`telefoon_2`.`phone` AS `telefoon_2`
FROM `civicrm_contact` `contact`
INNER JOIN `civicrm_membership` `la_lidmaatschap` ON `la_lidmaatschap`.`contact_id` = `contact`.`id`
LEFT JOIN `civicrm_value_lidmaatschap_11` `la_lidmaatschap_Lidmaatschap` ON `la_lidmaatschap`.`id` = `la_lidmaatschap_Lidmaatschap`.`entity_id`
INNER JOIN `civicrm_value_lidmaatschap_11` `lid_lidmaatschap_Lidmaatschap` ON `lid_lidmaatschap_Lidmaatschap`.`groep_38` = `la_lidmaatschap_Lidmaatschap`.`groep_38`
LEFT JOIN `civicrm_membership` `lid_lidmaatschap` ON `lid_lidmaatschap`.`id` = `lid_lidmaatschap_Lidmaatschap`.`entity_id`
AND (`lid_lidmaatschap`.`is_test` = 0)
INNER JOIN `civicrm_contact` `lid` ON `lid`.`id` = `lid_lidmaatschap`.`contact_id`
LEFT JOIN `civicrm_value_financi_n_5` `lid_Financi_n` ON `lid`.`id` = `lid_Financi_n`.`entity_id`
LEFT JOIN `civicrm_value_knvb_gegevens_6` `lid_KNVB_gegevens` ON `lid`.`id` = `lid_KNVB_gegevens`.`entity_id`
LEFT JOIN `civicrm_address` `adres` ON `adres`.`contact_id` = `lid`.`id`
AND (`adres`.`is_primary` = 1)
LEFT JOIN `civicrm_email` `e_mail` ON `e_mail`.`contact_id` = `lid`.`id`
AND (`e_mail`.`is_primary` = 1)
LEFT JOIN `civicrm_phone` `telefoon` ON `telefoon`.`contact_id` = `lid`.`id`
AND (`telefoon`.`is_primary` = 1
AND `telefoon`.`phone_type_id` IN (1))
LEFT JOIN `civicrm_phone` `telefoon_2` ON `telefoon_2`.`contact_id` = `lid`.`id`
AND (`telefoon_2`.`is_primary` = 1
AND `telefoon_2`.`phone_type_id` IN (2))
WHERE 1
AND `contact`.`is_deleted` = 0
AND `contact`.`id` IN (2)
AND `la_lidmaatschap`.`is_test` = 0
AND `lid_lidmaatschap`.`contact_id` IN (
SELECT
`civicrm_contact_lid_lidmaatschap_contact_id`.`id`
FROM `civicrm_contact` `civicrm_contact_lid_lidmaatschap_contact_id`
WHERE 1
AND ( 1 )
)
AND `lid_lidmaatschap`.`status_id` IN (1, 2, 8)
AND `lid`.`is_deleted` = 0
ORDER BY `achternaam` ASC, `tussenvoegsel` ASC, `voornaam` ASC
LIMIT 0, 50
Query in 1.40:
SELECT DISTINCT `lid_lidmaatschap_Lidmaatschap`.`covs_lid_37` AS `lidmaatschap_covs_lid`, `lid_lidmaatschap`.`membership_type_id` AS `lidmaatschapstype_id`, `lid_lidmaatschap`.`join_date` AS `lid_sinds`, `lid`.`id` AS `nummer_contact_id`, `lid`.`id` AS `nummer_contact_name`, `lid`.`last_name` AS `achternaam`, `lid`.`middle_name` AS `tussenvoegsel`, `lid`.`nick_name` AS `roepnaam`, `lid`.`first_name` AS `voornaam`, `lid`.`gender_id` AS `contactnummer`, `lid`.`birth_date` AS `geboortedatum`, `lid_Financi_n`.`rekeningnummer_28` AS `financi_n_rekeningnummer`, `lid_KNVB_gegevens`.`knvb_nummer_29` AS `knvb_gegevens_knvb_nummer`, `adres`.`street_address` AS `straat_en_huisnummer`, `adres`.`postal_code` AS `postcode`, `adres`.`city` AS `plaats`, `e_mail`.`email` AS `e_mail`, `telefoon`.`phone` AS `telefoon`, `telefoon_2`.`phone` AS `telefoon_2` FROM `civicrm_contact` `contact` INNER JOIN `civicrm_membership` `la_lidmaatschap` ON `la_lidmaatschap`.`contact_id` = `contact`.`id` AND (`la_lidmaatschap`.`is_test` = 0) LEFT JOIN `civicrm_value_lidmaatschap_11` `la_lidmaatschap_Lidmaatschap` ON `la_lidmaatschap`.`id` = `la_lidmaatschap_Lidmaatschap`.`entity_id` INNER JOIN `civicrm_value_lidmaatschap_11` `lid_lidmaatschap_Lidmaatschap` ON `lid_lidmaatschap_Lidmaatschap`.`groep_38` = `la_lidmaatschap_Lidmaatschap`.`groep_38` AND (`lid_lidmaatschap`.`is_test` = 0) LEFT JOIN `civicrm_membership` `lid_lidmaatschap` ON `lid_lidmaatschap`.`id` = `lid_lidmaatschap_Lidmaatschap`.`entity_id` INNER JOIN `civicrm_contact` `lid` ON `lid`.`id` = `lid_lidmaatschap`.`contact_id` AND (`lid`.`is_deleted` = 0) LEFT JOIN `civicrm_value_financi_n_5` `lid_Financi_n` ON `lid`.`id` = `lid_Financi_n`.`entity_id` LEFT JOIN `civicrm_value_knvb_gegevens_6` `lid_KNVB_gegevens` ON `lid`.`id` = `lid_KNVB_gegevens`.`entity_id` LEFT JOIN `civicrm_address` `adres` ON `adres`.`contact_id` = `lid`.`id` AND (`adres`.`is_primary` = 1) LEFT JOIN `civicrm_email` `e_mail` ON `e_mail`.`contact_id` = `lid`.`id` AND (`e_mail`.`is_primary` = 1) LEFT JOIN `civicrm_phone` `telefoon` ON `telefoon`.`contact_id` = `lid`.`id` AND (`telefoon`.`is_primary` = 1 AND `telefoon`.`phone_type_id` IN (1)) LEFT JOIN `civicrm_phone` `telefoon_2` ON `telefoon_2`.`contact_id` = `lid`.`id` AND (`telefoon_2`.`is_primary` = 1 AND `telefoon_2`.`phone_type_id` IN (2)) WHERE 1 AND ((`lid_lidmaatschap_Lidmaatschap`.`groep_38` IN (
SELECT `civicrm_group_contact_lid_lidmaatschap_Lidmaatschap_Groep`.`contact_id`
FROM `civicrm_group_contact` `civicrm_group_contact_lid_lidmaatschap_Lidmaatschap_Groep`
WHERE 1 AND `civicrm_group_contact_lid_lidmaatschap_Lidmaatschap_Groep`.`status` = 'Added' AND `civicrm_group_contact_lid_lidmaatschap_Lidmaatschap_Groep`.`group_id` IN ('2')
)) OR (`lid_lidmaatschap_Lidmaatschap`.`groep_38` IN (
SELECT `civicrm_group_contact_cache_lid_lidmaatschap_Lidmaatschap_Groep`.`contact_id`
FROM `civicrm_group_contact_cache` `civicrm_group_contact_cache_lid_lidmaatschap_Lidmaatschap_Groep`
WHERE 1 AND `civicrm_group_contact_cache_lid_lidmaatschap_Lidmaatschap_Groep`.`group_id` IN ('2')
))) AND `lid_lidmaatschap`.`contact_id` IN (
SELECT `civicrm_contact_lid_lidmaatschap_contact_id`.`id`
FROM `civicrm_contact` `civicrm_contact_lid_lidmaatschap_contact_id`
WHERE 1 AND ( 1 )
) AND `lid_lidmaatschap`.`status_id` IN (1, 2, 8) ORDER BY `achternaam` ASC, `tussenvoegsel` ASC, `voornaam` ASChttps://lab.civicrm.org/extensions/finsburypark/-/issues/16SK/FB Radio buttons2023-03-30T14:24:31Zaydunsaidan.saunders@squiffle.ukSK/FB Radio buttonsFor a a Yes/No radio button the tick/cross confirmation boxes are on top so you can't actually change it:
![image](/uploads/4c1f1253f313b056c0b3ef764f596d6c/image.png)
That's a simple Contact search with 'Is Deceased' column in the tab...For a a Yes/No radio button the tick/cross confirmation boxes are on top so you can't actually change it:
![image](/uploads/4c1f1253f313b056c0b3ef764f596d6c/image.png)
That's a simple Contact search with 'Is Deceased' column in the table and in-place edit enabled.https://lab.civicrm.org/extensions/finsburypark/-/issues/15New Mosaico template screen - padding2023-03-30T13:19:25Zaydunsaidan.saunders@squiffle.ukNew Mosaico template screen - padding![image](/uploads/c809b17163527d84471ec3a8c42e668d/image.png)![image](/uploads/c809b17163527d84471ec3a8c42e668d/image.png)https://lab.civicrm.org/extensions/chasse/-/issues/33Array and string offset access syntax with curly braces is deprecated2023-03-24T11:46:54ZRichArray and string offset access syntax with curly braces is deprecated*Created by: magnolia61*
Could it be that this extension needs a little update?
The dblog is filled with notices:
`Deprecated function: Array and string offset access syntax with curly braces is deprecated in require_once() (line 3 of ...*Created by: magnolia61*
Could it be that this extension needs a little update?
The dblog is filled with notices:
`Deprecated function: Array and string offset access syntax with curly braces is deprecated in require_once() (line 3 of /var/www/vhosts/xyz/web/sites/all/modules/civicrm_extensions/chasse/chasse.php).
`
- CiviCRM: 5.48
- CMS: Drupal 7.89
- PHP: 7.4.28 (fpm-fcgi)
- Database: 10.5.15-MariaDB-0+deb11u1 engine: InnoDB 10 row format: Dynamic
- Webserver: Apache/2.4.53 (Debian)
- OS: Linuxhttps://lab.civicrm.org/extensions/mosaicomsgtpl/-/issues/27Header and Footer no longer available as settings2023-03-24T11:41:13ZStoobHeader and Footer no longer available as settingsI noticed after upgrading to Mosaico 2.9 that the Header and Footer tab is gone.
While this may make sense that Mosaico users don't need a footer, if the footer is default enabled for _traditional_ mailings, and they use both mailing sy...I noticed after upgrading to Mosaico 2.9 that the Header and Footer tab is gone.
While this may make sense that Mosaico users don't need a footer, if the footer is default enabled for _traditional_ mailings, and they use both mailing systems in parallel there is no longer way to remove the footer for Mosaico mailings.
![fot](/uploads/74da7d85aac7b762758115b206579f64/fot.png)https://lab.civicrm.org/extensions/pelf/-/issues/1Compatibility with civiCase extension?2023-03-24T11:40:01ZlarnoultCompatibility with civiCase extension?Hello,
What a promising extension!
I wanted to give it a try, unfortunately it is not (yet) compatible with [the compucorp civiCase extension ](https://github.com/compucorp/uk.co.compucorp.civicase)
Is this something that could happen i...Hello,
What a promising extension!
I wanted to give it a try, unfortunately it is not (yet) compatible with [the compucorp civiCase extension ](https://github.com/compucorp/uk.co.compucorp.civicase)
Is this something that could happen in the future?
Thx,https://lab.civicrm.org/extensions/pelf/-/issues/3Cannot see other Case Status2023-03-24T11:39:28Zct_itsupportCannot see other Case StatusHi Rich - I am sure this is probably something daft in my config/setup but when I go to change the Case Status in your tutorial, I did not see any of the new Case Statuses defined in the setup. I am just using the self generating Grant ...Hi Rich - I am sure this is probably something daft in my config/setup but when I go to change the Case Status in your tutorial, I did not see any of the new Case Statuses defined in the setup. I am just using the self generating Grant Application case type you present in the pelf-setup. Looking at the civicrm_option_value table, I could see that the Filter column was set to NULL for these new Statuses. Changing these to 0 sorted the issue. As I say, it may well be my setup, but just letting you know!https://lab.civicrm.org/extensions/gocardless/-/issues/131Support template contributions2023-03-24T09:27:24ZRichSupport template contributionsNormally when a subsequent payment comes in, the repeattransaction API will copy the previous Contribution to generate the new one.
A template contribution can be provided instead as the source of the data for the new Contribution, and ...Normally when a subsequent payment comes in, the repeattransaction API will copy the previous Contribution to generate the new one.
A template contribution can be provided instead as the source of the data for the new Contribution, and this solves several problems, such as allowing the template to be changed between payments.
Another driver for this feature is https://lab.civicrm.org/extensions/upgraderecur/-/issues/1RichRich