Notifications
Clear all
Feb 09, 2018 3:59 pm
<span lang="en">I found a problem when the import database "install_db.sql" when I execute in mssql there is an error like this</span>. im use MSSQL 2008. <em>Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'UpdateHostingPlanQuotas'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.</em> <em>Msg 468, Level 16, State 9, Procedure GetDnsRecordsTotal, Line 28</em> <em>Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.</em> <em>Msg 468, Level 16, State 9, Procedure GetDnsRecordsTotal, Line 56</em> <em>Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.</em> <em>Msg 468, Level 16, State 9, Procedure GetDnsRecordsTotal, Line 66</em> <em>Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.</em> <em>Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'UpdateHostingPlanQuotas'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.</em> <em>Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'UpdatePackageQuotas'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.</em> <em>Msg 468, Level 16, State 9, Procedure UpdateServiceProperties, Line 20</em> <em>Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. </em>
<span lang="en">how to solve the problem ? so I can move on to the next step installation. Regards, Genta </span>
<em> </em>
<span lang="en"> </span>
2 Replies
Feb 09, 2018 4:13 pm
Hello,
It sounds like your running the install_db.sql manually. Please when you make the database ensure the collation is set to "SQL_Latin1_General_CP1_CI_AS"
Thanks,
Trevor Robinson
Feb 09, 2018 9:40 pm
Hi Trevor,
thx for feedback.
<span lang="en">after making the change "collation" I get the same error</span>. can you show sql query in here for SolidCp 1.4? Fyi,
i use this link tutorial for installation
https://solidcp.com/kb/installation/manual-offline-solidcp-installation/
Thanks, Genta
<span lang="en"> </span>