Defect Report 01 submitted.

Dump:

Notice: Undefined variable: conn in C:\Users\April\Documents\IT810\VolunTrackKU\src\voluntrack\DBManager.php on line 55

Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\Users\April\Documents\IT810\VolunTrackKU\src\voluntrack\DBManager.php:72 Stack trace: #0 C:\Users\April\Documents\IT810\VolunTrackKU\src\voluntrack\register.php(14): voluntrack\DBManager->register_user('Jim', 'Tompson', 'r', '[email protected]', '$2y$10$FV24anA5...') #1 {main} thrown in C:\Users\April\Documents\IT810\VolunTrackKU\src\voluntrack\DBManager.php on line 72

Test for IT810

Can't create foreign key constraint error creating the USER_PROJECT table. SQL follows:

CREATE TABLE IF NOT EXISTS ebdb.USER_PROJECT(USER_IDINT UNSIGNED NOT NULL,PROJECT_IDINT UNSIGNED NOT NULL,PROJECT_START_DATE_TIMEDATETIME(0) NOT NULL,PROJECT_END_DATE_TIMEDATETIME(0) NOT NULL, INDEXPROJECT_ID_idx (PROJECT_IDASC,USER_IDASC), INDEXUser_id _idx (USER_IDASC), CONSTRAINTUser_id FOREIGN KEY (USER_ID) REFERENCES ebdb.USER (USER_ID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT PROJECT_ID FOREIGN KEY (PROJECT_ID,USER_ID) REFERENCES ebdb.PROJECT (Project_Name,Project_id) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB ;