Support No Answer 'tc_motm_thread_id' doesn't have a default value

[SelfSufficientMe]

Can you help me with this please...? I haven't been able to get MOTM to run since installing it a month ago.

Server Error
Mysqli statement execute error : Field 'tc_motm_thread_id' doesn't have a default value

 

[Clement]

You have the old themescorp version installed ?

 

[SelfSufficientMe]

You have the old themescorp version installed ?

no, I uninstalled it before installing this version

 

[Clement]

Can you please check if the field tc_motm_thread_id is in your xf_thread table in the database

 

[SelfSufficientMe]

No it doesn't appear to be there... Although, I'm not all that confident in working on databases to be honest. I did a search for the phrase and it came back 0.

 

[Clement]

A phrase ? It's not a phrase that you search, you got to go in the xf_thread table in the database (phpmyadmin) and then in structure tab.

 

[SelfSufficientMe]

Ok I've found the right place to look thank you... and no field tc_motm_thread_id is not there.

What should I do to get this to work?

 

[Clement]

I am stupid... it's in the xengallery_album table you got to look.

 

[SelfSufficientMe]

Ahh ok lol... Yes, field tc_motm_thread_id is in this table.

 

[Clement]

Then the uninstall of the TC version didn't work correctly.

Delete that column, it should do it.

Clément