Re: errir in SQL syntax

2017-12-18 Thread John Ralls
> On Dec 18, 2017, at 8:29 AM, AC wrote: > > 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? That page documents the SQL sc

Fwd: Re: errir in SQL syntax

2017-12-18 Thread AC
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 mailto:gnuc...@acarver.net>> wrote: You miss

Re: errir in SQL syntax

2017-12-17 Thread Colin Law
Does that happen when you try to save from within gnucash? Colin On 18 Dec 2017 7:19 a.m., "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 e

Re: errir in SQL syntax

2017-12-17 Thread AC
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 t

errir in SQL syntax

2017-12-17 Thread Wolfgang Paul Rauchholz
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_guidCHAR(32) N