Upgrading to 1.2.1

[Phife]

Upgrade Errors
Uh oh, your upgrade to 1.2.1 has failed!

The following elements of the database are incorrect:

• Column xf_node.title missing.

This is likely caused by an add-on conflict. You may need to restore a backup, remove the offending add-on data from the database, and retry the upgrade. Contact support if you are not sure how to proceed.

That is the list of plugins I use. I have no idea how to fix this issue.

Help!

 

[Paul B]

See this thread: http://xenforo.com/community/thread...nt-information-and-actions-to-be-taken.56027/

 

[Phife]

I'm not very technically talented. We're on 1.2.0 and all our plugins have been tested by the community and have been reported to work with 1.2.0. We got that error whilst upgrading to 1.2.1.

What part of that thread should I be looking at?

 

[Paul B]

Ah, I assumed you were upgrading from 1.1.x.

There have been no changes to the database schema from 1.2.0 to 1.2.1 so you should have already been seeing errors related to this after you upgraded to 1.2.0.

The xf_node.title is a core table column so I'm confused as to how it can be missing.
Did you perhaps uninstall any add-ons recently?

 

[Phife]

We installed HTML in node titles by waindigo and then uninstalled it within 5 minutes and attempted to upgrade to 1.2.1 from 1.2.0.

We had no errors when upgrading to 1.2.0.

 

[Jeremy]

That's a confusing installation file, but that add-on modifies the xf_node.title column, so its most likely your issue.

 

[Paul B]

I just installed and uninstalled that add-on and it removed that column from the table.

 

[Jeremy]

I can confirm this via the code as well.

 

[Paul B]

I would recommend restoring from a backup and then proceeding with the upgrade to 1.2.1.

If you don't have a recent backup then you will need to recreate that column and re-enter all of the missing data.

 

[Phife]

I installed the plugin again and the upgrade worked. However, all node titles are K.I.A.

 

[Jeremy]

Once a table (or column) is dropped, the data is gone. Paul's advice is really what you needed to follow:

I would recommend restoring from a backup and then proceeding with the upgrade to 1.2.1.

If you don't have a recent backup then you will need to recreate that column and re-enter all of the missing data.

 

[Jon W]

Thanks for letting me know about this and sorry for the trouble.

The MySql query that you will need to run (using PhpMyAdmin or similar) is:

ALTER TABLE  `xf_node` ADD  `title` VARCHAR( 50 ) NOT NULL AFTER  `node_id`

but as @Brogan said, you might be better off restoring a backup as the above will give every node a blank title, so you would need to re-enter them all manually by editing all the nodes.

I am releasing an update to this add-on to fix this problem.