Pets MySQL Error [PLUS R2] Missing table
Does someone has the table for me? I can't find it.
PHP Code:
Error in query: SELECT * FROM pets WHERE room_id = 14MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.pets' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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() in C:\Users\Administrator\Desktop\TempEMU\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 144
Re: Pets MySQL Error [PLUS R2] Missing table
Please run this in your database:
PHP Code:
CREATE TABLE IF NOT EXISTS `pets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `room_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL, `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `z` int(11) NOT NULL DEFAULT '0', `rotation` int(11) NOT NULL DEFAULT '0', `walk_mode` enum('stand','freeroam','specified_range') NOT NULL DEFAULT 'freeroam', `min_x` int(11) NOT NULL DEFAULT '0', `min_y` int(11) NOT NULL DEFAULT '0', `max_x` int(11) NOT NULL DEFAULT '0', `max_y` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `room_id` (`room_id`), KEY `user_id` (`user_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5404 ;
