MySQL Forums
Forum List  »  PHP

Column count doesn't match value count at row 1
Posted by: Mark Williams
Date: October 01, 2012 09:47PM

Hi all. Long story short. I have no idea what I am doing here. My website got hacked and I didn't have a backup of the DB newer than 3 weeks before the have (shame on me). I am trying to merge the newest post table into an older backup but I'm running into problems. I'm getting "ERROR 1136 (21S01) at line 60: Column count doesn't match value count at row 1" and I have no idea why and I'm hoping that you guys might be able to spot something. Here is the first few lines in the DB




SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- line 10
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `hacksden_forum1`
--

-- --------------------------------------------------------

--
-- Table structure for table `post`
--

CREATE TABLE IF NOT EXISTS `post` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`parentid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext,
`allowsmilie` smallint(6) NOT NULL default '0',
`showsignature` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`visible` smallint(6) NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`infraction` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
`htmlstate` enum('off','on','on_nl2br') NOT NULL default 'on_nl2br',
`post_thanks_amount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`),
KEY `threadid_visible_dateline` (`threadid`,`visible`,`dateline`,`userid`,`postid`),
KEY `dateline` (`dateline`),
KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41888 ;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`postid`, `threadid`, `parentid`, `username`, `userid`, `title`, `dateline`, `pagetext`, `allowsmilie`, `showsignature`, `ipaddress`, `iconid`, `visible`, `attach`, `infraction`, `reportthreadid`, `htmlstate`, `post_thanks_amount`) VALUES --line 60


I don't need to be spoon fead by please remeber that I'm not at all familiar with mysql. I've been at this for days and just keep hitting roadblocks along the way. This on however I can't seem to get past.

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Column count doesn't match value count at row 1
October 01, 2012 09:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.