Does that happen when you try to save from within gnucash? Colin
On 18 Dec 2017 7:19 a.m., "Wolfgang Paul Rauchholz" <wp.rauchh...@gmail.com> wrote: My config: Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64 Setting up the database on my home server. Will connect fomr laptops in the network onto mariadb. When trying to execute this command. CREATE TABLE slots ( id integer PRIMARY KEY AUTOINCREMENT NOT NULL, obj_guid CHAR(32) NOT NULL, name text(4096) NOT NULL, slot_type integer NOT NULL, int64_val integer, string_val text(4096), double_val real, timespec_val CHAR(14), guid_val CHAR(32), numeric_val_num integer, numeric_val_denom integer ); I get this error. I can't find anything in google, so I'd hoped I get some help here. Thank you ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL, obj_guid CHAR(32) NOT NULL, name tex' at line 2 Thansk for your help -- Wolfgang Rauchholz _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.