Skip to content

Instantly share code, notes, and snippets.

View chumkui's full-sized avatar

chumkui

2 followers · 2 following
View GitHub Profile
@chumkui
chumkui / WebformImageHandler.php
Created May 29, 2024 17:50
CiviCRM form with handler to reproduce the Contact Filter bug
<?php
namespace Drupal\webform_image_handler\Plugin\WebformHandler;
use Drupal\Core\Form\FormStateInterface;
use Drupal\webform\Plugin\WebformHandlerBase;
use Drupal\webform\WebformSubmissionInterface;
/**
* Form submission handler.
@chumkui
chumkui / mysqli_real_escape_string_error.txt
Created January 10, 2024 16:31
mysqli_real_escape_string error
#0 /var/www/html/vendor/pear/db/DB/mysqli.php(872): mysqli_real_escape_string(Object(mysqli), Array)
#1 /var/www/html/vendor/civicrm/civicrm-packages/DB/DataObject.php(1851): DB_mysqli->escapeSimple(Array)
#2 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(2225): DB_DataObject->escape(Array)
#3 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(2951): CRM_Core_DAO::escapeString(Array)
#4 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Api3SelectQuery.php(99): CRM_Core_DAO::createSQLFilter('a.name', Array)
#5 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/SelectQuery.php(114): Civi\API\Api3SelectQuery->buildWhereClause()
#6 /var/www/html/vendor/civicrm/civicrm-core/api/v3/utils.php(1258): Civi\API\SelectQuery->run()
#7 /var/www/html/vendor/civicrm/civicrm-core/api/v3/CaseType.php(47): _civicrm_api3_basic_get('CRM_Case_BAO_Ca...', Array)
#8 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_case_type_get(Array)
#9 /var/www/html/vendo
@chumkui
chumkui / drush12.composer.json
Created October 10, 2023 14:36
Drush 12 composer.json
{
"name": "drupal/recommended-project",
"description": "Project template for Drupal projects with a relocated document root",
"type": "project",
"license": "GPL-2.0-or-later",
"homepage": "https://www.drupal.org/project/drupal",
"support": {
"docs": "https://www.drupal.org/docs/user_guide/en/index.html",
"chat": "https://www.drupal.org/node/314178"
},
@chumkui
chumkui / deprecated_function_unserialize.txt
Last active July 21, 2023 16:07
Deprecated function warning
Deprecated function: unserialize(): Passing null to parameter #1 ($data) of type string is deprecated in CRM_CivirulesPostTrigger_Activity->setTriggerParams() (line 8 of /var/www/html/web/sites/default/files/civicrm/ext/civirules/CRM/CivirulesPostTrigger/Activity.php)
#0 /var/www/html/web/core/includes/bootstrap.inc(347): _drupal_error_handler_real(8192, 'unserialize(): ...', '/var/www/html/w...', 8)
#1 [internal function]: _drupal_error_handler(8192, 'unserialize(): ...', '/var/www/html/w...', 8)
#2 /var/www/html/web/sites/default/files/civicrm/ext/civirules/CRM/CivirulesPostTrigger/Activity.php(8): unserialize(NULL)
#3 /var/www/html/web/sites/default/files/civicrm/ext/civirules/CRM/Civirules/BAO/Rule.php(170): CRM_CivirulesPostTrigger_Activity->setTriggerParams(NULL)
#4 /var/www/html/web/sites/default/files/civicrm/ext/civirules/CRM/Civirules/Trigger/Post.php(104): CRM_Civirules_BAO_Rule::findRulesByObjectNameAndOp('Activity', 'create')
#5 /var/www/html/web/sites/default/files/civicrm/ext/civirules/civirul
@chumkui
chumkui / searchkit_activities_issue.sql
Created July 20, 2023 12:39
SearchKit SQL for Activities issue
SELECT `a`.`id` AS `id`, GROUP_CONCAT(DISTINCT `Case_CaseContact_Contact_01`.`display_name` SEPARATOR "") AS `GROUP_CONCAT_Case_CaseContact_Contact_01_display_name`, `a`.`subject` AS `subject`, GROUP_CONCAT(`Case_CaseActivity_Activity_01`.`subject` SEPARATOR "") AS `GROUP_CONCAT_Case_CaseActivity_Activity_01_subject`, GROUP_CONCAT(`Case_CaseContact_Contact_01`.`id` SEPARATOR "") AS `GROUP_CONCAT_Case_CaseContact_Contact_01_id`, GROUP_CONCAT(`Case_CaseActivity_Activity_01`.`id` SEPARATOR "") AS `GROUP_CONCAT_Case_CaseActivity_Activity_01_id`, GROUP_CONCAT(DISTINCT `Food_Discovery_1`.`session_date_332` SEPARATOR "") AS `GROUP_CONCAT_Case_CaseActivity_Activity_01_Food_Discovery_Session_date`
FROM civicrm_case a
LEFT JOIN (SELECT `b`.`case_id`,`b`.`contact_id`,`c`.`id`,`c`.`contact_type`,`c`.`external_identifier`,`c`.`display_name`,`c`.`organization_name`,`c`.`contact_sub_type`,`c`.`first_name`,`c`.`middle_name`,`c`.`last_name`,`c`.`do_not_email`,`c`.`do_not_phone`,`c`.`do_not_mail`,`c`.`do_not_sms`,`c`.`do_
@chumkui
chumkui / searchkit_activities_issue.json
Created July 20, 2023 12:36
SearchKit API Calls
{
"version": 4,
"select": [
"id",
"GROUP_CONCAT(DISTINCT Case_CaseContact_Contact_01.display_name) AS GROUP_CONCAT_Case_CaseContact_Contact_01_display_name",
"subject",
"GROUP_CONCAT(Case_CaseActivity_Activity_01.subject) AS GROUP_CONCAT_Case_CaseActivity_Activity_01_subject",
"GROUP_CONCAT(Case_CaseContact_Contact_01.id) AS GROUP_CONCAT_Case_CaseContact_Contact_01_id",
"GROUP_CONCAT(Case_CaseActivity_Activity_01.id) AS GROUP_CONCAT_Case_CaseActivity_Activity_01_id",
"GROUP_CONCAT(DISTINCT Case_CaseActivity_Activity_01.Food_Discovery.Session_date) AS GROUP_CONCAT_Case_CaseActivity_Activity_01_Food_Discovery_Session_date"
@chumkui
chumkui / civicrm_error.log
Created January 15, 2023 16:54
Error on trying to add data to a field
$Fatal Error Details = array:3 [ "message" => "DB Error: unknown error" "code" => null "exception" => PEAR_Exception {#1694 #cause: DB_Error {#1707 +error_message_prefix: "" +mode: 16 +level: 1024 +code: -1 +message: "DB Error: unknown error" +userinfo: "INSERT INTO civicrm_value_interview_15 ( `interview_date_9`,`interviewer1_134`,`entity_id` ) VALUES ( 20230109000000,'\x013\x01',62569 ) ON DUPLICATE KEY UPDATE `interview_date_9` = 20230109000000,`interviewer1_134` = '\x013\x01' [nativecode=1366 ** Incorrect integer value: '\x013\x01' for column 'interviewer1_134' at row 1]" +backtrace: array:29 [ 0 => array:6 [ "file" => "/var/www/html/sites/all/modules/civicrm/vendor/pear/db/DB.php" "line" => 997 "function" => "__construct" "class" => "PEAR_Error" "type" => "->" "args" => array:5 [ 0 => "DB Error: unknown error" 1 => -1 2 => 16 3 => array:2 [ 0 => "CRM_Core_Error" 1 => "exceptionHandler" ] 4 => "INSERT INTO civicrm_value_interview_15 ( `interview_date_9`,`interviewer1_134`,`entity_id` ) VALUES ( 2023010900
@chumkui
chumkui / vagrant_up_error.txt
Created August 5, 2020 18:14
Console output for Vagrant up vagrant-hostsupdater error
$ vagrant up
==> drupalvm: [vagrant-hostsupdater] Removing hosts
==> drupalvm: Attempting graceful shutdown of VM...
==> drupalvm: Checking if box 'geerlingguy/drupal-vm' version '2.0.9' is up to date...
==> drupalvm: Clearing any previously set forwarded ports...
==> drupalvm: Clearing any previously set network interfaces...
==> drupalvm: Preparing network interfaces based on configuration...
drupalvm: Adapter 1: nat
drupalvm: Adapter 2: hostonly
==> drupalvm: Forwarding ports...
@chumkui
chumkui / sp_BackupDatabases
Created July 17, 2018 14:13
Amendment to Microsofts sp_BackupDatabases to correct for longer file paths
--// Copyright � Microsoft Corporation. All Rights Reserved.
--// This code released under the terms of the
--// Microsoft Public License (MS-PL, http://opensource.org/licenses/ms-pl.html.)
USE [master]
GO
@chumkui
chumkui / gist:88f3b62c79ac00920078ac65da03f0b2
Created December 20, 2017 13:52
Console output for Apache Install error log
PS C:\Users\mstevens\Documents\dev\drupalprojects\cepr2.dev> vagrant up --provision
Bringing machine 'cepr2vm' up with 'virtualbox' provider...
==> cepr2vm: Checking if box 'geerlingguy/ubuntu1404' is up to date...
==> cepr2vm: [vagrant-hostsupdater] Checking for host entries
==> cepr2vm: [vagrant-hostsupdater] found entry for: 192.168.100.78 portal.cepr.dev
==> cepr2vm: [vagrant-hostsupdater] found entry for: 192.168.100.78 www.portal.cepr.dev
==> cepr2vm: [vagrant-hostsupdater] found entry for: 192.168.100.78 adminer.portal.cepr.dev
==> cepr2vm: [vagrant-hostsupdater] found entry for: 192.168.100.78 xhprof.portal.cepr.dev
==> cepr2vm: [vagrant-hostsupdater] found entry for: 192.168.100.78 pimpmylog.portal.cepr.dev
==> cepr2vm: [vagrant-hostsupdater] found entry for: 192.168.100.78 dashboard.portal.cepr.dev