[Oyabun]

Originally Posted by RollaJedi

ok, I read many posts back about deleting certain tables in your phpmyadmin thing.
If anyone wants to know how to get past this error on step 4, you delete the following fields from the tables:

Table: Administrator
field: rpgadminperms

Table: usergroup
field: rpgperms (or something but it had rpg prefixed to it)

Table: user
fields: rpg, items, inventory

Also, you need to delete any tables that begin with rpg_ (example: rpg_example)

after you delete those, run the patch.


Now, for my newest problem, is after I've done all of this, I can finally get past step 4, but I again get halted at step 5 with this NEW error!:

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO `datastore`
(`title`, `data`)
VALUES
('rpg_alignments', ''),
('rpg_battlemusic', ''),
('rpg_categories', ''),
('rpg_classes', ''),
('rpg_clans', ''),
('rpg_elements', ''),
('rpg_genders', ''),
('rpg_ibots', ''),
('rpg_items', ''),
('rpg_races', ''),
('rpg_scenes', ''),
('rpg_types', '');

MySQL Error : Duplicate entry 'rpg_alignments' for key 1
Error Number : 1062
Date : Wednesday, December 19th 2007 @ 01:16:56 PM
Script : http://www.******.com/forums/installer/index.php
Referrer : http://www.*****.com/forums/installer/index.php
IP Address : ********
Username : ********
Classname : vb_database

I just did what you did in step 4. So i got the same error here.
In phpMyAdmin i used the "search" option and searched every value in the table datastore.

I mean these:

PHP Code:

VALUES 
    ('rpg_alignments', ''),
    ('rpg_battlemusic', ''),
    ('rpg_categories', ''),
    ('rpg_classes', ''),
    ('rpg_clans', ''),
    ('rpg_elements', ''),
    ('rpg_genders', ''),
    ('rpg_ibots', ''),
    ('rpg_items', ''),
    ('rpg_races', ''),
    ('rpg_scenes', ''),
    ('rpg_types', ''); 


I deleted them and tried the installation script again.

Step 10) Install Complete

You have now successfully installed RPG Integration Hack.

That is what I got so far.
I know your post is very old. But maybe some guys want to know how to do it