Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2006, 04:59 AM
lrmzx9 lrmzx9 is offline
 
Join Date: Jan 2006
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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.
Reply With Quote
  #2  
Old 01-17-2006, 05:27 AM
Reef Reef is offline
 
Join Date: May 2003
Location: USA
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 01-17-2006, 05:42 AM
lrmzx9 lrmzx9 is offline
 
Join Date: Jan 2006
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 01-17-2006, 05:56 AM
Reef Reef is offline
 
Join Date: May 2003
Location: USA
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 01-17-2006, 06:10 AM
lrmzx9 lrmzx9 is offline
 
Join Date: Jan 2006
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm, I did get a bunch of images, but I dont recall an import file. I dont see an uninstall either.
Reply With Quote
  #6  
Old 01-17-2006, 06:27 AM
Reef Reef is offline
 
Join Date: May 2003
Location: USA
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Attached Files
File Type: php rpginferno_uninstallation.php (2.4 KB, 4 views)
Reply With Quote
  #7  
Old 01-17-2006, 06:30 AM
lrmzx9 lrmzx9 is offline
 
Join Date: Jan 2006
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #8  
Old 01-17-2006, 06:41 AM
Reef Reef is offline
 
Join Date: May 2003
Location: USA
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #9  
Old 01-17-2006, 06:43 AM
lrmzx9 lrmzx9 is offline
 
Join Date: Jan 2006
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #10  
Old 01-17-2006, 06:57 AM
Reef Reef is offline
 
Join Date: May 2003
Location: USA
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:16 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04305 seconds
  • Memory Usage 2,268KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete