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/tes...stallation.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/showthrea...ht=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