 |
|
|
Joined: 8/25/2009
Posts: 12
|
|
|
Hi All!
When i install module in localhost >> "EndJob Installation successful."
But when i install module in host(godaddy) >> "EndJob Installation Failed"
Similar to other modules like (Module HTML .v.v. Install localhost >> Ok , Install Host Godaddy >> failed) it failed, please help me fix the error, thanks!
Error below:
1. Install localhost:
|
| |
|
|
|
| StartJob |
|
| Starting Installation |
| |
| Info |
|
| Starting Installation - topcmm_123flashchat |
| |
| Info |
|
| Starting Installation - Script |
| |
| Info |
|
| Begin Sql execution |
| |
| Info |
|
| Creating backup of previous version - Uninstall.SqlDataProvider |
| |
| Info |
|
| Created - Uninstall.SqlDataProvider |
| |
| Info |
|
| Finished Sql execution |
| |
| Info |
|
| Component installed successfully - Script |
| |
| Info |
|
| Starting Installation - Module |
| |
| Info |
|
| Module registered successfully - topcmm_123flashchat |
| |
| Info |
|
| Component installed successfully - Module |
| |
| Info |
|
| Starting Installation - Assembly |
| |
| Info |
|
| Assembly already registered - bin\topcmm_123flashchat.dll |
| |
| Info |
|
| Creating backup of previous version - bin\topcmm_123flashchat.dll |
| |
| Info |
|
| Created - bin\topcmm_123flashchat.dll |
| |
| Info |
|
| Component installed successfully - Assembly |
| |
| Info |
|
| Starting Installation - File |
| |
| Info |
|
| Creating backup of previous version - App_LocalResources\Edittopcmm_123flashchat.ascx.resx |
| |
| Info |
|
| Created - App_LocalResources\Edittopcmm_123flashchat.ascx.resx |
| |
| Info |
|
| Creating backup of previous version - App_LocalResources\Settings.ascx.resx |
| |
| Info |
|
| Created - App_LocalResources\Settings.ascx.resx |
| |
| Info |
|
| Creating backup of previous version - App_LocalResources\Viewtopcmm_123flashchat.ascx.resx |
| |
| Info |
|
| Created - App_LocalResources\Viewtopcmm_123flashchat.ascx.resx |
| |
| Info |
|
| Creating backup of previous version - 123FlashChatHostAndFree.aspx |
| |
| Info |
|
| Created - 123FlashChatHostAndFree.aspx |
| |
| Info |
|
| Creating backup of previous version - 123FlashChatPanel.aspx |
| |
| Info |
|
| Created - 123FlashChatPanel.aspx |
| |
| Info |
|
| Creating backup of previous version - Documentation\Documentation.css |
| |
| Info |
|
| Created - Documentation\Documentation.css |
| |
| Info |
|
| Creating backup of previous version - Documentation\Documentation.html |
| |
| Info |
|
| Created - Documentation\Documentation.html |
| |
| Info |
|
| Creating backup of previous version - Documentation\logo.gif |
| |
| Info |
|
| Created - Documentation\logo.gif |
| |
| Info |
|
| Creating backup of previous version - Edittopcmm_123flashchat.ascx |
| |
| Info |
|
| Created - Edittopcmm_123flashchat.ascx |
| |
| Info |
|
| Creating backup of previous version - login_chat.aspx |
| |
| Info |
|
| Created - login_chat.aspx |
| |
| Info |
|
| Creating backup of previous version - Offline123.jpg |
| |
| Info |
|
| Created - Offline123.jpg |
| |
| Info |
|
| Creating backup of previous version - Online123.jpg |
| |
| Info |
|
| Created - Online123.jpg |
| |
| Info |
|
| Creating backup of previous version - server.xml |
| |
| Info |
|
| Created - server.xml |
| |
| Info |
|
| Creating backup of previous version - Settings.ascx |
| |
| Info |
|
| Created - Settings.ascx |
| |
| Info |
|
| Creating backup of previous version - Viewtopcmm_123flashchat.ascx |
| |
| Info |
|
| Created - Viewtopcmm_123flashchat.ascx |
| |
| Info |
|
| Component installed successfully - File |
| |
| Info |
|
| Installation committed |
| |
| Info |
|
| Installation successful. - topcmm_123flashchat |
| |
| Info |
|
| Deleted temporary install folder |
| |
| EndJob |
|
| Installation successful. |
| |
| |
|
|
2. Install Host Godaddy
|
| Error loading files from temporary folder - see below |
| StartJob |
Starting Installation |
| Info |
Starting Installation - topcmm_123flashchat |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - 01.00.00.SqlDataProvider |
| Info |
Created - 01.00.00.SqlDataProvider |
| Info |
Executing 01.00.00.SqlDataProvider |
| Info |
Start Sql execution: 01.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'ContactUs_Delete', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_SelectAll', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_Save', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_Select', because it does not exist or you do not have permission. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) if exists (select * from dbo.sysusers where name='slscompanyusa') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on ' + @name + ' to [slscompanyusa]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end |
| Info |
End Sql execution: 01.00.00.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - topcmm_123flashchat |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
|
|
|
| |
|
|
 | |
|
|
|
for support with 3rd party modules, please use support options provided by the developer/vendor. Thank you.
|
| |
|
|
| |
|
|
Joined: 8/25/2009
Posts: 12
|
|
|
When i install User Online Module of DNN >> Error:
(Install in localhost >> succssess!)
Install Extension
|
| Error loading files from temporary folder - see below |
| StartJob |
Starting Installation |
| Info |
Starting Installation - DNN_UsersOnline |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - Providers\DataProviders\SqlDataProvider\04.09.04.SqlDataProvider |
| Info |
Created - Providers\DataProviders\SqlDataProvider\04.09.04.SqlDataProvider |
| Info |
Executing 04.09.04.SqlDataProvider |
| Info |
Start Sql execution: 04.09.04.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'ContactUs_Delete', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_SelectAll', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_Save', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_Select', because it does not exist or you do not have permission. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) if exists (select * from dbo.sysusers where name='slscompanyusa') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on ' + @name + ' to [slscompanyusa]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end |
| Info |
End Sql execution: 04.09.04.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - DNN_UsersOnline |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
|
|
Please help me! use hosting of godaddy!
|
| |
|
|
| |
|
|
 |
https://www.evotiva.com
Joined: 9/3/2004
Posts: 389
|
|
|
www.uyvien.com wrote:SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'ContactUs_Delete', because it does not exist or you do not have permission. Cannot find the object 'ContactUs_SelectAll', because it does not exist or you do not have permission.
I bet this post on Bruce's blog could be the answer: http://www.ifinity.com.au/Blog/EntryI...
[With DotNetNuke 5.2 a new change was introduced, where a specific GRANT EXECUTE statement was run for all the objects on the database. This caused plenty of problems with shared hosts, where a specific database user is used to run all of the Sql for a specified database, and those users don’t have permission to use ‘grant execute’...]
Thanks,
Horacio.-
|
| |
|
|
| |