[MYSQL] #1136 - Количество столбцов не совпадает с количеством значений в записи 1

Vlad Breezy · 5 Окт 2022

Здравствуйте, читатели PI.

Столкнулся с ошибкой в MYSQL, добавляя новые переменные. "pRub" - "pDonateMoney2"

C:

CREATE TABLE `accounts` (
  `pID` int(11) NOT NULL,
  `password` varchar(65) NOT NULL,
  `salt` varchar(10) NOT NULL,
  `Name` varchar(64) NOT NULL,
  `pLevel` int(11) NOT NULL,
  `pPhousekey` int(11) NOT NULL,
  `pAdmin` int(11) NOT NULL,
  `pFull` int(4) NOT NULL,
  `pDefender` int(11) NOT NULL DEFAULT 0,
  `pFuelcar` float NOT NULL,
  `pHeadValue` int(11) NOT NULL,
  `pContract` int(11) NOT NULL,
  `pCar` int(11) NOT NULL DEFAULT 462,
  `pCar2` int(11) NOT NULL DEFAULT 462,
  `pRub` int(11) NOT NULL,
  `pDonatemoney2` int(11) NOT NULL,
  `pDonateRank` int(11) NOT NULL,
  `pDonateRankTime` int(11) NOT NULL,
  `pSex` int(11) NOT NULL,
  `pMuted` int(11) NOT NULL,
  `pExp` int(11) NOT NULL,
  `pCash` int(11) NOT NULL,
  `pKills` int(11) NOT NULL,
  `pJailed` int(11) NOT NULL,
  `pJailTime` int(11) NOT NULL,
  `pMats` int(11) NOT NULL,
  `pHeal` int(11) NOT NULL,
  `pLeader` int(11) NOT NULL,
  `pMember` int(11) NOT NULL,
  `pRank` int(11) NOT NULL,
  `pJob` int(11) NOT NULL,
  `pCarLic` int(11) NOT NULL,
  `pBizLic` int(11) NOT NULL,
  `pFlyLic` int(11) NOT NULL,
  `pBoatLic` int(11) NOT NULL,
  `pFishLic` int(11) NOT NULL,
  `pGunLic` int(11) NOT NULL,
  `pSDPistol` int(11) NOT NULL,
  `pDesertEagle` int(11) NOT NULL,
  `pShotGun` int(11) NOT NULL,
  `pMP5` int(11) NOT NULL,
  `pAK47` int(11) NOT NULL,
  `pM4` int(11) NOT NULL,
  `pChar` int(11) NOT NULL,
  `pModel` int(11) NOT NULL,
  `pPnumber` int(11) NOT NULL,
  `pPayDayHad` int(11) NOT NULL,
  `pWarns` int(11) NOT NULL,
  `punWarns` int(11) NOT NULL,
  `punWarnstime` int(11) NOT NULL,
  `pFuel` int(11) NOT NULL,
  `pRobTime` int(11) NOT NULL,
  `pReportTime` int(11) NOT NULL,
  `pVerevka` int(11) NOT NULL,
  `pOtmbI4ka` int(11) NOT NULL,
  `pAutoTime` int(11) NOT NULL,
  `pAutoSkill` int(11) NOT NULL,
  `pMarried` int(11) NOT NULL,
  `pMuteTime` int(11) NOT NULL,
  `pMobile` int(11) NOT NULL,
  `pBank` int(11) NOT NULL,
  `pBoxSkill` int(11) NOT NULL,
  `pKongfuSkill` int(11) NOT NULL,
  `pKickboxSkill` int(11) NOT NULL,
  `pFightSkill` int(11) NOT NULL,
  `pFightSkil` int(11) NOT NULL,
  `pFightTime` int(11) NOT NULL,
  `pHospital` int(11) NOT NULL,
  `pIzol` int(11) NOT NULL,
  `pDostup` int(11) NOT NULL DEFAULT 0,
  `pZakonp` int(11) NOT NULL,
  `pVipTime` int(11) NOT NULL,
  `pVipData` int(11) NOT NULL,
  `pNarcoLomka` int(11) NOT NULL,
  `pProz` int(11) NOT NULL,
  `pMestoJail` int(11) NOT NULL,
  `pWanted` int(11) NOT NULL,
  `pHousecash` int(11) NOT NULL,
  `pDataReg` varchar(64) NOT NULL,
  `pIpReg` varchar(64) NOT NULL,
  `pNumbercar` varchar(64) NOT NULL,
  `pEmail` varchar(64) NOT NULL,
  `pOnline` int(11) NOT NULL DEFAULT 0,
  `pGetonDate` varchar(64) NOT NULL,
  `pGetonIP` varchar(32) NOT NULL,
  `Weapons` varchar(64) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL DEFAULT '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0',
  `Ammos` varchar(64) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL DEFAULT '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0',
  `day_online` int(11) NOT NULL,
  `Texts` varchar(32) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL DEFAULT '0, 0, 0',
  `SkinHome1` int(11) NOT NULL,
  `SkinHome2` int(11) NOT NULL,
  `SkinHome3` int(11) NOT NULL,
  `pHomez` int(11) NOT NULL DEFAULT 255,
  `satiety` int(11) NOT NULL DEFAULT 100,
  `checkip` int(11) NOT NULL DEFAULT 0,
  `keyip` varchar(32) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `pHotvet` int(11) NOT NULL DEFAULT 0,
  `family` int(11) NOT NULL DEFAULT 0,
  `acsent` varchar(32) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0, 0',
  `settings` varchar(32) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0, 0 ',
  `odet` int(11) NOT NULL DEFAULT 0,
  `one_tuneveh` varchar(78) NOT NULL DEFAULT '-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `two_tuneveh` varchar(78) NOT NULL DEFAULT '-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `one_vehcolor` varchar(11) NOT NULL DEFAULT '0,0',
  `two_vehcolor` varchar(11) NOT NULL DEFAULT '0,0',
  `voenbill` int(11) NOT NULL DEFAULT 0,
  `medcard` int(11) NOT NULL DEFAULT 0,
  `drugs` varchar(32) NOT NULL DEFAULT '0 0 0 0 0 0 0',
  `acessories` varchar(100) NOT NULL DEFAULT '0,0,0,0,0,0',
  `vigs` int(11) NOT NULL DEFAULT 0,
  `age` int(11) NOT NULL DEFAULT 0,
  `national` int(11) NOT NULL DEFAULT 0,
  `pSaveWeapon` int(11) NOT NULL DEFAULT 0,
  `pPrefix` varchar(32) NOT NULL,
  `pInv` int(11) NOT NULL DEFAULT 0,
  `CMDaccess` varchar(32) CHARACTER SET cp1250 NOT NULL DEFAULT '000000000000',
  `pDayAfk` int(11) NOT NULL DEFAULT 0,
  `pOnlineYes` int(11) NOT NULL DEFAULT 0,
  `pAfkYes` int(11) NOT NULL DEFAULT 0,
  `pBlNick` int(11) NOT NULL DEFAULT 0,
  `newDonation` int(11) NOT NULL DEFAULT 0,
  `pCountry` varchar(24) NOT NULL DEFAULT 'unknown',
  `pAdminCountry` varchar(24) NOT NULL DEFAULT 'unknown',
  `pOffCountry` int(11) NOT NULL DEFAULT 0,
  `pOffBH` int(11) NOT NULL DEFAULT 0,
  `pKInCapt` int(11) NOT NULL DEFAULT 0,
  `pAccent` varchar(32) NOT NULL DEFAULT '-',
  `pRepAdm` int(11) NOT NULL DEFAULT 0,
  `pKickAdm` int(11) NOT NULL DEFAULT 0,
  `pWarnAdm` int(11) NOT NULL DEFAULT 0,
  `pBanAdm` int(11) NOT NULL DEFAULT 0,
  `pMuteAdm` int(11) NOT NULL DEFAULT 0,
  `pJailAdm` int(11) NOT NULL DEFAULT 0,
  `pUsedJail` int(11) NOT NULL DEFAULT 0,
  `pcWarn` int(11) NOT NULL,
  `pcBan` int(11) NOT NULL,
  `pDedMoroz` int(11) NOT NULL,
  `pNinja` int(11) NOT NULL,
  `pDedUse` int(1) NOT NULL,
  `pNinjaUse` int(1) NOT NULL,
  `pIznas` int(11) NOT NULL,
  `pMinet` int(11) NOT NULL,
  `pArmBody` int(1) NOT NULL,
  `pArmBodyUse` int(1) NOT NULL,
  `pFullDostup` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `pQuest` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0',
  `pQuestDone` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0',
  `pMsg` int(11) NOT NULL,
  `pNoKickAuto` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

INSERT INTO `accounts` (`pID`, `password`, `salt`, `Name`, `pLevel`, `pPhousekey`, `pAdmin`, `pFull`, `pDefender`, `pFuelcar`, `pHeadValue`, `pContract`, `pCar`, `pCar2`, `pRub`, `pDonatemoney2`, `pDonateRank`, `pDonateRankTime`, `pSex`, `pMuted`, `pExp`, `pCash`, `pKills`, `pJailed`, `pJailTime`, `pMats`, `pHeal`, `pLeader`, `pMember`, `pRank`, `pJob`, `pCarLic`, `pBizLic`, `pFlyLic`, `pBoatLic`, `pFishLic`, `pGunLic`, `pSDPistol`, `pDesertEagle`, `pShotGun`, `pMP5`, `pAK47`, `pM4`, `pChar`, `pModel`, `pPnumber`, `pPayDayHad`, `pWarns`, `punWarns`, `punWarnstime`, `pFuel`, `pRobTime`, `pReportTime`, `pVerevka`, `pOtmbI4ka`, `pAutoTime`, `pAutoSkill`, `pMarried`, `pMuteTime`, `pMobile`, `pBank`, `pBoxSkill`, `pKongfuSkill`, `pKickboxSkill`, `pFightSkill`, `pFightSkil`, `pFightTime`, `pHospital`, `pIzol`, `pDostup`, `pZakonp`, `pVipTime`, `pVipData`, `pNarcoLomka`, `pProz`, `pMestoJail`, `pWanted`, `pHousecash`, `pDataReg`, `pIpReg`, `pNumbercar`, `pEmail`, `pOnline`, `pGetonDate`, `pGetonIP`, `Weapons`, `Ammos`, `day_online`, `Texts`, `SkinHome1`, `SkinHome2`, `SkinHome3`, `pHomez`, `satiety`, `checkip`, `keyip`, `pHotvet`, `family`, `acsent`, `settings`, `odet`, `one_tuneveh`, `two_tuneveh`, `one_vehcolor`, `two_vehcolor`, `voenbill`, `medcard`, `drugs`, `acessories`, `vigs`, `age`, `national`, `pSaveWeapon`, `pPrefix`, `pInv`, `CMDaccess`, `pDayAfk`, `pOnlineYes`, `pAfkYes`, `pBlNick`, `newDonation`, `pCountry`, `pAdminCountry`, `pOffCountry`, `pOffBH`, `pKInCapt`, `pAccent`, `pRepAdm`, `pKickAdm`, `pWarnAdm`, `pBanAdm`, `pMuteAdm`, `pJailAdm`, `pUsedJail`, `pcWarn`, `pcBan`, `pDedMoroz`, `pNinja`, `pDedUse`, `pNinjaUse`, `pIznas`, `pMinet`, `pArmBody`, `pArmBodyUse`, `pFullDostup`, `pQuest`, `pQuestDone`, `pMsg`, `pNoKickAuto`) VALUES

[MYSQL] #1136 - Количество столбцов не совпадает с количеством значений в записи 1

Vlad Breezy

Ученик