Category Archives: Software Tips

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

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.

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

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

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

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

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

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

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

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

Latest iTunes direct download offline installer links

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

InDesign PDF export blank 0kB error [SOLVED]

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

How to set FireFox homepage and disable top sites/recommended/highlights [SOLVED]

Question: Help! How do I disable the “Top Sites” “Recommended by Pocket” and “Highlights” when I start Firefox? Also, how do I set my OWN homepage? Thank you. Answer: In the Firefox address bar, type about:preferences and press Enter. That takes you to preferences. Now you can: Set your preferred Homepage for new windows Set your preferred page for new tabs Disable Top Sites by unchecking (under the “Firefox Home Content”  heading) Disable Recommended by Pocket Disable Highlights I hope