I tried using topic solved (last version published) and it wouldn't work.
So I uninstalled it and removed it from the packages directory.
Now i get an error that prohibits any board from posting a topic. There are no options for topic solved in the boards / modify settings.
This is the error
Field 'is_solved' doesn't have a default value
File: /home/mejilla1/public_html/sibionus.com/Sources/Subs-Post.php
Line: 1869
I need to get back, I presume, something it overwrote to bring me back to a full 2.0.17 install.
help?
same answer as from the mod's support thread... you'll need to edit your database table for it
any other mods that you install that give the same error about not having a default value, you'd do the same....find it in your database and change default to null
usually you can find them either in the the topics table or the message table depending on the mod.
Quote from: shadav on January 24, 2021, 02:46:33 PM
Quote from: rcane on January 24, 2021, 01:57:09 PM
Using 2.0.17 and Ants Mutant curve theme.
Install was fine. trying to post the first topic to test it and i get this error
Field 'is_solved' doesn't have a default value
File: /home/mydomain/public_html/mywebaddress.com/Sources/Subs-Post.php
Line: 1869
in your database find smf_topics and click on structure
find is_solved and edit it
change default to NULL and save
The field is_solved needs a default value.
And shadav beat me to it :P
Yep, I needed to add that NULL value.
though, across any themes installed (all of them) the mod doesn't actually work for me. I can post fine now--just no buttons for 'solved'.
When you installed the mod, did you apply it to the additional themes?
I believe so. I'll Can do it again to verify
Yes, I didn't have the theme's parent button checked off though some of the children were.
Seems to be working now....and thus I shall click your solved button as tribute.
beter reverse the mod parser and remove it from your DB to be clean.. never understood while this is not done when uninstaling your mods :P
because many mods need to be uninstalled to be upgraded....
or maybe you're just uninstalling the mod temporarily....
How many screams would we hear if someone with a mod that has 150 settings uninstalled the mod to test something and then lost all the settings because of that?