I'm about to release a 30 minute video and accompanying blog post on deploying Sitefinity. During research & recording I encountered this troublesome error. This thread led me to the solution. Like others in this thread, my development database was using tables that looked this like:
However, on the production server/database Sitefinity was expecting database tables that look like this:
'Charity' is the database username I'm using through the shared hosting provider.
Because these tables didn't exist, Sitefinity created them...but they are empty. When Sitefinity tried to find a web page it throws the error shown in the subject of this thread.
My solution was to remove charity tables that Sitefinity created by executing this SQL:
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
This command will obliterate everything in your database.
Then I re-transferred the database (with the dbo table names) to the production server and renamed all of these tables using the following SQL:
WHILE @@fetch_status = 0
You'll need to modify the dbo and charity values for your unique deployment.
Anyway the video is already uploaded and I'm waiting for encoding to finish. When it's published, it will work at this URL:
Thanks to everyone in this thread for helping to make this possible.
Telerik | Sitefinity CMS