I have set up a contractors database with details table shown below. It was working fine for a while but now I am getting the attached error. Would anyone hove any ideas as to why I am getting this error. I am new to moodle so would appreciate any help you can give. Thanks
CONTRACTORS
new table 'details' setup in new database 'contractors'
Database contractors - Table details running on localhost
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jan 31, 2005 at 03:54 PM
# Server version: 4.0.15
# PHP Version: 4.3.3
#
# Database : `contractors`
#
# --------------------------------------------------------
#
# Table structure for table `details`
#
CREATE TABLE `details` (
`username` text NOT NULL,
`password` mediumtext NOT NULL,
`date` date NOT NULL default '0000-00-00',
`firstname` mediumtext NOT NULL,
`lastname` mediumtext NOT NULL,
`company` mediumtext NOT NULL,
`company_tel` mediumint(9) NOT NULL default '0',
`vehicle_reg` mediumtext NOT NULL,
`mobile` mediumint(9) NOT NULL default '0',
`induction_year` date NOT NULL default '0000-00-00',
`location` mediumtext NOT NULL,
`email` mediumtext NOT NULL,
FULLTEXT KEY `username` (`username`),
FULLTEXT KEY `username_2` (`username`)
) TYPE=MyISAM;
#
# Dumping data for table `details`
#
INSERT INTO `details` VALUES ('johndoe05', 'johndoe05', '2005-01-31', 'John Doe', '', 'Company A',
1234567, '05 L 1234', 87, '2005-01-31', 'Limerick', 'bobhope05@stryker.com');