Category: uncategorized

cannot truncate tables because it has constraints.     SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table leads; SET FOREIGN_KEY_CHECKS = 1;     […]

  re.sub('[^A-Za-z0-9]+', '', mystring)

  you can downgrade to version 1 , execute composer install and then revert back composer self-update --1 revert to version 2 […]

  reference: https://stackoverflow.com/questions/29926773/run-shell-command-in-jenkins-as-root-user   sudo vi /etc/default/jenkins $JENKINS_USER="root" sudo chown -R root:root /var/lib/jenkins sudo chown -R root:root /var/cache/jenkins sudo chown -R root:root […]

when connecting to an openvpn server (at least on ubuntu 20.04) you lose your dns server, meaning you're not able to access […]

su user ssh-keygen   it is saved on: Enter file in which to save the key (/var/lib/jenkins/.ssh/id_rsa)

 copy paste /var/lib/jenkins/jobs directory between installations

  tar -czvf name-of-archive.tar.gz /path/to/directory-or-file     tar -xzvf archive.tar.gz

  select the insert query right-click -> edit as table you can modify your insert query visually   this is super helpful […]

  SugarCE-6.5.26 still available on sourceforge 2021-03-13