Could not insert data because Column count doesn't match value count at row 1
now, i was doing work with my database but now in the users section
here's the dump for my users table:
Code: Select all
CREATE TABLE `users` (
`uId` int(6) NOT NULL auto_increment,
`username` text NOT NULL,
`password` text NOT NULL,
`fname` text NOT NULL,
`email` text NOT NULL,
`address` text NOT NULL,
`city` text NOT NULL,
`state` text NOT NULL,
`zip` text NOT NULL,
`country` text NOT NULL,
`phone` text NOT NULL,
`ip` text NOT NULL,
`gid` int(6) NOT NULL default '0',
`rid` int(6) NOT NULL default '0',
`ostatus` tinyint(4) NOT NULL default '0',
`holdreason` text NOT NULL,
`astatus` tinyint(4) NOT NULL default '0',
`date` text NOT NULL,
`deadline` text NOT NULL,
`dead` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`uId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=486;