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

MS SQL issue when creating tables with 3.0.5 db_tools

XMLWordPrintable

      SQL ERROR [ mssql_odbc ]
       
      [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'test_id', table 'phpbb_validation.dbo.phpbb_test'; column does not allow nulls. INSERT fails. [23000]
       
      SQL
       
      INSERT INTO phpbb_test (test_text, test_bool, test_time) VALUES ('This is a test message.', 1, 1236314346)

      This was generated when DavidIQ tested the svn version of UMIL with the example files we have in the documentation. I copied the sql_create_table function from db_tools to UMIL since it was much nicer than what we had.

      The test_id field that the table was created with was:

      'test_id'		=> array('UINT', NULL, 'auto_increment'),

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

              Created:
              Updated:
              Resolved: