joaopaulo98 • 21.11.13 10:48
erro na importação de db 21.11.13 10:48
ola qando eu vou importar a db do habzin da um erro mais eu sei mais ou menos qal é o erro mais nao sei arumar vou mostrar um pedaço do erro q nao cabe tudo Obs: no xampp
- erro:
Erro
consulta SQL:
--
-- Extraindo dados da tabela `achievements`
--
INSERT INTO `achievements` ( `id_ai` , `id` , `group_name` , `category` , `level` ,`reward_pixels` , `reward_points` , `progress_needed` )
VALUES ( 1, 3, 'ACH_EmailVerification', 'identity', 1, 0, 0, 1 ) , ( 2, 4, 'ACH_Login','identity', 1, 0, 0, 5 ) , ( 3, 6, 'ACH_AvatarLooks', 'identity', 1, 0, 0, 1 ) , ( 4, 8,'ACH_RoomEntry', 'explore', 1, 0, 0, 5 ) , ( 5, 10, 'ACH_HappyHour', 'social', 1, 0, 0, 1) , ( 6, 11, 'ACH_RegistrationDuration', 'identity', 1, 1, 0, 3 ) , ( 7, 16,'ACH_AvatarTags', 'identity', 1, 0, 0, 5 ) , ( 8, 17, 'ACH_RespectEarned', 'social', 1, 0,0, 1 ) , ( 9, 18, 'ACH_RespectGiven', 'social', 1, 0, 0, 2 ) , ( 10, 19,'ACH_AllTimeHotelPresence', 'identity', 1, 0, 0, 30 ) , ( 11, 23, 'ACH_PetLover', 'pets',1, 0, 0, 1 ) , ( 12, 24, 'ACH_PetLevelUp', 'pets', 1, 0, 0, 2 ) , ( 13, 25,'ACH_PetFeeding', 'pets', 1, 0, 0, 200 ) , ( 14, 26, 'ACH_PetRespectGiver', 'pets', 1, 0,0, 2 ) , ( 15, 27, 'ACH_PetRespectReceiver', 'pets', 1, 0, 0, 3 ) , ( 16, 28, 'ACH_Name','identity', 1, 0, 0, 1 ) , ( 17, 29, 'ACH_GiftGiver', 'social', 1, 0, 0, 1 ) , ( 18, 30,'ACH_GiftReceiver', 'social', 1, 0, 0, 1 ) , ( 19, 31, 'ACH_VipClub', 'identity', 1, 0, 0, 1 ), ( 20, 32, 'ACH_BasicClub', 'identity', 1, 0, 0, 1 ) , ( 21, 33,'ACH_BattleBallTilesLocked', 'battleball', 1, 0, 0, 25 ) , ( 22, 34,'ACH_GameAuthorExperience', 'room_builder', 1, 0, 0, 400 ) , ( 23, 35,'ACH_GamePlayerExperience', 'games', 1, 0, 0, 100 ) , ( 24, 36, 'ACH_EsA', 'freeze',1, 0, 0, 2 ) , ( 25, 38, 'ACH_TagB', 'games', 1, 0, 0, 1 ) , ( 26, 39, 'ACH_TagC','explore', 1, 0, 0, 3 ) , ( 27, 40, 'ACH_TagA', 'room_builder', 1, 0, 0, 10 ) , ( 28, 42,'ACH_Spr', 'room_builder', 1, 0, 0, 1 ) , ( 29, 47, 'ACH_RbTagC', 'explore', 1, 0, 0, 3 ) ,( 30, 48, 'ACH_RbTagA', 'room_builder', 1, 0, 0, 10 ) , ( 31, 50,'ACH_RoomDecoFurniCount', 'room_builder', 1, 0, 0, 15 ) , ( 32, 51,'ACH_RoomDecoFurniTypeCount', 'room_builder', 1, 0, 0, 10 ) , ( 33, 52,'ACH_RoomDecoHosting', 'room_builder', 1, 0, 0, 5 ) , ( 34, 53,'ACH_RoomDecoFloor', 'room_builder', 1, 0, 0, 3 ) , ( 35, 54,'ACH_RoomDecoLandscape', 'room_builder', 1, 0, 0, 3 ) , ( 36, 55,'ACH_RoomDecoWallpaper', 'room_builder', 1, 0, 0, 3 ) , ( 37, 56, 'ACH_RbBunnyTag','room_builder', 1, 0, 0, 10 ) , ( 38, 57, 'ACH_NotesLeft', 'social', 1, 0, 0, 2 ) , ( 39, 58,'ACH_NotesReceived', 'social', 1, 0, 0, 2 ) , ( 40, 59, 'ACH_MusicPlayer', 'music', 1, 0,0, 5 ) , ( 41, 60, 'ACH_MusicCollector', 'music', 1, 0, 0, 2 ) , ( 42, 62,'ACH_SkateBoardJump', 'games', 1, 0, 0, 5 ) , ( 43, 63, 'ACH_SkateBoardSlide','games', 1, 0, 0, 20 ) , ( 44, 64, 'ACH_BattleBallQuestCompleted', 'battleball', 1, 0, 0, 3) , ( 45, 65, 'ACH_FreezeQuestCompleted', 'freeze', 1, 0, 0, 3 ) , ( 46, 66,'ACH_BadMonkeyLevelUp', 'pets', 1, 0, 0, 1 ) , ( 47, 67, 'ACH_BattleBallWinner','battleball', 1, 0, 0, 50 ) , ( 48, 68, 'ACH_BattleBallPlayer', 'battleball', 1, 0, 0, 50 ) , (49, 69, 'ACH_FreezeWinner', 'freeze', 1, 0, 0, 50 ) , ( 50, 70, 'ACH_FreezePlayer','freeze', 1, 0, 0, 50 ) , ( 51, 71, 'ACH_FreezePowerUp', 'freeze', 1, 0, 0, 100 ) , ( 52, 72,'ACH_RoomDecoHoleFurniCount', 'room_builder', 1, 0, 0, 10 ) , ( 53, 73,'ACH_Xmas11QuestCompleted', 'explore', 1, 0, 0, 6 ) , ( 54, 74,'ACH_SnowWarTotalScore', 'games', 1, 0, 0, 10 ) , ( 55, 75, 'ACH_snowBoardBuild','room_builder', 1, 0, 0, 16 ) , ( 56, 76, 'ACH_SnowWarWeeklyTopTen', 'games', 1, 0, 0,1 ) , ( 57, 77, 'ACH_SnowWarWeeklyBest', 'games', 1, 0, 0, 1 ) , ( 58, 78,'ACH_Valentines12QuestCompleted', 'explore', 1, 0, 0, 2 ) , ( 59, 79,'ACH_RoomHorseJumpCount', 'pets', 1, 0, 0, 250 ) , ( 60, 80, 'ACH_HorseJumping','pets', 1, 0, 0, 50 ) , ( 61, 81, 'ACH_HorseConsecutiveJumpsCount', 'pets', 1, 0, 0, 6 ) ,( 62, 82, 'ACH_HorseRent', 'pets', 1, 0, 0, 4 ) , ( 63, 83, 'ACH_HorseQuestCompleted','pets', 1, 0, 0, 5 ) , ( 64, 84, 'ACH_AprilFools12QuestCompleted', 'explore', 1, 0, 0, 1 ), ( 65, 93, 'ACH_GuideGroupMember', '', 1, 0, 0, 1 ) , ( 66, 94,'ACH_HabboWayGraduate', 'identity', 1, 50, 0, 1 ) , ( 67, 95,'ACH_GuideEnrollmentLifetime', '', 1, 0, 0, 1 ) , ( 68, 96,
- no final:
- Mensagens do MySQL : Documentação
#1054 - Unknown column 'id_ai' in 'field list'
Whiskey • 24.11.13 1:08
