Hi,
you shouldn’t have more than one primary key in your table. Please compare your table structure with the following. The ONLY primary key is ‘id’.
Change this and your CRUD generator should work. You can check this btw. using phpMyAdmin.
Here is the correct SQL up to chapter 6
–
– Tabellenstruktur für Tabelle tbl_issue
–
CREATE TABLE tbl_issue
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(256) NOT NULL,
description
varchar(2000) DEFAULT NULL,
project_id
int(11) DEFAULT NULL,
type_id
int(11) DEFAULT NULL,
status_id
int(11) DEFAULT NULL,
owner_id
int(11) DEFAULT NULL,
requester_id
int(11) DEFAULT NULL,
create_time
datetime DEFAULT NULL,
create_user_id
int(11) DEFAULT NULL,
update_time
datetime DEFAULT NULL,
update_user_id
int(11) DEFAULT NULL,
PRIMARY KEY (id
),
KEY FK_issue_project
(project_id
),
KEY FK_issue_owner
(owner_id
),
KEY FK_issue_requester
(requester_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
Let me know if this helps.
Peter