Hi Christian,

Is this problem reproducible? If so, could you active the log file
via "log = /var/log/mysql/mysql.log" in /etc/mysql/my.cnf and try again?
It would be good to see what was the last query that phpmyadmin sent to
the server. If phpmyadmin has any debugging log it would be good to have, too.

I couldn't find a way to enable logging or debugging in phpMyAdmin, so only the mysql.log-excerpt can be posted here:
----8<-----------------------------------
060826  0:00:44     19 Connect     [EMAIL PROTECTED] on
                    19 Query       SET NAMES utf8
19 Query SET collation_connection = 'utf8_unicode_ci' 19 Query SHOW SESSION VARIABLES LIKE 'collation_connection' 19 Query SHOW SESSION VARIABLES LIKE 'character_set_connection'
060826  0:00:45      19 Query       SHOW CHARACTER SET
                    19 Query       SHOW COLLATION
                    19 Query       SELECT *,
                   `TABLE_SCHEMA`       AS `Db`,
                   `TABLE_NAME`         AS `Name`,
                   `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`
             WHERE `TABLE_SCHEMA` IN ('gallery2')
060826  0:00:47      19 Init DB     system
060826 0:00:50 19 Query SHOW TABLE STATUS FROM `gallery2` LIKE 'g2_AccessMap'
                    19 Query       SET SQL_QUOTE_SHOW_CREATE = 1
19 Query SHOW CREATE TABLE `gallery2`.`g2_AccessMap`
----8<-----------------------------------

(I was trying to move the whole database "gallery2" to the database "system", but I tried other combinations, so the names don't matter)

Reproducing the shown commands on the command-line mysql-client works fine (sadly), so I don't know what to think of it. Is it possible, that the supposed-to-be bad-command isn't written to the log because of the segfault?

bye,

-christian-


Bye,
   Markus



--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to