1 Topic by AWiT.at

  • AWiT.at
  • AWiT.at
  • Member
  • Offline
  • From: Vienna / AT / EU / Tera / Sol
  • Registered: 2019-09-19
  • Posts: 1

Topic: Error Checking Version iRedAdmin / Error mysql database backup

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9 OPENLDAP edition
- Deployed with iRedMail Easy or the downloadable installer? NO
- Linux/BSD distribution name and version: Ubuntu 18.04 LTS Server
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? not yet
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Salve !

Since a few days i got this Error msg while Backing up my mysql databases with
"/var/vmail/backup/backup_mysql.sh" script.

ERROR 1364 (HY000) at line 1: Field 'id' doesn't have a default value

therefore i got an error msg into the iRedAdmin Dashboard after login (see Screenshot/Attachment)

BR
AW

Post's attachments

iredadmin_snapshot_20190919.png
iredadmin_snapshot_20190919.png 7.87 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

AWiT.at's Website

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,156

Re: Error Checking Version iRedAdmin / Error mysql database backup

- Did you modify the "iredadmin" SQL database?
- Try to re-create sql tables in "iredadmin" db with template file: /opt/www/iredadmin/SQL/iredadmin.mysql.