Attempting to use the samples in the Databases block, I converted
everything (I thought) to use a MySQL db and am able to add and delete
groups just fine.
However, adding a new user gives this:
"Syntax error or access violation, message from server: "You have an
error in your SQL syntax. Chec
Let me put it another way.
I changed this...
create table user (
uid integer identity primary key,
name varchar(50),
firstname varchar(50),
uname varchar(20),
unique (uname)
);
create table groups (
gid integer identity primary key,
gname
look for element "autoincrement-modules" in cocoon.xconf
> ="Syntax error or access violation, message from server: "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 'CALL IDENTITY()'
> at line 1""
>
> N