Hi.

I have a problem in my portal. When I try access to admin options, I have this error:

Erro: afiliados não está disponível de momento.
DotNetNuke.Services.Exceptions.ModuleLoadException: Incorrect syntax near ','. ---> System.Data.SqlClient.SqlException: Incorrect syntax near ','. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetVendors(Int32 PortalId, Boolean UnAuthorized, Int32 PageIndex, Int32 PageSize) at DotNetNuke.Services.Vendors.VendorController.GetVendors(Int32 PortalId, Boolean UnAuthorized, Int32 PageIndex, Int32 PageSize, Int32& TotalRecords) at DotNetNuke.Modules.Admin.Vendors.Vendors.BindData(String SearchText, String SearchField) in D:\inetpub\vhosts\aveiromagazine.com\httpdocs\Admin\Vendors\Vendors.ascx.vb:line 113 at DotNetNuke.Modules.Admin.Vendors.Vendors.Page_Load(Object sender, EventArgs e) in D:\inetpub\vhosts\aveiromagazine.com\httpdocs\Admin\Vendors\Vendors.ascx.vb:line 282 --- End of inner exception stack trace ---

but in localhost everything works fine... Why?

Cheers vidryne

Since yesterday... I've the version 4.9.2, and upgrad to version 4.9.3, but the error occurs...

I've added a new portal, but in localhost everything works fine... I can do every operations in my localhost...

Cheers, vidryne

Hi.

I'm gone crazy with this problem... I try to install a new DNN, move files from localhost to host, everything.

The problem continues... In localhost everything work fines, but in host I can't access to the list of affiliates, or users... But everything works... 

Cheers, vidryne