#2 checkoutaction.php
Line 120 of checkoutaction.php has a bug with certain installs of MySQL. This line:
$sql = "INSERT INTO checkedout (ID, KitID , StudentID , DateOut , ExpectedDateIn , DateIn , FinePaid , Reserved, Accessories, Notes, CheckoutUser) VALUES ('', '$KitID', '$StudentID', NOW(), '$ReturnDate', '', NULL , NULL, '$Accessories', '$Notes', '$CheckoutUser');";
Should read:
$sql = "INSERT INTO checkedout (KitID , StudentID , DateOut , ExpectedDateIn , DateIn , FinePaid , Reserved, Accessories, Notes, CheckoutUser) VALUES ('$KitID', '$StudentID', NOW(), '$ReturnDate', '', NULL , NULL, '$Accessories', '$Notes', '$CheckoutUser');";
(Note I removed the call to insert values into ID, as it is NotNull, and auto-increment.) If left as before, you get an "Invalid integer" error from MySQL.
