[mjp1111]

quote:
Yesterday at 01:02 AM mjp1111 said this in Post #1983
I keep getting this emailed to me - I think it is due to using spells or potions -

Invalid SQL: SELECT items_user.item5,items_user.itid5,items.type,items .extra FROM items_user
LEFT JOIN items ON items.itemid=items_user.itid5
WHERE userid='10'
mysql error: Unknown column 'items_user.item5' in 'field list'

mysql error number: 1054

At any time did you switch an item category from personal to public or vice versa? Do you recall any changes you made to the item categories before this happened? An easy solution would be to add those columns back to the items_user table, but I would rather figure out why this happened.

I don't think I switched categories. The only new categories were shops created by users.

I changed the battle type - I have narrowed it down - it is the Spells that don't work. I changed the items to Potions and it worked fine, but whenever I select Spells, everything just dies.