Category Archives: Software Tips

Mass Delete Multiple Downloaded Quicken Transactions

6 comments

Sometimes  you may need to delete Quicken downloaded transactions. However, on face value, it appears that Quicken makes it very time consuming to delete downloaded transactions. 🙁  Thankfully, there is a way to delete more than one transaction at a time! This cuts down on the number of clicks required and will hopefully save you some time. 🙂 UPDATE: I finally figured out a way to delete ALL downloaded transactions in a Quicken account. I am making this Tip 1

Read more computer tips, Software Tips

MySQL Server has gone away when importing large sqlfile [Navicat, SOLVED]

Leave a comment

Recently I tried importing a 1.2GB SQL dump file and Navicat kept immediately timing out with: [Err] 2006 – MySQL server has gone away Eventually, I was able to the entire file (6 million records worth) to import by unchecking* the “Run multiple queries in each execution” option before starting the import process. After this, the process completed perfectly! *normally I always uncheck that box, but for some reason this time I forgot to uncheck it on my first attempt.

Read more Software Tips, Work

Google Photos crashes when saving edits on Samsung Note 10 (S10, S9, S8) [SOLVED]

Leave a comment

Recently my wife unable to save photos after editing them in Google Photos. Specifically, the Google Photos app would crash immediately upon trying to save edits and this issue was occurring on a Samsung Note 10+. Checking with some friends, they were having similar issues on their S10 phones. After trying a number of adjustments (restarting, clearing cache, clearing data) I finally realized that the issue was due to motion photos. Specifically, during a recent software update, it seems that

Read more Android tips, camera tips, photography, Software Tips

How to fix the fatal error allowed memory size exhausted [SOLVED] (PHP)

Leave a comment

How to fix the following memory size error on turnkeylinux (or similar)? ( ! ) Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 80 bytes) in /var/www/fit2019/index.php on line 2841 Call Stack # Time Memory Function Location 1 0.0015 510656 {main}( ) ../index.php:0 2 0.0153 523256 funcMakeTableTotal2019( ) ../index.php:487 3 2.0429 33543952 mssql_fetch_assoc ( ) ../index.php:2841 Answer:Edit the configuration file: /etc/php5/apache2/php.ini and set the memory limit to a value higher than 32M: memory_limit = 128M Then

Read more programming, Software Tips

Improve Lenovo PC performance, remove McAfee LiveSafe, replace with best Antivirus

Leave a comment

Recently we purchased some new Lenovo AIO PCs with Windows 10. These systems have nice Ryzen CPUs, SSDs and plenty of RAM but there is still room for performance improvement! One of the first things I like to is uninstall programs that I do not need. There are a ton of candidates but McAfee LiveSafe is one of the first that I uninstall. It takes up precious resources and nearly a GB of space on the SSD. Uninstalling is quick

Read more computer tips, Software Tips, Windows

How do I clean my coffee maker? [AI Answered]

Leave a comment

NOTE: this is an AI generated answer, using OpenAI GPT-2. Here is the question prompt and the resulting answer: Q: How do I clean my coffee maker? A. There are numerous cleaning methods to choose from. 1.) Pour some water into the coffee maker and submerge the lid. Do not wash the glass. 2.) Dip the coffee maker upside down in water for 10 seconds and then rinse. 3.) Put the lid back on and let the coffee maker sit

Read more Gadgets and Tech, programming, Software Tips

Latest iTunes direct download offline installer links

2 comments

If the Apple iTunes download page is not working, you can use the links below. The downloads are directly from apple.com You can check the URLs to make sure that you are downloading iTunes 12.9 from an official source [apple.com] Download iTunes 12.9 offline installer for Windows 64-bit [EXE 257.5 MB] Download iTunes 12.9 offline installer for Windows 32-bit [EXE 195.4 MB] Download iTunes 12.9 offline installer for MacOS [DMG 273 MB] Download iTunes from Windows Store (Requires Windows 10 Version

Read more Internet tips, Software Tips

InDesign PDF export blank 0kB error [SOLVED]

Leave a comment

Question. I am trying to export a large Adobe InDesign project as a PDF but I only get a 0kB blank PDF. 🙁 I have tried restarting and sometimes that helps but it is driving me crazy. How do I fix this InDesign error? Answer. If your project is very large, your PDF may still be exporting in the background. Here is how to check: Start your PDF export Go to the menu item  Window->Utilities->Background Tasks Check the resulting list

Read more computer tips, Software Tips, tech tips