New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: Database > Backup/Restore > Restore menampilkan error #832

Closed
eddieridwan opened this Issue Mar 1, 2018 · 1 comment

Comments

1 participant
@eddieridwan
Collaborator

eddieridwan commented Mar 1, 2018

Menampilkan error seperti berikut pada waktu Database > Backup/Restore > Restore menggunakan file .sql hasil Database > Backup/Restore > Backup.

Error: CREATE TABLE inventaris (id int(11) NOT NULL AUTO_INCREMENT,id_jenis_barang int(6) DEFAULT NULL,asal_sendiri int(6) DEFAULT NULL,asal_pemerintah int(6) DEFAULT NULL,asal_provinsi int(6) DEFAULT NULL,asal_kab int(6) DEFAULT NULL,asal_sumbangan int(6) DEFAULT NULL,hapus_rusak int(6) DEFAULT NULL,hapus_dijual int(6) DEFAULT NULL,hapus_sumbangkan int(6) DEFAULT NULL,tanggal_mutasi date NOT NULL,jenis_mutasi int(6) DEFAULT NULL,keterangan varchar(100) DEFAULT NULL,PRIMARY KEY (id),KEY id_jenis_barang (id_jenis_barang),CONSTRAINT inventaris_ibfk_1 FOREIGN KEY (id_jenis_barang) REFERENCES jenis_barang (id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1;Error: CREATE TABLE jenis_barang (id int(11) NOT NULL AUTO_INCREMENT,nama varchar(30) DEFAULT NULL,keterangan varchar(100) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=latin1;Error: CREATE TABLE suplemen (id int(11) NOT NULL AUTO_INCREMENT,nama varchar(100) DEFAULT NULL,sasaran tinyint(4) DEFAULT NULL,keterangan varchar(300) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

@eddieridwan eddieridwan added the bug label Mar 1, 2018

@eddieridwan eddieridwan added this to SEDANG DIKERJAKAN in Rilis yang sedang dikerjakan Mar 7, 2018

@eddieridwan eddieridwan self-assigned this Mar 7, 2018

eddieridwan added a commit that referenced this issue Mar 7, 2018

#831, #832: Sekarang menu Database > Backup/Restore membuat backup ya…
…ng berhasil diimpor phpmyadmin, dan bisa di-restore tanpa error. [bug-fix]
@eddieridwan

This comment has been minimized.

Collaborator

eddieridwan commented Mar 7, 2018

Sudah dicommit ke master.

@eddieridwan eddieridwan closed this Mar 7, 2018

@eddieridwan eddieridwan moved this from SEDANG DIKERJAKAN to SUDAH DI MASTER in Rilis yang sedang dikerjakan Mar 7, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment