Closed Thread
Results 1 to 2 of 2

Thread: Drupal and Mysql error

  1. #1
    pettinger.daniel12 is offline x10Hosting Member pettinger.daniel12 is an unknown quantity at this point
    Join Date
    May 2011
    Posts
    8

    Drupal and Mysql error

    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:

    Code:
    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.

  2. #2
    pettinger.daniel12 is offline x10Hosting Member pettinger.daniel12 is an unknown quantity at this point
    Join Date
    May 2011
    Posts
    8

    Exclamation Re: Drupal and Mysql error

    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?

Closed Thread

Similar Threads

  1. MySql Server for Drupal
    By vicho11 in forum Free Hosting
    Replies: 2
    Last Post: 02-16-2011, 07:15 PM
  2. MySQL / Drupal suspension problems
    By ianspringham in forum Free Hosting
    Replies: 0
    Last Post: 10-01-2010, 02:01 AM
  3. Timeouts when Drupal tries to access MySQL
    By jhahoney in forum Scripts & 3rd Party Apps
    Replies: 0
    Last Post: 09-13-2010, 02:40 PM
  4. MySQL Problem on drupal
    By icywind in forum Free Hosting
    Replies: 6
    Last Post: 12-26-2009, 06:55 AM
  5. [AdFree] Drupal and MySQL connection
    By _eti_ in forum Free Hosting
    Replies: 6
    Last Post: 12-06-2007, 12:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers