You need to reply to all to make this back to the mailing list. Forwarding for the list.
Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL Maybe somebody can correct this? Wolfgang On Mon, Dec 18, 2017 at 8:30 AM, AC <gnuc...@acarver.net <mailto:gnuc...@acarver.net>> wrote: You misspelled AUTO_INCREMENT (note the underscore character). On 2017-12-17 23:03, Wolfgang Paul Rauchholz 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 > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> https://lists.gnucash.org/mailman/listinfo/gnucash-user <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. -- 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.
