Every webmaster knows the free PHP tool for the administration of MySQL databases phpMyAdmin, where one can do all important operations in its MySQL databases via browser. This is more likely to be developed in a easy manner and its surface is still based on a frameset.
Many webmasters are not familiar and so there are various alternatives, which are however often only developed and supported for a short time. A new competitor in this environment is Chive, which is based on the web2.0 Framework yii and offers a modern interface. The tool has been released on December 23, 2011 in the version 1.0.1, reason enough.
After unpacking the package onto the server, it can be started directly without a large configuration, you call the index.php and you should get an input mask, into which you can enter its database details. I was directly greeted by the following error message:
Internal Server Error
Strtotime () [<a href=’function.strtotime’> function.strtotime </a>]: It is not safe to rely on the system’s timezone settings. You are * required * to use the date.timezone setting or the date_default_timezone_set () function. In case you use any of these methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘Europe / Berlin’ for ‘CET / 1.0 / no DST’ instead
This is caused by Chive, if no time zone is defined in php.ini. If you have access to php.ini, you can simply add this option with the following line:
Date.timezone = “UTC”
Instead of “UTC” you can also use any time zone, for example “Europe / Berlin”. An overview can be found at php.net. Then you just have to restart the PHP instance and Chive should work fine.
Chive has apparently solved the problem already in earlier versions and in the index.php there is a fallback, which however does not always seem to work and triggers an error even with Chive 1.0.1.
If you do not have access to the php.ini, because you have a simple web hosting package at a cheap provider like me at speicheranbieter.de, you can also create the .htaccess remedy and add the following line:
SetEnv TZ UTC
Instead of UTC you can also use any time zone here. The .htaccess you only have to save and Chive should work without restarting the PHP instance.
Alternatively you can edit the index.php and if possible add the following line at the beginning of the file:
Again, of course, any valid time zone can be used. It should be noted with both codechanges in the files, that these are overwritten with an update to a new version and possibly have to be carried out again.
If someone can not understand, please comment, I try as best I can to help.