hmsiccbl / screensaver1

Screensaver Version 1 - End of life on December 1, 2018
GNU General Public License v2.0
3 stars 3 forks source link

Error when attempting first login with 'dev' user #170

Closed jgrundstad closed 8 years ago

jgrundstad commented 8 years ago

Hi, I'm running into this error when attempting a first login with the 'dev' user. Please let me know if there is any other info I can gather.

Thanks!


From the site -

Login failed! (sorry) Based upon the user ID and password you provided, we are not yet sure of who you are. In keeping with our policy of protecting data from unauthorized users, we cannot give you the benefit of the doubt and let you into this system. Instead, we must ask that you try once again to tell us who you are. Try again I am having trouble logging into Screensaver

From the Tomcat logs:

2015-12-17 20:18:49,264  WARN hibernate.util.JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42703
2015-12-17 20:18:49,270 ERROR hibernate.util.JDBCExceptionReporter:234 - ERROR: column screensave0_.gender does not exist
  Position: 435
2015-12-17 20:18:49,279  INFO util.servlet.EntityViewerInitializerPhaseListener:36 - intercepted javax.faces.event.PhaseEvent[source=org.apache.myfaces.lifecycle.LifecycleImpl@31285907]

There doesn't appear to be any reference to 'gender' in the screensaver_user table...

                        Table "public.screensaver_user"
                Column                |            Type             | Modifiers
--------------------------------------+-----------------------------+-----------
 screensaver_user_id                  | integer                     | not null
 version                              | integer                     | not null
 date_created                         | timestamp without time zone | not null
 first_name                           | text                        | not null
 last_name                            | text                        | not null
 email                                | text                        |
 phone                                | text                        |
 mailing_address                      | text                        |
 comments                             | text                        |
 login_id                             | text                        |
 digested_password                    | text                        |
 ecommons_id                          | text                        |
 harvard_id                           | text                        |
 harvard_id_expiration_date           | date                        |
 harvard_id_requested_expiration_date | date                        |
 created_by_id                        | integer                     |
 date_loaded                          | timestamp without time zone |
 date_publicly_available              | timestamp without time zone |