the "Save draft" button returns an SQL error

[Viredae]

I have recently restored and updated my forum into 3.2.x after a catastrophic failure broke it, and everything has been fine for a while now, but a user just sent me a message about him getting an error when trying to save a draft for a post, I tried to recreate the error and this is what I got:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Field 'draft_id' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_drafts (user_id, topic_id, forum_id, save_time, draft_subject, draft_message) VALUES (2, 0, 5, 1602772358, 'test topic', '<t>this is a test</t>')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/posting.php
LINE: 760
CALL: phpbb\db\driver\factory->sql_query()

I of course did the standard search to be safe, but I suspect it might have something to do with the above, any idea what the first steps to resolving this might be?

[ViolaF]

https://www.phpbb.de/community/viewtopi ... 7#p1395687

[Brf]

This is the same problem you had with the log_id column a few weeks ago.

[Viredae]

Ok, it's fixed, thanks for the help, and I should have probably considered that solution.