View Single Post
  #490  
Old 05-30-2006, 08:07 AM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Amaranth
Thanks alot for answering my questions! There are some problems that persist though... I am not able to Mass XP the users anymore. Moderators and Admins have very low XP, trying to re-set the values doesn`t have any effect. Trying to update the RPG user tables only returns information that Admin user was updated, no-one else... Ah well, I`ll fool around a little more and see if I get any wiser.

Here is the latest error message, when trying to re-install the mod:
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
ALTER TABLE `vb_administrator` 
    ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
MySQL Error  : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date         : Monday, May 29th 2006 @ 07:33:08 PM
Edit: Okay, I found out that I needed to edit my config.php file and allow myself to run SQL queries from the Admin CP. Using commands like "ALTER TABLE vb_administrator DROP rpgadminperms" on similar syntas for vb_user rpg, items, inventory and vb_usergroup drop rpgpermissions... But, I still don?t understand the last error message I get, which is the part where it`s trying to feed info the rpg_alignments, rpg_battlemusic etc. tables...

Now I have deleted all the vb_rpg_* tables using the "DROP TABLE vb_rpg_alignments" and so on - but the install script still stops and says there is a duplicate key entry or whatever... Which I don`t understand, cuz I have deleted all the tables, and they should have been reconstructed in empty form... Please help!
Ok that was hella much... Uhm why didn't you uninstall using the uninstall.php script this time? Because I know for a fact that removes the rpgadminperms there...
And I cant explain any error messages I don't see.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01142 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete