Import file "instal...
 
Notifications
Clear all

Import file "install_db.sql" query error solidcp 1.4

3 Posts
2 Users
0 Reactions
775 Views
Posts: 6
Topic starter
(@genta)
Active Member
Joined: 7 years ago
<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
Posts: 1457
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

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

Reply
Posts: 6
Topic starter
(@genta)
Active Member
Joined: 7 years ago

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>
Reply
Share: