PDA

View Full Version : How can this be fixed?


Olli460
20 Jul 2006, 13:48
Invalid SQL:

INSERT INTO Tablesrpg_items
(`categoryid`, `itemname`, `cost`, `description`, `icon`, `stock`, `sold`, `damage`, `itemorder`, `itemtype`, `levelreq`, `extra`)
VALUES
(1, 'Dagger', 320, 'Weapon used by thieves', 'dagger', 34, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mage Masher', 200, 'Weapon originally used for combating mages', 'dagger', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Dagger', 950, 'Thief dagger made of mythril', 'dagger', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Butterfly Sword', 300, 'Standard thief sword', 'thiefsword', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'The Ogre', 700, 'Standard thief sword', 'thiefsword', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Masamune', 5600, 'Sword from a foreign land', 'thiefsword', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Air Racket', 400, 'Long-range combat racket.', 'racket', 21, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Rod', 260, 'Combat Rod', 'rod', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Rod', 760, 'Rod made of mythril', 'rod', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Broadsword', 330, 'Ordinary sword used in combat', 'blade', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Iron Sword', 660, 'Sword made of iron', 'blade', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Sword', 1300, 'Sword made out of mythril', 'blade', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Blood Sword', 2000, 'Sword varnished with blood', 'blade', 33, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mage Staff', 320, 'Staff used by black mages', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Flame Staff', 1100, 'Staff with a divine fire spirit dwelling inside', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Ice Staff', 980, 'Staff with a divine ice power dwelling inside', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Lightning Staff', 1200, 'Staff with a divine thunder power inside', 'staff', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Javelin', 880, 'Spear used by Dragon Knights', 'polearm', 44, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Spear', 1100, 'Spear made of mythril', 'polearm', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Partisan', 1600, 'Spear adorned with brilliant gems', 'polearm', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Poison Knuckles', 500, 'Combat knuckles', 'fist', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Claws', 750, 'Claws made of mythril', 'fist', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Shirt', 270, 'Clothes made of leather.', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Plate', 530, 'Plate worn for combat', 'shirt', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Vest', 670, 'Plate made of bronze', 'shirt', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Chain Plate', 810, 'Plate that provides brimming strength', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Cotton Robe', 200, 'Ordinary shirt', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Vest', 1180, 'Vest braided with mythril', 'vest', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Armor', 650, 'Armor made of bronze', 'plate', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Linen Cuirass', 800, 'Armor packed with magic', 'plate', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Hat', 150, 'Not a suitable item to wear in combat', 'hat', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Steepled Hat', 260, 'Hat worn by mages.', 'hat', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bandana', 500, 'Mysterious bandana that makes you light-footed', 'hat', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Rubber Helmet', 250, 'Helm worn by soldier trainees', 'helm', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Helmet', 300, 'Helmet made of bronze', 'helm', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Iron Helmet', 400, 'Helmet made of iron', 'helm', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Barbut', 600, 'Headgear that raises Spirit', 'helm', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Helmet', 1000, 'Helmet made of mythril', 'helm', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Pearl Armlet', 100, 'Regular wristlet', 'armgear', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Wrist', 130, 'Regular wristlet', 'armgear', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Glass Armlet', 250, 'Armlet made of glass', 'armgear', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bone Wrist', 330, 'Wristlet made from bones. Raises Earth Elem-Atk', 'armgear', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Armlet', 500, 'Armlet made of mythril', 'armgear', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Wrist', 200, 'Wristlet that raises Spirit when equipped', 'armgear', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Gloves', 480, 'Gloves made of bronze', 'glove', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Gloves', 980, 'Gloves made of mythril', 'glove', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Thunder Gloves', 1200, 'with a thunder god? power dwelling inside', 'glove', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Diamond Gloves', 2000, 'Gloves made of diamond', 'glove', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Hi-Potion', 200, 'Restores 300 HP in the field and 450 HP in battle.', 'vial1', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Potion', 100, 'Restores 100 HP in the field and 150 HP in battle', 'vial1', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Ether', 500, 'Restores 100 MP in the field and 150 MP in battle.', 'vial1', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Elixir', 1500, 'Full restores HP and MP.', 'vial1', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Gysahl Greens', 100, 'Cures Berserk and lures chocobos.', 'greens', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Phoenix Down', 150, 'Recovers a character from KO.', 'feather', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Echo Screen', 50, 'Cures Silence status.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Soft', 50, 'Cures Petrify and Gradual Petrify.', 'vial2', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Antidote', 50, 'Cures Poison and Venom.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Eye Drops', 50, 'Cures Darkness.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Magic Tag', 100, 'Cures Zombie status.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Vaccine', 100, 'Cures Virus.', 'vial2', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Remedy', 300, 'Cures various status abnormalities.', 'vial2', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Annoyntment', 150, 'Cures Trouble status.', 'vial2', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Tent', 800, 'Restores a large amount of HP and MP and removes some status effects.', 'tent', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Ore', 500, 'Restores HP. It cannot be used in field. It radiates a mysterious light.', 'orb', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0');

MySQL Error : You have an error in your SQL syntax near ';
' at line 68
Error Number : 1064

This is the error I got. Ive seen it answered somewhere but I cant find it. I know you have to edit something in installer dealing with the 0, 0, 0, 0, 0 etc. part. I think it had to do with deleting a 0 or something Im not sure. Help please?

Revan
20 Jul 2006, 15:36
(3, 'Ore', 500, 'Restores HP. It cannot be used in field. It radiates a mysterious light.', 'orb', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0');

remove the ; at the end.
Also I believe you need to update your MySQL, 3.x is no longer supported and I believe that error there is fixed in 4.1/4.2

Olli460
21 Jul 2006, 10:59
Hmm well it seems this is the wrong error then. I had looked and this was something that was similar to mine. I dont know what the deal is but I tend to get errors when i try to install but I keep trying to find out how to fix it. First it was the admin permissions thing, I got that fixed. Then it was the datastore error which I had run a query and got that fixed. Then it was an error similar to this and I thought the ; was the problem so I deleted it. Now it is an error which is like this but it was identified with unknown category or whatever when I tried changing the '0,0,0,0,0,0'); to '0,0,0,0,0,0'). When I get a screenshot, Ill show you. My mysql version is 4.1.19. Is there another possibility why I keep encounting errors when I try to install this product? If you need to know anything, just ask and Ill see if I can help you so you can help me. I really like how this hack is developed and the features that are always added are incredible. I run a gaming forums and I know my members would love something like this seeing how the majority are RPG players. Oh and I run 3.5.4 so...I simply dont know why I keep encounting errors when installing.