This project is read-only.

Administration Page Error

Apr 16, 2009 at 1:23 PM
Hey I really like the product so far but I am getting an error trying to do anything in the Administration panel.

Exception Details: System.InvalidOperationException: Sequence contains no elements

Source Error:

Line 171:        public static style get(dbDataContext db, int theme)
Line 172:        {
Line 173: return db.styles.First(t => t.id == theme);Line 174:        }
Line 175:


I have reinstalled the database a few times and it still happens.
Apr 16, 2009 at 3:16 PM

For some reason, it appears that the styles table was not getting populated.  Run this SQL to populate it with the default data:


USE [SlickTicket]
INSERT INTO styles VALUES ('current','#e0e0e0','#4c5762','#37414A','#93bb3a','#c3e671','#3d454d','#f2f2f2','#4c5762','#4c5762');
INSERT INTO styles VALUES ('default','#e0e0e0','#4c5762','#37414A','#93bb3a','#c3e671','#3d454d','#f2f2f2','#4c5762','#4c5762');
INSERT INTO styles VALUES ('Light Blue','#444444','#c3d9ff','#e0ecff','#ff7700','#ffa500','#ffffff','#444444','#eff5ff','#ffffff');
INSERT INTO styles VALUES ('Maroon and Grey','#444444','#4a4a4a','#ffffff','#ff7700','#ffa500','#ffffff','#ffffff','#ededed','#A53C3C');
INSERT INTO styles VALUES ('Basic','#444444','#4a4a4a','#ffffff','#0100ff','#07008f','#ffffff','#ffffff','#ededed','#ededed');
INSERT INTO styles VALUES ('Blue/Green','#02243C','#02243C','#F9F9F9','#5BC236','#a0e189','#F9F9F9','#F9F9F9','#E6E6E6','#005DB3');
INSERT INTO styles VALUES ('Forest','#374D3C','#374D3C','#f5f5f5','#b87800','#faa300','#f5f5f5','#DADAD4','#e0e0e0','#DADAD4');
INSERT INTO styles VALUES ('Dark','#444444','#4a4a4a','#ffffff','#ff7700','#ffa500','#ffffff','#ffffff','#ededed','#555555');

Apr 16, 2009 at 3:35 PM
That did it

Thanks