Integrity constraint violation: 1048 Column 'uid' cannot be null. [#2627148]

Error while submitting the unsubscribe form.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'uid' cannot be null: INSERT INTO {unsubscribe} (uid, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => 1449042568 ) in unsubscribe_user_add() (line 386 of unsubscribe/unsubscribe.module).

Patch to fix this is attached.

Comment	File	Size	Author
#2	2627148-unsubscribe-undefined-mail.patch	664 bytes	vaibhav571
#2	7.x-1.x: PHP 5.3 & MySQL 5.5, D7 Patch Failed to Apply PHP 5.3 & MySQL 5.5, D7 Patch Failed to Apply

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

2 December 2015 at 08:02

vaibhav571 created an issue. See original summary.

Comment #2

vaibhav571 CreditAttribution: vaibhav571 as a volunteer commented 2 December 2015 at 08:03

File	Size
2627148-unsubscribe-undefined-mail.patch	664 bytes
7.x-1.x: PHP 5.3 & MySQL 5.5, D7 Patch Failed to Apply PHP 5.3 & MySQL 5.5, D7 Patch Failed to Apply

Comment #3

Maedi CreditAttribution: Maedi commented 26 May 2018 at 13:27

Priority:

Normal

» Critical

No question about it, the line...

$mail = $form_state['values']['mail'];

...must be in the function for the module to work.

+1 for this patch/adding in the line. It fixes an otherwise broken module.

Comment #4

oemb29 CreditAttribution: oemb29 commented 19 April 2023 at 19:31

I added the line Worked but displays this issue:

Warning: array_flip(): Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->load() (line 175 of /home/xx/public_html/x/includes/entity.inc).
Warning: array_flip(): Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->cacheGet() (line 388 of /home/xx/public_html/x/includes/entity.inc).
Notice: Trying to get property of non-object in unsubscribe_user_check() (line 331 of /home/xx/public_html/x/sites/all/modules/unsubscribe/unsubscribe.module).