PDA

View Full Version : Help me , error install


belsv
27 Feb 2006, 08:51
I had problem when install RPG
Database error in vBulletin 3.5.3:

Invalid SQL:

CREATE TABLE `Tablesrpg_alignments`
(
`alignmentid` int(10) unsigned NOT NULL auto_increment,
`alignmentname` varchar(50) NOT NULL DEFAULT '',
`alignmentleader` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`alignmentid`)
) TYPE=InnoDB;;

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

Please help me

Revan
27 Feb 2006, 10:00
Noted in bug tracker and fixed in SVN.
Open /installer/hacks/rpg_integr_hack/mysql-schema.php and find all instances of:
TYPE=InnoDB;
Replace with
TYPE=InnoDB

belsv
27 Feb 2006, 10:40
Thanks so much ! But I also had problem with step 5) Inserting Default Data

Database error in vBulletin 3.5.3:

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

I knew that it's error SQL inject but I didn't know what file I must del ';' . Please show me . Thanks so much for support !

Revan
27 Feb 2006, 13:03
I really don't know. That seems almost as if there's an error in your MySQL configuration. I really can't help, sorry :(

Marco van Herwaarden
27 Feb 2006, 13:25
@belsv
What MySQL version are you using?

@Revan
Why are you forcing InnoDB?

belsv
27 Feb 2006, 13:59
[QUOTE=MarcoH64]@belsv
What MySQL version are you using?
I using Client API version 3.23.58

@Revan
what I need config in my SQL database ?

I just don't know where is that code ?

Marco van Herwaarden
27 Feb 2006, 15:16
What MySQL version are you using?
I using Client API version 3.23.58
I will need the version of the MySQL server, not the client API.

Tri@de
27 Feb 2006, 15:56
Ops wrong post sorry