<div dir="ltr"><div>Hi!<br></div><div><br></div><div>I found a couple of problems in the most recent version of cqpweb.<br></div><div></div><div>The file: cqpweb/lib/sql-definitions.php</div><div><br></div><div>1) The problem is somewhere near &quot;TYPE_DT_DATE, TYPE_DT_TIME&quot;:<br></div><div>        CREATE TABLE `metadata_template_info` (<br>                        `id`                         int unsigned NOT NULL AUTO_INCREMENT,<br>                        `description`                varchar(255) CHARSET utf8mb4 collate utf8mb4_unicode_520_nopad_ci default &#39;&#39;,<br>                        `primary_classification`     varchar(64)      CHARSET ascii COLLATE ascii_bin default NULL,<br>                        primary key (`id`) TYPE_DT_DATE, TYPE_DT_TIME<br>                ) ENGINE=InnoDB  <br></div>        /* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 104 | 2021-Feb-15 10:26 */&lt;/p&gt;<br>&lt;p class=&quot;errormessage&quot;&gt;Error # 1064: 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 &#39; TYPE_DT_TIME<br><div>                ) ENGINE=InnoDB  <br></div><div><br></div><div><br></div><div>2) In this case it seems one comma is missed:<br></div><div>        CREATE TABLE `saved_restrictions` (<br>                        `id`                         bigint unsigned NOT NULL AUTO_INCREMENT,<br>                        `corpus_id`                  int unsigned NOT NULL,<br>                        `cache_time`                 int unsigned NOT NULL default 0,<br>                        `serialised_restriction`     text CHARSET utf8mb4 collate utf8mb4_nopad_bin,<br>                        `size_bytes`                 bigint unsigned NOT NULL default 0,<br>                        `n_ids`                      int unsigned NOT NULL default 0,<br>                        `n_items`                    int unsigned NOT NULL default 0,<br>                        `n_tokens`                   bigint unsigned NOT NULL default 0,<br>                        `data`                       longblob,<br>                        key (`corpus_id`),<br>                        key (`serialised_restriction`(191)),<br>                        key (`cache_time`)<br>                        primary key (`id`)<br>                ) ENGINE=InnoDB  <br></div><div>        /* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 104 | 2021-Feb-15 10:32 */&lt;/p&gt;<br>&lt;p class=&quot;errormessage&quot;&gt;Error # 1064: 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 &#39;primary key (`id`)<br>                ) ENGINE=InnoDB  <br></div><div><br></div><div><br></div><div></div><div>With best wishes,</div><div>Mansur<br></div><div></div><div><br></div><div><br></div></div>