R412 does not associate files with users or groups

[GoogleCodeExporter]

What steps will reproduce the problem?
--------------------------------------
1. Add users and groups
2. Upload file and assign to desired people/groups

What is the expected output? What do you see instead?
-----------------------------------------------------
The file should be associated with users and groups, instead it is listed as an 
orphan file. Editing the orphan to assign associations appears to work but 
doesn't change the issue. No entry is made on tbl_files_relations after the 
initial assignment or upload.

What version of the product are you using? On what operating system?
--------------------------------------------------------------------
Release R412 on 64-bit Windows 7 Professional using WAMP Server 2.4 (Apache 
v2.4.4,PHP 5.4.12, and MySQL 5.6.12, default package install)  and interacting 
with Firefox 23.0.1.

Please provide any additional information below.
------------------------------------------------
Tested with .xlsx and .zip files, both extension were enabled in security 
settings.

Original issue reported on code.google.com by SimonAGo...@gmail.com on 12 Sep 2013 at 3:50

[GoogleCodeExporter]

Am having the same problem.

Original comment by skboh...@gmail.com on 21 Oct 2013 at 12:39

[GoogleCodeExporter]

Me to i'm having the same problem, an no solution so far

Original comment by Nielsvar...@gmail.com on 17 Dec 2013 at 8:35

[GoogleCodeExporter]

#3 techbozo@gmail.com found the solution.

OK - I have found that the answer to my "assigning" issue is related to a fix 
for many of my other issues. When installing - database.php creates many MySQL 
fields as "Not Null". In other words -- when doing insert queries sometimes 
there are fields that are requiring a value that isn't given. This causes 
problems when creating your first User during installation because the database 
says "Address" is required and then breaks. When trying to assign orphan files 
to a client, the MySQL database will not allow Null value for 
tbl_files_relations.download_count, tbl_files_relations.folder_id and 
tbl_files_relations.group_id. To solve many of these related issues, I needed 
to change "Not Null" to something like DEFAULT NULL or some other default 
value, depending on the field usage.  I assume this problem must be unique to 
my setup and configuration.  This scenario must not cause errors on other 
systems, but I hope this info will help someone that is having problems.

Original comment by Nielsvar...@gmail.com on 17 Dec 2013 at 9:16