WebTechKitchen; Your Web Technology Kitchen, contact us to create, or maintain your websites and other digital properties.

Fix sql dump, Unknown collation: utf8mb4_0900_ai_ci

Submitted by barnettech on Fri, 01/13/2023 - 09:45
sed -i '' 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' backup.sql  
sed -i '' 's/CHARSET=utf8mb4/CHARSET=utf8/g' backup.sql  

https://tecadmin.net/resolved-unknown-collation-utf8mb4_0900_ai_ci/

or this worked https://meetanshi.com/blog/error-1273-unknown-collation-utf8mb4-0900-ai…
just open the file and do %s/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g

Working mutation observer

Submitted by barnettech on Fri, 11/18/2022 - 17:00
function waitForElm(selector) {
  return new Promise(resolve => {
    if (document.querySelector(selector)) {
      return resolve(document.querySelector(selector));
    }

    const observer = new MutationObserver(mutations => {
      if (document.querySelector(selector)) {
        resolve(document.querySelector(selector));
        observer.disconnect();
      }
    });

    observer.observe(document.body, {
      childList: true,
      subtree: true
    });
  });
}

waitForElm('.ief-entity-submit').then((elm) => {
  console.log('Element is ready');
  console.log(elm.textContent);
});