Monster Arena Problem

PHP Code:

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: [url]http://forum.hotelcali.net/monsterbattle.php?do=enterbattle&battlenumber=1[/url]
Referer: [url]http://forum.hotelcali.net/monsterarena.php[/url]
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:
[sql]ALTER TABLE `rpg_items_user` ADD `item4` char(250) NOT NULL default 'No Item',[/sql]
[sql]ALTER TABLE `rpg_items_user` ADD `points4` int(5) NOT NULL default '0',[/sql]
[sql]ALTER TABLE `rpg_items_user` ADD `description4` char(250) NOT NULL default 'No Description',[/sql]
[sql]ALTER TABLE `rpg_items_user` ADD `icon4` char(250) NOT NULL default '',[/sql]
[sql]ALTER TABLE `rpg_items_user` ADD `itid4` int(5) NOT NULL default '0'[/sql]