Hi - sorry. i have tried the text only and this has not work either. i have now tried the scond option as i am still very new to all this and do not understand how to edit a sql. database.

The results i recived when uploading the new sql was

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 17, 2007 at 09:11 AM
-- Server version: 4.1.22
-- PHP Version: 5.2.3
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
MySQL said:

#1193 - Unknown system variable 'SQL_MODE'

sorry i'm sure this task is supposed to be easy