dbo schema System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'ScheduleTask'

7 months ago
Hi there
Im trying to set up a nopcommerce store version 4.2 on shared hosting using the dbo schema
I create the adatabse and user
the webhost applies dbo to the sql tables
I then try to install my site using the wizard but get an error


"An error occurred while starting the application.

.NET Core 4.6.27414.05 X64 v4.0.0.0    |   Microsoft.AspNetCore.Hosting version 2.2.0-rtm-35687    |    Microsoft Windows 10.0.14393    |   Need help?"

the host says this error is relating to

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'ScheduleTask'

if they do not apply DBO schema, i can install my site.

But if they use DBO i get these errors and cannot set up a site !

I need to use DBO schema for a plug in I wish to use.

any ideas?!!
7 months ago
Error message saying, ScheduleTask table is not available in your database. Did you check that manually?
7 months ago
mhsjaber wrote:
Error message saying, ScheduleTask table is not available in your database. Did you check that manually?
hi there
thanks for the reply. how do i check it?
7 months ago
i connected via query espress and typed in ScheduleTask then ran
it came back as could not find stored procedure 'ScheduleTask'
7 months ago
toadman wrote:
Error message saying, ScheduleTask table is not available in your database. Did you check that manually? hi there
thanks for the reply. how do i check it?


There are lot of ways to check that. But in simple execute below code.
Select * From ScheduleTask


If table doenst exist, it will throw an error.
7 months ago
mhsjaber wrote:
Error message saying, ScheduleTask table is not available in your database. Did you check that manually? hi there
thanks for the reply. how do i check it?

There are lot of ways to check that. But in simple execute below code.
Select * From ScheduleTask


If table doenst exist, it will throw an error.
Thanks ! I ran that and it gave the error: Invalid object name 'ScheduleTask'.

i guess that means it doiesnt exist  ? Im on shared hosting is this somthing the host provider has to fix?

Thanks again !
7 months ago
You can do that yourself. Just execute a query to create that table. Make sure table column names and types match with related Entity class.