Running the SQL in this update will at present give us "User warning: Unknown column role_expire.rid ..." on MySQL 5.1.

The SQL should be "SELECT re.rid... " not "SELECT role_expire.rid..." as once you alias a table in the FROM clause, you have to refer to it by the alias.

CommentFileSizeAuthor
#1 role_expire-fix_update_function-817002-0.patch815 bytesMark Theunissen

Comments

Mark Theunissen’s picture

Mark Theunissen commented
StatusFileSize
new role_expire-fix_update_function-817002-0.patch815 bytes
stewsnooze’s picture

stewsnooze
he / him
commented

This patch doesn't apply as it was taken from the Drupal root, not the module root. (i.e. role_expire/)

However I've applied it manually

stewsnooze’s picture

stewsnooze
he / him
commented
Status: Active » Reviewed & tested by the community

Committed to CVS HEAD

Mark Theunissen’s picture

Mark Theunissen commented

Woops, and thanks!

sharplesa’s picture

sharplesa commented
Status: Reviewed & tested by the community » Closed (fixed)

Closing based on Stew's comment #3 above.