daily pastebin goal
79%
SHARE
TWEET

Untitled

a guest Jan 18th, 2019 90 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # **Excel:** formula delimiters not recognized
  2.  
  3. ## Problem
  4.  
  5. Excel failed to recognize delimiters in my formulas, and would interpret everything as being in the first argument to a function that accepts multiple arguments.
  6.  
  7. ## Solution
  8.  
  9.  1. CMD: `control international`
  10.  2. Click "Additional Settingsā€¦"
  11.  3. Make sure the "List separator" is only one character
  12.  
  13. # **Git CLI:** unable to find editor
  14.  
  15. ## Problem
  16.  
  17. Trying to run Git commands requiring an editor break with an error:
  18.  
  19. ```
  20. hint: Waiting for your editor to close the file... error: cannot spawn /usr/bin/vim: No such file or directory
  21. error: unable to start editor '/usr/bin/vim'
  22. Please supply the message using either -m or -F option.
  23. ```
  24.  
  25. ## Solution
  26. Make sure the `vim` executable is on your path and set the `core.editor` configuration to point to it.
  27.  
  28. ```
  29. git config --global core.editor vim
  30. ```
  31.  
  32. # **Git CLI:** apparent Cygwin DLL version mismatch
  33.  
  34. ## Problem
  35.  
  36. Running commands like `git help remote` results in an error:
  37.  
  38. ```
  39. 2 [main] sh (69208) C:\Program Files\Git\usr\bin\sh.exe: *** fatal error - cygheap base mismatch detected - 0x27511F01410/0x166A9271410.
  40. This problem is probably due to using incompatible versions of the cygwin DLL.
  41. Search for cygwin1.dll using the Windows Start->Find/Search facility
  42. and delete all but the most recent version.  The most recent version *should*
  43. reside in x:\cygwin\bin, where 'x' is the drive on which you have
  44. installed the cygwin distribution.  Rebooting is also suggested if you
  45. are unable to find another cygwin DLL.
  46.       1 [main] sh 69364 fork: child -1 - forked process 69208 died unexpectedly, retry 0, exit code 0xC0000142, errno 11
  47.  
  48. /mingw64/libexec/git-core/git-sh-setup: fork: retry: Resource temporarily unavailable
  49. ```
  50.  
  51. ## Solution
  52.  
  53. Windows Defender's Exploit Protection module prevents the executable(s) in `C:\Program Files\Git` listed in the error message from executing properly. In my case, the executables that needed to be added as exceptions were:
  54.  
  55.   - `C:\Program Files\Git\usr\bin\basename.exe`
  56.   - `C:\Program Files\Git\usr\bin\bash.exe`
  57.   - `C:\Program Files\Git\usr\bin\env.exe`
  58.   - `C:\Program Files\Git\usr\bin\sed.exe`
  59.   - `C:\Program Files\Git\usr\bin\sh.exe`
  60.   - `C:\Program Files\Git\usr\bin\uname.exe`
  61.  
  62. Adding the listed executables as program exceptions and re-running the command until the error messages disappear should resolve the issue.
  63.  
  64.  1. Go to "Exploit Protection": **Windows Security** > **App & browser control** > **Exploit Protection** > **Program Settings**
  65.  2. Click on **Add program to customize** and select **Choose exact file path**
  66.  3. Select the executable listed in the error message
  67.  4. Scroll to the **"Force randomization for images (Mandatory ASLR)"** section and make sure the checkbox for **Override system settings** is checked, and the switch is in the **Off** position
  68.  
  69. # **Flutter:** adb fails to get device properties
  70.  
  71. ## Problem
  72.  
  73. Trying to debug a Flutter application from Visual Studio Code on a physical device has a fatal error:
  74.  
  75. ```
  76. Error retrieving device properties for ro.product.cpu.abi:
  77. ```
  78.  
  79. ## Solution
  80.  
  81. Windows Defender's Exploit Protection module prevented `adb` from executing properly.
  82.  
  83.  1. Go to "Exploit Protection": **Windows Security** > **App & browser control** > **Exploit Protection** > **Program Settings**
  84.  2. Click on **Add program to customize** and select **Choose exact file path**
  85.  3. Select your **`adb.exe`** executable which in my case was `C:\Android\Sdk\platform-tools\adb.exe`
  86.  4. Scroll to the **"Validate heap integrity"** section and make sure the checkbox for **Override system settings** is checked, and the switch is in the **Off** position
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top