Error 2020

H

Hytten

New Member
Apr 17, 2020
3
1
Hi!

I've followed this. got this error after step 3.
You must be registered for see links


Whats wrong?

localhost - /
2011-12-04 05:59 6148
You must be registered for see links

2011-09-15 08:15 246
You must be registered for see links

2011-09-18 09:46 127
You must be registered for see links

2012-03-09 13:39 <dir>
You must be registered for see links

2012-03-09 13:39 <dir>
You must be registered for see links

2011-10-05 11:56 1888
You must be registered for see links

2011-10-04 17:08 738
You must be registered for see links

2012-03-09 13:43 <dir>
You must be registered for see links

2020-04-20 18:46 168
You must be registered for see links

Post automatically merged:

I have skype and discord if someone could help me out along the way. Thanks!
Post automatically merged:

SET@@global.sql_mode=''
> OK
> Time: 0,047s

I have 391 errors from original database
Post automatically merged:

[SQL] Query Original Database start
[ERR] 1265 - Data truncated for column 'is_rare' at row 1
[ERR]
INSERT INTO `furniture` VALUES ('492912', 'pirate_bottle_2', 'Glass Bottle 2', 's', '1', '1', '1', '1', '0', '0', '5200', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493012', 'ship_wheel', 'Ships Wheel', 's', '2', '1', '1', '1', '0', '0', '5227', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493112', 'pirate_stairs', 'Stair Block', 's', '1', '1', '0.7', '1', '0', '1', '5223', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493212', 'pirate_crate', 'Crate', 's', '1', '1', '0', '1', '0', '1', '5209', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493312', 'pirate_stage2', 'Ship Corner', 's', '1', '1', '0.7', '1', '0', '1', '5220', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493412', 'pirate_chest1', 'Treasure chest', 's', '2', '1', '1', '0', '0', '0', '5201', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493512', 'pirate_dvdr2', 'Ship Edging 2', 's', '1', '1', '1', '1', '0', '0', '5208', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493612', 'pirate_gate', 'Gate', 's', '1', '1', '0.01', '1', '0', '0', '5214', '1', '1', '1', '1', '1', 'gate', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493712', 'pirate_grate', 'Grate', 's', '2', '2', '0', '1', '0', '1', '5226', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493812', 'spacerent_room', 'spacerent_room name', 's', '1', '1', '1', '1', '0', '1', '5224', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('493912', 'pirate_bottle_3', 'Glass Bottle 3', 's', '1', '1', '1', '1', '0', '0', '5199', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494012', 'pirate_parrot', 'Pirate Talking Parrot', 's', '1', '1', '1', '0', '0', '0', '5210', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494112', 'pirate_mast3grp', 'Group Upper Sail', 's', '1', '1', '1', '1', '0', '0', '5211', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494212', 'pirate_mast4grp', 'Group Crows Nest', 's', '1', '1', '1', '1', '0', '1', '5225', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494312', 'pirate_bottle_10', 'Glass Bottle 10', 's', '1', '1', '1', '1', '0', '0', '5213', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494412', 'pirate_dvdr1', 'Ship Edging 1', 's', '1', '2', '0.001', '0', '0', '0', '5240', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494512', 'pirate_bottle_4', 'Glass Bottle 4', 's', '1', '1', '1', '1', '0', '0', '5218', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494612', 'pirate_plank', 'Plank', 's', '2', '1', '1', '1', '0', '1', '5234', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494712', 'pirate_mast3', 'Basic Upper Sail', 's', '1', '1', '1', '0', '0', '0', '5229', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('494812', 'pirate_barrel2', 'Orange barrel', 's', '1', '1', '1', '1', '0', '0', '5233', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('513504', 'ads
[ERR] 1265 - Data truncated for column 'tab_colour' at row 1
[ERR]
INSERT INTO `permissions_rights` VALUES ('207', '9', '20');
INSERT INTO `permissions_rights` VALUES ('208', '9', '21');
INSERT INTO `permissions_rights` VALUES ('209', '9', '22');
INSERT INTO `permissions_rights` VALUES ('210', '9', '23');
INSERT INTO `permissions_rights` VALUES ('211', '9', '24');
INSERT INTO `permissions_rights` VALUES ('212', '9', '25');
INSERT INTO `permissions_rights` VALUES ('213', '9', '26');
INSERT INTO `permissions_rights` VALUES ('214', '9', '27');
INSERT INTO `permissions_rights` VALUES ('215', '9', '28');
INSERT INTO `permissions_rights` VALUES ('216', '9', '29');
INSERT INTO `permissions_rights` VALUES ('217', '9', '30');
INSERT INTO `permissions_rights` VALUES ('218', '9', '31');
INSERT INTO `permissions_rights` VALUES ('219', '9', '32');
INSERT INTO `permissions_rights` VALUES ('220', '9', '33');
INSERT INTO `permissions_rights` VALUES ('221', '9', '34');
INSERT INTO `permissions_rights` VALUES ('222', '9', '35');
INSERT INTO `permissions_rights` VALUES ('223', '9', '36');
INSERT INTO `permissions_rights` VALUES ('224', '9', '37');
INSERT INTO `permissions_rights` VALUES ('225', '9', '38');
INSERT INTO `permissions_rights` VALUES ('226', '9', '39');
INSERT INTO `permissions_rights` VALUES ('227', '9', '40');
INSERT INTO `permissions_rights` VALUES ('228', '9', '41');
INSERT INTO `permissions_rights` VALUES ('229', '9', '42');
INSERT INTO `permissions_rights` VALUES ('230', '9', '43');
INSERT INTO `permissions_rights` VALUES ('231', '9', '44');
INSERT INTO `permissions_rights` VALUES ('232', '9', '45');
INSERT INTO `permissions_rights` VALUES ('233', '9', '46');
INSERT INTO `permissions_rights` VALUES ('234', '9', '47');
INSERT INTO `permissions_rights` VALUES ('235', '9', '48');
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
[ERR] 1146 - Table 'hotel.room_chat_styles' doesn't exist
[ERR]
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 DEFAULT '',
`custom` enum('0','1') NOT NULL DEFAULT '0',
`wall_height` int(11) NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of room_models
-- ----------------------------
INSERT INTO `room_models` VALUES ('model_0', '0', '4', '0', '2', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nx00000000xx00000000xx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nx00000000xx00000000xx00000000xxxxxxxxxxxxxxxxxxxxxx
[SQL] Finished with error
Post automatically merged:

I succesfully uploaded database to navicat. Had some help from youtube. When I go to browser and try going to localhost it still says following:

localhost - /
2011-12-04 05:59 6148
You must be registered for see links

2011-09-15 08:15 246
You must be registered for see links

2011-09-18 09:46 127
You must be registered for see links

2012-03-09 13:39 <dir>
You must be registered for see links

2012-03-09 13:39 <dir>
You must be registered for see links

2011-10-05 11:56 1888
You must be registered for see links

2011-10-04 17:08 738
You must be registered for see links

2012-03-09 13:43 <dir>
You must be registered for see links

2020-04-20 18:46 168
You must be registered for see links
 
Last edited:

Users who are viewing this thread

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

Latest posts

Top