satishsoni1 / clients-oriented-ftp

Automatically exported from code.google.com/p/clients-oriented-ftp
0 stars 0 forks source link

tbl_files_relations empty #410

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
When giving a owner to a file nothing gets written in to the table 
tbl_files_relations.
So i only get orphan files, its impossible to give a file a owner

Original issue reported on code.google.com by Nielsvar...@gmail.com on 12 Dec 2013 at 3:13

GoogleCodeExporter commented 8 years ago
can the problem be in upload-process-form.php?

Original comment by Nielsvar...@gmail.com on 13 Dec 2013 at 7:59

GoogleCodeExporter commented 8 years ago
Hi! Are you on Apache or IIS?

Original comment by i...@subwaydesign.com.ar on 14 Dec 2013 at 4:36

GoogleCodeExporter commented 8 years ago
IIS7

Original comment by Nielsvar...@gmail.com on 14 Dec 2013 at 11:33

GoogleCodeExporter commented 8 years ago
Do u have a idea what the problem can be ?

Original comment by Nielsvar...@gmail.com on 16 Dec 2013 at 12:53

GoogleCodeExporter commented 8 years ago
#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:17