[ solved] Can't execute SQL in 2.89

[Markco]

Version of script: 2.89
Version phpmyadmin : Version : 4.9.6
server : MariaDB 10
Serveur Web
nginx/1.17.10
Version du client de base de données : libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
Extension PHP : mysqliDocumentation mbstringDocumentation
Version de PHP : 7.3.24
Hello,

Result debug

Code: Select all

 Error:

Can't execute SQL: INSERT INTO `hesk_tickets` ( `trackid`, `name`, `email`, `category`, `priority`, `subject`, `message`, `dt`, `lastchange`, `articles`, `ip`, `language`, `openedby`, `owner`, `attachments`, `merged`, `history` , `custom1`, `custom2`, `custom3`, `custom4`, `custom5`, `custom6`, `custom7`, `custom8`, `custom9`, `custom10`, `custom11`, `custom12`, `custom13`, `custom14`, `custom15`, `custom16`, `custom17`, `custom18`, `custom19`, `custom20`, `custom21`, `custom22`, `custom23`, `custom24`, `custom25`, `custom26`, `custom27`, `custom28`, `custom29`, `custom30`, `custom31`, `custom32`, `custom33`, `custom34`, `custom35`, `custom36`, `custom37`, `custom38`, `custom39`, `custom40`, `custom41`, `custom42`, `custom43`, `custom44`, `custom45`, `custom46`, `custom47`, `custom48`, `custom49`, `custom50` ) VALUES ( '14R-QBM-MLS3', 'Marco', 'xx@free.fr', '8', '3', 'Test de mail depuis le contact', 'test', NOW(), NOW(), NULL, '90.54.125.xx', NULL, '0', '0', '', '', '
09/09/2021 - 12:47:18 | submitted by Customer
' , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )

MySQL said:
Field 'status' doesn't have a default value

Connection test at the database is OK
Connection test at mail il OK

How to fix the problem?

Thank you

[Markco]

Add:
Repair all table in phpmyadmin did not work, I always have the Mysql execution mistake

[Klemen]

See my reply here, and try running that SQL code in phpMyAdmin:
viewtopic.php?t=6501

[Markco]

ok thank you very much it's Solved