PDA

View Full Version : Some db errors


jvillan
22 Feb 2005, 15:50
Im getting the following errors after install (upgrading to 3.0.7 THEN installed the hack):

when i go to RPG Main :
Database error in vBulletin 3.0.7:

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=10002
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'

Itemshop:

Invalid SQL: SELECT uttpoints FROM user WHERE userid=10002
mysql error: Unknown column 'uttpoints' in 'field list'
Edit Your Character:

Invalid SQL: SELECT rpgclass, rpggender, rpgrace, alignment, element, inbattle, rpgstats FROM user WHERE userid='10002'
mysql error: Unknown column 'rpgstats' in 'field list'

Healing Center:

Invalid SQL: SELECT uttpoints AS money FROM user WHERE userid='10002'
mysql error: Unknown column 'uttpoints' in 'field list'


hope i can get this working soon, thanks!

Revan
22 Feb 2005, 18:31
* Install uCS hack
* Run ALTER TABLE `user` ADD `rpgstats` char(1) NOT NULL DEFAULT '1'