The 5th annual nopCommerce conference will take place in India on the 10th-11th of October. Please find more about this event here

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

Posted: August 23, 2019 at 8:12 AM Quote #245130
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?!!
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: August 23, 2019 at 9:37 AM Quote #245132
Error message saying, ScheduleTask table is not available in your database. Did you check that manually?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Jaber Kibria
Software Engineer | nop-station.com
Email: [email protected]
----------------------------------------------------------------
Expertise in .NET Framework, Algolia, Plugins, Themes, Customization, Upgrade, API

Please upvote if it helps.
Posted: August 23, 2019 at 10:54 AM Quote #245141
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?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: August 23, 2019 at 10:55 AM Quote #245142
i connected via query espress and typed in ScheduleTask then ran
it came back as could not find stored procedure 'ScheduleTask'
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: August 23, 2019 at 3:24 PM Quote #245147
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.
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Jaber Kibria
Software Engineer | nop-station.com
Email: [email protected]
----------------------------------------------------------------
Expertise in .NET Framework, Algolia, Plugins, Themes, Customization, Upgrade, API

Please upvote if it helps.
Posted: August 24, 2019 at 6:19 AM Quote #245171
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 !
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: August 24, 2019 at 7:43 AM Quote #245176
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.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Jaber Kibria
Software Engineer | nop-station.com
Email: [email protected]
----------------------------------------------------------------
Expertise in .NET Framework, Algolia, Plugins, Themes, Customization, Upgrade, API

Please upvote if it helps.
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2019
Learn more