[12:52:44 CDT(-0500)] <TonyUnicon> hey pspaude
[12:52:53 CDT(-0500)] <TonyUnicon> do you have access to a db with demo data loaded?
[12:53:25 CDT(-0500)] <pspaude> No but my db can be in a couple seconds, oh wait there is the demo site too. What do you need?
[12:53:54 CDT(-0500)] <pspaude> Ok, logged in and ready
[13:03:33 CDT(-0500)] <TonyUnicon> can you run this query for me?
[13:04:06 CDT(-0500)] <TonyUnicon> select * from elective where color_id not in (select id from color)
[13:06:23 CDT(-0500)] <pspaude> ok one second...
[13:09:09 CDT(-0500)] <pspaude> alright the demo site wasn't pure. My local will be up in a second, is linuxCI ok I might be able to get in there faster.
[13:09:53 CDT(-0500)] <TonyUnicon> its really the demo data im worried
[13:09:54 CDT(-0500)] <TonyUnicon> about
[13:09:58 CDT(-0500)] <TonyUnicon> you sure its not too much trouble?
[13:10:10 CDT(-0500)] <TonyUnicon> what did the demo db come back with?
[13:10:31 CDT(-0500)] <pspaude> Well the demo site was changed to art elective
[13:11:44 CDT(-0500)] <TonyUnicon> hmm ok
[13:11:55 CDT(-0500)] <TonyUnicon> i dont want to take up a lot of your time
[13:12:02 CDT(-0500)] <TonyUnicon> I can manually sift through the xml
[13:12:20 CDT(-0500)] <TonyUnicon> Dan mentioned there might be a bad reference in the demo data
[13:12:56 CDT(-0500)] <pspaude> No its not too much trouble almost in linux CI.
[13:13:16 CDT(-0500)] <TonyUnicon> linux has had the demo changeset set?
[13:13:21 CDT(-0500)] <TonyUnicon> ci linux that ius
[13:13:22 CDT(-0500)] <TonyUnicon> is*
[13:16:21 CDT(-0500)] <pspaude> Yep no results for linux CI. So, my local is almost up. It will be good I want to log some of the password stuff. uPortal.... :/
[13:19:54 CDT(-0500)] <TonyUnicon> yeah…boo to uportal
[13:27:15 CDT(-0500)] <pspaude> Ok no results for demo data for your query.
[13:27:30 CDT(-0500)] <TonyUnicon> sweet dude, thanks for your help, you saved me a good bit of time
[13:27:54 CDT(-0500)] <pspaude> No problem, no one should be forced to go through xml manually 
I think that is cruel and unusual punishment.
[13:28:57 CDT(-0500)] <TonyUnicon> yeah its no fun at all