Field 'Categories' doesn't have a default value

Hello, I am in the process on configuring several different modules after setting up media server.  When posting a Video comment I am receiving the following error "Database access error. Description: Field 'Categories' doesn't have a default value"

I am a bit confused by this, is this something I am supposed to set or is this a technical issue?  Any guidance is appreciated. 

Hello

Looks like it's a technical issue, but it shouldn't appear if you have a clean, non-modified version.

What Dolphin do you use? 

I am was running 7.1.1 clean install no mods yet and the error occurs, I wiped it and started fresh with 7.1.2 and same error.

I am using MariaDB instead of traditional MySQL.  I have had no issues yet running MariaDB on Drupal and Joomla so I figured it should be fine with Boonex however its possible this is the problem.  

I will load up MySQL and give it another go.

Hello

Yes, it may cause the problem. Dolphin requires to use MySQL.

You may check server requirements here.

So I removed MariaDB and put back on MySQL 5.6, fresh install of Bonnex7.2 and the problem is still there.  I also realize the same error was also occuring when uploading videos and not just Video comments.   It's very possible this was affecting many items.  

The problem was Both Maria 5.5 and MySQL 5.6 both seem to be running in Strict mode by default on Windows.  

Regardless the fix was the following, change  sql-mode=""STRICT_TRANS_TABLES" to sql-mode="NO_ENGINE_SUBSTITUTION"

See the following link for more information.  https://www.farbeyondcode.com/Solution-for-MariaDB-Field--xxx--doesn-t-have-a-default-value-5-2720.html

So I wiped it all again, put MariaDB back on, turned off strict mode and its working properly on MariaDB

Running Boonex on Windows Server 2012, IIS8 + Wincache and now MariaDB for the past few days and so far very impressed with the performance.  I may find some other quirks over time however at this point I am very happy with this setup in comparison to previous Apache deployments.  MariaDB is great, I see no reason not to use this unless there are known issues with it and Boonex.

For all practical purposes, MariaDB is a binary drop in replacement of the same MySQL version (for example MySQL 5.1 -> MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are compatible. MySQL 5.5 will be compatible with MariaDB 5.5). What this means is that:

• Data and table definition files (.frm) files are binary compatible.
• All client APIs, protocols and structs are identical.
• All filenames, binaries, paths, ports, sockets, and etc... should be the same.
• All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.
  • There are some installation issues with PHP5 that you should be aware of (a bug in how the old PHP5 client checks library compatibility).
• The mysql-client package also works with MariaDB server.
• The shared client library is binary compatible with MySQL's client library.

This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go. (No need to convert any datafiles if you use same main version, like 5.1).

We do monthly merges with the MySQL code base to ensure we keep up our compatibility and get any and all features and bug fixes Oracle adds.

geek_girl thanks for your input, that certainly clarifies a few things.