XF 1.5 Errors due to Add on conflicts

[kiwixpop]

Well I may be sleep deprived but I was dumb and did not back up my files prior to starting this newest upgrade due to the fact I had no issues with the last upgrade. However I have an issue now.

I got this error when upgrading

Uh oh, your upgrade to 1.5.0 has failed!

The following elements of the database are incorrect:

Column xf_profile_post_comment.message_state missing.
Column xf_profile_post_comment.likes missing.
Column xf_profile_post_comment.like_users missing.
Column xf_profile_post_comment.warning_id missing.
Column xf_profile_post_comment.warning_message 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.

And that cases this error when you try to post on member's recent status update or try to visit a profile of a member

Server Error

Mysqli prepare error: Unknown column 'profile_post_comment.message_state' in 'where clause'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/ProfilePost.php at line 1100
XenForo_Model_ProfilePost->getProfilePostComments() in XenForo/Model/ProfilePost.php at line 1317
XenForo_Model_ProfilePost->addProfilePostCommentsToProfilePosts() in XenForo/ControllerPublic/Member.php at line 259
XenForo_ControllerPublic_Member->actionMember() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/guiltyp/docs/xenforo/index.php at line 13

I removed anything that had appeared in the latter error that were addons and I have currently disabled all add ons I have. I probably should have done that prior to upgrading.

Can get some help?

I have a back up of my site from the last grade I did, which was back in April. If I replace my currently (and messed up) directory files, will I lose any information? (Like posts and members from after that last upgrade?)

Thank you for your help in advance. I do feel like an utter dunce.

 

[whynot]

I have a back up of my site from the last grade I did, which was back in April. If I replace my currently (and messed up) directory files, will I lose any information? (Like posts and members from after that last upgrade?)

They are in the database.

 

[kiwixpop]

okay thanks, so I won't lose anything. That will be much easier to fix .

I run a roleplay forum and we have over 6,000 threads and over 170,000 posts and I don't want to lose anyone's stories. ^^'

 

[Paul B]

Which add-ons do you have installed?
Have you uninstalled any recently?

Those columns were added in 1.5 Beta 1.

 

[kiwixpop]

I have quite a few installed. The ones I uninstalled were :

Nobita: comment like, profile cover, BD medals (I hope to get this one back), Waindigo user edit front end, the tag me addon and the bookmarks

I also disabled all of the addons and still got the errors

 

[Chris D]

This may help:

I think you already did this, but it might have been before uninstalling that add on in which case we don't actually know for sure whether that did do some damage. That said, I would be expecting to see errors if any of these columns didn't exist.

Run each one of these and note which fail and which succeed. They are the same queries I gave you when you first had the problem.

            ALTER TABLE xf_profile_post_comment
            ADD message_state ENUM('visible', 'moderated', 'deleted') NOT NULL DEFAULT 'visible'

            ALTER TABLE xf_profile_post_comment
            ADD likes INT UNSIGNED NOT NULL DEFAULT 0

            ALTER TABLE xf_profile_post_comment
            ADD like_users BLOB NOT NULL

            ALTER TABLE xf_profile_post_comment
            ADD warning_id INT UNSIGNED NOT NULL DEFAULT 0,

            ALTER TABLE xf_profile_post_comment
            ADD warning_message VARCHAR(255) NOT NULL DEFAULT ''

Of course it's a difficult scenario for us to support fully as there is potentially an add on involved.

This was likely caused by an add-on to do with liking profile post comments. Upgrade the profile post comment liking add-on, then run the queries above, and if necessary re-run the upgrade.

 

[kiwixpop]

Sadly I am still having this issue.

 

[Chris D]

What are they specifically?

 

[kiwixpop]

I have removed the files for the addons I believe was causing the issue, I still get this

Server Error

Mysqli prepare error: Unknown column 'profile_post_comment.message_state' in 'where clause'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/ProfilePost.php at line 1100
XenForo_Model_ProfilePost->getProfilePostComments() in XenForo/Model/ProfilePost.php at line 1317
XenForo_Model_ProfilePost->addProfilePostCommentsToProfilePosts() in XenForo/ControllerPublic/Member.php at line 259
XenForo_ControllerPublic_Member->actionMember() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/guiltyp/docs/xenforo/index.php at line 13

 

[Chris D]

Then I don't believe you read or performed the actions in my post here:

XF 1.5 - Errors due to Add on conflicts

 

[kiwixpop]

How do I do that?

 

[Chris D]

If you are not comfortable with or don't know how to run queries using PhpMyAdmin then you will either need to contact your host so they can do it for you, or restore a recent back up.

We've given you the solutions, you need to carry them out, somehow, to fix the problem.

Do you have a back up before this problem happened?

 

[bailer]

Edit:
this query worked for me.

ALTER TABLE xf_profile_post_comment
ADD message_state ENUM('visible', 'moderated', 'deleted') NOT NULL DEFAULT 'visible'

 

[borbole]

How do I do that?

Simply copy/paste those queries and run them at the phpmyadmin.

 

[kiwixpop]

Contacted my host and we fixed it thanks!