Re: Lost connection to MySQL server during query
Hi again Peter
this query crashes the server every time from where it is in the site. i can't find anything in any of the relevant logs.
as for the row counts, there's currently 6 rows in 'chatroom' and 5 in 'chatroom_allowed_user' so they're tiny right now...
mysql is on version 4.1.15 via php5 on apache 2, all (apart from apache) from dotdeb sources.
the following is from a mysqldump done just now:
DROP TABLE IF EXISTS `chatroom`;
CREATE TABLE `chatroom` (
`chatroom_id` int(63) unsigned NOT NULL auto_increment,
`lang_id` int(10) unsigned NOT NULL default '0',
`chatroom_label` varchar(255) default NULL,
`chatroom_date_created_timestamp` int(32) unsigned NOT NULL default '0',
`chatroom_is_permanent_chatroom` tinyint(1) NOT NULL default '0',
`chatroom_date_deleted_timestamp` int(32) unsigned default NULL,
`user_id` int(63) unsigned NOT NULL default '0',
PRIMARY KEY (`chatroom_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40000 ALTER TABLE `chatroom` DISABLE KEYS */;
INSERT INTO `chatroom` (`chatroom_id`,`lang_id`,`chatroom_label`,`chatroom_date_created_timestamp`,`chatroom_is_permanent_chatroom`,`chatroom_date_deleted_timestamp`,`user_id`) VALUES
(31,0,'abc',1149526417,0,NULL,1),
(30,0,'test1',1149526397,0,NULL,1),
(26,0,'bean',1148935369,0,NULL,196),
(25,0,'hello',1148501419,0,NULL,276),
(24,0,'hi',1147873771,0,NULL,195),
(27,0,'evening',1148935496,0,NULL,276),
(28,0,'splaindawg',1149011334,0,NULL,1),
(29,0,'fwfwe',1149011389,0,NULL,1);
/*!40000 ALTER TABLE `chatroom` ENABLE KEYS */;
DROP TABLE IF EXISTS `chatroom_allowed_user`;
CREATE TABLE `chatroom_allowed_user` (
`chatroom_allowed_user_id` int(63) unsigned NOT NULL auto_increment,
`chatroom_id` int(63) unsigned NOT NULL default '0',
`user_id` int(63) unsigned NOT NULL default '0',
`chatroom_allowed_user_date_deleted_timestamp` int(32) unsigned default NULL,
PRIMARY KEY (`chatroom_allowed_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40000 ALTER TABLE `chatroom_allowed_user` DISABLE KEYS */;
INSERT INTO `chatroom_allowed_user` (`chatroom_allowed_user_id`,`chatroom_id`,`user_id`,`chatroom_allowed_user_date_deleted_timestamp`) VALUES
(56,24,196,NULL),
(57,25,155,NULL),
(58,26,190,NULL),
(59,27,196,NULL),
(64,31,155,NULL),
(63,30,204,NULL),
(62,29,1,NULL);
/*!40000 ALTER TABLE `chatroom_allowed_user` ENABLE KEYS */;
hope that's enough info?
thanks so much for your help...