Database issue please help

scottieo321

Well-Known Member
Hi Everyone. Got myself into a little pickle right now concerning the Database i keep getting this error (Uploaded File). Can anyone help out as to what is the problem with it or give me a new SQL file with the correct setup for this set table. I'm testing on version 1.7.7.1. Any input would be great-full thanks.
 
Code:
11:17:03 Database(0): [Error] Error 1054 (Unknown column 'iv.id' in 'field list') in MySQLQuery SQL: 'select iv.id as id, v.class_name, 0 as owner_id, iv.worldspace, iv.inventory, iv.parts, iv.fuel, iv.damage from `Object_DATA` iv join `world_vehicle` wv on iv.`world_vehicle_id` = wv.`id` join `vehicle` v on wv.`vehicle_id` = v.`id` where iv. `instance_id` = 6 union select id.`unique_id`, d.`class_name`, id.`owner_id`, id.`worldspace`, id.`inventory`, `Hitpoints`, `Fuel`, `Damage`  from `Object_DATA` id inner join `deployable` d on id.`deployable_id` = d.`id` where id.`instance_id` = 6 AND `deployable_id` IS NOT NULL'
11:17:03 Database(0): [Error] Failed to fetch objects from database
 
Back
Top