Hi Javier
I just follow the wizard to connect to the database and import the data. I then try to edit any of the data and save it back, it doesn't have to be in the time field and it just gives me the error.
This is the database and a standard kind of row.
-- phpMyAdmin SQL Dump
-- version 4.6.5.2
--
https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 13, 2017 at 08:31 AM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 7.1.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `fafa1424_records`
--
-- --------------------------------------------------------
--
-- Table structure for table `newrecords`
--
CREATE TABLE `newrecords` (
`id` int(11) NOT NULL,
`memberID` varchar(4) NOT NULL,
`animalID` varchar(25) DEFAULT NULL,
`nickName` varchar(50) NOT NULL,
`animal` varchar(256) NOT NULL,
`family` varchar(150) DEFAULT NULL,
`code` varchar(10) DEFAULT NULL,
`dateOfEncounter` date DEFAULT '1970-01-01',
`encounterAddress` varchar(256) DEFAULT NULL,
`postcode` varchar(256) DEFAULT NULL,
`LGA` varchar(256) DEFAULT NULL,
`encounterType` varchar(100) DEFAULT NULL,
`animalCondition` varchar(256) DEFAULT NULL,
`comment` mediumtext,
`animalSex` varchar(30) DEFAULT NULL,
`age` varchar(50) DEFAULT NULL,
`initalWeight` varchar(20) DEFAULT NULL,
`pouchCondition` varchar(256) DEFAULT NULL,
`initialAssessor` varchar(256) DEFAULT NULL,
`rehabilitatorName` varchar(256) DEFAULT NULL,
`fateOfAnimal` varchar(256) DEFAULT NULL,
`memberHolding` varchar(256) DEFAULT NULL,
`dateOfFate` date DEFAULT '1970-01-01',
`releaseLocation` varchar(256) DEFAULT NULL,
`releasePostcode` varchar(256) DEFAULT NULL,
`releaseGPS` varchar(50) DEFAULT NULL,
`chipNumber` varchar(256) DEFAULT NULL,
`rehabilitator1` varchar(256) DEFAULT NULL,
`rehabilitator2` varchar(256) DEFAULT NULL,
`rehabilitator3` varchar(256) DEFAULT NULL,
`rehabilitator4` varchar(256) DEFAULT NULL,
`date_transfer1` date DEFAULT '0000-00-00',
`date_transfer2` date DEFAULT '0000-00-00',
`date_transfer3` date DEFAULT '0000-00-00',
`date_transfer4` date DEFAULT '0000-00-00',
`timeOfCall` time DEFAULT NULL,
`callerDetails` varchar(256) DEFAULT NULL,
`contactNumber` varchar(20) DEFAULT NULL,
`incidentDetails` varchar(1024) DEFAULT NULL,
`memberContacted` varchar(256) DEFAULT NULL,
`actionTaken` varchar(256) DEFAULT NULL,
`finalised` varchar(5) DEFAULT NULL,
`recordFinalised` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `newrecords`
--
INSERT INTO `newrecords` (`id`, `memberID`, `animalID`, `nickName`, `animal`, `family`, `code`, `dateOfEncounter`, `encounterAddress`, `postcode`, `LGA`, `encounterType`, `animalCondition`, `comment`, `animalSex`, `age`, `initalWeight`, `pouchCondition`, `initialAssessor`, `rehabilitatorName`, `fateOfAnimal`, `memberHolding`, `dateOfFate`, `releaseLocation`, `releasePostcode`, `releaseGPS`, `chipNumber`, `rehabilitator1`, `rehabilitator2`, `rehabilitator3`, `rehabilitator4`, `date_transfer1`, `date_transfer2`, `date_transfer3`, `date_transfer4`, `timeOfCall`, `callerDetails`, `contactNumber`, `incidentDetails`, `memberContacted`, `actionTaken`, `finalised`, `recordFinalised`) VALUES
(721, '0335', '0335-15-0003', 'Smokey', 'Frogmouth, Tawny', 'BN', '313', '2015-09-16', 'South West Rocks Road, ', '2440 - POLA CREEK', 'Kempsey Shire Council', 'Collision - Motor Vehicle', 'Injury to body', 'Found on the road at night, possibly hit by car.16', 'Unknown', 'Unknown', 'unkown', 'N/A', '0335 - Yvonne', '0335 - Yvonne', '', '0335 - Yvonne', NULL, '', '', '', '', '', '', '', '', '1970-01-01', '1970-01-01', '1970-01-01', '1970-01-01', '05:12:12', '', '', '', '', '', '', 0);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `newrecords`
--
ALTER TABLE `newrecords`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `animalid` (`animalID`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `newrecords`
--
ALTER TABLE `newrecords`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13709;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;