Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
Error in PlusEMU SQL
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="olliedean" data-source="post: 429636" data-attributes="member: 27500"><p>Comes up with these errors, using Navicat, 371 errors:</p><p></p><p></p><p>[Err] 1265 - Data truncated for column 'is_rare' at row 1</p><p>[Err] INSERT INTO `furniture` VALUES ('300003', 'ads_mpu_720', 'Square Glass Window', 's', '1', '1', '0', '1', '0', '1', '4036', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('360005', 'anc_comfy_tree', 'Not so tall tree', 's', '1', '1', '5', '1', '1', '0', '4653', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('360006', 'anc_sunset_wall', 'Jungle landscape', 'i', '0', '0', '0', '1', '0', '0', '4462', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('381982', 'prizetrophy_frank', 'Frank Trophy', 's', '1', '1', '1', '1', '0', '0', '4641', '1', '1', '1', '1', '1', 'trophy', '0', '1', '0', '0', '0', '0', '1', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'Room Background', 's', '1', '1', '0', '1', '0', '1', '3996', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('445457', 'CF_200_ruby', 'Big Ruby', 's', '1', '1', '1', '1', '0', '0', '4613', '1', '1', '1', '1', '1', 'exchange', '200', '1', '0', '0', '0', '0', '1', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('445458', 'CF_75_ruby_small', 'Small Ruby', 's', '1', '1', '1', '1', '0', '0', '4612', '1', '1', '1', '1', '1', 'exchange', '75', '1', '0', '0', '0', '0', '1', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('456456', 'tstool', 'tstool', 's', '1', '1', '1', '1', '1', '0', '456456', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '1', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('461932', 'kuurna_red_chair1', 'Pixel Dining Table', 's', '1', '1', '1', '0', '1', '0', '461932', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('462033', 'kuurna_table', 'Pixel Dining Table', 's', '2', '2', '1.3', '1', '0', '0', '3926', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('462133', 'kuurna_red_table1', 'Pixel Side Table', 's', '1', '1', '1.3', '1', '0', '0', '4621', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('462233', 'kuurna_red_lamp', 'Pixel Lamp', 's', '1', '1', '1', '0', '0', '0', '4622', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490312', 'ads_vpiggy_flag', 'Piggy Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5195', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490412', 'ads_vpiggy_pig', 'Golden Pig', 's', '1', '1', '1', '0', '0', '0', '5196', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490512', 'pirate_side1', 'pirate_side1 name', 's', '1', '1', '1', '1', '0', '1', '5215', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490612', 'pirate_stage', 'Stage', 's', '2', '2', '0.9', '1', '0', '1', '5230', '1', '1', '1', '1', '1', 'default', '0', '5', '0', '0.8,2.0,3.0,4.0,5.0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490712', 'pirate_roombg', 'Pirate Room Background', 's', '1', '1', '1', '1', '0', '1', '5216', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490812', 'pirate_flag', 'Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5232', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('490912', 'pirate_gunrack', 'Gun Rack', 's', '2', '1', '1', '1', '0', '0', '5236', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');</p><p>INSERT INTO `furniture` VALUES ('491012', 'pirate_cannon', 'Pirate Cannon', 's', '2', '1', '1', '1', '0', '0', '5222', '1', '1', '1', '1', '1', 'cannon', '0', '2', '0', '0', '0', '0', '0', '0', '0')</p><p>[Err] 1265 - Data truncated for column 'tab_colour' at row 1</p><p>[Err] INSERT INTO `permissions_rights` VALUES ('236', '9', '49');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `permissions_subscriptions`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `permissions_subscriptions`;</p><p>CREATE TABLE `permissions_subscriptions` (</p><p> `id` int(10) NOT NULL AUTO_INCREMENT,</p><p> `subscription_id` int(10) NOT NULL,</p><p> `permission_id` int(10) NOT NULL,</p><p> PRIMARY KEY (`id`)</p><p>) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of permissions_subscriptions</p><p>-- ----------------------------</p><p>INSERT INTO `permissions_subscriptions` VALUES ('1', '1', '1');</p><p>INSERT INTO `permissions_subscriptions` VALUES ('2', '2', '2');</p><p>INSERT INTO `permissions_subscriptions` VALUES ('3', '3', '3');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `quests`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `quests`;</p><p>CREATE TABLE `quests` (</p><p> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,</p><p> `type` varchar(32) NOT NULL DEFAULT '',</p><p> `level_num` int(11) NOT NULL DEFAULT '0',</p><p> `goal_type` int(10) NOT NULL DEFAULT '0',</p><p> `goal_data` int(10) unsigned NOT NULL DEFAULT '0',</p><p> `action` varchar(32) NOT NULL DEFAULT '',</p><p> `pixel_reward` int(11) NOT NULL DEFAULT '10',</p><p> `data_bit` varchar(2) NOT NULL DEFAULT '',</p><p> `reward_type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',</p><p> `timestamp_unlock` int(11) NOT NULL DEFAULT '0',</p><p> `timestamp_lock` int(11) NOT NULL,</p><p> PRIMARY KEY (`id`)</p><p>) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8;</p><p></p><p>-- ----------------------------</p><p>-- Records of quests</p><p>-- ----------------------------</p><p>INSERT INTO `quests` VALUES ('2', 'identity', '1', '14', '1', 'CHANGEFIGURE', '10', '_2', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('3', 'social', '2', '9', '1', 'CHATWITHSOMEONE', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('6', 'social', '5', '12', '1', 'DANCE', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('15', 'social', '1', '8', '1', 'ENTEROTHERSROOM', '10', '_2', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('17', 'identity', '2', '15', '1', 'CHANGEMOTTO', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('101', 'room_builder', '1', '0', '3', 'MOVEITEM', '10', '_2', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('104', 'explore', '1', '17', '1936', 'FINDLIFEGUARDTOWER', '10', '_2', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('105', 'room_builder', '2', '1', '3', 'ROTATEITEM', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('106', 'room_builder', '3', '2', '1', 'PLACEITEM', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('107', 'room_builder', '4', '3', '1', 'PICKUPITEM', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('108', 'room_builder', '5', '4', '2', 'SWITCHSTATE', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('109', 'room_builder', '6', '5', '1', 'STACKITEM', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('110', 'room_builder', '7', '6', '1', 'PLACEFLOOR', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('111', 'room_builder', '8', '7', '1', 'PLACEWALLPAPER', '10', '_1', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('113', 'identity', '3', '16', '1', 'WEARBADGE', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('115', 'social', '3', '10', '1', 'REQUESTFRIEND', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('116', 'social', '4', '11', '1', 'GIVERESPECT', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('118', 'social', '6', '13', '1', 'WAVE', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('119', 'explore', '2', '17', '1948', 'SWIM', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('120', 'explore', '3', '17', '1969', 'FINDSURFBOARD', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('121', 'explore', '4', '17', '1956', 'FINDBEETLE', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('122', 'explore', '5', '17', '1369', 'FINDNEONFLOOR', '10', '', '0', '0', '0');</p><p>INSERT INTO `quests` VALUES ('123', 'explore', '6', '17', '1375', 'FINDDISCOBALL', '10', '', '0', '0', </p><p>[Err] 1146 - Table 'retro.room_chat_styles' doesn't exist</p><p>[Err] INSERT INTO `room_chat_styles` VALUES ('18', '', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('19', 'piglet', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('20', 'sausagedog', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('21', 'firingmylazer', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('22', 'dragon', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('23', 'staff', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('24', 'bats', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('25', 'console', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('26', '', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('27', 'storm', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('28', 'parrot', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('29', 'pirate', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('30', 'bot_guide', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('31', 'bot_rentable', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('32', 'skelestock', '');</p><p>INSERT INTO `room_chat_styles` VALUES ('33', 'bot_frank', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('34', 'notification', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('35', 'goat', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('36', 'santa', 'mod_tool');</p><p>INSERT INTO `room_chat_styles` VALUES ('37', '', 'mod_tool');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `room_filter`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `room_filter`;</p><p>CREATE TABLE `room_filter` (</p><p> `id` int(11) NOT NULL AUTO_INCREMENT,</p><p> `word` varchar(15) NOT NULL DEFAULT '',</p><p> `room_id` int(11) NOT NULL DEFAULT '0',</p><p> PRIMARY KEY (`id`),</p><p> KEY `room_id` (`room_id`),</p><p> KEY `word` (`word`)</p><p>) ENGINE=InnoDB DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of room_filter</p><p>-- ----------------------------</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `room_items_moodlight`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `room_items_moodlight`;</p><p>CREATE TABLE `room_items_moodlight` (</p><p> `id` int(11) NOT NULL AUTO_INCREMENT,</p><p> `item_id` int(10) unsigned NOT NULL,</p><p> `enabled` enum('0','1') NOT NULL DEFAULT '0',</p><p> `current_preset` int(11) NOT NULL,</p><p> `preset_one` text NOT NULL,</p><p> `preset_two` text NOT NULL,</p><p> `preset_three` text NOT NULL,</p><p> PRIMARY KEY (`id`),</p><p> KEY `item_id` (`item_id`),</p><p> KEY `enabled` (`enabled`)</p><p>) ENGINE=InnoDB DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of room_items_moodlight</p><p>-- ----------------------------</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `room_items_tele_links`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `room_items_tele_links`;</p><p>CREATE TABLE `room_items_tele_links` (</p><p> `id` int(11) NOT NULL AUTO_INCREMENT,</p><p> `tele_one_id` int(10) unsigned NOT NULL,</p><p> `tele_two_id` int(10) unsigned NOT NULL,</p><p> PRIMARY KEY (`id`),</p><p> KEY `tele_one_id` (`tele_one_id`)</p><p>) ENGINE=InnoDB DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of room_items_tele_links</p><p>-- ----------------------------</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `room_items_toner`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `room_items_toner`;</p><p>CREATE TABLE `room_items_toner` (</p><p> `id` int(11) unsigned NOT NULL,</p><p> `enabled` enum('0','1') DEFAULT '0',</p><p> `data1` int(11) NOT NULL,</p><p> `data2` int(11) NOT NULL,</p><p> `data3` int(11) NOT NULL,</p><p> PRIMARY KEY (`id`),</p><p> UNIQUE KEY `id` (`id`),</p><p> KEY `enabled` (`enabled`)</p><p>) ENGINE=InnoDB DEFAULT CHARSET=utf8;</p><p></p><p>-- ----------------------------</p><p>-- Records of room_items_toner</p><p>-- ----------------------------</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `room_models`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `room_models`;</p><p>CREATE TABLE `room_models` (</p><p> `id` varchar(100) NOT NULL,</p><p> `door_x` int(11) NOT NULL,</p><p> `door_y` int(11) NOT NULL,</p><p> `door_z` double NOT NULL,</p><p> `door_dir` int(4) NOT NULL DEFAULT '2',</p><p> `heightmap` text NOT NULL,</p><p> `public_items` text NOT NULL,</p><p> `club_only` enum('0','1') NOT NULL DEFAULT '0',</p><p> `poolmap` varchar(100) NOT NULL DEFAU</p><p>[Err] 1146 - Table 'retro.server_settings' doesn't exist</p><p>[Err] INSERT INTO `server_settings` VALUES ('room.promotion.lifespan', '120', 'The lifespan of a room promotion.');</p><p>INSERT INTO `server_settings` VALUES ('trading.auto_exchange_redeemables', '0', 'When enabled credits that are traded will automatically be redeemed.');</p><p>INSERT INTO `server_settings` VALUES ('user.currency_scheduler.credit_reward', '100', 'The amount of credits a user will recieve every x minutes');</p><p>INSERT INTO `server_settings` VALUES ('user.currency_scheduler.ducket_reward', '100', 'The amount of pixels a user will recieve every x minutes');</p><p>INSERT INTO `server_settings` VALUES ('user.currency_scheduler.tick', '15', 'The time a user will have to wait for Credits/Pixels update in minutes');</p><p>INSERT INTO `server_settings` VALUES ('user.login.message.enabled', '0', 'If this is enabled, a message from the server_locale table will be given to the user.');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `server_status`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `server_status`;</p><p>CREATE TABLE `server_status` (</p><p> `users_online` int(11) NOT NULL DEFAULT '0',</p><p> `loaded_rooms` int(11) NOT NULL DEFAULT '0',</p><p> UNIQUE KEY `users_online` (`users_online`) USING BT<img src="https://cdn.devbest.com/data/assets/smilies/REE.png" srcset="https://cdn.devbest.com/data/assets/smilies/REE.png 1x, https://cdn.devbest.com/data/assets/smilies/REE-2x.png 2x" class="smilie" loading="lazy" alt="REE" title="REE REE" data-shortname="REE" /></p><p>) ENGINE=InnoDB DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of server_status</p><p>-- ----------------------------</p><p>INSERT INTO `server_status` VALUES ('0', '0');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `subscriptions`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `subscriptions`;</p><p>CREATE TABLE `subscriptions` (</p><p> `id` int(10) NOT NULL DEFAULT '0',</p><p> `name` varchar(50) NOT NULL,</p><p> `badge_code` varchar(10) NOT NULL,</p><p> `credits` int(11) NOT NULL DEFAULT '100',</p><p> `duckets` int(11) NOT NULL DEFAULT '100',</p><p> `respects` int(11) NOT NULL DEFAULT '3',</p><p> PRIMARY KEY (`id`)</p><p>) ENGINE=InnoDB DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of subscriptions</p><p>-- ----------------------------</p><p>INSERT INTO `subscriptions` VALUES ('1', 'Silver VIP', 'SVIP', '200', '150', '15');</p><p>INSERT INTO `subscriptions` VALUES ('2', 'Gold VIP', 'GVIP', '300', '200', '20');</p><p>INSERT INTO `subscriptions` VALUES ('3', 'Events Staff', 'EVENT', '500', '250', '20');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `talents`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `talents`;</p><p>CREATE TABLE `talents` (</p><p> `id` int(11) NOT NULL AUTO_INCREMENT,</p><p> `type` enum('citizenship','helper') NOT NULL,</p><p> `level` int(11) DEFAULT '0',</p><p> `data_actions` text NOT NULL,</p><p> `data_gifts` text NOT NULL,</p><p> PRIMARY KEY (`id`)</p><p>) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of talents</p><p>-- ----------------------------</p><p>INSERT INTO `talents` VALUES ('1', 'citizenship', '0', '', 'A1 KUMIANKKA');</p><p>INSERT INTO `talents` VALUES ('2', 'citizenship', '1', '', 'A1 KUMIANKKA');</p><p>INSERT INTO `talents` VALUES ('3', 'citizenship', '2', 'TRADE', 'A1 KUMIANKKA');</p><p>INSERT INTO `talents` VALUES ('4', 'citizenship', '3', 'CITIZEN', 'A1 KUMIANKKA|pixel_walldeco');</p><p></p><p>-- ----------------------------</p><p>-- Table structure for `talents_sub_levels`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `talents_sub_levels`;</p><p>CREATE TABLE `talents_sub_levels` (</p><p> `id` int(11) NOT NULL AUTO_INCREMENT,</p><p> `talent_level` int(11) NOT NULL DEFAULT '0',</p><p> `sub_level` int(11) NOT NULL DEFAULT '0',</p><p> `badge_code` varchar(45) NOT NULL DEFAULT '',</p><p> `required_progress` int(11) NOT NULL DEFAULT '0',</p><p> PRIMARY KEY (`id`)</p><p>) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;</p><p></p><p>-- ----------------------------</p><p>-- Records of talents_sub_levels</p><p>-- ----------------------------</p><p>INSERT INTO `talents_sub_levels` VALUES ('1', '0', '1', 'ACH_SafetyQuizGraduate1', '1');</p><p>INSERT INTO `talents_sub_levels` VALUES ('2', '1', '1', 'ACH_AvatarLooks1', '1');</p><p>INSERT INTO `talents_sub_levels` VALUES ('3', '1', '2', 'ACH_RespectGiven1', '2');</p><p>INSERT INTO `talents_sub_levels` VALUES ('4', '1', '3', 'ACH_AllTimeHotelPresence1', '60');</p><p>INSERT INTO `talents_sub_levels` VALUES </p><p>[Msg] Finished - Unsuccessfully</p><p>--------------------------------------------------</p></blockquote><p></p>
[QUOTE="olliedean, post: 429636, member: 27500"] Comes up with these errors, using Navicat, 371 errors: [Err] 1265 - Data truncated for column 'is_rare' at row 1 [Err] INSERT INTO `furniture` VALUES ('300003', 'ads_mpu_720', 'Square Glass Window', 's', '1', '1', '0', '1', '0', '1', '4036', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `furniture` VALUES ('360005', 'anc_comfy_tree', 'Not so tall tree', 's', '1', '1', '5', '1', '1', '0', '4653', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('360006', 'anc_sunset_wall', 'Jungle landscape', 'i', '0', '0', '0', '1', '0', '0', '4462', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('381982', 'prizetrophy_frank', 'Frank Trophy', 's', '1', '1', '1', '1', '0', '0', '4641', '1', '1', '1', '1', '1', 'trophy', '0', '1', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'Room Background', 's', '1', '1', '0', '1', '0', '1', '3996', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `furniture` VALUES ('445457', 'CF_200_ruby', 'Big Ruby', 's', '1', '1', '1', '1', '0', '0', '4613', '1', '1', '1', '1', '1', 'exchange', '200', '1', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `furniture` VALUES ('445458', 'CF_75_ruby_small', 'Small Ruby', 's', '1', '1', '1', '1', '0', '0', '4612', '1', '1', '1', '1', '1', 'exchange', '75', '1', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `furniture` VALUES ('456456', 'tstool', 'tstool', 's', '1', '1', '1', '1', '1', '0', '456456', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `furniture` VALUES ('461932', 'kuurna_red_chair1', 'Pixel Dining Table', 's', '1', '1', '1', '0', '1', '0', '461932', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('462033', 'kuurna_table', 'Pixel Dining Table', 's', '2', '2', '1.3', '1', '0', '0', '3926', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('462133', 'kuurna_red_table1', 'Pixel Side Table', 's', '1', '1', '1.3', '1', '0', '0', '4621', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('462233', 'kuurna_red_lamp', 'Pixel Lamp', 's', '1', '1', '1', '0', '0', '0', '4622', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490312', 'ads_vpiggy_flag', 'Piggy Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5195', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490412', 'ads_vpiggy_pig', 'Golden Pig', 's', '1', '1', '1', '0', '0', '0', '5196', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490512', 'pirate_side1', 'pirate_side1 name', 's', '1', '1', '1', '1', '0', '1', '5215', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490612', 'pirate_stage', 'Stage', 's', '2', '2', '0.9', '1', '0', '1', '5230', '1', '1', '1', '1', '1', 'default', '0', '5', '0', '0.8,2.0,3.0,4.0,5.0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490712', 'pirate_roombg', 'Pirate Room Background', 's', '1', '1', '1', '1', '0', '1', '5216', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490812', 'pirate_flag', 'Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5232', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('490912', 'pirate_gunrack', 'Gun Rack', 's', '2', '1', '1', '1', '0', '0', '5236', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `furniture` VALUES ('491012', 'pirate_cannon', 'Pirate Cannon', 's', '2', '1', '1', '1', '0', '0', '5222', '1', '1', '1', '1', '1', 'cannon', '0', '2', '0', '0', '0', '0', '0', '0', '0') [Err] 1265 - Data truncated for column 'tab_colour' at row 1 [Err] INSERT INTO `permissions_rights` VALUES ('236', '9', '49'); -- ---------------------------- -- Table structure for `permissions_subscriptions` -- ---------------------------- DROP TABLE IF EXISTS `permissions_subscriptions`; CREATE TABLE `permissions_subscriptions` ( `id` int(10) NOT NULL AUTO_INCREMENT, `subscription_id` int(10) NOT NULL, `permission_id` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of permissions_subscriptions -- ---------------------------- INSERT INTO `permissions_subscriptions` VALUES ('1', '1', '1'); INSERT INTO `permissions_subscriptions` VALUES ('2', '2', '2'); INSERT INTO `permissions_subscriptions` VALUES ('3', '3', '3'); -- ---------------------------- -- Table structure for `quests` -- ---------------------------- DROP TABLE IF EXISTS `quests`; CREATE TABLE `quests` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(32) NOT NULL DEFAULT '', `level_num` int(11) NOT NULL DEFAULT '0', `goal_type` int(10) NOT NULL DEFAULT '0', `goal_data` int(10) unsigned NOT NULL DEFAULT '0', `action` varchar(32) NOT NULL DEFAULT '', `pixel_reward` int(11) NOT NULL DEFAULT '10', `data_bit` varchar(2) NOT NULL DEFAULT '', `reward_type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0', `timestamp_unlock` int(11) NOT NULL DEFAULT '0', `timestamp_lock` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of quests -- ---------------------------- INSERT INTO `quests` VALUES ('2', 'identity', '1', '14', '1', 'CHANGEFIGURE', '10', '_2', '0', '0', '0'); INSERT INTO `quests` VALUES ('3', 'social', '2', '9', '1', 'CHATWITHSOMEONE', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('6', 'social', '5', '12', '1', 'DANCE', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('15', 'social', '1', '8', '1', 'ENTEROTHERSROOM', '10', '_2', '0', '0', '0'); INSERT INTO `quests` VALUES ('17', 'identity', '2', '15', '1', 'CHANGEMOTTO', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('101', 'room_builder', '1', '0', '3', 'MOVEITEM', '10', '_2', '0', '0', '0'); INSERT INTO `quests` VALUES ('104', 'explore', '1', '17', '1936', 'FINDLIFEGUARDTOWER', '10', '_2', '0', '0', '0'); INSERT INTO `quests` VALUES ('105', 'room_builder', '2', '1', '3', 'ROTATEITEM', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('106', 'room_builder', '3', '2', '1', 'PLACEITEM', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('107', 'room_builder', '4', '3', '1', 'PICKUPITEM', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('108', 'room_builder', '5', '4', '2', 'SWITCHSTATE', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('109', 'room_builder', '6', '5', '1', 'STACKITEM', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('110', 'room_builder', '7', '6', '1', 'PLACEFLOOR', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('111', 'room_builder', '8', '7', '1', 'PLACEWALLPAPER', '10', '_1', '0', '0', '0'); INSERT INTO `quests` VALUES ('113', 'identity', '3', '16', '1', 'WEARBADGE', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('115', 'social', '3', '10', '1', 'REQUESTFRIEND', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('116', 'social', '4', '11', '1', 'GIVERESPECT', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('118', 'social', '6', '13', '1', 'WAVE', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('119', 'explore', '2', '17', '1948', 'SWIM', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('120', 'explore', '3', '17', '1969', 'FINDSURFBOARD', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('121', 'explore', '4', '17', '1956', 'FINDBEETLE', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('122', 'explore', '5', '17', '1369', 'FINDNEONFLOOR', '10', '', '0', '0', '0'); INSERT INTO `quests` VALUES ('123', 'explore', '6', '17', '1375', 'FINDDISCOBALL', '10', '', '0', '0', [Err] 1146 - Table 'retro.room_chat_styles' doesn't exist [Err] INSERT INTO `room_chat_styles` VALUES ('18', '', ''); INSERT INTO `room_chat_styles` VALUES ('19', 'piglet', ''); INSERT INTO `room_chat_styles` VALUES ('20', 'sausagedog', ''); INSERT INTO `room_chat_styles` VALUES ('21', 'firingmylazer', ''); INSERT INTO `room_chat_styles` VALUES ('22', 'dragon', ''); INSERT INTO `room_chat_styles` VALUES ('23', 'staff', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('24', 'bats', ''); INSERT INTO `room_chat_styles` VALUES ('25', 'console', ''); INSERT INTO `room_chat_styles` VALUES ('26', '', ''); INSERT INTO `room_chat_styles` VALUES ('27', 'storm', ''); INSERT INTO `room_chat_styles` VALUES ('28', 'parrot', ''); INSERT INTO `room_chat_styles` VALUES ('29', 'pirate', ''); INSERT INTO `room_chat_styles` VALUES ('30', 'bot_guide', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('31', 'bot_rentable', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('32', 'skelestock', ''); INSERT INTO `room_chat_styles` VALUES ('33', 'bot_frank', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('34', 'notification', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('35', 'goat', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('36', 'santa', 'mod_tool'); INSERT INTO `room_chat_styles` VALUES ('37', '', 'mod_tool'); -- ---------------------------- -- Table structure for `room_filter` -- ---------------------------- DROP TABLE IF EXISTS `room_filter`; CREATE TABLE `room_filter` ( `id` int(11) NOT NULL AUTO_INCREMENT, `word` varchar(15) NOT NULL DEFAULT '', `room_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `room_id` (`room_id`), KEY `word` (`word`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of room_filter -- ---------------------------- -- ---------------------------- -- Table structure for `room_items_moodlight` -- ---------------------------- DROP TABLE IF EXISTS `room_items_moodlight`; CREATE TABLE `room_items_moodlight` ( `id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(10) unsigned NOT NULL, `enabled` enum('0','1') NOT NULL DEFAULT '0', `current_preset` int(11) NOT NULL, `preset_one` text NOT NULL, `preset_two` text NOT NULL, `preset_three` text NOT NULL, PRIMARY KEY (`id`), KEY `item_id` (`item_id`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of room_items_moodlight -- ---------------------------- -- ---------------------------- -- Table structure for `room_items_tele_links` -- ---------------------------- DROP TABLE IF EXISTS `room_items_tele_links`; CREATE TABLE `room_items_tele_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tele_one_id` int(10) unsigned NOT NULL, `tele_two_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `tele_one_id` (`tele_one_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of room_items_tele_links -- ---------------------------- -- ---------------------------- -- Table structure for `room_items_toner` -- ---------------------------- DROP TABLE IF EXISTS `room_items_toner`; CREATE TABLE `room_items_toner` ( `id` int(11) unsigned NOT NULL, `enabled` enum('0','1') DEFAULT '0', `data1` int(11) NOT NULL, `data2` int(11) NOT NULL, `data3` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of room_items_toner -- ---------------------------- -- ---------------------------- -- Table structure for `room_models` -- ---------------------------- DROP TABLE IF EXISTS `room_models`; CREATE TABLE `room_models` ( `id` varchar(100) NOT NULL, `door_x` int(11) NOT NULL, `door_y` int(11) NOT NULL, `door_z` double NOT NULL, `door_dir` int(4) NOT NULL DEFAULT '2', `heightmap` text NOT NULL, `public_items` text NOT NULL, `club_only` enum('0','1') NOT NULL DEFAULT '0', `poolmap` varchar(100) NOT NULL DEFAU [Err] 1146 - Table 'retro.server_settings' doesn't exist [Err] INSERT INTO `server_settings` VALUES ('room.promotion.lifespan', '120', 'The lifespan of a room promotion.'); INSERT INTO `server_settings` VALUES ('trading.auto_exchange_redeemables', '0', 'When enabled credits that are traded will automatically be redeemed.'); INSERT INTO `server_settings` VALUES ('user.currency_scheduler.credit_reward', '100', 'The amount of credits a user will recieve every x minutes'); INSERT INTO `server_settings` VALUES ('user.currency_scheduler.ducket_reward', '100', 'The amount of pixels a user will recieve every x minutes'); INSERT INTO `server_settings` VALUES ('user.currency_scheduler.tick', '15', 'The time a user will have to wait for Credits/Pixels update in minutes'); INSERT INTO `server_settings` VALUES ('user.login.message.enabled', '0', 'If this is enabled, a message from the server_locale table will be given to the user.'); -- ---------------------------- -- Table structure for `server_status` -- ---------------------------- DROP TABLE IF EXISTS `server_status`; CREATE TABLE `server_status` ( `users_online` int(11) NOT NULL DEFAULT '0', `loaded_rooms` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `users_online` (`users_online`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of server_status -- ---------------------------- INSERT INTO `server_status` VALUES ('0', '0'); -- ---------------------------- -- Table structure for `subscriptions` -- ---------------------------- DROP TABLE IF EXISTS `subscriptions`; CREATE TABLE `subscriptions` ( `id` int(10) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL, `badge_code` varchar(10) NOT NULL, `credits` int(11) NOT NULL DEFAULT '100', `duckets` int(11) NOT NULL DEFAULT '100', `respects` int(11) NOT NULL DEFAULT '3', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of subscriptions -- ---------------------------- INSERT INTO `subscriptions` VALUES ('1', 'Silver VIP', 'SVIP', '200', '150', '15'); INSERT INTO `subscriptions` VALUES ('2', 'Gold VIP', 'GVIP', '300', '200', '20'); INSERT INTO `subscriptions` VALUES ('3', 'Events Staff', 'EVENT', '500', '250', '20'); -- ---------------------------- -- Table structure for `talents` -- ---------------------------- DROP TABLE IF EXISTS `talents`; CREATE TABLE `talents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` enum('citizenship','helper') NOT NULL, `level` int(11) DEFAULT '0', `data_actions` text NOT NULL, `data_gifts` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of talents -- ---------------------------- INSERT INTO `talents` VALUES ('1', 'citizenship', '0', '', 'A1 KUMIANKKA'); INSERT INTO `talents` VALUES ('2', 'citizenship', '1', '', 'A1 KUMIANKKA'); INSERT INTO `talents` VALUES ('3', 'citizenship', '2', 'TRADE', 'A1 KUMIANKKA'); INSERT INTO `talents` VALUES ('4', 'citizenship', '3', 'CITIZEN', 'A1 KUMIANKKA|pixel_walldeco'); -- ---------------------------- -- Table structure for `talents_sub_levels` -- ---------------------------- DROP TABLE IF EXISTS `talents_sub_levels`; CREATE TABLE `talents_sub_levels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `talent_level` int(11) NOT NULL DEFAULT '0', `sub_level` int(11) NOT NULL DEFAULT '0', `badge_code` varchar(45) NOT NULL DEFAULT '', `required_progress` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of talents_sub_levels -- ---------------------------- INSERT INTO `talents_sub_levels` VALUES ('1', '0', '1', 'ACH_SafetyQuizGraduate1', '1'); INSERT INTO `talents_sub_levels` VALUES ('2', '1', '1', 'ACH_AvatarLooks1', '1'); INSERT INTO `talents_sub_levels` VALUES ('3', '1', '2', 'ACH_RespectGiven1', '2'); INSERT INTO `talents_sub_levels` VALUES ('4', '1', '3', 'ACH_AllTimeHotelPresence1', '60'); INSERT INTO `talents_sub_levels` VALUES [Msg] Finished - Unsuccessfully -------------------------------------------------- [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Error in PlusEMU SQL
Top