Monster Arena Problem

[AnthonyJR]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT
rpg_items_user.item4 AS spell,
rpg_items_user.itid4,
rpg_items.type AS type,
rpg_items.extra AS extra
FROM rpg_items_user AS rpg_items_user
LEFT JOIN rpg_items AS rpg_items ON(rpg_items.itemid = rpg_items_user.itid4)
WHERE userid='1'

mysql error: Unknown column 'rpg_items_user.item4' in 'field list'

mysql error number: 1054

Date: Wednesday 23rd of March 2005 10:03:22 PM
Script: http://forum.hotelcali.net/monsterbattle.php?do=enterbattle&battlenumber=1
Referer: http://forum.hotelcali.net/monsterarena.php
Username: prophecy
IP Address:


:( problem???

ive done every thing correctly before

[Revan]

It is trying to fetch your Spells from the database.
Tell me, do you actually HAVE spells?
To me this seems like you've tampered with the items_user db manually, because if everything is done correctly, this shouldn't be a problem.

For now, you can try to run these queries, and tell me if any of them echo errors:
ALTER TABLE `rpg_items_user` ADD `item4` char(250) NOT NULL default 'No Item',
ALTER TABLE `rpg_items_user` ADD `points4` int(5) NOT NULL default '0',
ALTER TABLE `rpg_items_user` ADD `description4` char(250) NOT NULL default 'No Description',
ALTER TABLE `rpg_items_user` ADD `icon4` char(250) NOT NULL default '',
ALTER TABLE `rpg_items_user` ADD `itid4` int(5) NOT NULL default '0'