Hello,

i get still the User Warning with the Version 06 :(

user warning: Column 'acted_upon' cannot be null query: INSERT INTO node_invites ( iid, nid ,email_invitee ,uid_inviter ,status ,sent ,acted_upon ,notes_invitee ,notes_inviter ) VALUES

Can you help me?

CommentFileSizeAuthor
#1 node_invite.install.patch478 bytesshaisachs

Comments

shaisachs’s picture

StatusFileSize
new478 bytes

Given the comments in #291587: User Warning as well as the update statements added in 5.x-0.2 and 5.x-0.3, my guess is that the preferred approach is to change the acted_upon column so that it is an int which defaults to null, rather than a not null int column. It looks like this approach was added to the _update functions, but not to the _install function, meaning that if you had started with 5.x-0.1 and upgraded up to 5.x-0.6, the code would work for you fine, but if you had installed 5.x-0.6 from scratch, then you'd get the error message.

The attached patch fixes the install file to use the approach found in the 5.x-0.3 update function. You will have to uninstall node_invite and then reinstall it to get it to work. That will wipe out your node_invite data, so if you have some node invitation data you care about, just issue this command to mysql instead of uninstalling node_invite:

ALTER TABLE node_invites CHANGE acted_upon acted_upon INT(11) UNSIGNED DEFAULT NULL

shaisachs’s picture

Status: Active » Needs review

Whoops, forgot to update the status. I've tested this approach and it prevents the error message.

hadsie’s picture

Version: 5.x-0.6 » 5.x-1.0

I've just applied this patch to the 5.x branch. Not too many people are using it anymore but thought it would be good to anyhow. Thanks for the patch @shaisachs!

hadsie’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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