[Bitsys]

Today at 03:55 AM mjp1111 said this in Post #1985
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.

What file is that database error coming from? Also, do you have a link to your forums so that I can see the IDs of the item categories?

What happens when you change the spell category to something other than spells? Does the error still occur?

Wait, before answering those questions, try the following:

In battlefight.php, find:

PHP Code:

$itemcats = $DB_site->query("SELECT id, battletype FROM items_cats ORDER BY battletype"); 


and REPLACE it with:

PHP Code:

$itemcats = $DB_site->query("SELECT id, battletype FROM items_cats WHERE type = 0 ORDER BY battletype"); 


Let me know if that doesn't work.

Today at 07:44 AM mjp1111 said this in Post #1986
This thing is also bugging me - battles are working fine apart from the spells thing as per last post, I've updated stats repeatedly, but postbit info shows up as -

RPG name: N/A
Level: 2 Alignment:
Race: HP: /206 Alive
Not in battle.
Check Stats :---

i.e. RPG name, X/206 HP and :--- all refuse to show up - any ideas?

I think the edits to showthread.php did not properly execute. Give me your showthread.php and I will fix it. Also, try running DB Fix.