Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-600

Column 'user_id' cannot be null [1048] (see #1781, #1834)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • None
    • 3.0.x
    • Viewing posts
    • None
    • PHP Environment:
      Database:

      Continued from here:

      http://www.phpbb.com/bugs/viewreport.php?b=1781" target="_blank
      http://www.phpbb.com/bugs/viewreport.php?b=1834" target="_blank

      Well Acyd, I wasn't sure if I should open a report on this again, but since I got this on a fresh installation (after inserting data such as posts and users) and I got a nice backtrace this time.. :roll:

      Although the "Dreamweaver bug" was real, it wasn't causing this error (apparently). It's got to do with auto pruning, that's why I don't always get the error.

      [phpBB Debug] PHP Notice: in file /includes/functions.php on line 1964: Undefined property: data
      [phpBB Debug] PHP Notice: in file /includes/functions.php on line 2025: Undefined index: file
      [phpBB Debug] PHP Notice: in file /includes/functions.php on line 2073: Undefined index: line
      Return to forum index
      General Error
      SQL ERROR [ mysql4 ]

      Column 'user_id' cannot be null [1048]

      SQL

      INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type) VALUES (NULL, '', 1148228816, 'LOG_AUTO_PRUNE', 'a:1:

      Unknown macro: {i}

      ', 0)

      BACKTRACE

      FILE: includes/db/mysql4.php
      LINE: 116
      CALL: dbal_mysql4->sql_error('INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation...')

      FILE: includes/functions.php
      LINE: 2000
      CALL: dbal_mysql4->sql_query('INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation...')

      FILE: includes/functions_admin.php
      LINE: 1733
      CALL: add_log('admin', 'LOG_AUTO_PRUNE', 'Report')

      FILE:
      LINE:
      CALL: auto_prune('24', 'posted', '0', '7', '1')

      Please notify the board administrator or webmaster : [..]@gmail.com
      Powered by phpBB © 2006 phpBB Group
      HTTP/1.1 200 OK Date: Sun, 21 May 2006 16:26:59 GMT Server: Apache/1.3.33 (Unix) mod_python/2.7.10 Python/2.2.2 mod_webapp/1.2.0-dev mod_perl/1.29 mod_throttle/3.1.2 PHP/4.4.1 FrontPage/5.0.2.2510 mod_ssl/2.8.22 OpenSSL/0.9.7d X-Powered-By: PHP/4.4.1 Cache-Control: private, no-cache="set-cookie", pre-check=0, post-check=0 Expires: 0 Pragma: no-cache Keep-Alive: timeout=10, max=996 Connection: Keep-Alive Transfer-Encoding: chunked Content-Type: text/html dee

            Acyd Burn Meik Sievertsen [X] (Inactive)
            ElbertF ElbertF
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: