[Bitsys]

Today at 09:00 PM Confuzzled said this in Post #2162
Hello people I installed this addon on a site for someone and all was well. Suddenly though, it broke and we get a error like this.

Invalid SQL: SELECT items_user.item15,items_user.itid15,items.type FROM items_user
                        LEFT JOIN items ON items.itemid=items_user.itid15
                        WHERE items_user.userid='1'
mysql error: Unknown column 'items_user.item15' in 'field list'

mysql error number: 1054

Date: Friday 22nd of August 2003 10:03:16 PM
Script: http://www.domain/vb/vb/battlefight....ttlenumber=461
Referer: http://www.domain/vb/battle.php?action=browse

The part that's REALLY confusing, is that it's adding a /vb onto it, could that be breaking it? We didn't do anything to the hack, it just suddenly did this @_@

I've run the database checker in the admincp, but still no avail
Any solutions?

~Francisco

What is the structure of your items_user table?

In battlefight.php, are you able to find the following:

PHP Code:

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


Have you added any personal item shops recently?