Installing Laravel on GoDaddy Shared Hosting Site

A while ago I starting playing around with Laravel on my GoDaddy Hosting account.  GoDaddy makes it really easy to get started with Laravel, and numerous other frameworks, and assorted web application.  It has an “Installatron” app in cPanel which automatically installs a package for you, and configures it all for you.  That seems nice, … Continue reading Installing Laravel on GoDaddy Shared Hosting Site

Mixing OpenOffice/LibreOffice, MySQL, MacOS/Windows, and ODBC/JDBC

This post is about some difficulty I had in making an Apache OpenOffice Base “odb” front end work with an MySQL database backend on Mac OS X, and how I got things working. I originally had an Apache OpenOffice (AOO) Base “odb” file working on Windows, accessing MySQL with ODBC.  The “odb” file had a … Continue reading Mixing OpenOffice/LibreOffice, MySQL, MacOS/Windows, and ODBC/JDBC

PHP/MySQL Multibyte Characters

While using PHP to display web pages drawing on a MySQL database, I’ve had some difficulty with strings in non-English characters.  In my case, it happened to be Inuktitut syllabics.  Most text seemed to display properly, but some didn’t.  Ultimately, I found the simple solution, was I needed to enable the “mbstring” extension in PHP, and … Continue reading PHP/MySQL Multibyte Characters

Importing Excel spreadsheet into MySQL

I’ve recently had to import a large Excel spreadsheet into MySQL.  Of course, there’s lots of ways of doing this, and most of the time, it’s a rather trivial thing to do.  That is, it’s easy if you have English characters and single-line text fields. Approach 1:  CSV.  This is often the “go to” approach … Continue reading Importing Excel spreadsheet into MySQL

MySQL can’t insert without default val on auto-increment

So, I had a weird error with MySQL 5.6 Win 64 server.  Every time I tried to insert a record, I got an error that a field didn’t have a default value.  I was using Apache OpenOffice, with an ODBC driver, but the same underlying problem occurred with MySQL WorkBench, so it was a MySQL … Continue reading MySQL can’t insert without default val on auto-increment