Azure Emulator Error

B

Berk

berkibap#4233
Developer
Oct 17, 2015
863
190
Hi
I'm getting Error En Query Mysql :
You must be registered for see links

And Mysql.log:
Error en query:
SELECT * FROM catalog_targetedoffers WHERE enabled = '1' LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.catalog_targetedoffers' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetRow()


Error en query:
SELECT * FROM hotelview_badges WHERE enabled = '1'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.hotelview_badges' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()


Error en query:
SELECT * FROM users_rankings ORDER BY score DESC
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.users_rankings' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
konum: 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'
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()


Error en query:
SELECT count FROM server_peaks WHERE date = '31.10.2015'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.server_peaks' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetInteger()


Error en query:
SELECT * FROM rooms_competitions WHERE enabled = '1' LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.rooms_competitions' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetRow()


Error en query:
SELECT * FROM catalog_targetedoffers WHERE enabled = '1' LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.catalog_targetedoffers' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetRow()


Error en query:
SELECT * FROM hotelview_badges WHERE enabled = '1'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.hotelview_badges' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()


Error en query:
SELECT * FROM users_rankings ORDER BY score DESC
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.users_rankings' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
konum: 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'
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()


Error en query:
SELECT count FROM server_peaks WHERE date = '31.10.2015'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.server_peaks' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetInteger()


Error en query:
SELECT * FROM rooms_competitions WHERE enabled = '1' LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.rooms_competitions' doesn't exist
konum: MySql.Data.MySqlClient.MySqlStream.ReadPacket()
konum: MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
konum: MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult()
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
konum: System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
konum: Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetRow()
 
Sort by date Sort by votes
Yadz

Yadz

Active Member
Feb 20, 2015
174
25
  • Table 'hotel.catalog_targetedoffers' doesn't exist
  • Table 'hotel.hotelview_badges' doesn't exist
  • Table 'hotel.users_rankings' doesn't exist
  • Unknown column 'order_num' in 'order clause'
  • Table 'hotel.server_peaks' doesn't exist
  • Table 'hotel.rooms_competitions' doesn't exist
Add these tables/columns and it will work.
Btw I believe this isn't the SQL provided with Azure emu when you download it, is it?
 
Upvote 0 Downvote
Linxon

Linxon

IzyHosting.com
Mar 28, 2015
104
8
You have to add a new database or just add:
Table 'hotel.catalog_targetedoffers' doesn't exis
Table 'hotel.hotelview_badges' doesn't exist
Table 'hotel.users_rankings' doesn't exist
Unknown column 'order_num' in 'order clause'
Table 'hotel.server_peaks' doesn't exist
Table 'hotel.rooms_competitions' doesn't exist
-----------------------------------------------------------------
I dont think that you are using a real Azure Database.
Try to find a new Azure database, and you will not
get these errors.
-----------------------------------------------------------------
Hope this helped! :)
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top