Issue:  Whenever I click SAVE under the Administrator section in EnergyCAP Online, I receive a "Whoops" message stating something went wrong.  It happens in any section under Administrator. 

Resolution:  You are receiving this because in the AccountPeriod table of the database there is a 13 line of data with the accountperiodID of '1025' and zero's.  This is incorrect and needs to be removed/deleted.  Please use the SQL script below to remove it. 

Run this first: 

SELECT * FROM AccountPeriod

Use this to determine if that 13th line exists.  If it does use this to determine if the accountperiodID for that line is '1025' or something else. 

Once you determine the accountperiodID that needs to be removed, run the script below: **Remember to run a backup of the database first before running this script.**

DELETE
FROM AccountPeriod
WHERE accountperiodID = XXXX {Insert 13th line ID here}

Once you have successfully run this script, go back and click SAVE again under the Administrator section. 

If this does not resolve the issue, contact Technical Support by entering in a support ticket (http://support.energycap.com)

This is for EnergyCAP Self-hosted clients only