[Solved] Help:after upgrading cacti's version

[PK]

I followed the cacti manual for upgrading cacti,In the procdures of upgrading, It appears the errors: "[Fail] ALTER TABLE `poller_time` ADD COLUMN `pid` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `id` and other tips were OK.

Old version:0.8.6.h
New version:0.8.7.b

How can I fix this error,or this error do not need to pay attentions. Plz help me.

[BSOD2600]

read http://forums.cacti.net/viewtopic.php?t=11747 and repost.

1) If you manually run that command in mysql, what is the error?
2) You might have to restore your db backup (you did make one, right?), then upgrade to cacti 0.8.6j, and then upgrade to 0.8.7b.

[PK]

Thank you for your reply.

you means that I should first upgrade the version to 0.8.6.j Can you give me the link about this vesion? I intalled the version 0.8.7.b by the beta windows installer.

[BSOD2600]

I intalled the version 0.8.7.b by the beta windows installer.

Wait a minute, you use the windows installer to UPGRADE your existing installation? It's not designed for upgrades, which it clearly states. Furthermore, it would've overwritten your old database, so then you wouldn't be getting those alter table errors. Your steps don't make sense.

[PK]

NO,I intalled the new version in a new server ,then I migrated the cacti to this server,I followed the upgrade step by step, everythings was OK ,just appeared the aboved errors.

[BSOD2600]

Ah, alright. Kind of a weird way to upgrade/migrate, but whatever.

So did you manually run the alter table statement and see what the error was?

[PK]

after to execute that command, it was informed "Error 1060 <42S21>:duplicate column name 'pid'"

[BSOD2600]

Alright, then it should probably be ok to ignore and carry on.

[PK]

Thank you for your help,this problem was resolved.