sql schema error

  • I had a problem with a new install of 2.2.27. PHP 7.2, MariaDB 8.0.18.


    I was giving my a bad syntax error on this query:


    INSERT INTO __calendars (id,name,color,private,feed,system, type, restricted, affiliation) VALUES ('1','Raids','#00628c','0',NULL,'1', '1', '1', 'core');


    Turns out "system" and maybe "type" are reserved words in mariadb and must be surrounded with backticks. It has been a minute since I've used mysql proper, but I suspect they are reserved there as well. I know system at least is reserved in Postgres. Any backticks are the fix for the three __calendars insert statements, like this.


    INSERT INTO __calendars (id,name,color,private,feed,`system`, `type`, restricted, affiliation) VALUES ('1','Raids','#00628c','0',NULL,'1', '1', '1', 'core');


  • Won't be fixed for the 2.2 branch, as this has already been fixed with the 2.3 branch.

    Viele Grüße,
    GodMod


    Bitte sendet mir keine unaufgeforderten Support-PNs. | Please don't send me unwanted support-PMs.
    Du willst dich bei mir bedanken: | You want to thank me:

    amazon_wishlist.jpg paypal_logo.jpg

  • GodMod

    Added the Label Bug
  • GodMod

    Added the Label Not planned

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!