2.0.19 Database error

Started by S H Legal, April 07, 2025, 04:59:00 AM

Previous topic - Next topic

S H Legal

Field 'is_solved' doesn't have a default value
File: /home/sites/mndeu8pss3zz/public_html/cumbrianonces.co.uk/Sources/Subs-Post.php
Line: 1878

I have a simular message on two forums both on same server & both started yesterday & stopping people posting

GL700Wing

Quote from: S H Legal on April 07, 2025, 04:59:00 AMField 'is_solved' doesn't have a default value
File: /home/sites/mndeu8pss3zz/public_html/cumbrianonces.co.uk/Sources/Subs-Post.php
Line: 1878

I have a simular message on two forums both on same server & both started yesterday & stopping people posting
Try this solution  (you need to make a database edit).
Life doesn't have to be perfect to be wonderful ...

Slava
Ukraini!
"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

Kindred

1- Please do not post the same question multiple times.
2- Please do not piggyback on someone else's report -- especially a report that is completely different from your issue.
Слaва
Украинi

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."

S H Legal

Quote from: Kindred on April 07, 2025, 07:21:29 AM1- Please do not post the same question multiple times.
2- Please do not piggyback on someone else's report -- especially a report that is completely different from your issue.

sorry new & posted & then started new topic as case of panic stations

S H Legal

Field 'is_solved' doesn't have a default value
File: /home/sites/mndeu8pss3zz/public_html/premierpunters.uk/Sources/Subs-Post.php
Line: 1878

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.19, while your database is at version 2.0.18. The above error might possibly go away if you execute the latest version of upgrade.php.


getting this message on a forum any one know if there is a patch

Illori

you have a thread on this already here https://www.simplemachines.org/community/index.php?topic=591432.0, please dont open multiple threads on the same issue.

the version error is not an issue you need to fix.

GL700Wing

Quote from: S H Legal on April 08, 2025, 05:23:33 AMField 'is_solved' doesn't have a default value
File: /home/sites/mndeu8pss3zz/public_html/premierpunters.uk/Sources/Subs-Post.php
Line: 1878
@S H Legal  As per this post you need to make a database edit.
In your database find smf_topics and click on structure
Find is_solved and edit it
Change default to NULL and save

More info here.
Life doesn't have to be perfect to be wonderful ...

Slava
Ukraini!
"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

Advertisement: