mysql disabled strict standards on your server

Database Dedicated Server Solution PHP Scripts

Get following error on php site and upload images, video, files, not working also folder creation & copy files from other server via url copy not working. error display as bellow

================================================================================
Fatal error: [SQL] [1364] Field ‘icon’ doesn’t have a default value
INSERT INTO files (`name`,`path`,`pid`,`time`,`size`) VALUES
================================================================================

here is solution:

looks to be an issue with your sql query and you may need to hire a database administrator to look further into this issue. However, I did want to verify that this issue is NOT related to strict standards being enabled before having you go that route. For that reason, I went ahead and disabled strict standards on your server:

# mysql -e “select @@sql_mode;”
+————————+
| @@sql_mode |
+————————+
| NO_ENGINE_SUBSTITUTION |
+————————+
================================================================================

Leave a Reply

Your email address will not be published.