Every piece of meldable gear in the game has certain "stat caps" that you can't exceed. Some items have very high stat caps, like perception on a Forager's Sledgehammer, and others can have a stat cap of 0, so you can't meld any of a certain stat to it, like GP on a Forager's Vest.

The site I sent you shows you that the perception cap for Dodore's Choker is +4, gathering cap is also +4, and the GP cap is +8, so the meld you want should look something like this...
http://ffxiv.ariyala.com/PB4Q
...But it will depend of course on the prices of materia on your server and/or the size of your wallet. You always want the most expensive and/or highest grade ones to go in the first few slots, as these are often guaranteed and/or a higher success chance of melding. Note the success rates for melds on the right side when you click to add materia to the item. In this case, the first is guaranteed, the next would be 29%, the next 22% and the last 13%.

The site as well as the game, show you the success rates and also how much of a stat you will gain before you meld, so you need to be very careful and make sure you review all the information you're given on screen before you choose to make the attempt.

By the sounds of it, this was a rather expensive mistake... It can be fixed, but the materia you did manage to attach to the choker will be lost. If you visit the NPC Mutamix in Central Thanalan at "The Bon Fire", he offers an option to remove materia from an item. This will wipe out all materia, but you get to keep your item and perform fresh melds.

I hope that helps!