[CMX_CMGSCCC]

Originally Posted by JsnakeJ

I get this error when trying to change my username.



I believe I just need to run a query to change a column count or something, not quite sure though.

A slight bug in the PHP code, its missing a comma.

You can add it yourself at the following spot..

Inside estore/action.changeusername.php

Find:

	// log this change into estorenamechanges
	$vbulletin->db->query_write("
		INSERT INTO " . TABLE_PREFIX . "estorenamechanges (changeid, dateline, changeuserid, oldusername, changedbyuserid)
		VALUES
		(
			0,
			" . TIMENOW . ",
			'" . $vbulletin->userinfo['userid'] . "'
			'" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "',
			'" . $vbulletin->userinfo['userid'] . "'
		)
	");

Replace that with:

	// log this change into estorenamechanges
	$vbulletin->db->query_write("
		INSERT INTO " . TABLE_PREFIX . "estorenamechanges (changeid, dateline, changeuserid, oldusername, changedbyuserid)
		VALUES
		(
			0,
			" . TIMENOW . ",
			'" . $vbulletin->userinfo['userid'] . "',
			'" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "',
			'" . $vbulletin->userinfo['userid'] . "'
		)
	");

This will be fixed inside the next release as well.

-CMX