Sorry, there was a problem reacting to this content

[*Salvo*]

Hi all,

I m facing an issue described in the subject. From admincp log:

 

IPS\Db\Exception::1364

INSERT INTO `ipb_core_reputation_index` ( `member_id`, `app`, `type`, `type_id`, `rep_date`, `rep_rating`, `member_received`, `rep_class`, `class_type_id_hash`, `item_id`, `reaction` ) VALUES ( 1, 'forums', 'pid', 78477, 1703684445, 1, 2799, 'IPS\forums\Topic\Post', '418cb08783ec966ec54cca1cad5ea341', 4198, 1 )
Field 'misc' doesn't have a default value

and I don't know if it can be helpful, backtrace:

 

#0 /home/***/public_html/forum/system/Db/Db.php(941): IPS\_Db->preparedQuery()
#1 /home/***/public_html/forum/system/Content/Reactable.php(122): IPS\_Db->insert()
#2 /home/****/public_html/forum/system/Content/Controller.php(3238): IPS\forums\Topic\_Post->react()
#3 /home/***/public_html/forum/system/Content/Controller.php(2425): IPS\Content\_Controller->_react()
#4 /home/***/public_html/forum/applications/forums/modules/front/forums/topic.php(1276): IPS\Content\_Controller->__call()
#5 /home/***/public_html/forum/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_topic->__call()
#6 /home/***/public_html/forum/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#7 /home/***/public_html/forum/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute()
#8 /home/***/public_html/forum/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute()
#9 /home/***/public_html/forum/index.php(13): IPS\_Dispatcher->run()
#10 {main}

What is missing?

 

[Nathan Explosion]

You likely have strict mode enabled on mysql. Ask your host about turning it off.

Edited December 27, 2023 by Nathan Explosion

[*Salvo*]

@Nathan Explosion That did the trick! Thank you so much!

[Stuart Silvester]

You have a `misc` column on the `core_reputation_index` table that isn't part of Invision Community. It's possible that this was added by a third party at some point and can be removed if you are no longer using it.

[*Salvo*]

Yup, I didn't know it. II will delete it immediately, thank you so much!