posta17@orsenigo.it
New member
So cercando di installare su un db la nuova versione di dadabik appena ricevuta (8.0 Lerici PRO)
Ottengo questo errore:
On-line registration done......your installation code is:
[08] Error: during query execution. CREATE TABLE dbik_table_list ( name_table varchar(255) NOT NULL default '' PRIMARY KEY, allowed_table varchar(1) NOT NULL default '', enable_insert_table varchar(1) NOT NULL default '', enable_edit_table varchar(1) NOT NULL default '', enable_delete_table varchar(1) NOT NULL default '', enable_details_table varchar(1) NOT NULL default '', enable_list_table varchar(1) NOT NULL default '', enable_delete_authorization_table varchar(1) NOT NULL default '0', enable_update_authorization_table varchar(1) NOT NULL default '0', enable_browse_authorization_table varchar(1) NOT NULL default '0', alias_table varchar(255) NOT NULL default '', enable_template_table varchar(1) NOT NULL default '0', template_table text NOT NULL, menu_order_table INT NOT NULL default '1', menu_parent_table VARCHAR(255) NOT NULL DEFAULT 'top', separator_before_table CHAR(1) NOT NULL DEFAULT 'n', pk_field_table varchar(500) NOT NULL default '') ENGINE=InnoDB
The DBMS server said: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Linux Debian "stretch"
Apache 2.4.25
Php 7.0.19
MySql 5.8 (MariaDb 10.1.23)
Grazie per l'aiuto
Michele Orsenigo
Ottengo questo errore:
On-line registration done......your installation code is:
[08] Error: during query execution. CREATE TABLE dbik_table_list ( name_table varchar(255) NOT NULL default '' PRIMARY KEY, allowed_table varchar(1) NOT NULL default '', enable_insert_table varchar(1) NOT NULL default '', enable_edit_table varchar(1) NOT NULL default '', enable_delete_table varchar(1) NOT NULL default '', enable_details_table varchar(1) NOT NULL default '', enable_list_table varchar(1) NOT NULL default '', enable_delete_authorization_table varchar(1) NOT NULL default '0', enable_update_authorization_table varchar(1) NOT NULL default '0', enable_browse_authorization_table varchar(1) NOT NULL default '0', alias_table varchar(255) NOT NULL default '', enable_template_table varchar(1) NOT NULL default '0', template_table text NOT NULL, menu_order_table INT NOT NULL default '1', menu_parent_table VARCHAR(255) NOT NULL DEFAULT 'top', separator_before_table CHAR(1) NOT NULL DEFAULT 'n', pk_field_table varchar(500) NOT NULL default '') ENGINE=InnoDB
The DBMS server said: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Linux Debian "stretch"
Apache 2.4.25
Php 7.0.19
MySql 5.8 (MariaDb 10.1.23)
Grazie per l'aiuto
Michele Orsenigo