[ToNetU]

Hello,

It appears that our MySQL query kill script is ending this query prematurely because it is running for upwards of 2-3 minutes without completing:

[ 1273196161 ] [ *** ] [ 40493302 ] [ 146 ] [ *** ] [ Query ] [ KILLED ] [ ] [ ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0' ]
[ 1273196161 ] [ *** ] [ 40494206 ] [ 80 ] [ *** ] [ Query ] [ KILLED ] [ '***.***.com' ] [ ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0' ]
[ 1273197062 ] [ *** ] [ 40505463 ] [ 52 ] [ *** ] [ Query ] [ KILLED ] [ '***.***.com' ] [ ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0' ]

Unfortunately this limit is in place to prevent queries from becoming stuck and overloading the server. It doesn't look like this query is working properly as it shouldn't need to run for longer than a few seconds. I checked the table "post" and there is not currently a column named mobile.

can i know why it is taking so long for this query to complete?

btw i installed it without any problem in my test forum , but when i tried to install it into my live forum i got this error:

Database error in vBulletin 4.0.3:

Invalid SQL:
ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0';

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, May 6th 2010 @ 08:34:41 PM
Error Date    : Thursday, May 6th 2010 @ 08:36:01 PM
Script        : http://www.***.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.***.com/forum/admincp/plugin.php?do=productadd
IP Address    : *****
Username      : tonetu
Classname     : vB_Database
MySQL Version :

maybe the reason is because my test database is 30 mb, but my live database is 3 gb ?

installed, thanks..