BE 3.1 Can't add new page

Topics: Business Logic Layer
Oct 15, 2014 at 12:31 AM
Running BE 3.1 on Azure with DB using Azure SQL. Everything seems to be working so far except I can add Pages. In the interface, I just get the red toast popup that indicates saving the page failed.

If I run in Visual Studio 2013; set a breakpoint; and follow thru until the exception is thrown I get the following exception:

{"The parameterized query '(@blogid nvarchar(36),@id nvarchar(36),@title nvarchar(4),@desc ' expects the parameter '@keywords', which was not supplied."}
Oct 16, 2014 at 2:10 PM
I found the solution to this, which ended up being a multipart solution.
  1. The DB was missing the SortOrder field. I needed to run the SortOrderUpdate.sql file from the setup folder. The ReadMe.txt file in the setup folder doesn't mention this step.
  2. The keywords field in the Pages settings dialog is required.
Running the script to create the SortOrder column in the database and then including keywords fixed the problem.
Marked as answer by rwgodfrey on 10/16/2014 at 7:11 AM