coldwind โพสต์ 2020-7-26 22:13:22

What is this? How do I solve this?

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 โพสต์ 2020-7-26 22:22:45

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

popiazaza โพสต์ 2020-7-27 11:26:40

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

coldwind โพสต์ 2020-7-27 17:29:05

Does not...oT^To

popiazaza โพสต์ 2020-7-27 20:50:30

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.




หน้า: [1]
ดูในรูปแบบกติ: What is this? How do I solve this?