MyBB Community Forums
Default Value - mybb_mysubs - Printable Version

+- MyBB Community Forums (
+-- Forum: Extensions (
+--- Forum: Plugins (
+---- Forum: Plugin Support (
+---- Thread: Default Value - mybb_mysubs (/thread-230052.html)

Default Value - mybb_mysubs - piii - 2020-11-05

1364 - Field 'order' doesn't have a default value

I tried doing this command - 

alter table mybb_mysubs alter order set default 0;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order set default 0' at line 1

RE: Default Value - mybb_mysubs - GodLess101 - 2020-11-11

I recommend you google SQL Queries before trying to run them.

'order' is a reserved keyword, and therefore is not interpreted as a 'column' like how you see it.

You would have to enclose it in single brackets or like this order, as such, it would look similar to:
ALTER TABLE mybb_mysubs ALTER `order` SET DEFAULT 0;