Rob,
please post structure of these tables here.
Thank you Jane. This s a dump of the tables that giving the error.
Thanks.
Rob
-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Jul 27, 2008 at 02:30 PM
-- Server version: 5.0.62
-- PHP Version: 5.2.3
--
-- Database: `nyrc_2`
--
-- --------------------------------------------------------
--
-- Table structure for table `For_Sale`
--
CREATE TABLE `For_Sale` (
`id` int(11) NOT NULL auto_increment,
`group` varchar(50) NOT NULL,
`buysell` varchar(10) NOT NULL,
`item` varchar(255) NOT NULL,
`description` text NOT NULL,
`price` varchar(20) default NULL,
`contact` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='buysell' AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Table structure for table `Passwords`
--
CREATE TABLE `Passwords` (
`id` int(11) NOT NULL auto_increment,
`password` varchar(50) NOT NULL,
`group` varchar(50) default NULL,
`name` varchar(50) NOT NULL,
`position` varchar(50) default NULL,
`email` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Table structure for table `calendar`
CREATE TABLE `calendar` (
`id` int(11) NOT NULL auto_increment,
`group` varchar(50) NOT NULL,
`start_date` datetime NOT NULL,
`start_time` varchar(50) default NULL,
`duration` varchar(255) NOT NULL,
`event_name` varchar(255) NOT NULL,
`description` text NOT NULL,
`contact` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
-- --------------------------------------------------------
--
-- Table structure for table `committee`
--
CREATE TABLE `committee` (
`id` int(11) NOT NULL auto_increment,
`group` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`phone` varchar(50) default NULL,
`email` varchar(50) default NULL,
`position` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Table structure for table `contacts`
--
CREATE TABLE `contacts` (
`id` int(11) NOT NULL auto_increment,
`surname` varchar(50) NOT NULL,
`first_name` varchar(50) NOT NULL,
`position` varchar(50) default NULL,
`list_order` int(11) NOT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`responsibility` varchar(50) default NULL,
`group` varchar(50) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`id` int(11) NOT NULL auto_increment,
`description` varchar(255) NOT NULL,
`file` varchar(50) NOT NULL,
`group` varchar(50) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `gallery`
--
CREATE TABLE `gallery` (
`id` int(11) NOT NULL auto_increment,
`group` varchar(50) NOT NULL,
`pic1` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`id` int(11) NOT NULL auto_increment,
`group` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
--
-- Table structure for table `links`
--
CREATE TABLE `links` (
`id` int(11) NOT NULL auto_increment,
`group` varchar(50) default NULL,
`link_name` varchar(200) NOT NULL,
`url` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;