How To Install/Update CPAN on MacOS Mojave with fatal error: ‘EXTERN.h’ file not found

Author: erics, June 12th, 2019

The Problem Tried to install the latest version of cpan and got stuck. Tracked it down to the dependency module Mac::SystemDirectory which was failing to build:

The Solution Use the MacOS installer command to deploy the needed files:

The, rerunning the cpan install works:

Categories: How-To's, Technology Tags: 10.14, CPAN, Error, extern.h, Fatal, Fatal Error, File not found, Header, headers, howto, Install, installer, Libraries, Library, MacOS, Mojave, not found, Package, perl, pkg, System, tips, update, upgrade, XCode | No comments

How To Solve the LOAD DATA INFILE Error from –secure-file-priv

Author: erics, June 12th, 2019

The Problem Tried to load a Tab-delimited text file into MuSQL 5.6.43 and got the following error: mysql> LOAD DATA INFILE ‘sample.txt’ INTO TABLE test_table; ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement Solution One mysql> SHOW VARIABLES LIKE “secure_file_priv”; Copy the file into the […]

Categories: How-To's, Technology Tags: Data, Error, File, howto, INFILE, Load, LOAD DATA, LOAD DATA INFILE, LOAD DATA LOCAL INFILE, local, mysql, Priv, Privilege, Secure, secure_file_priv, secure-file-priv, Show, SHOW VARIABLES, tips, VARIABLES | No comments

How To Increase WordPress Memory After PHP Fatal error: Allowed memory size exhausted

Author: erics, February 13th, 2017

PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 277644940 bytes) in /volumes/data/customer/wordpress/wp-content/plugins/searchwp/vendor/pdfparser/vendor/smalot/pdfparser/src/Smalot/PdfParser/Parser.php on line 72, referer: http://dev.thecustomer.com/index.php?swpnonce=1387006674.5392169952592578125000 To increase the PHP memory limit to 256MB, edit wp-config.php and add the following just before the line that says “That’s all, stop editing! Happy blogging.”:

Categories: How-To's, Technology Tags: Allowed memory size exhausted, Error, Exhausted, Fatal, howto, Memory, php, tips, WordPress | No comments

How To Fix MySQL Remote Login Errors

Author: erics, August 25th, 2016

In this case I had done a restore from a MySQL 5.1 server to a MySQL 5.6 server. That was not too smart, because it broke the mysql database table structures and prevented me from logging in remotely. Local login worked both via the socket and TCP. mysql -u root -p -h remoteHostName Enter password: […]

Categories: How-To's, Technology Tags: Error, howto, login, mysql, mysql_upgrade, remote, Remote Login, tips | No comments

How To Fix “No Public Key Available” Errors for apt-get update on Debian

Author: erics, June 29th, 2016

root@myHost # apt-get update Hit http://cloudfront.debian.net wheezy Release.gpg Hit http://cloudfront.debian.net wheezy-updates Release.gpg Hit http://cloudfront.debian.net wheezy-backports Release.gpg Hit http://cloudfront.debian.net wheezy Release Hit http://cloudfront.debian.net wheezy-updates Release Hit http://cloudfront.debian.net wheezy-backports Release Hit http://cloudfront.debian.net wheezy/main Sources Hit http://cloudfront.debian.net wheezy/main amd64 Packages Hit http://cloudfront.debian.net wheezy/main Translation-en Hit http://cloudfront.debian.net wheezy-updates/main Sources Hit http://security.debian.org wheezy/updates Release.gpg Get:1 http://cloudfront.debian.net wheezy-updates/main amd64 Packages/DiffIndex [2,488 […]

Categories: How-To's, Technology Tags: apt-get, Debian, Error, howto, key, Linux, public, Public Key, tips | No comments

How To Fix Apple iCloud Mail Errors on Snow Leopard

Author: erics, August 7th, 2014

Some actions taken while the account “iCloud” was offline could not be completed online. Mail has undone actions on some messages so that you can redo the actions when online. Mail has saved other messages in mailbox “Recovered Messages (iCloud)” in “On My Mac” so that you can complete the actions when online. Step 1. […]

Categories: How-To's, Technology Tags: 10.6.8, Actions, apple, Error, iCloud, IMAP, mail, Recovered, Snow Leopard | No comments

How To Fix Netflix DRM Error N8156-6013 on MacOSX

Author: erics, June 16th, 2013

I tried to use my new Harman Kardon bluetooth headphones with Netflix running on Firefox and got the following message: “Digital Rights Management Error DRM N8156-6013, please call Netflix support” Netflix uses Microsoft Silverlight for DRM. Silverlight creates a licensing file that identifies your computer hardware. This file needs to be deleted, and will be […]

Categories: How-To's, Technology Tags: apple, Bluetooth, DRM, Error, Harman Kardon, Headphones, howto, Mac, N8156, NetFlix, tips | 1 comment

How To Create a Code Block in PHP for Error Handling

Author: erics, October 19th, 2012

The do/while statement is sometimes used to break out of a block of code when an error condition occurs. For example:

Because the condition for the loop is false, the loop is executed only once, regardless of what happens inside the loop. However, if an error occurs, the code after the break is not […]

Categories: How-To's, Technology Tags: Block, break, Code, Code Block, Error, Error Handling, Errors, php | No comments

How To Prevent Fatal Error Cannot Redeclare Function In PHP

Author: erics, August 8th, 2012

Categories: How-To's, Technology Tags: Cannot Redeclare Function, Error, Fatal Error, howto, php, tips | No comments