Updating to vBulletin 3.6 – Update Timeouts

If you’re running in this specific problem you are probably trying to update a pretty large forum. This happens because the post table is too big and the PHP Connection Timeout is being fired.

The browser might just stop loading or showing a blank white page. In some cases this error pops up:

This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase ‘Connection Timeout’.

..so, whether you increase the Connection Timeout or you manually run the tables by using SSH Access.

If you want to update the big tables manually, here are the queries:

  • ALTER TABLE vb3_post ADD COLUMN infraction smallint(5);
  • ALTER TABLE vb3_thread ADD COLUMN deletedcount smallint(5);
  • ALTER TABLE vb3_post ADD COLUMN reportthreadid int(11);
  • ALTER TABLE vb3_thread ADD COLUMN lastpostid int(11);

The post tables took around 48 minutes here, updating 1,6 million rows of postings.

After running those queries, open up upgrade_360b1.php, find Alter Post table OH NO HERE WE GO! — new system will allow a refresh if it dies at least and comment out the following:

	$upgrade->add_field(
	sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1),
	'post',
	'infraction',
	'smallint',
	FIELD_DEFAULTS
	);

	$upgrade->add_field(
		sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'thread', 1, 1),
		'thread',
		'deletedcount',
		'smallint',
		FIELD_DEFAULTS
	);

	$upgrade->execute();


	$upgrade->add_field(
		sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1),
		'post',
		'reportthreadid',
		'int',
		FIELD_DEFAULTS
	);

	$upgrade->add_field(
		sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'thread', 1, 1),
		'thread',
		'lastpostid',
		'int',
		FIELD_DEFAULTS
	);

	$upgrade->execute();

Then run it and you should be fine.. hope that helps!

1 comment so far ↓

#1 arn on 10.28.06 at 8:23 am

Warning… at least one of these mysql calls does not properly create the reportthreadid column correctly.

see http://www.vbulletin.com/forum/showthread.php?t=195194

Leave a Comment