Answer from : http://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values

This is caused by the STRICT_TRANS_TABLES SQL mode defined in the %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem.

If editing that file doesn't fix the issue, see http://dev.mysql.com/doc/refman/5.6/en/option-files.html for other possible locations of config files.

Options -Indexes
Options +FollowSymLinks
DirectoryIndex index.php

<Files "error_log">
        order allow,deny
        deny from all
</Files>

<IfModule mod_rewrite.c>
#SetEnv HTTP_MOD_REWRITE 1

RewriteEngine on
RewriteBase /
RewriteBase /ossn/

RewriteRule ^rewrite.php$ installation/tests/apache_rewrite.php [L]

RewriteRule ^action\/([A-Za-z0-9\_\-\/]+)$ system/handlers/actions.php?action=$1&%{QUERY_STRING} [L]

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^([A-Za-z0-9\_\-]+)$ index.php?h=$1 [QSA,L]

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^([A-Za-z0-9\_\-]+)\/(.*)$ index.php?h=$1&p=$2 [QSA,L]

</IfModule>

<IfModule mod_expires.c>
        ExpiresActive On
        ExpiresDefault "access plus 1 year"
</IfModule>

Hi all, I am so amaze when looking this social web, then I want to installed on my own website, but unfortunately I get little frustrated while installing, any one here can help me? This is the problem

On mysql user database I have check all the privileges, and of course I set user and password even with the simple password.
The result always denied.

For any kind help, I'll appreciate it thank you