Mark Posts as Best Answer [Deleted]

[mauzao9]

Even uninstalling this addon over it being disabled, breaks my xF 2 install:


Ideas?

 

[mcatze]

Clear the db, search for the missing field, manually should be a first step.

 

[mauzao9]

Clear the db manually should be a first step.

Even if you uninstall it still leaves the DB Data and breaks the installation? Holy bananas

 

[mcatze]

I do not know this add-on, but this is what i would do. Maybe you can check the install files which tables are used.

 

[Kirby]

Well, the error message is quite clear:

Field 'alternative_best_answers' doesn't have a default value

So either remove this non-standard field from table xf_thread (if you do not use/need it any longer) or make sure it does have a default value.

 

[mauzao9]

So either remove this non-standard field from table xf_thread (if you do not use/need it any longer) or make sure it does have a default value.

Oh! See I was struggling to know what table was it, searching on phpmyadmin wasn't returning results on that table.

 

[Xyphien]

Currently you can either uninstall the add-on, set a default value for the alternative_best_answers field or disable STRICT_TRANS_TABLES in your mysql config.

I will address this issue in the next version.

How do you do any of these steps? I cannot seem to figure this out. No one on my forum can use the service. And with 37k+ members it's really stressful not having them be able to do anything...

 

[Ozzy47]

Use phpMYAdmin, find the table xf_thread and remove the field alternative_best_answers or make sure it does have a default value.

 

[Xyphien]

Use phpMYAdmin, find the table xf_thread and remove the field alternative_best_answers or make sure it does have a default value.

there isn't even a xf_thread in the phpmyadmin

 

[Ozzy47]

Can you see alternative_best_answers anywhere?

 

[Ozzy47]

Do you still have the install files that you uploaded with the addon?

 

[Ozzy47]

@mauzao9 how did you end up resolving the field issue?

 

[Paul B]

there isn't even a xf_thread in the phpmyadmin

There is, otherwise your site would be very broken.

Go to the next page.

 

[Xyphien]

There is, otherwise your site would be very broken.

Go to the next page.

idk why I couldn't look it up, but it was in fact on the second page lol. Yeah, dropping the alternative_best_answers seemed to have fixed the error! Thank you all so much!

 

[Ozzy47]

Glad you found it and it is resolved.

 

[Ariel Schnee]

Why did you delete this addon now?

I wanted it.

My life sucks.

 

[Wesker]

Why did you delete this addon now?

I wanted it.

My life sucks.

I think I have the add on but not sure I am able to share it per XF rules. You can DM the original author he maybe able to send it.

 

[Ozzy47]

You would need the author’s permission to share the addon.

 

[Delta3D]

I've uninstalled the add-on and deleted the only table I could find for it in my MYSQL yet the issue that others here have posted still persists. How do you eliminate this add-on completely? Using 2.0.3 and none of my users can post in the forums now. Help!

 

[Paul B]

As I posted in your other thread, delete the alternative_best_answers field from the xf_thread table.