Database error in vBulletin 3.5.2:

[lrmzx9]

I am recieving one of these errors with every mod I try to add. Can someone help me figure out why? I am new to VB.

This is the one that came up with RPG Lite

Invalid SQL:
CREATE TABLE `inferno_attack` (
`aid` int(11) NOT NULL auto_increment,
`aname` text NOT NULL,
`atype` text NOT NULL,
`asprite` text NOT NULL,
`amp_cost` int(15) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM;;

MySQL Error : Table 'inferno_attack' already exists
Error Number : 1050
Date : Tuesday, January 17th 2006 @ 01:57:45 AM
Script : http://www.southernsportbike.com/test/admincp/rpginferno_installation.php
Referrer : http://www.southernsportbike.com/test/login.php
IP Address : 24.240.28.24
Username : test
Classname : vb_database


I am not familiar with SQL really. so the simplest explanation would be nice, lol.

[Reef]

MySQL Error : Table 'inferno_attack' already exists

Means that table is already present in your database. Evidently you have already tried running the installer

I haven't messed with the RPG inferno lite because I have the full release but with the full version there was an installation script (not a product).. If the lite version is the same way then is there an option for uninstall? Or possible a second script to run for uninstallation?

One of the 2 should exist and you will need to run it to remove the previously installed tables... Otherwise you will need to remove those manually using a script like phpmyadmin..

I'm sure there is an uninstaller, so run that then try to reinstall.

[lrmzx9]

I will look. I got this same error with UCASH. tho it shows up it has no affect on the forum.

The RPG actually works on the forum despite the error. However it comes with no items,bots, anything...lol... is there a place to download premade user sets? I am installing this all on a test forum first. The UCASH is really my main concern. along with USHOP.

[Reef]

Again I dont know how the lite version is packaged but the full version came with a second download of images and such.. I still had to spend days setting everything up and trying to make everyone happy but it was well worth the trouble and the cost.

[lrmzx9]

hmm, I did get a bunch of images, but I dont recall an import file. I dont see an uninstall either.

[Reef]

I just checked the lite release and there is an uninstall file named rpginferno_uninstallation.php [attached]

This should be uploaded to you admincp and ran from there then deleted when done.

[lrmzx9]

Do u kno if this holds the same for UCASH? I just ran it, deleted it. All the RPG settings are still in my admin CP

thanks for all the help btw

[Reef]

UCASH should have an uninstaller or is a product you can uninstall from there. I don't use that either since RPG infirno has it's own cash/gil system.

Now that you ran the uninstaller try running the installer again for RPG.. If you want rid of it and it is still leaving remnants after the uninstall you should ask for help in the inferno thread or read through it to see if anyone else had similar probs.

https://vborg.vbsupport.ru/showthread.php?t=103792&highlight=RPG+Inferno

[lrmzx9]

yeah, i ran the install on my main forum, same issue, ran the uninstall then the install and it worked fine. Does the RPG cash system reflect user posts etc? I am new to this RPG. I came from PHPBB

[Reef]

The cash system with inferno full is influenced by postcount if you want..

Just for future referrence I did a little digging.. If you ever need to remove the admincp links for inferno after an uninstall:

Remove these files from includes/xml/

bitfield_rpginferno.xml
cpnav_rpginferno.xml

then run

/admincp/index.php?do=buildbitfields

[lrmzx9]

ahhh, cool. Thanks for all the help. I have the RPG installed now, but I have 0 items of any kind. lol. Is there a pack of them somewhere on here with an easy install? Or do you have to go through and add em 1 by 1?

[Reef]

Glad to help.

You'll need to check the inferno thread for that.. Expect it to take a very long time to get it setup completely though.. It is massive..

[lrmzx9]

I am seeing that. The guys loved the cheesy one we had on the phpBB board. Im sure they will donate for the full version. Any other cool mods you would recommend I try?

[Reef]

Are many nice mods available.. the arcade system is popular on my board.. I use ibproarcade but v3arcade is very nice also

[lrmzx9]

I have the arcade system, I tried to import the items list and its saying
Invalid File Specified
when i try to import the xml file.
this can be quite frustrating...

I am having trouble adding my own items, I need to SELECT ALL CLASSES but im not getting a java window to allow me to

[Reef]

When importing the file are you doing it thru RPG Inferno Settings / Import RPG Inferno?

I dont understand what you mean by javascript window. On my version you only have to click a link and all classes are selected.

[lrmzx9]

ah, I had no "jobs" defined so there were none to check! It will take forever to create items/spells/weapons/armor/bots etc for this damn thing... if only that import would work lol