Your PHP settings limit the maximum file size per upload to 16 MB. Depending on your server environment -- Drupal upload error

I have changed the upload_max_filesize = 800M and also post_max_size = 800M . I am still getting the same error. I have also restarted the apache.

Then I added the following code snipet in .htaccess file of my drupal root directory.

• php_value upload_max_filesize 800M
• php_value post_max_size 800M

It worked.

Now I am able to upload upto 800 MB of files.

user warning: Data too long for column 'timezone' at row 1 query error in Drupal

I am trying to resolve this error.

I commented this line in my my.ini of Mysql.

# sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Now its working fine.