Advertisement:

Author Topic: Topic Solved mod resulted in no new posts allowed  (Read 401 times)

Offline rcane

  • Semi-Newbie
  • *
  • Posts: 77
Topic Solved mod resulted in no new posts allowed
« on: January 24, 2021, 02:37:26 PM »
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?

Online shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,080
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Topic Solved mod resulted in no new posts allowed
« Reply #1 on: January 24, 2021, 02:49:45 PM »
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.

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

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,621
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Topic Solved mod resulted in no new posts allowed
« Reply #2 on: January 24, 2021, 02:50:02 PM »
The field is_solved needs a default value.

And shadav beat me to it :P
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline rcane

  • Semi-Newbie
  • *
  • Posts: 77
Re: Topic Solved mod resulted in no new posts allowed
« Reply #3 on: January 24, 2021, 08:49:19 PM »
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'.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,092
  • Gender: Male
    • Kindred-999 on GitHub
Re: Topic Solved mod resulted in no new posts allowed
« Reply #4 on: January 24, 2021, 11:23:52 PM »
When you installed the mod, did you apply it to the additional themes?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline rcane

  • Semi-Newbie
  • *
  • Posts: 77
Re: Topic Solved mod resulted in no new posts allowed
« Reply #5 on: January 25, 2021, 12:36:00 AM »
I believe so. I’ll Can do it again to verify

Offline rcane

  • Semi-Newbie
  • *
  • Posts: 77
Re: Topic Solved mod resulted in no new posts allowed
« Reply #6 on: January 25, 2021, 01:01:12 AM »
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.

Offline Herman's Mixen

  • SMF Hero
  • ******
  • Posts: 7,304
    • HermanMixen on Facebook
    • @Hermans_Mixen on Twitter
    • Herman's Mixen
Re: Topic Solved mod resulted in no new posts allowed
« Reply #7 on: January 25, 2021, 02:15:42 AM »
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
Met vriendelijke groet, The Burglar!

 House Mixes | Mixcloud | Any Intelligent fool can make things bigger, more complex, and more violent.
It takes a touch of genius - and a lot of courage - to move in the opposite direction. - Albert Einstein

Former Godfather of our dutch community ;)

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,092
  • Gender: Male
    • Kindred-999 on GitHub
Re: Topic Solved mod resulted in no new posts allowed
« Reply #8 on: January 25, 2021, 07:39:53 AM »
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?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."