Category Archives: Ask J.D.

Mass Delete Multiple Downloaded Quicken Transactions

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

Increasing the PHP file upload limit for phpMyAdmin on IIS/FastCGI [SOLVED]

Recently I encountered a somewhat unusual web host. They were running FastCGI/PHP on MS IIS and they needed their PHP file upload limits increased. This is trivial on a normal PHP installation, but it took a bit more sleuthing to determine the proper location(s) for php.ini on this IIS install. For reference, here are the locations: C:\Program Files\PHP\v7.4\php.ini C:\Program Files (x86)\PHP\v5.3\php.ini The changes needed were: upload_max_filesize = 200M post_max_size =200M A few tips: Make the changes to the proper php.ini

youtube Api Could not be loaded ! Please Check and Renew SSL Certificate ! [SOLVED]

Recently I encountered the following error message on a client’s site: This error is fairly glaring as it covers the video that was meant to be playing. After some research, I was able to narrow the issue to a slider plugin and specifically the following javascript libary: jquery.themepunch.revolution.min.js and another more recent site had the same code in the file: rs6.min.js on both sites, the file was located in: \wp-content\plugins\revslider\public\assets\js\ After reviewing the code, it is evident that the javascript

Comparison list of various laptops and PCs

Updated for 2024 Random PCs and laptops I have used in the past for work and play: Lenovo T14 Gen4 Processor AMD Ryzen™ 7 PRO 7840U Processor (3.30 GHz up to 5.10 GHz) selected upgrade Operating System Windows 11 Pro 64 selected upgrade Operating System Language Windows 11 Pro 64 English selected upgrade Microsoft Productivity Software  None Memory 32 GB LPDDR5X-6400MHz (Soldered) selected upgrade Solid State Drive 1 TB SSD M.2 2280 PCIe Gen4 Performance TLC Opal selected upgrade Display 14″ WUXGA (1920 x 1200), IPS, Anti-Glare, Non-Touch, 100%sRGB, 400 nits, 60Hz,

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.

Best iPad for video meetings – ALL iPad camera specs LIST Video Conferencing & Photography

Last updated: April 28th, 2020 The iPad was first introduced in 2010 without a camera. Since then, the capabilities and models of the iPad family have steadily expanded. In this time of physical/social distancing and teleconferencing via a myriad of apps (Zoom, Skype, Facebook Messenger, WhatsApp, Facetime, etc.), camera quality has become even more important. Unfortunately, it can be hard to keep track of the camera changes over the iPad line after so many years. Therefore, I compiled a handy

Rotate a tablet screen when using TeamViewer or remote work software

Summary: sometimes a PC or tablet may be stuck in the wrong screen orientation when you log in via TeamViewer or other remote software. Solution: Turn rotation lock ON Rotate via the “orientation setting” Apply settings and you are done! Details: Recently I had to do some work for a client via TeamViewer. While that is normal, the ruggedized tablet that I was logging into was a little out of the usual. Specifically, the tiny tablet was running Windows 10