You shouldn't have a comma after displayname
and :fullname
, and before the ending parenthesis.
. . .
user_nicename,
display_name, <-- superfluous comma
)
VALUES (
. . .
:fullname,
:fullname, <-- superfluous comma
)"
Some languages (e.g. PHP and Perl) permit commas after the last element in a list, but SQL does not.