Re: Column count doesn't match value count at row 1 after adding new rows

[Larry Derejko]

I hope this is what you are looking for. these are the create statments

Thanks Larry


CREATE TABLE `listings` (
`id` int(11) NOT NULL DEFAULT '0',
`name` varchar(512) NOT NULL,
`description` text,
`notes` text,
`Emailed_Date` varchar(60) DEFAULT NULL,
`Phoned_Date` varchar(60) DEFAULT NULL,
`Exit_Date` varchar(60) DEFAULT NULL,
`next_contact` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`salesperson_id` int(11) DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`update_to_id` int(11) DEFAULT NULL,
`update_confirmation_id` varchar(255) DEFAULT NULL,
`update_email` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `request_listings` (
`id` int(11) NOT NULL,
`name` varchar(512) NOT NULL,
`description` text,
`notes` text,
`next_contact` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`salesperson_id` int(11) DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`update_to_id` int(11) DEFAULT NULL,
`update_confirmation_id` varchar(255) DEFAULT NULL,
`update_email` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;