Modules used: Occurs in both: 7.x-1.0-beta30 and 7.x-1.x-dev; 2014-Jan-23
Re: Leaving the "User Relationships Role Names to integrate with" field blank in drupalchat settings, will crash the entire server.

Issue:

By not having anything in the field for "User Relationships Role Names to integrate with" and by having "Relationship method=User relationship Module", then once you save it, it will immediately crash Drupal with an error.

"PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064/
..... in user_relationships_load() (line 780 of.... /user_relationships"

The only way I could fix my mistake, was to go into the backend of the SQL and disable
the DrupalChat. This brought the website back. However, I then had to immediately
delete the drupalchat from module folder, clear the cache, and reput it back in.
Then I could access the drupalchat configuration, to fix my mistake and put in the correct
user relationships into the drupalchat settings.

I think there should be something that gives a warning when trying to save if that
field is blank, some type of error like "Field can not be left blank, otherwise it will happily crash Drupal".

Comments

  • darklrd committed d3969f7 on 7.x-1.x
    Issue #2187119 by darklrd: Blank Relationship field will crash drupal
    
darklrd’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

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