I am having trouble with the master details view. Somewhere im doing something wrong. I created a main table and linked another table in mysql to it and in dadabik I linked the linked table in master details view selecting the table and foreign key.
Mysql is not updating the foreign key with the right number, so my entries is not displaying in the master details view.
When I use phpmyadmin and change the foreign keys all to 1 then the entries appear in master details view.
[pre]
CREATE TABLE `expences` (
`idexpences` int(11) NOT NULL AUTO_INCREMENT,
`expences_expense` varchar(45) DEFAULT NULL,
`expences_ammount` int(11) DEFAULT NULL,
`expences_total` int(11) DEFAULT NULL,
`debt_cancell_idpersonal_details` int(10) unsigned NOT NULL,
PRIMARY KEY (`idexpences`),
UNIQUE KEY `idexpences_UNIQUE` (`idexpences`),
KEY `fk_expences_debt_cancell_idx` (`debt_cancell_idpersonal_details`),
CONSTRAINT `fk_expences_debt_cancell` FOREIGN KEY (`debt_cancell_idpersonal_details`) REFERENCES `debt_cancell` (`idpersonal_details`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
[/pre]
[pre]
You are using DaDaBIK version 9.2-Monterosso enterprise, installed on 11-15-2018 (installation code: 140855bc739c14ccd4), the latest version of DaDaBIK is 9.2-Monterosso released on 11-07-2018
You are runnning the last release of DaDaBIK
PHP Version: 7.2.10-0ubuntu0.18.04.1
mysql version: 5.7.24-0ubuntu0.18.04.1
Web server: Apache/2.4.29 (Ubuntu)
Client: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36
[/pre]
Mysql is not updating the foreign key with the right number, so my entries is not displaying in the master details view.
When I use phpmyadmin and change the foreign keys all to 1 then the entries appear in master details view.
[pre]
CREATE TABLE `expences` (
`idexpences` int(11) NOT NULL AUTO_INCREMENT,
`expences_expense` varchar(45) DEFAULT NULL,
`expences_ammount` int(11) DEFAULT NULL,
`expences_total` int(11) DEFAULT NULL,
`debt_cancell_idpersonal_details` int(10) unsigned NOT NULL,
PRIMARY KEY (`idexpences`),
UNIQUE KEY `idexpences_UNIQUE` (`idexpences`),
KEY `fk_expences_debt_cancell_idx` (`debt_cancell_idpersonal_details`),
CONSTRAINT `fk_expences_debt_cancell` FOREIGN KEY (`debt_cancell_idpersonal_details`) REFERENCES `debt_cancell` (`idpersonal_details`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
[/pre]
[pre]
You are using DaDaBIK version 9.2-Monterosso enterprise, installed on 11-15-2018 (installation code: 140855bc739c14ccd4), the latest version of DaDaBIK is 9.2-Monterosso released on 11-07-2018
You are runnning the last release of DaDaBIK
PHP Version: 7.2.10-0ubuntu0.18.04.1
mysql version: 5.7.24-0ubuntu0.18.04.1
Web server: Apache/2.4.29 (Ubuntu)
Client: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36
[/pre]