View Single Post
  #770  
Old 11-26-2004, 04:01 PM
X-Sector X-Sector is offline
 
Join Date: Oct 2003
Posts: 154
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got this error when done installing the RPG hack :

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT
user.userid,
user.username,
user.rpgclass,
user.element,
user.rpgrace,
user.rpgtype AS rpgtype,
user.alignment,
user.rpggender,
user.posts,
user.maxhp,
user.maxma,
user.maxpp,
user.inbattle,
user.xp,
user.ma AS uma,
user.hp AS uhp,
user.pp AS upp,
user.ap AS uap,
user.uttpoints AS money,
rpg_battle_options.namefield AS namefield,
userfield.*,
rpg_battle_options.exprate,
rpg_battle_options.privacy AS battleprivacy,
rpg_items_user.*,
rpg_battle_stats.*,
rpg_rpg_race.name AS rpgracename,
rpg_rpg_race.alignment AS rpgalignmentname,
rpg_rpg_classf.name AS fclassname,
rpg_rpg_classf.folder AS fclassfolder,
rpg_rpg_classm.name AS mclassname,
rpg_rpg_classm.folder AS mclassfolder,
rpg_rpg_element.name AS elename
FROM rpg_battle_options
LEFT JOIN user ON user.userid=1
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment

mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054

Date: Friday 26th of November 2004 12:00:46 PM
Script: http://www.xelation.net/forums/rpgcp.php
Referer:
Username: vFlow
IP Address: ********
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01139 seconds
  • Memory Usage 1,766KB
  • 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)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