The website encountered an unexpected error. Please try again later.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'renew' at row 1: INSERT INTO {cas_server_ticket_store} (id, expiration, type, session, user, service, renew) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => ST-xlgayJucBa3-VIwENA2Ncaei7OGxiq9yXuJAP0HNm9I [:db_insert_placeholder_1] => 2016-10-05 17:39:30 [:db_insert_placeholder_2] => service [:db_insert_placeholder_3] => zbHymxpMzyKNOmpzlMiC09yUiZ2zXp0t_eDAa5EQT10 [:db_insert_placeholder_4] => ajay [:db_insert_placeholder_5] => http://example-one.localhost/casservice?returnto=http://example-one.loca... [:db_insert_placeholder_6] => ) in Drupal\cas_server\Ticket\TicketFactory->createServiceTicket() (line 94 of modules/contrib/cas_server/src/Ticket/TicketFactory.php).

While trying to logout from Site, encountered an unexpected error.

CommentFileSizeAuthor
#3 renew.patch1.54 KByalet
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

ajay_reddy created an issue. See original summary.

ajay_reddy’s picture

ajay_reddy
Location Fremont, California, USA
CreditAttribution: ajay_reddy as a volunteer and at Valuebound for Drupal Bangalore Community commented
Title: Unexpexted while trying to logout » Unexpected error while trying to logout
yalet’s picture

yalet CreditAttribution: yalet commented
FileSize
renew.patch1.54 KB

This doesn't look a logout error, it looks like a login error, when a service ticket is trying to be inserted. Can you give steps to reproduce?

I've attached a patch that should take care of the error in that message.

ajay_reddy’s picture

ajay_reddy
Location Fremont, California, USA
CreditAttribution: ajay_reddy as a volunteer and at Valuebound for Drupal Bangalore Community commented
Status: Active » Reviewed & tested by the community

Yes, its in login.
Ty for patch.

mahaveer003’s picture

mahaveer003 CreditAttribution: mahaveer003 as a volunteer and at Valuebound commented

@yalet Thanks For Patch Works for me Also Please add this patch in next release.

UnsettlingTrend’s picture

UnsettlingTrend
Primary language English
CreditAttribution: UnsettlingTrend as a volunteer commented

Would be nice if this patch would get committed; same problem and fix for me!

budalokko’s picture

budalokko CreditAttribution: budalokko commented

It worked for me too.

As a bonus motivation for comitting this, I'd say it solves #2819351: Fails to save service ticket, invalid value for renew column too. The patch there is nearly the same.

j_ten_man’s picture

j_ten_man CreditAttribution: j_ten_man commented
Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.