What is the appropriate configuration to use for WFFM on a development environment (Sitecore 8.2)? I want to be able to create/edit forms, submit them and then view the submitted information in the form reports window.
I have been looking at the Instllation Guide here where it describes the configuration steps for CM and CD environment, but I'm not sure how it should be set up on a dev environment?
I noticed the database
Sitecore_Wffm.mdf is placed into the Website\Data folder during installation, but no mention of this is made in the install guide, although a script
WFFM_Analytics.sql is mentioned and should be run on the reporting database (
I am currently getting the following error in the logs, so I assume something has been set up wrong, but I'm not sure what:
13960 12:15:26 ERROR Exception when storing an aggregation result into reporting database. Item will be postponed and retried later. Exception: System.Data.SqlClient.SqlException Message: Invalid object name 'FormFieldValues'. Source: .Net SqlClient Data Provider