20% OFF para compra e renovação →

Mensagens Recentes

Páginas: [1] 2 3 ... 10
1
Formulários / Re:Criticar Saldos em formularios de multiplos registros
« Última Mensagem: por Edivaldo Online Hoje às07:36:02 pm »
Coluna Valor total = Qt_Total * Preço_Unitario
Assim teria

Coluna Acunulado do Mes = Qt_Anterior + Qt_Periodo
Coluna do Saldo ate o mes = Qt_total - Acumulado_mes

e para o financeiro é a mesma coisa so criar columa_anterior_financeira
.....

Tenho algumas planilhas em excel se quizer posso te enviar
2
Formulários / Re:Erro na Geração de Forms
« Última Mensagem: por Edivaldo Online Hoje às07:21:26 pm »
Oi Colega

Ja vi aqui no forum alguma coisa sobre o call, da uma olhada neste link:
https://forum.scriptcase.com.br/index.php?topic=12591.0

Espero que ajude
3
Banco de Dados / Re:deletado todos registro problema
« Última Mensagem: por Kleyber Online Hoje às02:44:41 pm »
Acho que isso é erro no script. Faça mais testes com esse script pra ver o que acontece.
4
Banco de Dados / Re:deletado todos registro problema
« Última Mensagem: por jose_rsantos Online Hoje às02:21:47 pm »
Então
Alexandre Pereira
estou utilizando o truncate e mesmo assim persiste esta questão ....
5
Banco de Dados / Re:deletado todos registro problema
« Última Mensagem: por Alexandre Pereira Bühler Online Hoje às02:15:05 pm »
Truncate não seria mais eficiente?
Logically, TRUNCATE TABLE is equivalent to a DELETE statement that deletes all rows, but there are practical differences under some circumstances.
https://mariadb.com/kb/en/library/truncate-table/
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
https://www.mainelydesign.com/blog/view/difference-between-truncate-empty-delete-from-in-mysql

6
Formulários / Teclas de atalhos do scriptcase Tools 9
« Última Mensagem: por Edivaldo Online Hoje às01:00:09 pm »
Bom dia

Colegas onde encotro as teclas de atalhos da estessão scriptcase Tools que foram incorporadas na versão 9

Agradecido
7
Banco de Dados / deletado todos registro problema
« Última Mensagem: por jose_rsantos Online Hoje às10:22:53 am »
Pessoal , estou tentando e não consegui encontrar a resposta, tenho um script em php que quando incia o processo, deve deletar todos os registros da tabela, até ai tudo bem acontece, mas  de vez em quando, a tabela deleta todos os registro mais volta a criar registros com campos null

mesmo deletado os registro por gerenciador de banco de dados como phpadmim ou mysql-font utilizando o comando empty, a tabela persiste e criar varios registro com campos null

já deletei a tabela e recriei a estrutura mais quando recrio a tabela já vei com mesmo problema.
 
8
Menu / Menu Árvore / Re:Plano de contas em árvore
« Última Mensagem: por driver123 Online Hoje às06:14:04 am »
Eu uso menu dinâmico.


Oi Pessoal

Eu já vi em alguns sistemas concorrentes o uso de planos de contas em formato de árvore, onde o usuario vai clicando no nivel mais alto, e vai abrindo as abas dos niveis inferiores.

Tem alguma forma de fazer isso ligado a um campo de um formulario?



บาคาร่า Gclub แทงบอล Sbobet
Eu também.
9
Configuração PHP / Ambiente / Performance / SC9 não está importando projetos
« Última Mensagem: por rrma Online Novembro 17, 2018, 03:40:47 pm »
Bom dia a todos.

Tinha o SC9 local e decidi migrar para um vps, a fim de testar a performance dele online.

Ambiente do servidor:
Ubuntu 18.04
Php 7.0
Mysql 5.7

DIagnosis não apresenta nenhum erro, SC abre, cria projetos, aplicações, tudo normal, exceto pela importação de projetos.

Ele faz o upload do zip, fica girando o logo SC um tempão e volta para o campo de selecionar projeto sem fazer mais nada.

Acompanhei os logs do mysql:

Código: [Selecionar]
root@SC9:/var/log# tail -f /var/log/mysql/mysql.log
/usr/sbin/mysqld, Version: 5.7.23-0ubuntu0.18.04.1-log ((Ubuntu)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
2018-11-17T18:24:59.070316Z     2 Connect root@localhost on sc9 using Socket
2018-11-17T18:24:59.071055Z     2 Init DB sc9
2018-11-17T18:24:59.073520Z     2 Query DELETE FROM sc_tbati WHERE Ultimo_Acesso < '1542477299' AND Attr1 LIKE '%s:14:\"keep_me_logged\";s:1:\"N\";%'
2018-11-17T18:24:59.180172Z     2 Query SELECT COUNT(*) FROM sc_tbati WHERE Login = 'rodrigo' AND IP = '8c71fa16e565101' AND Attr1 LIKE '%s:10:\"session_id\";s:26:\"kqu5b8eukb4fl8jcriob5oq3l0\";%' AND Attr1 LIKE '%s:2:\"ip\";s:14:\"187.21.133.192\";%'
2018-11-17T18:24:59.180690Z     2 Query SELECT COUNT(*) FROM sc_tbati
2018-11-17T18:24:59.181040Z     2 Query UPDATE sc_tbati SET Ultimo_Acesso = '1542479099', Pagina = '10303', Cod_Prj = 'project', Cod_Apl = '', Campo = '' WHERE Login = 'rodrigo' AND Attr1 LIKE '%s:10:\"session_id\";s:26:\"kqu5b8eukb4fl8jcriob5oq3l0\";%' AND Attr1 LIKE '%s:2:\"ip\";s:14:\"187.21.133.192\";%'
2018-11-17T18:24:59.186440Z     2 Quit
2018-11-17T18:27:37.082163Z     3 Connect root@localhost on sc9 using Socket
2018-11-17T18:27:37.082435Z     3 Init DB sc9
2018-11-17T18:27:37.084810Z     3 Query DELETE FROM sc_tbati WHERE Ultimo_Acesso < '1542477457' AND Attr1 LIKE '%s:14:\"keep_me_logged\";s:1:\"N\";%'
2018-11-17T18:27:37.178827Z     3 Query SELECT COUNT(*) FROM sc_tbati WHERE Login = 'rodrigo' AND IP = '8c71fa16e565101' AND Attr1 LIKE '%s:10:\"session_id\";s:26:\"kqu5b8eukb4fl8jcriob5oq3l0\";%' AND Attr1 LIKE '%s:2:\"ip\";s:14:\"187.21.133.192\";%'
2018-11-17T18:27:37.179335Z     3 Query SELECT COUNT(*) FROM sc_tbati
2018-11-17T18:27:37.179618Z     3 Query UPDATE sc_tbati SET Ultimo_Acesso = '1542479257', Pagina = '10303', Cod_Prj = 'project', Cod_Apl = '', Campo = '' WHERE Login = 'rodrigo' AND Attr1 LIKE '%s:10:\"session_id\";s:26:\"kqu5b8eukb4fl8jcriob5oq3l0\";%' AND Attr1 LIKE '%s:2:\"ip\";s:14:\"187.21.133.192\";%'
2018-11-17T18:27:37.183558Z     3 Quit
2018-11-17T18:28:18.441803Z     4 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:28:18.442341Z     5 Connect root@localhost on  using Socket
2018-11-17T18:28:18.442566Z     5 Query SELECT @@version, @@version_comment
2018-11-17T18:28:18.442852Z     5 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:28:18.443022Z     5 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:28:18.443252Z     5 Query SET lc_messages = 'pt_PT'
2018-11-17T18:28:18.447063Z     4 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'server%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:28:18.450182Z     4 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'server%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:28:18.451366Z     5 Quit
2018-11-17T18:28:18.451543Z     4 Quit
2018-11-17T18:30:16.508861Z     6 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:30:16.509206Z     7 Connect root@localhost on  using Socket
2018-11-17T18:30:16.509373Z     7 Query SELECT @@version, @@version_comment
2018-11-17T18:30:16.509619Z     7 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:30:16.509747Z     7 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:30:16.509857Z     7 Query SET lc_messages = 'pt_PT'
2018-11-17T18:30:16.511669Z     7 Init DB sc9
2018-11-17T18:30:16.511950Z     7 Query SELECT CURRENT_USER()
2018-11-17T18:30:16.512322Z     7 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:16.512792Z     7 Query SELECT @@lower_case_table_names
2018-11-17T18:30:16.513008Z     7 Query SELECT *,
                `TABLE_SCHEMA`       AS `Db`,
                `TABLE_NAME`         AS `Name`,
                `TABLE_TYPE`         AS `TABLE_TYPE`,
                `ENGINE`             AS `Engine`,
                `ENGINE`             AS `Type`,
                `VERSION`            AS `Version`,
                `ROW_FORMAT`         AS `Row_format`,
                `TABLE_ROWS`         AS `Rows`,
                `AVG_ROW_LENGTH`     AS `Avg_row_length`,
                `DATA_LENGTH`        AS `Data_length`,
                `MAX_DATA_LENGTH`    AS `Max_data_length`,
                `INDEX_LENGTH`       AS `Index_length`,
                `DATA_FREE`          AS `Data_free`,
                `AUTO_INCREMENT`     AS `Auto_increment`,
                `CREATE_TIME`        AS `Create_time`,
                `UPDATE_TIME`        AS `Update_time`,
                `CHECK_TIME`         AS `Check_time`,
                `TABLE_COLLATION`    AS `Collation`,
                `CHECKSUM`           AS `Checksum`,
                `CREATE_OPTIONS`     AS `Create_options`,
                `TABLE_COMMENT`      AS `Comment`
            FROM `information_schema`.`TABLES` t
            WHERE `TABLE_SCHEMA` COLLATE utf8_bin
                IN ('sc9')
                 ORDER BY Name ASC LIMIT 250 OFFSET 0
2018-11-17T18:30:16.528679Z     7 Query SHOW MASTER STATUS
2018-11-17T18:30:16.529072Z     7 Query SHOW SLAVE STATUS
2018-11-17T18:30:16.535134Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbapl`
2018-11-17T18:30:16.536436Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbapl'  ORDER BY version DESC
2018-11-17T18:30:16.538550Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbapl'
2018-11-17T18:30:16.538997Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbati`
2018-11-17T18:30:16.539456Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbati'  ORDER BY version DESC
2018-11-17T18:30:16.539749Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbati'
2018-11-17T18:30:16.540135Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbcmp`
2018-11-17T18:30:16.540663Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbcmp'  ORDER BY version DESC
2018-11-17T18:30:16.540971Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbcmp'
2018-11-17T18:30:16.541270Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbconex`
2018-11-17T18:30:16.542693Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbconex'  ORDER BY version DESC
2018-11-17T18:30:16.542996Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbconex'
2018-11-17T18:30:16.543306Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbevt`
2018-11-17T18:30:16.543789Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbevt'  ORDER BY version DESC
2018-11-17T18:30:16.544062Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbevt'
2018-11-17T18:30:16.544347Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbgroup`
2018-11-17T18:30:16.544767Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbgroup'  ORDER BY version DESC
2018-11-17T18:30:16.545037Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbgroup'
2018-11-17T18:30:16.545318Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tblog`
2018-11-17T18:30:16.545786Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tblog'  ORDER BY version DESC
2018-11-17T18:30:16.546060Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tblog'
2018-11-17T18:30:16.546399Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tblog_apl`
2018-11-17T18:30:16.546861Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tblog_apl'  ORDER BY version DESC
2018-11-17T18:30:16.547139Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tblog_apl'
2018-11-17T18:30:16.547416Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tblog_cmp`
2018-11-17T18:30:16.547879Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tblog_cmp'  ORDER BY version DESC
2018-11-17T18:30:16.548144Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tblog_cmp'
2018-11-17T18:30:16.548420Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tblog_evt`
2018-11-17T18:30:16.548894Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tblog_evt'  ORDER BY version DESC
2018-11-17T18:30:16.549159Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tblog_evt'
2018-11-17T18:30:16.549436Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbmsg`
2018-11-17T18:30:16.550451Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbmsg'  ORDER BY version DESC
2018-11-17T18:30:16.550725Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbmsg'
2018-11-17T18:30:16.551020Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbprj`
2018-11-17T18:30:16.552408Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbprj'  ORDER BY version DESC
2018-11-17T18:30:16.552714Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbprj'
2018-11-17T18:30:16.553067Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbrep`
2018-11-17T18:30:16.554413Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbrep'  ORDER BY version DESC
2018-11-17T18:30:16.554728Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbrep'
2018-11-17T18:30:16.555024Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbrep_fields`
2018-11-17T18:30:16.555492Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbrep_fields'  ORDER BY version DESC
2018-11-17T18:30:16.555763Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbrep_fields'
2018-11-17T18:30:16.556088Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbrep_tables`
2018-11-17T18:30:16.556563Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbrep_tables'  ORDER BY version DESC
2018-11-17T18:30:16.556860Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbrep_tables'
2018-11-17T18:30:16.557152Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbsess`
2018-11-17T18:30:16.558765Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbsess'  ORDER BY version DESC
2018-11-17T18:30:16.559517Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbsess'
2018-11-17T18:30:16.560236Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbtodo`
2018-11-17T18:30:16.561846Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbtodo'  ORDER BY version DESC
2018-11-17T18:30:16.562452Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbtodo'
2018-11-17T18:30:16.563007Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbtrans`
2018-11-17T18:30:16.563985Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbtrans'  ORDER BY version DESC
2018-11-17T18:30:16.564514Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbtrans'
2018-11-17T18:30:16.565078Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbuser_group`
2018-11-17T18:30:16.566181Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbuser_group'  ORDER BY version DESC
2018-11-17T18:30:16.566624Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbuser_group'
2018-11-17T18:30:16.566966Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbusu`
2018-11-17T18:30:16.568046Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbusu'  ORDER BY version DESC
2018-11-17T18:30:16.568342Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbusu'
2018-11-17T18:30:16.568648Z     7 Query SELECT COUNT(*) FROM `sc9`.`sc_tbversao`
2018-11-17T18:30:16.570354Z     6 Query SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'sc9'  AND table_name = 'sc_tbversao'  ORDER BY version DESC
2018-11-17T18:30:16.570645Z     6 Query SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'sc9'  AND `table_name` = 'sc_tbversao'
2018-11-17T18:30:16.570985Z     7 Query SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'sc9' LIMIT 1
2018-11-17T18:30:16.571460Z     7 Query SELECT @@default_storage_engine
2018-11-17T18:30:16.571962Z     7 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:16.572347Z     7 Query SELECT CURRENT_USER()
2018-11-17T18:30:16.572526Z     7 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
2018-11-17T18:30:16.573116Z     7 Query SELECT CURRENT_USER()
2018-11-17T18:30:16.573281Z     7 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:16.573907Z     6 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'db%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:16.574636Z     6 Query SELECT `comment`
            FROM `phpmyadmin`.`pma__column_info`
            WHERE db_name     = 'sc9'
                AND table_name  = ''
                AND column_name = '(db_comment)'
2018-11-17T18:30:16.577233Z     6 Query SELECT `comment`
            FROM `phpmyadmin`.`pma__column_info`
            WHERE db_name     = 'sc9'
                AND table_name  = ''
                AND column_name = '(db_comment)'
2018-11-17T18:30:16.577591Z     7 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:16.577994Z     7 Query SELECT CURRENT_USER()
2018-11-17T18:30:16.578185Z     7 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
2018-11-17T18:30:16.578684Z     7 Query SELECT CURRENT_USER()
2018-11-17T18:30:16.578835Z     7 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:16.579437Z     6 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'db%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:16.582883Z     7 Quit
2018-11-17T18:30:16.583088Z     6 Quit
2018-11-17T18:30:18.114299Z     8 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:30:18.114651Z     9 Connect root@localhost on  using Socket
2018-11-17T18:30:18.114827Z     9 Query SELECT @@version, @@version_comment
2018-11-17T18:30:18.115041Z     9 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:30:18.115239Z     9 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:30:18.115340Z     9 Query SET lc_messages = 'pt_PT'
2018-11-17T18:30:18.119085Z     9 Init DB sc9
2018-11-17T18:30:18.120984Z     9 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:18.125015Z     8 Query SELECT query, label, id FROM `phpmyadmin`.`pma__bookmark` WHERE dbase = 'sc9' AND user = 'root' ORDER BY label
2018-11-17T18:30:18.127031Z     8 Query SELECT query, label, id FROM `phpmyadmin`.`pma__bookmark` WHERE dbase = 'sc9' AND user = '' ORDER BY label
2018-11-17T18:30:18.127482Z     9 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:18.127912Z     9 Query SELECT CURRENT_USER()
2018-11-17T18:30:18.128082Z     9 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
2018-11-17T18:30:18.128691Z     9 Query SELECT CURRENT_USER()
2018-11-17T18:30:18.128872Z     9 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:18.129487Z     8 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'db%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:18.130223Z     8 Query SELECT `comment`
            FROM `phpmyadmin`.`pma__column_info`
            WHERE db_name     = 'sc9'
                AND table_name  = ''
                AND column_name = '(db_comment)'
2018-11-17T18:30:18.130763Z     8 Query SELECT `comment`
            FROM `phpmyadmin`.`pma__column_info`
            WHERE db_name     = 'sc9'
                AND table_name  = ''
                AND column_name = '(db_comment)'
2018-11-17T18:30:18.131105Z     9 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:18.131596Z     9 Query SELECT CURRENT_USER()
2018-11-17T18:30:18.131750Z     9 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
2018-11-17T18:30:18.132261Z     9 Query SELECT CURRENT_USER()
2018-11-17T18:30:18.132434Z     9 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:18.133219Z     8 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'db%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:18.135191Z     8 Quit
2018-11-17T18:30:18.135338Z     9 Quit
2018-11-17T18:30:19.552077Z    10 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:30:19.552468Z    11 Connect root@localhost on  using Socket
2018-11-17T18:30:19.552639Z    11 Query SELECT @@version, @@version_comment
2018-11-17T18:30:19.552885Z    11 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:30:19.553011Z    11 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:30:19.553119Z    11 Query SET lc_messages = 'pt_PT'
2018-11-17T18:30:19.555016Z    11 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:19.555477Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbapl`
2018-11-17T18:30:19.558012Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbapl`
2018-11-17T18:30:19.559271Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbati`
2018-11-17T18:30:19.559867Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbati`
2018-11-17T18:30:19.560167Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbcmp`
2018-11-17T18:30:19.560786Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbcmp`
2018-11-17T18:30:19.561150Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbconex`
2018-11-17T18:30:19.561567Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbconex`
2018-11-17T18:30:19.561829Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbevt`
2018-11-17T18:30:19.562254Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbevt`
2018-11-17T18:30:19.562557Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbgroup`
2018-11-17T18:30:19.562978Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbgroup`
2018-11-17T18:30:19.563217Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tblog`
2018-11-17T18:30:19.563698Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tblog`
2018-11-17T18:30:19.564058Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tblog_apl`
2018-11-17T18:30:19.564429Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tblog_apl`
2018-11-17T18:30:19.564691Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tblog_cmp`
2018-11-17T18:30:19.565065Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tblog_cmp`
2018-11-17T18:30:19.565380Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tblog_evt`
2018-11-17T18:30:19.565761Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tblog_evt`
2018-11-17T18:30:19.566030Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbmsg`
2018-11-17T18:30:19.566460Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbmsg`
2018-11-17T18:30:19.566712Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbprj`
2018-11-17T18:30:19.567118Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbprj`
2018-11-17T18:30:19.567380Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbrep`
2018-11-17T18:30:19.567752Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbrep`
2018-11-17T18:30:19.568009Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbrep_fields`
2018-11-17T18:30:19.568439Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbrep_fields`
2018-11-17T18:30:19.568718Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbrep_tables`
2018-11-17T18:30:19.569128Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbrep_tables`
2018-11-17T18:30:19.569424Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbsess`
2018-11-17T18:30:19.569770Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbsess`
2018-11-17T18:30:19.570013Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbtodo`
2018-11-17T18:30:19.570491Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbtodo`
2018-11-17T18:30:19.570791Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbtrans`
2018-11-17T18:30:19.571157Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbtrans`
2018-11-17T18:30:19.571432Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbuser_group`
2018-11-17T18:30:19.571859Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbuser_group`
2018-11-17T18:30:19.572205Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbusu`
2018-11-17T18:30:19.572885Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbusu`
2018-11-17T18:30:19.573241Z    11 Query SHOW  COLUMNS FROM `sc9`.`sc_tbversao`
2018-11-17T18:30:19.573846Z    11 Query SHOW INDEXES FROM `sc9`.`sc_tbversao`
2018-11-17T18:30:19.574595Z    11 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:19.575094Z    11 Query SELECT CURRENT_USER()
2018-11-17T18:30:19.575381Z    11 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
2018-11-17T18:30:19.576113Z    11 Query SELECT CURRENT_USER()
2018-11-17T18:30:19.576349Z    11 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:19.577268Z    10 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'db%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:19.578568Z    10 Query SELECT `comment`
            FROM `phpmyadmin`.`pma__column_info`
            WHERE db_name     = 'sc9'
                AND table_name  = ''
                AND column_name = '(db_comment)'
2018-11-17T18:30:19.579287Z    10 Query SELECT `comment`
            FROM `phpmyadmin`.`pma__column_info`
            WHERE db_name     = 'sc9'
                AND table_name  = ''
                AND column_name = '(db_comment)'
2018-11-17T18:30:19.579842Z    11 Query SHOW TABLES FROM `sc9`
2018-11-17T18:30:19.580343Z    11 Query SELECT CURRENT_USER()
2018-11-17T18:30:19.580558Z    11 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
2018-11-17T18:30:19.581284Z    11 Query SELECT CURRENT_USER()
2018-11-17T18:30:19.581503Z    11 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:19.582364Z    10 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'db%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:19.585536Z    10 Quit
2018-11-17T18:30:19.585767Z    11 Quit
2018-11-17T18:30:20.058277Z    12 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:30:20.058615Z    13 Connect root@localhost on  using Socket
2018-11-17T18:30:20.058799Z    13 Query SELECT @@version, @@version_comment
2018-11-17T18:30:20.059020Z    13 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:30:20.059143Z    13 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:30:20.059253Z    13 Query SET lc_messages = 'pt_PT'
2018-11-17T18:30:20.065163Z    13 Quit
2018-11-17T18:30:20.065462Z    12 Quit
2018-11-17T18:30:21.936517Z    14 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:30:21.936909Z    15 Connect root@localhost on  using Socket
2018-11-17T18:30:21.937098Z    15 Query SELECT @@version, @@version_comment
2018-11-17T18:30:21.937356Z    15 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:30:21.937512Z    15 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:30:21.937634Z    15 Query SET lc_messages = 'pt_PT'
2018-11-17T18:30:21.939569Z    15 Query SELECT CURRENT_USER()
2018-11-17T18:30:21.940050Z    15 Init DB sc9
2018-11-17T18:30:21.942147Z    15 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:21.945275Z    15 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:21.947521Z    15 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:21.950723Z    15 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:21.952695Z    15 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:21.964361Z    15 Query SELECT DATABASE()
2018-11-17T18:30:21.965046Z    15 Init DB phpmyadmin
2018-11-17T18:30:21.965387Z    15 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'server%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root') LIMIT 0, 25
2018-11-17T18:30:21.966308Z    15 Query SELECT SQL_CALC_FOUND_ROWS `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'server%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root') LIMIT 1
2018-11-17T18:30:21.966653Z    15 Query SELECT FOUND_ROWS()
2018-11-17T18:30:21.968266Z    15 Query SELECT @@have_profiling
2018-11-17T18:30:21.968519Z    15 Query SELECT @@lower_case_table_names
2018-11-17T18:30:21.968769Z    15 Query SELECT TABLE_NAME
            FROM information_schema.VIEWS
            WHERE TABLE_SCHEMA = 'phpmyadmin'
                AND TABLE_NAME = 'pma__usergroups'
2018-11-17T18:30:21.969272Z    15 Query SELECT *,
                `TABLE_SCHEMA`       AS `Db`,
                `TABLE_NAME`         AS `Name`,
                `TABLE_TYPE`         AS `TABLE_TYPE`,
                `ENGINE`             AS `Engine`,
                `ENGINE`             AS `Type`,
                `VERSION`            AS `Version`,
                `ROW_FORMAT`         AS `Row_format`,
                `TABLE_ROWS`         AS `Rows`,
                `AVG_ROW_LENGTH`     AS `Avg_row_length`,
                `DATA_LENGTH`        AS `Data_length`,
                `MAX_DATA_LENGTH`    AS `Max_data_length`,
                `INDEX_LENGTH`       AS `Index_length`,
                `DATA_FREE`          AS `Data_free`,
                `AUTO_INCREMENT`     AS `Auto_increment`,
                `CREATE_TIME`        AS `Create_time`,
                `UPDATE_TIME`        AS `Update_time`,
                `CHECK_TIME`         AS `Check_time`,
                `TABLE_COLLATION`    AS `Collation`,
                `CHECKSUM`           AS `Checksum`,
                `CREATE_OPTIONS`     AS `Create_options`,
                `TABLE_COMMENT`      AS `Comment`
            FROM `information_schema`.`TABLES` t
            WHERE `TABLE_SCHEMA` COLLATE utf8_bin
                IN ('phpmyadmin')
                AND t.`TABLE_NAME` COLLATE utf8_bin = 'pma__usergroups' ORDER BY Name ASC
2018-11-17T18:30:21.972005Z    15 Query SELECT COUNT(*) FROM `phpmyadmin`.`pma__usergroups`
2018-11-17T18:30:21.973223Z    14 Query SELECT `master_field`,
                `foreign_db`,
                `foreign_table`,
                `foreign_field`
            FROM `phpmyadmin`.`pma__relation`
            WHERE `master_db`    = 'phpmyadmin'
                AND `master_table` = 'pma__usergroups'
2018-11-17T18:30:21.975059Z    15 Query SHOW CREATE TABLE `phpmyadmin`.`pma__usergroups`
2018-11-17T18:30:21.977399Z    14 Query SELECT `prefs` FROM `phpmyadmin`.`pma__table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'phpmyadmin' AND `table_name` = 'pma__usergroups'
2018-11-17T18:30:21.979323Z    15 Query SHOW FULL COLUMNS FROM `phpmyadmin`.`pma__usergroups`
2018-11-17T18:30:21.979799Z    15 Query SHOW INDEXES FROM `phpmyadmin`.`pma__usergroups`
2018-11-17T18:30:21.980343Z    15 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2018-11-17T18:30:21.982430Z    15 Query SHOW  COLUMNS FROM `phpmyadmin`.`pma__usergroups`
2018-11-17T18:30:21.982898Z    14 Query REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{\"db\":\"phpmyadmin\",\"table\":\"pma__usergroups\"}]')
2018-11-17T18:30:21.986209Z    15 Query SELECT TABLE_NAME
            FROM information_schema.VIEWS
            WHERE TABLE_SCHEMA = 'sc9'
                AND TABLE_NAME = 'pma__usergroups'
2018-11-17T18:30:21.987032Z    15 Query SELECT CURRENT_USER()
2018-11-17T18:30:21.987327Z    15 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:21.988252Z    14 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'table%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:21.989238Z    15 Query SELECT TABLE_NAME
            FROM information_schema.VIEWS
            WHERE TABLE_SCHEMA = 'sc9'
                AND TABLE_NAME = 'pma__usergroups'
2018-11-17T18:30:21.990914Z    15 Init DB phpmyadmin
2018-11-17T18:30:21.991232Z    15 Query SELECT TABLE_NAME
            FROM information_schema.VIEWS
            WHERE TABLE_SCHEMA = 'sc9'
                AND TABLE_NAME = 'pma__usergroups'
2018-11-17T18:30:21.991788Z    15 Init DB phpmyadmin
2018-11-17T18:30:21.991970Z    15 Query SELECT TABLE_NAME
            FROM information_schema.VIEWS
            WHERE TABLE_SCHEMA = 'sc9'
                AND TABLE_NAME = 'pma__usergroups'
2018-11-17T18:30:21.992384Z    15 Query SELECT CURRENT_USER()
2018-11-17T18:30:21.992546Z    15 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
2018-11-17T18:30:21.993297Z    14 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'table%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:21.994613Z    15 Quit
2018-11-17T18:30:21.994829Z    14 Quit
2018-11-17T18:30:22.178887Z    16 Connect phpmyadmin@localhost on  using Socket
2018-11-17T18:30:22.179244Z    17 Connect root@localhost on  using Socket
2018-11-17T18:30:22.179408Z    17 Query SELECT @@version, @@version_comment
2018-11-17T18:30:22.179625Z    17 Query SET CHARACTER SET 'utf8mb4'
2018-11-17T18:30:22.179740Z    17 Query SET collation_connection = 'utf8mb4_unicode_ci'
2018-11-17T18:30:22.179834Z    17 Query SET lc_messages = 'pt_PT'
2018-11-17T18:30:22.181530Z    17 Query SELECT CURRENT_USER()
2018-11-17T18:30:22.182001Z    17 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC
2018-11-17T18:30:22.183925Z    16 Query SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' GROUP BY `db_name`
2018-11-17T18:30:22.186105Z    16 Query SELECT `item_name` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' AND `item_type`='group' AND `db_name`='phpmyadmin'
2018-11-17T18:30:22.186413Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='phpmyadmin' AND `TABLE_TYPE`='BASE TABLE'
2018-11-17T18:30:22.191526Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='phpmyadmin' AND `TABLE_TYPE`!='BASE TABLE'
2018-11-17T18:30:22.192163Z    17 Query SELECT @@lower_case_table_names
2018-11-17T18:30:22.192339Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` COLLATE utf8_bin='phpmyadmin' AND `ROUTINE_TYPE`='FUNCTION'
2018-11-17T18:30:22.195583Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` COLLATE utf8_bin='phpmyadmin'AND `ROUTINE_TYPE`='PROCEDURE'
2018-11-17T18:30:22.197594Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE `EVENT_SCHEMA` COLLATE utf8_bin='phpmyadmin'
2018-11-17T18:30:22.198096Z    17 Query SELECT `TABLE_NAME` AS `name` FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='phpmyadmin' AND `TABLE_TYPE`='BASE TABLE' ORDER BY `TABLE_NAME` ASC LIMIT 0, 50
2018-11-17T18:30:22.198769Z    16 Query SELECT `item_name` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' AND `item_type`='table' AND `db_name`='phpmyadmin'
2018-11-17T18:30:22.199821Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='phpmyadmin' AND `TABLE_TYPE`='BASE TABLE'
2018-11-17T18:30:22.200387Z    17 Query SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='phpmyadmin' AND `TABLE_TYPE`='BASE TABLE'
2018-11-17T18:30:22.201866Z    16 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'server%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:22.202760Z    16 Query SELECT `tab` FROM `phpmyadmin`.`pma__usergroups` WHERE `allowed` = 'N' AND `tab` LIKE 'server%' AND `usergroup` = (SELECT usergroup FROM `phpmyadmin`.`pma__users` WHERE `username` = 'root')
2018-11-17T18:30:22.204442Z    16 Quit
2018-11-17T18:30:22.204569Z    17 Quit

Código: [Selecionar]
root@SC9:/var/log# tail -f /var/log/mysql/error.log
2018-11-17T18:22:00.383803Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181117 18:22:00
2018-11-17T18:22:02.196561Z 0 [Note] InnoDB: Shutdown completed; log sequence number 5720734
2018-11-17T18:22:02.198777Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-11-17T18:22:02.198808Z 0 [Note] Shutting down plugin 'MEMORY'
2018-11-17T18:22:02.198816Z 0 [Note] Shutting down plugin 'CSV'
2018-11-17T18:22:02.198824Z 0 [Note] Shutting down plugin 'sha256_password'
2018-11-17T18:22:02.198829Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-11-17T18:22:02.199107Z 0 [Note] Shutting down plugin 'binlog'
2018-11-17T18:22:02.199529Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Diagnosis gerado:
http://68.183.124.105/sc9/tmp/sc_diagnosis_20181117183801.html

Alguém faz ideia do que possa ser?

[EDIT]
A importação dá erro apenas na única aplicação que fiz no SC 9 (sub versão anterior). Nos projetos novos feito por ele a exportação/importação funciona normal. Vou entrar em contato com o suporte pra resgatar o projeto que dá erro.
10
Consultas / Re:Alterar tamanho e posição do popup de download
« Última Mensagem: por leonardo.byrro Online Novembro 17, 2018, 01:46:19 pm »
Anderson, boa tarde. Estou tendo o mesmo problema e não consigo resolver. Como você solucionou o problema?
Páginas: [1] 2 3 ... 10