um

S

Stevee

Posting Freak
Mar 29, 2011
580
35
hi, when I import my db for my r63 RP hotel, into navicat i get this error like here

[Err] 1265 - Data truncated for column 'cmd_disconnect' at row 1
[Err] INSERT INTO `items` VALUES ('5555123', '1', '0', '75', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555124', '1', '1', '75', '', '9', '12', '0', '0', '');
INSERT INTO `items` VALUES ('5555125', '1', '0', '29289', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555126', '1', '0', '29281', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555157', '1', '1', '128', '', '7', '16', '0', '0', '');
INSERT INTO `items` VALUES ('5555127', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555128', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555129', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555130', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555131', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555132', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555133', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555134', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555135', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555136', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555153', '1', '1', '442', '', '9', '13', '0', '0', '');
INSERT INTO `items` VALUES ('5555154', '1', '1', '442', '', '6', '12', '0', '4', '');
INSERT INTO `items` VALUES ('5555155', '1', '1', '442', '', '13', '12', '0', '0', '');
INSERT INTO `items` VALUES ('5555156', '1', '0', '442', '', '12', '23', '0', '0', '');
INSERT INTO `items` VALUES ('5555137', '1', '0', '219', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555152', '1', '1', '442', '', '10', '13', '0', '0', '');
INSERT INTO `items` VALUES ('5555139', '1', '0', '2785134', '0', '2', '17', '0', '4', '');
INSERT INTO `items` VALUES ('5555138', '1', '0', '2785134', '0', '1', '11', '0', '2', '');
INSERT INTO `items` VALUES ('5555140', '1', '1', '29292', '1', '8', '11', '0', '2', '');
INSERT INTO `items` VALUES ('5555141', '1', '1', '29293', '0', '8', '11', '0.5', '0', '');
INSERT INTO `items` VALUES ('5555142', '1', '0', '149', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555143', '1', '0', '149', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555144', '1', '1', '75', '', '1', '12', '0', '0', '');
INSERT INTO `items` VALUES ('5555145', '1', '1', '75', '', '2', '14', '0', '0', '');
INSERT INTO `items` VALUES ('5555146', '1', '1', '75', '', '1', '15', '0', '0', '');
INSERT INTO `items` VALUES ('5555147', '1', '1', '75', '', '1', '11', '0', '0', '');
INSERT INTO `items` VALUES ('5555148', '1', '1', '75', '', '1', '13', '0', '0', '');
INSERT INTO `items` VALUES ('5555149', '1', '1', '29289', '1', '6', '11', '0', '0', '');
INSERT INTO `items` VALUES ('5555150', '1', '0', '29281', '1', '1', '11', '0.5', '0', '');
INSERT INTO `items` VALUES ('5555151', '1', '0', '1552', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555158', '1', '1', '42', '', '9', '16', '0', '0', '');
INSERT INTO `items` VALUES ('5555159', '1', '1', '149', '', '12', '7', '0', '0', '');
INSERT INTO `items` VALUES ('5555160', '1', '1', '706', '', '11', '23', '0', '0', '');
INSERT INTO `items` VALUES ('5555161', '1', '1', '1149', '', '0', '0', '0', '0', '');

-- ----------------------------
-- Table structure for `linkfilter`
-- ----------------------------
DROP TABLE IF EXISTS `linkfilter`;
CREATE TABLE `linkfilter` (
`externalsite` varchar(80) NOT NULL,
PRIMARY KEY (`externalsite`),
KEY `site` (`externalsite`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of linkfilter
-- ----------------------------

-- ----------------------------
-- Table structure for `messenger_friendships`
-- ----------------------------
DROP TABLE IF EXISTS `messenger_friendships`;
CREATE TABLE `messenger_friendships` (
`user_one_id` int(10) unsigned NOT NULL,
`user_two
[Err] 1146 - Table 'rp_phx.permissions_vip' doesn't exist
[Err] -- ----------------------------
-- Records of permissions_vip
-- ----------------------------
INSERT INTO `permissions_vip` VALUES ('1', '1', '1', '1', '1', '1');

-- ----------------------------
-- Table structure for `quests`
-- ----------------------------
DROP TABLE IF EXISTS `quests`;
CREATE TABLE `quests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(100) NOT NULL,
`action` varchar(100) NOT NULL,
`needofcount` int(10) NOT NULL DEFAULT '1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`level_num` int(10) NOT NULL DEFAULT '1',
`pixel_reward` int(10) NOT NULL DEFAULT '50',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of quests
-- ----------------------------
INSERT INTO `quests` VALUES ('1', 'room_builder', 'MOVE_ITEM', '3', '1', '1', '50');
INSERT INTO `quests` VALUES ('2', 'identity', 'CHANGE_FIGURE', '1', '1', '1', '50');
INSERT INTO `quests` VALUES ('3', 'social', 'CHAT_WITH_SOMEONE', '1', '1', '6', '50');
INSERT INTO `quests` VALUES ('4', 'social', 'REQUEST_FRIEND', '1', '1', '2', '50');
INSERT INTO `quests` VALUES ('5', 'social', 'GIVE_RESPECT', '1', '1', '3', '50');
INSERT INTO `quests` VALUES ('7', 'room_builder', 'ROTATE_ITEM', '3', '1', '2', '50');
INSERT INTO `quests` VALUES ('6', 'social', 'DANCE', '1', '1', '5', '50');
INSERT INTO `quests` VALUES ('8', 'social', 'WAVE', '1', '1', '4', '50');
INSERT INTO `quests` VALUES ('9', 'room_builder', 'STACKITEM', '3', '1', '3', '50');
INSERT INTO `quests` VALUES ('10', 'room_builder', 'PICKUPITEM', '1', '1', '4', '50');
INSERT INTO `quests` VALUES ('11', 'room_builder', 'PLACEWALLPAPER', '1', '1', '7', '50');
INSERT INTO `quests` VALUES ('12', 'room_builder', 'SWITCHSTATE', '3', '1', '6', '50');
INSERT INTO `quests` VALUES ('13', 'room_builder', 'PLACEFLOOR', '1', '1', '8', '50');
INSERT INTO `quests` VALUES ('14', 'room_builder', 'PLACEITEM', '1', '1', '5', '50');
INSERT INTO `quests` VALUES ('15', 'social', 'ENTEROTHERSROOM', '1', '1', '1', '50');
INSERT INTO `quests` VALUES ('16', 'identity', 'WEARBADGE', '1', '1', '3', '50');
INSERT INTO `quests` VALUES ('17', 'identity', 'CHANGEMOTTO', '1', '1', '2', '50');
INSERT INTO `quests` VALUES ('18', 'explore', 'FINDLIFEGUARDTOWER', '1', '1', '1', '50');
INSERT INTO `quests` VALUES ('19', 'explore', 'SWIM', '1', '1', '2', '50');
INSERT INTO `quests` VALUES ('20', 'explore', 'FINDSURFBOARD', '1', '1', '3', '50');
INSERT INTO `quests` VALUES ('21', 'explore', 'FINDBEETLE', '1', '1', '4', '50');
INSERT INTO `quests` VALUES ('22', 'explore', 'FINDNEONFLOOR', '1', '1', '5', '50');
INSERT INTO `quests` VALUES ('23', 'explore', 'FINDDISCOBALL', '1', '1', '6', '50');
INSERT INTO `quests` VALUES ('24', 'explore', 'FINDJUKEBOX', '1', '1', '7', '50');

-- ----------------------------
-- Table structure for `ranks`
-- ----------------------------
DROP TABLE IF EXISTS `ranks`;
CREATE TABLE `ranks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`badgeid` varchar(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of ranks
-- ----------------------------
INSERT INTO `ranks` VALUES ('1', 'User', null);
INSERT INTO `ranks` VALUES ('2', 'VIP', 'VIP');
INSERT INTO `ranks` VALUES ('3', 'Silver Hobba', 'NWB');
INSERT INTO `ranks` VALUES ('4', 'Gold Hobba', 'HBA');
INSERT INTO `ranks` VALUES ('5', 'Super Hobba', 'HBA');
INSERT INTO `ranks` VALUES ('6', 'Moderator', 'ADM');
INSERT INTO `ranks` VALUES ('7', 'Administrator', 'ADM');

-- ----------------------------
-- Table structure for `room_ads`
-- ----------------------------
DROP TABLE IF EXISTS `room_ads`;
CREATE TABLE `room_ads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ad_image` text NOT NULL,
`ad_image_orig` text NOT NULL,
`ad_link` text NOT NULL,
`views` int(11) NOT NULL DEFAULT '0',
`views_limit` int(11) NOT NULL DEFAULT '0' COMMENT '0 = unlimited'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

You must be registered for see links
 
Sort by date Sort by votes
S

Stevee

Posting Freak
Mar 29, 2011
580
35
Also, I've done just about everything I could like, I've even delete the entire db and re-did it, i dont know what else is left to do.
 
Upvote 0 Downvote
Clit

Clit

Posting Freak
Feb 25, 2012
1,065
103
Stevee said:
hi, when I import my db for my r63 RP hotel, into navicat i get this error like here

[Err] 1265 - Data truncated for column 'cmd_disconnect' at row 1
[Err] INSERT INTO `items` VALUES ('5555123', '1', '0', '75', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555124', '1', '1', '75', '', '9', '12', '0', '0', '');
INSERT INTO `items` VALUES ('5555125', '1', '0', '29289', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555126', '1', '0', '29281', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555157', '1', '1', '128', '', '7', '16', '0', '0', '');
INSERT INTO `items` VALUES ('5555127', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555128', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555129', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555130', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555131', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555132', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555133', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555134', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555135', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555136', '1', '0', '29306', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555153', '1', '1', '442', '', '9', '13', '0', '0', '');
INSERT INTO `items` VALUES ('5555154', '1', '1', '442', '', '6', '12', '0', '4', '');
INSERT INTO `items` VALUES ('5555155', '1', '1', '442', '', '13', '12', '0', '0', '');
INSERT INTO `items` VALUES ('5555156', '1', '0', '442', '', '12', '23', '0', '0', '');
INSERT INTO `items` VALUES ('5555137', '1', '0', '219', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555152', '1', '1', '442', '', '10', '13', '0', '0', '');
INSERT INTO `items` VALUES ('5555139', '1', '0', '2785134', '0', '2', '17', '0', '4', '');
INSERT INTO `items` VALUES ('5555138', '1', '0', '2785134', '0', '1', '11', '0', '2', '');
INSERT INTO `items` VALUES ('5555140', '1', '1', '29292', '1', '8', '11', '0', '2', '');
INSERT INTO `items` VALUES ('5555141', '1', '1', '29293', '0', '8', '11', '0.5', '0', '');
INSERT INTO `items` VALUES ('5555142', '1', '0', '149', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555143', '1', '0', '149', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555144', '1', '1', '75', '', '1', '12', '0', '0', '');
INSERT INTO `items` VALUES ('5555145', '1', '1', '75', '', '2', '14', '0', '0', '');
INSERT INTO `items` VALUES ('5555146', '1', '1', '75', '', '1', '15', '0', '0', '');
INSERT INTO `items` VALUES ('5555147', '1', '1', '75', '', '1', '11', '0', '0', '');
INSERT INTO `items` VALUES ('5555148', '1', '1', '75', '', '1', '13', '0', '0', '');
INSERT INTO `items` VALUES ('5555149', '1', '1', '29289', '1', '6', '11', '0', '0', '');
INSERT INTO `items` VALUES ('5555150', '1', '0', '29281', '1', '1', '11', '0.5', '0', '');
INSERT INTO `items` VALUES ('5555151', '1', '0', '1552', '', '0', '0', '0', '0', '');
INSERT INTO `items` VALUES ('5555158', '1', '1', '42', '', '9', '16', '0', '0', '');
INSERT INTO `items` VALUES ('5555159', '1', '1', '149', '', '12', '7', '0', '0', '');
INSERT INTO `items` VALUES ('5555160', '1', '1', '706', '', '11', '23', '0', '0', '');
INSERT INTO `items` VALUES ('5555161', '1', '1', '1149', '', '0', '0', '0', '0', '');

-- ----------------------------
-- Table structure for `linkfilter`
-- ----------------------------
DROP TABLE IF EXISTS `linkfilter`;
CREATE TABLE `linkfilter` (
`externalsite` varchar(80) NOT NULL,
PRIMARY KEY (`externalsite`),
KEY `site` (`externalsite`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of linkfilter
-- ----------------------------

-- ----------------------------
-- Table structure for `messenger_friendships`
-- ----------------------------
DROP TABLE IF EXISTS `messenger_friendships`;
CREATE TABLE `messenger_friendships` (
`user_one_id` int(10) unsigned NOT NULL,
`user_two
[Err] 1146 - Table 'rp_phx.permissions_vip' doesn't exist
[Err] -- ----------------------------
-- Records of permissions_vip
-- ----------------------------
INSERT INTO `permissions_vip` VALUES ('1', '1', '1', '1', '1', '1');

-- ----------------------------
-- Table structure for `quests`
-- ----------------------------
DROP TABLE IF EXISTS `quests`;
CREATE TABLE `quests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(100) NOT NULL,
`action` varchar(100) NOT NULL,
`needofcount` int(10) NOT NULL DEFAULT '1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`level_num` int(10) NOT NULL DEFAULT '1',
`pixel_reward` int(10) NOT NULL DEFAULT '50',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of quests
-- ----------------------------
INSERT INTO `quests` VALUES ('1', 'room_builder', 'MOVE_ITEM', '3', '1', '1', '50');
INSERT INTO `quests` VALUES ('2', 'identity', 'CHANGE_FIGURE', '1', '1', '1', '50');
INSERT INTO `quests` VALUES ('3', 'social', 'CHAT_WITH_SOMEONE', '1', '1', '6', '50');
INSERT INTO `quests` VALUES ('4', 'social', 'REQUEST_FRIEND', '1', '1', '2', '50');
INSERT INTO `quests` VALUES ('5', 'social', 'GIVE_RESPECT', '1', '1', '3', '50');
INSERT INTO `quests` VALUES ('7', 'room_builder', 'ROTATE_ITEM', '3', '1', '2', '50');
INSERT INTO `quests` VALUES ('6', 'social', 'DANCE', '1', '1', '5', '50');
INSERT INTO `quests` VALUES ('8', 'social', 'WAVE', '1', '1', '4', '50');
INSERT INTO `quests` VALUES ('9', 'room_builder', 'STACKITEM', '3', '1', '3', '50');
INSERT INTO `quests` VALUES ('10', 'room_builder', 'PICKUPITEM', '1', '1', '4', '50');
INSERT INTO `quests` VALUES ('11', 'room_builder', 'PLACEWALLPAPER', '1', '1', '7', '50');
INSERT INTO `quests` VALUES ('12', 'room_builder', 'SWITCHSTATE', '3', '1', '6', '50');
INSERT INTO `quests` VALUES ('13', 'room_builder', 'PLACEFLOOR', '1', '1', '8', '50');
INSERT INTO `quests` VALUES ('14', 'room_builder', 'PLACEITEM', '1', '1', '5', '50');
INSERT INTO `quests` VALUES ('15', 'social', 'ENTEROTHERSROOM', '1', '1', '1', '50');
INSERT INTO `quests` VALUES ('16', 'identity', 'WEARBADGE', '1', '1', '3', '50');
INSERT INTO `quests` VALUES ('17', 'identity', 'CHANGEMOTTO', '1', '1', '2', '50');
INSERT INTO `quests` VALUES ('18', 'explore', 'FINDLIFEGUARDTOWER', '1', '1', '1', '50');
INSERT INTO `quests` VALUES ('19', 'explore', 'SWIM', '1', '1', '2', '50');
INSERT INTO `quests` VALUES ('20', 'explore', 'FINDSURFBOARD', '1', '1', '3', '50');
INSERT INTO `quests` VALUES ('21', 'explore', 'FINDBEETLE', '1', '1', '4', '50');
INSERT INTO `quests` VALUES ('22', 'explore', 'FINDNEONFLOOR', '1', '1', '5', '50');
INSERT INTO `quests` VALUES ('23', 'explore', 'FINDDISCOBALL', '1', '1', '6', '50');
INSERT INTO `quests` VALUES ('24', 'explore', 'FINDJUKEBOX', '1', '1', '7', '50');

-- ----------------------------
-- Table structure for `ranks`
-- ----------------------------
DROP TABLE IF EXISTS `ranks`;
CREATE TABLE `ranks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`badgeid` varchar(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of ranks
-- ----------------------------
INSERT INTO `ranks` VALUES ('1', 'User', null);
INSERT INTO `ranks` VALUES ('2', 'VIP', 'VIP');
INSERT INTO `ranks` VALUES ('3', 'Silver Hobba', 'NWB');
INSERT INTO `ranks` VALUES ('4', 'Gold Hobba', 'HBA');
INSERT INTO `ranks` VALUES ('5', 'Super Hobba', 'HBA');
INSERT INTO `ranks` VALUES ('6', 'Moderator', 'ADM');
INSERT INTO `ranks` VALUES ('7', 'Administrator', 'ADM');

-- ----------------------------
-- Table structure for `room_ads`
-- ----------------------------
DROP TABLE IF EXISTS `room_ads`;
CREATE TABLE `room_ads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ad_image` text NOT NULL,
`ad_image_orig` text NOT NULL,
`ad_link` text NOT NULL,
`views` int(11) NOT NULL DEFAULT '0',
`views_limit` int(11) NOT NULL DEFAULT '0' COMMENT '0 = unlimited'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

You must be registered for see links
Click to expand...

fix: 'unlimited'

thats just a quickie scan i did. not guaranteeing anything.
 
Upvote 0 Downvote
S

Stevee

Posting Freak
Mar 29, 2011
580
35
Vincenzo said:
fix: 'unlimited'

thats just a quickie scan i did. not guaranteeing anything.
Click to expand...

hm, I don't know really like I've tried multiple times to upload the .sql and it continues with errors, it also says something in the phoenixrp.swf bit after i upload the .swf but yeah.
 
Upvote 0 Downvote

Users who are viewing this thread

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

Latest posts

Top