mySQL error?

Hello,

I keep getting this query error,


Error in query:
CALL getroomitems(@roomid)
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'items.placedBy' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Database_Manager.Database.Session_Details.QueryAdapter.getTable()





I know it's saying that I don't have the column "Items.Placedby" but I was wondering if someone could help me resolve this issue.

Thanks,
Steve

You are missing the column placedBy in the items table.

Quote:

---

Originally Posted by HillBilly

You are missing the column placedBy in the items table.

---

Yeah, I fixed it.

Question for you though, do you know how to fix the horses problem? When I try and place my horse it moves around my avatar figure.