error when sending message to members

[chocodz]

XF\Db\Exception: MySQL query error [1364]: Field 'purchase_type' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
5. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
6. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
7. XF\Mvc\Entity\Entity->save() in src/XF/Service/Conversation/Creator.php at line 227
8. XF\Service\Conversation\Creator->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 42
9. XF\Service\Conversation\Creator->save() in src/XF/Pub/Controller/Conversation.php at line 328
10. XF\Pub\Controller\Conversation->actionAdd() in src/XF/Mvc/Dispatcher.php at line 352
11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
15. XF\App->run() in src/XF.php at line 524
16. XF::runApp() in index.php at line 20

how to solve that please

 

[chocodz]

@ENXF NET can you check that please

 

[Genesisdude]

What plugins do you have installed on your forum? Could be a issue with one of the plugins. If you have any installed, try disabling them one by one to figure out which one is causing this issue.

 

[chocodz]

What plugins do you have installed on your forum? Could be a issue with one of the plugins. If you have any installed, try disabling them one by one to figure out which one is causing this issue.

GenesisdudeI tried to disable them all and same error

 

[chocodz]

@Splicho can u check that please 🙏

 

[Splicho]

@Splicho can u check that please 🙏

chocodzWhat exactly did you try to do? And when does this error occur

 

[chocodz]

What exactly did you try to do? And when does this error occur

Splichoi tried to message members this poped up

 

[BattleKing]

Set the default value for the field purchase_type
How did you disabled all addons to see if the problem is not raised of one of these?

 

[chocodz]

Set the default value for the field purchase_type
How did you disabled all addons to see if the problem is not raised of one of these?

BattleKingi disabled all addon and i still cant send message to members

 

[BattleKing]

i disabled all addon and i still cant send message to members

chocodzand the error is still the same?

 

[chocodz]

and the error is still the same?

BattleKingYes still same error

 

[thomsa]

Yes still same error

chocodzlist your install addon here.

 

[chocodz]

list your install addon here.

thomsaHere you are

 

[thomsa]

Here you are
View attachment 37210 View attachment 37211

chocodzto disable all

and check about purchase addon service.

 

[shqawe]

If you can enable development mode then you can go to class extensions page and see which addon is extend conversation class and disable the class extension from the same page because if you don't uninstall the addon the extended class will be extended even when the addon is disabled.

 

[chocodz]

If you can enable development mode then you can go to class extensions page and see which addon is extend conversation class and disable the class extension from the same page because if you don't uninstall the addon the extended class will be extended even when the addon is disabled.

shqaweLike that ?

 

[shqawe]

Like that ? View attachment 37212

chocodzExactlly, now try to send pm and see if message succssfully sent then try to disable these classes one by one to find which one is make the problem.

 

[chocodz]

Exactlly, now try to send pm and see if message succssfully sent then try to disable these classes one by one to find which one is make the problem.

shqaweI tried but Still same error :/

 

[BattleKing]

I tried but Still same error :/

chocodzAgain is it still the same error message as in the first post?

 

[shqawe]

I tried but Still same error :/

chocodzthe best & fast solution what @BattleKing said just change the default value for purchase_type column.

 

[chocodz]

the best & fast solution what @BattleKing said just change the default value for purchase_type column.

shqaweWhere to change that ?

 

[sucre13]

What version of PHP are you using?

 

[chocodz]

What version of PHP are you using?

sucre13I am using 8.1 php .