What is this? How do I solve this?

coldwind

Discuz! Database Error(1364) Field 'storage' doesn't have a default valueREPLACE INTO common_admincp_session SET `uid`='1' , `adminid`='1' , `panel`='1' , `dateline`='1595776409' , `ip`='xxx.76.xxx.1xx' , `errorcount`='-1'



What is this? How do I solve this?
After logging in admin mode, these symptoms appear.

coldwind

and I saw this "การ backupสำรองข้อมูลเว็บDiscuzก่อนเว็บพังและวิธีการกู้ข้อมูล" and followed it with reference.
and then it show "error" all of them....

popiazaza

Try to open phpMyAdmin, go to "pre_common_admincp_session" table and manually delete all rows there.

coldwind

Does not...oT^To

popiazaza

It can happen in MariaDB 10.2.4+

Workaround below, although I recommend to upgrade to Discuz! X3.5 when it is available to get native compatibility.


1. Open phpmyadmin as root database user.
2. Go to "Variables" page.
3. Search for "mode".
4. Click "Edit" button on "sql mode".
5. Remove "STRICT_TRANS_TABLES" (and comma if exist).
6. Click "Save" button.