Joomla 2.x Smart Indexer fails with "undefined , undefined, null"

Recently ran into this issue on this very site so I did some digging.

JInstaller::install: SQL Error

JInstaller::install: SQL Error. DB function failed with error number 1064

If you get this error when you try to install extensions in a Joomla 1.5.x site on a server using MySQL 5,
check this out.

I had this when trying to install eXtplorer 2.1 witch was installed since I moved from another server using older MySQL. However I had some problems with it and needed a re-install. I uninstalled the older version and then downloaded eXtplorer 2.1 v2.1RC5. When I tried to install it I got an error stating something like this....

JInstaller::install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 35
SQL=CREATE TABLE IF NOT EXISTS '

"TYPE=MyISAM"

"ENGINE=MyISAM"

Fix for PHP Strict Standards issue with PHP 5.4.x

During some testing I found an issue with the latest PHP and osTicket. The one coding this puppy is not following php standards from what I understand so you need to disable logging for various errors. So in order to not get the dreaded PHP Strict Standards error in your logs make the following changes.