Drupal and Mysql error

[pettinger.daniel12]

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'identifier' cannot be null: INSERT INTO {flood} (event, identifier, timestamp, expiration) VALUES db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => failed_login_attempt_ip [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 1313330465 [:db_insert_placeholder_3] => 1313334065 ) in flood_register_event() (line 1149 of /home/magna/public_html/drupal/includes/common.inc).

That is the message I recieved after logging on the morning. Everything has been fine recently and all of a sudden that popped up. I checked around the drupal forums to see what could be wrong but they aren't very clear, and since this happened after no changes, I was wondering if it was an issue with the server. The piece of code in question from the error is:

function flood_register_event($name, $window = 3600, $identifier = NULL) {
  if (!isset($identifier)) {
    $identifier = ip_address();
  }
  db_insert('flood')
    ->fields(array(
      'event' => $name,
      'identifier' => $identifier,
      'timestamp' => REQUEST_TIME,
      'expiration' => REQUEST_TIME + $window,
    ))
    ->execute();
}

with ->execute(); being line 1149.

Any ideas?

Regards,
Magna.

 

[pettinger.daniel12]

After a few chats with people on drupal, I found another person with the same error who is also with x10, and also used the softaculous installer.

Although nothing is confirmed yet, this may be the source of the error, and not providing ip_address() with a value. Any comments from x10?