I apologize if this is not the correct place to ask. We got a problem when moving a DNN site from dev to production, we can't upload any files to our DNN site using File Manager from Admin tools. Permissions were set correctly. Site on dev server does not have this problem. Everything is still functioning correctly except this file upload problem. We used DNN version 8.0.4.

Below is the exception occurred everytime we tried uploading something:

DotNetNuke.Services.FileSystem.FolderManager - DotNetNuke.Services.FileSystem.FolderProviderException: The underlying system threw an exception. The file has not been added. ---> System.Data.SqlClient.SqlException: Implicit conversion from data type datetime to bit is not allowed. Use the CONVERT function to run this query.

2016-11-15 14:36:11,514 [BOI01-WEB-04][Thread:14][ERROR] DotNetNuke.Services.FileSystem.FolderManager - System.Data.SqlClient.SqlException (0x80131904): Implicit conversion from data type datetime to bit is not allowed. Use the CONVERT function to run this query.

I've found out that the version is different between our dev site and production one. While DNN version of dev site is 08.00.04 (226), the one of production site is 08.00.03 (6). Did that difference cause issue? Below is the screenshot of the current stored procedure AddFile

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.