the "Save draft" button returns an SQL error

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Viredae
Registered User
Posts: 9
Joined: Tue Sep 22, 2020 11:52 pm

the "Save draft" button returns an SQL error

Post by 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?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52139
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: the "Save draft" button returns an SQL error

Post by Brf »

This is the same problem you had with the log_id column a few weeks ago.
Viredae
Registered User
Posts: 9
Joined: Tue Sep 22, 2020 11:52 pm

Re: the "Save draft" button returns an SQL error

Post by Viredae »

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

Return to “[3.2.x] Support Forum”