Datastore problem?

Well, first it worked, but now it doesnt.

i just inserted the classes through phpmyadmin, but I couldnt see any of them in the Admin CP -> Edit Class, it also gave me an error when I tried to by items saying I need to be of a Generic Class. So I went into the admin CP -> add class; and added the Amazon again. when i refreshed the RPG CP to select it I got the error that I just posted above.

can you help?

[Revan]

You seem to be running v2. Or, you have not removed the code from profile.php.
Because this file is not edited in v3.

[AnthonyJR]

ok thx, that problem is fixed. now, the classes and elements and all the other insert didnt work during the installation, so I did them through PHPMYADMIN. the only problem is with the classes; 1) they dont show up when I hit the Edit Classes in the admin cp 2) after I change all my character info ( I can see the classes in the drop down menu ) and I go to the itemshop, it says I must be a Generic to buy any thing. I dont feel like adding all those classes one by one in the admin cp, how can I fix this?

[Revan]

The first thing that springs to mind is a fresh run of the rpg_install.php
Uninstall (or manually remove any trace of) the hack, then reinstall using the installer.
The installation definetely works now, as it's been verified by members using a table prefix too.

[AnthonyJR]

almost

Database error in vBulletin 3.0.7:

PHP Code:

Invalid SQL: 
CREATE TABLE `rpg_items_user` 
(
    `userid` int(10) unsigned NOT NULL default '0',
    `item0` char(250) NOT NULL default 'No Item',
    `points0` int(5) NOT NULL default '0',
    `description0` char(250) NOT NULL default 'No Description Available',
    `icon0` char(250) NOT NULL default '',
    `itid0` int(11) NOT NULL default '0',
    `item1` char(250) NOT NULL default 'No Item',
    `points1` int(5) NOT NULL default '0',
    `description1` char(250) NOT NULL default 'No Description Available',
    `icon1` char(250) NOT NULL default '',
    `itid1` int(11) NOT NULL default '0',
    `item2` char(250) NOT NULL default 'No Item',
    `points2` int(5) NOT NULL default '0',
    `description2` char(250) NOT NULL default 'No Description Available',
    `icon2` char(250) NOT NULL default '',
    `itid2` int(11) NOT NULL default '0',
    `item3` char(250) NOT NULL default 'No Item',
    `points3` int(5) NOT NULL default '0',
    `description3` char(250) NOT NULL default 'No Description Available',
    `icon3` char(250) NOT NULL default '',
    `itid3` int(11) NOT NULL default '0'    
    PRIMARY KEY (`userid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(`userid`)
) TYPE=MyISAM' at line 24 


in the mysql_schema file you have a space or tab behind one of the lines. fixed that and went through the whole installation with no problems once so ever. but I still get the same error, your install populated all the tables including the class table, but I still cant see any of the classes in the Admin Cp and it still says I need to be a Generic to purchase any items.

[Revan]

You need to download the latest file. That there has already been fixed.
The reason why the thread title says beta 2 is because I am no longer allowed to alter the thread title, it is too old.
So if I were you, I would click Install so that you will recieve a notification once database changes and/or major bugs are fixed.

As for the item saying you have to be generic, that is an error that is also fixed in abovementioned beta update.

[AnthonyJR]

the beta3 one? I believe I did download that one. Unless-- I downloaded your hack multiple times for some reason-- maybe the last time I installed the hack I didnt install the latest one. I'll download again and over write all files, I presume the latest file is in the same thread? I also shouldn't have to update the mysql right?

[Revan]

Well you need to run the rpg_install even if the hack was installed successfully in beta2.
Because beta3 modifies more of the database.

[AnthonyJR]

I just ran through the upgrade. it said i was running 3.0.0 and it was going to make it 3.0.0 Beta 3. There was a problem with the profilefield select so I just skipped that. But when I tried going to my RPG CP the whole page was blank. Everything RPG related is blank.

[Revan]

Of course it was an error with the profilefield select.... *stares*
You now have to manually add the profilefield with the name 'RPG Name' (EXACTLY like that, without the quotes), then uninstall the hack completely, then reinstall completely.
THAT should work.
Everything rpg related is blank because you probably never made it to the completed page, where everything is finalised.