Anil, Friday, June 28, 2002, 8:57:06 PM, you wrote: AG> I have a table with the following description: AG> mysql> describe xoops_groups_modules_link; AG> +---------+---------+------+-----+---------+-------+ AG> | Field | Type | Null | Key | Default | Extra | AG> +---------+---------+------+-----+---------+-------+ AG> | groupid | int(5) | | MUL | 0 | | AG> | mid | int(5) | | | 0 | | AG> | type | char(1) | | | | | AG> +---------+---------+------+-----+---------+-------+ AG> with the folloing contents in it: AG> mysql> select * from xoops_groups_modules_link; AG> +---------+-----+------+ AG> | groupid | mid | type | AG> +---------+-----+------+ AG> | 1 | 1 | A | AG> | 1 | 2 | A | AG> | 1 | 1 | R | AG> | 1 | 2 | R | AG> | 2 | 1 | R | AG> | 2 | 2 | R | AG> | 3 | 1 | R | AG> | 3 | 2 | R | AG> +---------+-----+------+ AG> Now, when i run the following query: AG> mysql> select * from xoops_groups_modules_link where type='R' and mid=2 and AG> groupid=3 ; AG> ERROR 2006: MySQL server has gone away AG> No connection. Trying to reconnect... AG> Connection id: 1 AG> Current database: xoops
AG> ERROR 2013: Lost connection to MySQL server during query AG> I cant find out why its happening so!! AG> Can someone plz help me. AG> Infact this table is dumped from a dump. If i create a same table by myself AG> and then run the same query it executes fine. Isn't that strange!! Check your table with CHECK TABLE statement, is there any error in the output? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
