Version 8 (modified by 14 years ago) (diff) | ,
---|
gbic server database for bbmri : exists contains data but cannot be shown in the molgenis application forms. Try to uploda form UI , problems with :
- truncate tables : bbmri, ...
''Unknown column 'Contact.Affilication' in 'field list'''' '''Unknown column 'Contact.labworker' in 'field list'''' '''Unknown column 'Contact.Roles' in 'field list''''
--> created the field in db bbmri table Contact & Roles .
Try to mysql dumb form localhost & import in server . Problem with bbmri table (!) There is no bbmri table
Contact table is full --> truncate, try to import ...
Unknown column 'Panel_individuals.individuals' in 'field list' mysql> alter table Panel_individuals ADD individuals VARCHAR(60);
Unknown column 'BiobankInstitute?.Institutes' in 'field list' mysql> alter table BiobankInstitute? ADD Institutes VARCHAR(60); Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0
''antonak@gbic:~$ mysqlimport -u molgenis -p bbmri bbmri.sql '' ''Enter password: '' ''mysqlimport: Error: Table 'bbmri.bbmri' doesn't exist, when using table: bbmri''