I spent some time finding more info about the text-wrap CSS option, but I can't find a browser that supports it. Within CiviCRM there is a reference within the monaco-editor (bower_components) for CSS white-space (cssMode.js & cssWorker.js). So far I can tell it is only in the Blog.tpl. Not a big deal, but maybe remove or replace it.
I just ran into the same issue. I have the latest version 5.47.1 on Wordpress 5.9.2. When I went to the demo site it was working fine, so I dove into the code, and when you do a fresh install I am pretty sure the note_date will not have the 'NOT NULL' portion. After I allowed the field to be null in my DB, it works correctly, populating the current timestamp, when left blank. The error is in FiveFortyThree.php at the end of the file: setNoteDateFieldNotNull() where they add the NOT NULL portion.
Run this to fix it:
ALTER TABLE "civicrm_note" CHANGE "note_date" "note_date" TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT "Date attached to the note";
Found the create table in civicrm.mysql file:
CREATE TABLE "civicrm_note" (
"id" int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Note ID',
"entity_table" varchar(64) NOT NULL COMMENT 'Name of table where item being referenced is stored.',
"entity_id" int unsigned NOT NULL COMMENT 'Foreign key to the referenced item.',
"note" text COMMENT 'Note and/or Comment.',
"contact_id" int unsigned COMMENT 'FK to Contact ID creator',
"note_date" timestamp DEFAULT CURRENT_TIMESTAMP COMMENT 'Date attached to the note',
"created_date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'When the note was created.',
"modified_date" timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was this note last modified/edited',
"subject" varchar(255) COMMENT 'subject of note description',
"privacy" varchar(255) COMMENT 'Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)',
PRIMARY KEY ("id"),
INDEX "index_entity"(entity_table, entity_id),
CONSTRAINT FK_civicrm_note_contact_id FOREIGN KEY ("contact_id") REFERENCES "civicrm_contact"("id") ON DELETE SET NULL
)
ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
When you have Contact and then Case as data sources, use default values, join "Client :: Contact ID" with "Contact :: Contact ID". Create fields Contact ID, Case ID, Case Type ID, create output, Contact type. Execute it.
It fails on the is_deleted field. I think "_case.is_deleted
" in the ON case should be "case.is_deleted
".
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT COUNT(*) AS count FROM (SELECT DISTINCT `contact`.`id` AS `contact_id`, `case`.`id` AS `case_id`, `case`.`case_type_id` AS `case_type_id` FROM `civicrm_contact` `contact` INNER JOIN (SELECT `_case`.`id` AS `id`, `_case`.`case_type_id` AS `case_type_id`, `_case`.`subject` AS `subject`, `_case`.`start_date` AS `start_date`, `_case`.`end_date` AS `end_date`, `_case`.`details` AS `details`, `_case`.`status_id` AS `status_id`, `_case`.`is_deleted` AS `is_deleted`, `_case`.`created_date` AS `created_date`, `_case`.`modified_date` AS `modified_date`, `_case_contact`.`case_id` AS `case_contact_case_id`, `_case_contact`.`contact_id` AS `case_contact_contact_id` FROM `civicrm_case` `_case` INNER JOIN `civicrm_case_contact` `_case_contact` ON `_case`.`id` = `_case_contact`.`case_id` WHERE 1 AND `_case`.`is_deleted` = 0 ) `case` ON `case`.`case_contact_contact_id` = `contact`.`id` AND (`_case`.`is_deleted` = 0) WHERE 1 AND `contact`.`is_deleted` = 0 ORDER BY `contact_id` ASC) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column '_case.is_deleted' in 'on clause']
[type] => DB_Error
[user_info] => SELECT COUNT(*) AS count FROM (SELECT DISTINCT `contact`.`id` AS `contact_id`, `case`.`id` AS `case_id`, `case`.`case_type_id` AS `case_type_id` FROM `civicrm_contact` `contact` INNER JOIN (SELECT `_case`.`id` AS `id`, `_case`.`case_type_id` AS `case_type_id`, `_case`.`subject` AS `subject`, `_case`.`start_date` AS `start_date`, `_case`.`end_date` AS `end_date`, `_case`.`details` AS `details`, `_case`.`status_id` AS `status_id`, `_case`.`is_deleted` AS `is_deleted`, `_case`.`created_date` AS `created_date`, `_case`.`modified_date` AS `modified_date`, `_case_contact`.`case_id` AS `case_contact_case_id`, `_case_contact`.`contact_id` AS `case_contact_contact_id` FROM `civicrm_case` `_case` INNER JOIN `civicrm_case_contact` `_case_contact` ON `_case`.`id` = `_case_contact`.`case_id` WHERE 1 AND `_case`.`is_deleted` = 0 ) `case` ON `case`.`case_contact_contact_id` = `contact`.`id` AND (`_case`.`is_deleted` = 0) WHERE 1 AND `contact`.`is_deleted` = 0 ORDER BY `contact_id` ASC) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column '_case.is_deleted' in 'on clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT COUNT(*) AS count FROM (SELECT DISTINCT `contact`.`id` AS `contact_id`, `case`.`id` AS `case_id`, `case`.`case_type_id` AS `case_type_id` FROM `civicrm_contact` `contact` INNER JOIN (SELECT `_case`.`id` AS `id`, `_case`.`case_type_id` AS `case_type_id`, `_case`.`subject` AS `subject`, `_case`.`start_date` AS `start_date`, `_case`.`end_date` AS `end_date`, `_case`.`details` AS `details`, `_case`.`status_id` AS `status_id`, `_case`.`is_deleted` AS `is_deleted`, `_case`.`created_date` AS `created_date`, `_case`.`modified_date` AS `modified_date`, `_case_contact`.`case_id` AS `case_contact_case_id`, `_case_contact`.`contact_id` AS `case_contact_contact_id` FROM `civicrm_case` `_case` INNER JOIN `civicrm_case_contact` `_case_contact` ON `_case`.`id` = `_case_contact`.`case_id` WHERE 1 AND `_case`.`is_deleted` = 0 ) `case` ON `case`.`case_contact_contact_id` = `contact`.`id` AND (`_case`.`is_deleted` = 0) WHERE 1 AND `contact`.`is_deleted` = 0 ORDER BY `contact_id` ASC) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column '_case.is_deleted' in 'on clause']"]
)