vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database error in vBulletin 3.5.2: (https://vborg.vbsupport.ru/showthread.php?t=105549)

lrmzx9 01-17-2006 04:59 AM

Database error in vBulletin 3.5.2:
 
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 01-17-2006 05:27 AM

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 01-17-2006 05:42 AM

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 01-17-2006 05:56 AM

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 01-17-2006 06:10 AM

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

Reef 01-17-2006 06:27 AM

1 Attachment(s)
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 01-17-2006 06:30 AM

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 01-17-2006 06:41 AM

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 01-17-2006 06:43 AM

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 01-17-2006 06:57 AM

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


All times are GMT. The time now is 07:24 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01748 seconds
  • Memory Usage 1,737KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete