(HELP) Azure - Error En Query MySQL

bramleyjordann · Oct 17, 2015

Hi all,
I am in need of some support resolving issue with my Azure EMU.

You must be registered for see images attach

Any Additional info, please ask

BIOS · Oct 17, 2015

Check your EMU SQL logs and it will tell you what it is? It's probably a missing column or something.

bramleyjordann · Oct 17, 2015

Where are thye located?

BIOS · Oct 17, 2015

bramleyjordann said:
Where are thye located?

In your EMU folder/Debug/

Usually in a folder called logs or something along those lines, shouldn't be too hard to find from there.

bramleyjordann · Oct 17, 2015

BIOS said:
In your EMU folder/Debug/

Usually in a folder called logs or something along those lines, shouldn't be too hard to find from there.

Ill have a look and get back to you.

Anyone able to Teamviewer and help me sort my hotel out?

bramleyjordann · Oct 17, 2015

This is my SQL Errors:

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 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 Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()

EngeldesTodes · Oct 17, 2015

geezs put it in code or something

BIOS · Oct 17, 2015

Just like I thought it would be.

Run this query.

ALTER TABLE catalog_items
ADD order_num INT NOT NULL
DEFAULT 0;

reishin · Oct 18, 2015

Simply Install Epic Catalogue will solve the problem

BIOS · Oct 18, 2015

There is no problem, it doesn't really affect anything directly.

Plus the above query will fix it anyway so the catalogue he is using now will work fine.

bramleyjordann · Oct 24, 2015

Thanks all,

close this thread

bramleyjordann · Oct 24, 2015

I reinstalled everything and it worked. Dont know what i did different but it now works

Examed · Oct 24, 2015

Oh Okay @Adil

(HELP) Azure - Error En Query MySQL

bramleyjordann

New Member

BIOS

ಠ‿ಠ

bramleyjordann

New Member

BIOS

ಠ‿ಠ

bramleyjordann

New Member

bramleyjordann

New Member

EngeldesTodes

Deutsch Techno-Freak WIR SIND EIN

BIOS

ಠ‿ಠ

reishin

x

BIOS

ಠ‿ಠ

bramleyjordann

New Member

bramleyjordann

New Member

Examed

Я весь высший лидер из вас всех

Users who are viewing this thread

Latest posts

Connect with us

Newest members