I run into an issue today with PostgreSQL. I had manually entered a row into a table and it caused the primary key to fall out of sequence. To reset the primary key sequence ID on the PostgreSQL table I used the setval and pg_get_serial_sequence functions. Source: How to reset postgres’ primary key sequence when […]
Fix
Xdebug with Built-in PHP Server
When using Xdebug with the built-in PHP server be sure you have the proper configuration in your php.ini file. Will will need at a minimum the following settings: If you run into an issue running Xdebug via PHPStorm, or another IDE, when using the built-in PHP server on macOS, or Ubuntu, you might have a […]
Fixing MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
To fix, “MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes” on Ubuntu edit your /etc/mysql/mysql.conf.d/mysqld.cnf. Once you have opened the file, increase the max_allowed_packet to a value that works for your environment. For example, in a local development environment, 100M can work. Then restart MySQL. Resources https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes
Getting macOS to trust all your self-signed SSL certificates from Homestead with a single shot
If you want Google Chrome on macOS (previously OS X) to always trust all of your sites hosted on your Laravel Homestead vagrant box add the Homestead ca.homestead.homestead.crt certificate file to your Mac’s Keychain Access and trust the certificate. Take a look at how this can be done. To import your .csr file as a […]
Stop Chrome & Firefox from blocking HTTPS requests by default for all domains hosted by Homestead
Virtual hosted Homestead SSL URLs in both Chrome and Firefox display an insecure message when visited. In this tutoial we will stop these browsers from blocking HTTPS requests by default for all domains hosted by Homestead. To get started, you simply need to import your certificate authority, .csr, file into Firefox. For Chrome you need […]
Disable MySQL Strict Mode and NO_ZERO_DATE Errors in Laravel Homestead
If you are using MySQL 8 or 5.7, on Laravel Forge, for example, use the command sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf. The options file /etc/mysql/conf.d/mysql.cnf is not the .cnf file we are using in this particular instance. Then add the sql_mode options you need and wrap them in quotes under the [mysqld] group. The sql_mode options needed […]
