[benjaminjones]

Hi. I decided to edit SCRP script: https://sampforum.blast.hk/showthread.php?tid=538107 . What I did was to increase the maxranks to 18, instead of 15. I did good in the gamemode but in the database file I am experiecing some troubles. So, If possible, help me.
I changed this:

pawn Код:

`factionRank1` varchar(32) DEFAULT NULL,
  `factionRank2` varchar(32) DEFAULT NULL,
  `factionRank3` varchar(32) DEFAULT NULL,
  `factionRank4` varchar(32) DEFAULT NULL,
  `factionRank5` varchar(32) DEFAULT NULL,
  `factionRank6` varchar(32) DEFAULT NULL,
  `factionRank7` varchar(32) DEFAULT NULL,
  `factionRank8` varchar(32) DEFAULT NULL,
  `factionRank9` varchar(32) DEFAULT NULL,
  `factionRank10` varchar(32) DEFAULT NULL,
  `factionRank11` varchar(32) DEFAULT NULL,
  `factionRank12` varchar(32) DEFAULT NULL,
  `factionRank13` varchar(32) DEFAULT NULL,
  `factionRank14` varchar(32) DEFAULT NULL,
  `factionRank15` varchar(32) DEFAULT NULL,
  `factionRank16` varchar(32) DEFAULT NULL,
  `factionRank17` varchar(32) DEFAULT NULL,
  `factionRank18` varchar(32) DEFAULT NULL,

As you can see, I added the rank of 16, 17, 18. Then I had to deal with the next thing in the database file.

pawn Код:

INSERT INTO `factions` (`factionID`, `factionName`, `factionColor`, `factionType`, `factionRanks`, `factionLockerX`, `factionLockerY`, `factionLockerZ`, `factionLockerInt`, `factionLockerWorld`, `factionWeapon1`, `factionAmmo1`, `factionWeapon2`, `factionAmmo2`, `factionWeapon3`, `factionAmmo3`, `factionWeapon4`, `factionAmmo4`, `factionWeapon5`, `factionAmmo5`, `factionWeapon6`, `factionAmmo6`, `factionWeapon7`, `factionAmmo7`, `factionWeapon8`, `factionAmmo8`, `factionWeapon9`, `factionAmmo9`, `factionWeapon10`, `factionAmmo10`, `factionRank1`, `factionRank2`, `factionRank3`, `factionRank4`, `factionRank5`, `factionRank6`, `factionRank7`, `factionRank8`, `factionRank9`, `factionRank10`, `factionRank11`, `factionRank12`, `factionRank13`, `factionRank14`, `factionRank15`, `factionRank16`,  `factionRank17`,  `factionRank18`, `factionSkin1`, `factionSkin2`, `factionSkin3`, `factionSkin4`, `factionSkin5`, `factionSkin6`, `factionSkin7`, `factionSkin8`, `SpawnX`, `SpawnY`, `SpawnZ`, `SpawnInterior`, `SpawnVW`) VALUES

So I added `factionRank16`, `factionRank17`, `factionRank18`,.
I saved the database and tried to upload it to wamp. It showed me the following error:

pawn Код:

SQL query:




--
-- Information about table `factions`
--

INSERT INTO `factions` (`factionID`, `factionName`, `factionColor`, `factionType`, `factionRanks`, `factionLockerX`, `factionLockerY`, `factionLockerZ`, `factionLockerInt`, `factionLockerWorld`, `factionWeapon1`, `factionAmmo1`, `factionWeapon2`, `factionAmmo2`, `factionWeapon3`, `factionAmmo3`, `factionWeapon4`, `factionAmmo4`, `factionWeapon5`, `factionAmmo5`, `factionWeapon6`, `factionAmmo6`, `factionWeapon7`, `factionAmmo7`, `factionWeapon8`, `factionAmmo8`, `factionWeapon9`, `factionAmmo9`, `factionWeapon10`, `factionAmmo10`, `factionRank1`, `factionRank2`, `factionRank3`, `factionRank4`, `factionRank5`, `factionRank6`, `factionRank7`, `factionRank8`, `factionRank9`, `factionRank10`, `factionRank11`, `factionRank12`, `factionRank13`, `factionRank14`, `factionRank15`, `factionRank16`,  `factionRank17`,  `factionRank18`, `factionSkin1`, `factionSkin2`, `factionSkin3`, `factionSkin4`, `factionSkin5`, `factionSkin6`, `factionSkin7`, `[...]
MySQL answered: Documents

#1136 - Column count doesn't match value count at row 1

What else do I have to do in order to fix this? If you can help, would be good.

[benjaminjones]

Bump

[Lordzy]

Not a solution of what you're looking for, but you've to really consider following this tutorial - https://sampforum.blast.hk/showthread.php?tid=420363

[benjaminjones]

Still not fixed, bumpin

[benjaminjones]

upppppppp

[Lordzy]

Your insert query given here is incomplete.

[benjaminjones]

Any idea how should It be?

[Sithis]

You need to show the full query. You are either inserting too many or too few values for the amount of columns you have.

[RayDcosta]

I think I'm a bit late, but check the number of queries you are inserting and the number of columns. There is a mismatch. Apart from that there seems to be no problems

[benjaminjones]

Well, I cannon find any problem with this, can you do it yourself, please?