MyBB Community Forums
Default Value - mybb_mysubs - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Extensions (https://community.mybb.com/forum-201.html)
+--- Forum: Plugins (https://community.mybb.com/forum-73.html)
+---- Forum: Plugin Support (https://community.mybb.com/forum-72.html)
+---- 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;
Result: 
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;