Hello, in my work we updated mysql from 3.22.23 to 3.23.49. But there are some problems:
mysql> describe uzivatele; +---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | | PRI | NULL | auto_increment | | jmeno | varchar(8) | | UNI | | | | heslo | varchar(32) | | | | | | plne_jmeno | varchar(64) | | | | | | posledni_prihlaseni | int(10) unsigned | | | 0 | | | aktivni | char(1) | | MUL | n | | | pocet_prihlaseni | int(10) unsigned | | | 0 | | +---------------------+------------------+------+-----+---------+----------------+ mysql> select * from uzivatele; +----+-------+----------------------------------+-----------------+---------------------+---------+------------------+ | id | jmeno | heslo | plne_jmeno | |posledni_prihlaseni | aktivni | pocet_prihlaseni | +----+-------+----------------------------------+-----------------+---------------------+---------+------------------+ | 1 | admin | ccf6d8aeb9a3f1c424b9536859803861 | Michal Dvořáček | |1018603709 | a | 37 | | 2 | kpo | d2d4383dd938b5a0531ec00396e5bfcd | Klára Polívková | |1018603813 | a | 205 | | 4 | sce | 59881fd5889ab2d711dbfd13db901936 | Silvie Černá | |1017518443 | a | 34 | | 5 | jpr | 8da062fa96aa2cab771ea087a1fa7db2 | Jakub Procházka | |1018603806 | a | 6 | | 6 | hsr | 00786ec4d5c2972eb610826b74a4fe8b | Hana Šrajerová | |1018451119 | a | 1 | +----+-------+----------------------------------+-----------------+---------------------+---------+------------------+ first problem was in simple query (from mysql.log): SELECT * FROM uzivatele WHERE aktivni = 'a' AND jmeno = 'kpo' AND heslo = 'd2d4383dd938b5a0531ec00396e5bfcd' old version returns one row (was excepted:) but new version return nothing! and next problem is with analyze/check/repair table mysql> analyze table uzivatele; +-----------------+---------+----------+--------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | | +-----------------+---------+----------+--------------------------------------------------------+ | sante.uzivatele | analyze | error | The handler for the table doesn't support |check/repair | +-----------------+---------+----------+--------------------------------------------------------+ First problem is solved (dump database, drop database, flush, create database, read from dump) but second problem is still actual. Can you help me, please ? Thank you. Michal Dvoracek [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
