Toggle sidebar

EMULATORE - Problema Azure EMU

NexingHack

NexingHack

Utente Normale
Autore del topic
24 Dicembre 2011
64
10
Miglior risposta
0
Assistenza Tecnica Habbo Retroserver​
Titolo
Problema Azure EMU ​
Tipologia del tuo problema/richiesta
EMULATORE ​
CMS/Server/DB/Client Utilizzato
CMS,DB PRIVATI. EMU AZURE EMU l'ultima versione ​
Qual è il tuo errore?
Error en QUERY ​
Screenshot
Perfavore, Entra oppure Registrati per vedere i Link!
​
Ulteriori informazioni
- ​
 
NexingHack ha detto:
Assistenza Tecnica Habbo Retroserver​
Titolo
Problema Azure EMU ​
Tipologia del tuo problema/richiesta
EMULATORE ​
CMS/Server/DB/Client Utilizzato
CMS,DB PRIVATI. EMU AZURE EMU l'ultima versione ​
Qual è il tuo errore?
Error en QUERY ​
Screenshot
Perfavore, Entra oppure Registrati per vedere i Link!
​
Ulteriori informazioni
- ​
Clicca per espandere...
Posta il MySQLErrors.txt
 
Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
in MySql.Data.MySqlClient.MySqlStream.ReadPacket()
in MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
in MySql.Data.MySqlClient.MySqlDataReader.NextResult()
in MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
in MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
in System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in 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'
in MySql.Data.MySqlClient.MySqlStream.ReadPacket()
in MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
in MySql.Data.MySqlClient.MySqlDataReader.NextResult()
in MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
in MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
in System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()
 
NexingHack ha detto:
Error en query:
SELECT * FROM catalog_items ORDER BY order_num ASC
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'order_num' in 'order clause'
in MySql.Data.MySqlClient.MySqlStream.ReadPacket()
in MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
in MySql.Data.MySqlClient.MySqlDataReader.NextResult()
in MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
in MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
in System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in 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'
in MySql.Data.MySqlClient.MySqlStream.ReadPacket()
in MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
in MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
in MySql.Data.MySqlClient.MySqlDataReader.NextResult()
in MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
in MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
in System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in Azure.Database.Manager.Database.Session_Details.QueryAdapter.GetTable()
Clicca per espandere...

Apri il tuo DB e nella voce SQL copia questi:

ALTER table catalog_items ADD `item_names` varchar(255) DEFAULT '' AFTER Specialname

UPDATE catalog_items, catalog_pages SET catalog_items.item_names = (SELECT item_name FROM catalog_furnis WHERE catalog_furnis.id = catalog_items.item_ids)

ALTER TABLE `users` ADD `DutyLevel` INT NOT NULL DEFAULT '0' AFTER `OnDuty`

ALTER table catalog_items add order_num INT(11) NOT NULL DEFAULT '1'; UPDATE catalog_items SET order_num = '1'; INSERT INTO server_langs VALUES (NULL, 'english', 'user_rank_update', 'Has dado rango con exito')

Se ti dice che già hai qualcosa stai tranquillo, è normale.
 
Devi accedere o registrarti per rispondere qui.
 
 
Top
Indietro