[TheAdminMarket]

Originally Posted by louva-a-Deus

I made an unsuccessful installation and did not install the mod but the tables were, how can I remove them?

If you're familiar using phpMyAdmin you must connect to your database and remove from table usergroup the field memberindex. Normally must be the last.

Another way is to modify the product-memberindex.xml and remove:

	<codes>
		<code version="1.0.0">
			<installcode><![CDATA[
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD memberindex INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD ismemberindex INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
   			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_facebook VARCHAR( 255 ) DEFAULT '' NOT NULL");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_twitter VARCHAR( 255 ) DEFAULT '' NOT NULL");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_google VARCHAR( 255 ) DEFAULT '' NOT NULL");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_linkedin VARCHAR( 255 ) DEFAULT '' NOT NULL");
			]]></installcode>
			<uninstallcode><![CDATA[
            $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP memberindex");
            $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP ismemberindex");
            $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_facebook");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_twitter");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_google");
			$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_linkedin");
            ]]></uninstallcode>
		</code>
	</codes>

Then save file and import it.

Most probably is not only that field but all. Don't know why the fields didn't removed during uninstall.