Please help me confirm database upgrade/alteration changes ?

[John Miller]

Hello,
I have a database with large no. of records (threads and posts), was upgrading from 3.0.x version to 3.5.3 latest version.

Upgradation was on following file and step.
upgrade_350rc3.php
Step 3

// #############################################################################
// Post Alter
if ($vbulletin->GPC['step'] == 3)
{
	$query[]['hideerror'] = "ALTER TABLE " . TABLE_PREFIX . "post DROP INDEX iconid";
	$explain[] = sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1);

	exec_queries();
}

// #############################################################################

How can i confirm via PhpMyAdmin if this alteration has been done ?

[Floris]

In phpmyadmin you can check if the post table has the field:
iconid

[John Miller]

hi floris,
post table has the field named iconid with following details:
type = smallint(5)
attributes = UNSIGNED
null = No
default = 0


thanks.

[John Miller]

bumping back,
is the alteration done or still needs to be run ?

from above information.

thanks.

[Floris]

Sorry, could you dump that table's structure (withou the data).

[John Miller]

Sorry, could you dump that table's structure (withou the data).

hi floris,
here is my complete database structure.

http://www.vbulletin.com/forum/showpost.php?p=1073973&postcount=22

thanks

[Floris]

CREATE TABLE `O_post` (
  `postid` int(10) unsigned NOT NULL auto_increment,
  `threadid` int(10) unsigned NOT NULL default '0',
  `parentid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `title` varchar(250) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `pagetext` mediumtext NOT NULL,
  `allowsmilie` smallint(6) NOT NULL default '0',
  `showsignature` smallint(6) NOT NULL default '0',
  `ipaddress` varchar(15) NOT NULL default '',
  `iconid` smallint(5) unsigned NOT NULL default '0',
  `visible` smallint(6) NOT NULL default '0',
  `attach` smallint(5) unsigned NOT NULL default '0',
  `isusenetpost` tinyint(4) NOT NULL default '0',
  `msgid` varchar(128) default NULL,
  `ref` text NOT NULL,
  `editlevel` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`postid`),
  KEY `iconid` (`iconid`),
  KEY `userid` (`userid`),
  KEY `threadid` (`threadid`,`userid`),
  KEY `isusenetpost` (`isusenetpost`),
  KEY `msgid` (`msgid`)
) TYPE=MyISAM AUTO_INCREMENT=2885835 ;

Just posting the table in question here for reference.

[Floris]

The KEY is still there, the query has not run.

What error do you run into?


[Edit]
It is quite possible that the index gets added at a later stage again. Quite hard to tell if this particular query has been run. Not sure how to help you right now having no error reported.

[John Miller]

The KEY is still there, the query has not run.

What error do you run into?


[Edit]
It is quite possible that the index gets added at a later stage again. Quite hard to tell if this particular query has been run. Not sure how to help you right now having no error reported.

i am not getting any errors now, forum is upgraded to 3.5.3 and running fine without any errors.

[Floris]

Problem solved