Field 'is_solved' doesn't have a default value

six_L · January 27, 2009, 04:02:00 AM

after updated to 2.0 form 1.17, an error has been happended

QuoteField 'is_solved' doesn't have a default value
File: D:\smf\Sources\RepairBoards.php(317) : runtime-created function
Line: 19

Kermit · January 27, 2009, 04:20:31 AM

Hmm aparently sth. is wrong with Blue Dream's Topic Solved mod

You should better uninstall it ,so you can see,if this helps

six_L · January 27, 2009, 04:24:54 AM

How do i uninstall it?

Kermit · January 27, 2009, 04:31:49 AM

Quote from: six_L on January 27, 2009, 04:24:54 AM
How do i uninstall it?

via Package Maneger

AdminCP -> Packages -> related package name - Uninstall

six_L · January 27, 2009, 05:09:03 AM

AdminCP -> Packages ->Browse Packages

QuoteNo packages yet.

Kermit · January 27, 2009, 05:13:36 AM

Weird,did you already try to repair your database tables via phpMyAdmin ?

What is phpMyAdmin?

six_L · January 27, 2009, 05:25:30 AM

Quotedid you already try to repair your database tables via phpMyAdmin ?

yes. i used " REPAIR TABLE smf_messages"

but the problem is still there.

Kermit · January 27, 2009, 05:27:14 AM

Why did you repair just smf_messages table ?

Btw. if you didn't install a mod,it's really weird,that you get an error,which should be caused actually due to installation of topic solved mod...

six_L · January 27, 2009, 05:39:27 AM

QuoteWhy did you repair just smf_messages table ?

i searched the forum to try use their mod for figuring out the problem.

Quotedue to installation of topic solved mod

it's true.

now, "topic solved" has not been installed. my forum is failed to work.

Kermit · January 27, 2009, 05:41:00 AM

Also you installed the mod manually ?

Then you should try to uninstall it manually as well

http://custom.simplemachines.org/mods/index.php?action=parse;mod=1601;attach=83029;smf_version=2.0_Beta_4

Here you can see,how to remove it manually

six_L · January 27, 2009, 05:49:05 AM

thanks you.
i'll try.

six_L · January 27, 2009, 06:42:58 AM

i'v done accroding

Quotehttp://custom.simplemachines.org/mods/index.php?action=parse;mod=1601;attach=83029;smf_version=2.0_Beta_4

for manual installtion.
but shows

QuoteField 'is_solved' doesn't have a default value
File: D:\smf\Sources\RepairBoards.php(317) : runtime-created function
Line: 19

Kermit · January 27, 2009, 06:50:04 AM

Did you run the install.php as well ? and that operations too ?

Move the included file "Subs-TopicSolved.php" to "./Sources".
Move the included file "topicsolved.gif" to "./Themes/default/images/post".

six_L · January 27, 2009, 07:05:20 AM

QuoteDid you run the install.php as well ? and that operations too ?

Move the included file "Subs-TopicSolved.php" to "./Sources".
Move the included file "topicsolved.gif" to "./Themes/default/images/post".

done.

Code Select

install.php shows

QuoteDatabase installation complete!

Dragooon · January 27, 2009, 07:07:07 AM

Try running this query in phpMyAdmin and see if it improves anything

Make sure to backup your DB!

Code Select

ALTER TABLE smf_topics
CHANGE is_solved is_solved TINYINT(3) NOT NULL DEFAULT 0

six_L · January 27, 2009, 07:16:16 AM

QuoteALTER TABLE smf_topics
CHANGE is_solved is_solved TINYINT(3) NOT NULL DEFAULT 0

can't.

Dragooon · January 27, 2009, 07:39:07 AM

What do you mean by can't?

six_L · January 27, 2009, 08:06:23 AM

can't figuring out the problem.

QuoteField 'is_solved' doesn't have a default value
File: D:\smf\Sources\RepairBoards.php(317) : runtime-created function
Line: 19

Dragooon · January 27, 2009, 08:21:42 AM

Still confused, you mean that query didn't help?

six_L · January 27, 2009, 08:53:04 AM

Quoteyou mean that query didn't help?

News:

Field 'is_solved' doesn't have a default value