PMA_token |s:32:"4a3c2b6526213c5921357e3174584270"; HMAC_secret |s:16:"A}7D{T]O@HPkPfJX";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1718401093;}encryption_key|s:32:"�NR"w�yu@NI�A�L��X'�L;�����z�";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.1";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:2:"es";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1718401003;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1718401003;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1708197993;s:9:"userprefs";a:2:{s:4:"lang";s:2:"es";s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:15:"server_1_ascacl";a:17:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:116:{i:0;s:11:"ascacl\_116";i:1;s:11:"ascacl\_223";i:2;s:11:"ascacl\_224";i:3;s:11:"ascacl\_240";i:4;s:10:"ascacl\_28";i:5;s:11:"ascacl\_342";i:6;s:11:"ascacl\_372";i:7;s:11:"ascacl\_433";i:8;s:11:"ascacl\_522";i:9;s:11:"ascacl\_535";i:10;s:11:"ascacl\_546";i:11;s:11:"ascacl\_552";i:12;s:11:"ascacl\_580";i:13;s:11:"ascacl\_621";i:14;s:11:"ascacl\_671";i:15;s:11:"ascacl\_712";i:16;s:11:"ascacl\_719";i:17;s:11:"ascacl\_737";i:18;s:11:"ascacl\_789";i:19;s:11:"ascacl\_872";i:20;s:11:"ascacl\_908";i:21;s:11:"ascacl\_921";i:22;s:11:"ascacl\_934";i:23;s:11:"ascacl\_970";i:24;s:15:"ascacl\_amlkncl";i:25;s:16:"ascacl\_cptvasdq";i:26;s:22:"ascacl\_dbgutd2gpzgefd";i:27;s:22:"ascacl\_dbpb6ax95xakvk";i:28;s:14:"ascacl\_dc2023";i:29;s:14:"ascacl\_dol294";i:30;s:14:"ascacl\_dol788";i:31;s:15:"ascacl\_doli129";i:32;s:15:"ascacl\_doli493";i:33;s:15:"ascacl\_doli595";i:34;s:15:"ascacl\_hesk328";i:35;s:15:"ascacl\_hesk415";i:36;s:15:"ascacl\_mood387";i:37;s:15:"ascacl\_mood446";i:38;s:15:"ascacl\_mood761";i:39;s:14:"ascacl\_prensa";i:40;s:11:"ascacl\_wp1";i:41;s:13:"ascacl\_wp116";i:42;s:13:"ascacl\_wp162";i:43;s:13:"ascacl\_wp164";i:44;s:13:"ascacl\_wp177";i:45;s:13:"ascacl\_wp188";i:46;s:13:"ascacl\_wp200";i:47;s:13:"ascacl\_wp203";i:48;s:13:"ascacl\_wp206";i:49;s:13:"ascacl\_wp246";i:50;s:12:"ascacl\_wp25";i:51;s:13:"ascacl\_wp254";i:52;s:13:"ascacl\_wp258";i:53;s:13:"ascacl\_wp275";i:54;s:13:"ascacl\_wp283";i:55;s:13:"ascacl\_wp286";i:56;s:13:"ascacl\_wp305";i:57;s:13:"ascacl\_wp314";i:58;s:13:"ascacl\_wp315";i:59;s:13:"ascacl\_wp330";i:60;s:13:"ascacl\_wp345";i:61;s:13:"ascacl\_wp348";i:62;s:13:"ascacl\_wp403";i:63;s:13:"ascacl\_wp406";i:64;s:13:"ascacl\_wp434";i:65;s:13:"ascacl\_wp448";i:66;s:12:"ascacl\_wp45";i:67;s:13:"ascacl\_wp472";i:68;s:11:"ascacl\_wp5";i:69;s:13:"ascacl\_wp501";i:70;s:13:"ascacl\_wp502";i:71;s:13:"ascacl\_wp505";i:72;s:13:"ascacl\_wp508";i:73;s:13:"ascacl\_wp512";i:74;s:13:"ascacl\_wp516";i:75;s:12:"ascacl\_wp52";i:76;s:13:"ascacl\_wp539";i:77;s:15:"ascacl\_wp54186";i:78;s:13:"ascacl\_wp600";i:79;s:13:"ascacl\_wp603";i:80;s:13:"ascacl\_wp606";i:81;s:13:"ascacl\_wp619";i:82;s:13:"ascacl\_wp621";i:83;s:13:"ascacl\_wp648";i:84;s:13:"ascacl\_wp649";i:85;s:13:"ascacl\_wp652";i:86;s:13:"ascacl\_wp660";i:87;s:13:"ascacl\_wp675";i:88;s:13:"ascacl\_wp682";i:89;s:13:"ascacl\_wp702";i:90;s:13:"ascacl\_wp706";i:91;s:13:"ascacl\_wp728";i:92;s:12:"ascacl\_wp73";i:93;s:13:"ascacl\_wp731";i:94;s:13:"ascacl\_wp736";i:95;s:12:"ascacl\_wp76";i:96;s:13:"ascacl\_wp769";i:97;s:13:"ascacl\_wp771";i:98;s:13:"ascacl\_wp772";i:99;s:13:"ascacl\_wp776";i:100;s:12:"ascacl\_wp80";i:101;s:13:"ascacl\_wp805";i:102;s:13:"ascacl\_wp816";i:103;s:13:"ascacl\_wp817";i:104;s:13:"ascacl\_wp837";i:105;s:13:"ascacl\_wp839";i:106;s:13:"ascacl\_wp855";i:107;s:12:"ascacl\_wp91";i:108;s:13:"ascacl\_wp923";i:109;s:13:"ascacl\_wp976";i:110;s:13:"ascacl\_wp977";i:111;s:13:"ascacl\_wp987";i:112;s:13:"ascacl\_wp999";i:113;s:15:"ascacl\_wp\_100";i:114;s:18:"ascacl\_wpcruce778";i:115;s:21:"ascacl\_wpmedioshehtk";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:14:"Bases de datos";s:3:"sql";s:3:"SQL";s:6:"status";s:13:"Estado actual";s:6:"rights";s:8:"Usuarios";s:6:"export";s:8:"Exportar";s:6:"import";s:8:"Importar";s:8:"settings";s:14:"Configuración";s:6:"binlog";s:16:"Registro binario";s:11:"replication";s:12:"Replicación";s:4:"vars";s:9:"Variables";s:7:"charset";s:20:"Juegos de caracteres";s:7:"plugins";s:12:"Complementos";s:6:"engine";s:7:"Motores";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:10:"Estructura";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Buscar";s:5:"query";s:20:"Generar una consulta";s:6:"export";s:8:"Exportar";s:6:"import";s:8:"Importar";s:9:"operation";s:11:"Operaciones";s:10:"privileges";s:11:"Privilegios";s:8:"routines";s:7:"Rutinas";s:6:"events";s:7:"Eventos";s:8:"triggers";s:12:"Disparadores";s:8:"tracking";s:11:"Seguimiento";s:8:"designer";s:10:"Diseñador";s:15:"central_columns";s:18:"Columnas centrales";}s:19:"profiling_supported";b:1;s:14:"mysql_cur_user";s:16:"ascacl@localhost";s:12:"is_superuser";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:15:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:0:{}}s:5:"query";a:5:{s:32:"f6f7780520f4761a8b74d24836599195";a:8:{s:3:"sql";s:66:"ALTER TABLE llxqn_expedition ADD COLUMN billed smallint DEFAULT 0;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"edf0dafaca2b51f1b7ee66019dd7fc74";a:8:{s:3:"sql";s:44:"SHOW TABLE STATUS WHERE Name='llxz7_ticket';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"855ec624d7f83ad4b02de64193c38474";a:8:{s:3:"sql";s:36:"SHOW FULL COLUMNS FROM llxz7_ticket;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"ea1a93f6b8aa4342e5a7408d6950cfe2";a:8:{s:3:"sql";s:85:"ALTER TABLE llxz7_ticket CONVERT TO CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"079d5f7ce81b8e1d5a3895c8c82a7075";a:8:{s:3:"sql";s:113:"ALTER TABLE llxz7_ticket MODIFY COLUMN column_name VARCHAR(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:20:"possible_as_geometry";b:0;s:18:"table_limit_offset";i:250;s:21:"table_limit_offset_db";s:14:"ascacl_doli647";}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}Import_message|a:2:{s:7:"message";s:2824:"<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>consulta SQL:</strong>  <a href="#" class="copyQueryBtn" data-text="CREATE TABLE `llxz7_accounting_account` (
  `rowid` bigint NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT &#039;1&#039;,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_pcg_version` varchar(32) NOT NULL,
  `pcg_type` varchar(60) DEFAULT NULL,
  `account_number` varchar(32) NOT NULL,
  `account_parent` int DEFAULT &#039;0&#039;,
  `label` varchar(255) NOT NULL,
  `labelshort` varchar(255) DEFAULT NULL,
  `fk_accounting_category` int DEFAULT &#039;0&#039;,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `active` tinyint NOT NULL DEFAULT &#039;1&#039;,
  `reconcilable` tinyint NOT NULL DEFAULT &#039;0&#039;,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_accounting_account` (`account_number`,`entity`,`fk_pcg_version`),
  KEY `idx_accounting_account_fk_pcg_version` (`fk_pcg_version`),
  KEY `idx_accounting_account_account_parent` (`account_parent`),
  CONSTRAINT `fk_accounting_account_fk_pcg_version` FOREIGN KEY (`fk_pcg_version`) REFERENCES `llxz7_accounting_system` (`pcg_version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;">Copiar</a>
    </p>
<p>
<code class="sql"><pre>
CREATE TABLE `llxz7_accounting_account` (
  `rowid` bigint NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_pcg_version` varchar(32) NOT NULL,
  `pcg_type` varchar(60) DEFAULT NULL,
  `account_number` varchar(32) NOT NULL,
  `account_parent` int DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `labelshort` varchar(255) DEFAULT NULL,
  `fk_accounting_category` int DEFAULT '0',
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `active` tinyint NOT NULL DEFAULT '1',
  `reconcilable` tinyint NOT NULL DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_accounting_account` (`account_number`,`entity`,`fk_pcg_version`),
  KEY `idx_accounting_account_fk_pcg_version` (`fk_pcg_version`),
  KEY `idx_accounting_account_account_parent` (`account_parent`),
  C[...]
</pre></code>
</p>
<p>
    <strong>MySQL ha dicho: </strong><a href="./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentación" alt="Documentación" class="icon ic_b_help"></a>
</p>
<code>#1826 - Duplicate foreign key constraint name &#039;fk_accounting_account_fk_pcg_version&#039;</code><br></div>";s:11:"go_back_url";s:70:"index.php?route=/database/import&db=ascacl_doli647&amp;no_history=true";}is_multi_query|b:0;sql_from_query_box|b:1;sql_history|a:5:{i:0;a:3:{s:2:"db";s:14:"ascacl_doli493";s:5:"table";s:0:"";s:8:"sqlquery";s:44:"SHOW TABLE STATUS WHERE Name='llxz7_ticket';";}i:1;a:3:{s:2:"db";s:14:"ascacl_doli493";s:5:"table";s:0:"";s:8:"sqlquery";s:36:"SHOW FULL COLUMNS FROM llxz7_ticket;";}i:2;a:3:{s:2:"db";s:14:"ascacl_doli493";s:5:"table";s:0:"";s:8:"sqlquery";s:85:"ALTER TABLE llxz7_ticket CONVERT TO CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci;";}i:3;a:3:{s:2:"db";s:14:"ascacl_doli493";s:5:"table";s:0:"";s:8:"sqlquery";s:36:"SHOW FULL COLUMNS FROM llxz7_ticket;";}i:4;a:3:{s:2:"db";s:14:"ascacl_doli493";s:5:"table";s:0:"";s:8:"sqlquery";s:85:"ALTER TABLE llxz7_ticket CONVERT TO CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci;";}}__upload_status|a:1:{s:7:"handler";s:47:"PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin";}errors|a:0:{}