Azure 2.0.200 Permissions_ranks

W

Woiah

Member
Mar 5, 2012
234
8
Hi Devbest! Im running a hotel using Revcms 1.9.9.9 and Azure 2.0.200 Emu!

But i have a problem!
In database i dont have Permissions_ranks!

I dont have any commands in the client!
Can someone help me!
 
Sort by date Sort by votes
F

FastHabbo

Member
Aug 23, 2011
160
8
I'm getting this issue too, any fixes?
ive tried importing permission ranks from another db
I just get this error anyone know why?

Source Server : Hotle
Source Server Version : 50545
Source Host : localhost:3306
Source Database : r63b

Target Server Type : MYSQL
Target Server Version : 50545
File Encoding : 65001

Date: 2015-12-08 21:51:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for permissions_ranks_copy
-- ----------------------------
DROP TABLE IF EXISTS `permissions_ranks_copy`;
CREATE TABLE `permissions_ranks_copy` (
`rank` int(1) unsigned NOT NULL,
`floodtime` int(2) NOT NULL DEFAULT '30',
`support_tool` enum('0','1') NOT NULL DEFAULT '0',
`ambassadeur` enum('0','1') NOT NULL DEFAULT '0',
`moderator` enum('0','1') NOT NULL DEFAULT '0',
`manager` enum('0','1') NOT NULL DEFAULT '0',
`admin` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`staff_chat` enum('0','1') NOT NULL DEFAULT '0',
`user_is_staff` enum('0','1') NOT NULL DEFAULT '0',
`user_not_kickable` enum('0','1') NOT NULL DEFAULT '0',
`user_can_change_name` enum('0','1') NOT NULL DEFAULT '0',
`user_enter_full_rooms` enum('0','1') NOT NULL DEFAULT '0',
`user_enter_any_room` enum('0','1') NOT NULL DEFAULT '0',
`user_can_read_whisper` enum('0','1') NOT NULL DEFAULT '0',
`user_room_staff_pick` enum('0','1') NOT NULL DEFAULT '0',
`cmd_global_refresh_permissions` enum('0','1') NOT NULL DEFAULT '0',
`cmd_user_can_give_currency` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_read_chatlog` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_send_alert` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_ban_user` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_kick_user` enum('0','1') NOT NULL DEFAULT '0',
`user_control_any_room` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`rank`),
UNIQUE KEY `rank` (`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of permissions_ranks_copy
-- ----------------------------
INSERT INTO `permissions_ranks_copy` VALUES ('1', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('2', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('3', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('4', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('5', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('6', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('7', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('8', '30', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully
 
Upvote 0 Downvote
W

Woiah

Member
Mar 5, 2012
234
8
FastHabbo said:
I'm getting this issue too, any fixes?
ive tried importing permission ranks from another db
I just get this error anyone know why?

Source Server : Hotle
Source Server Version : 50545
Source Host : localhost:3306
Source Database : r63b

Target Server Type : MYSQL
Target Server Version : 50545
File Encoding : 65001

Date: 2015-12-08 21:51:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for permissions_ranks_copy
-- ----------------------------
DROP TABLE IF EXISTS `permissions_ranks_copy`;
CREATE TABLE `permissions_ranks_copy` (
`rank` int(1) unsigned NOT NULL,
`floodtime` int(2) NOT NULL DEFAULT '30',
`support_tool` enum('0','1') NOT NULL DEFAULT '0',
`ambassadeur` enum('0','1') NOT NULL DEFAULT '0',
`moderator` enum('0','1') NOT NULL DEFAULT '0',
`manager` enum('0','1') NOT NULL DEFAULT '0',
`admin` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`staff_chat` enum('0','1') NOT NULL DEFAULT '0',
`user_is_staff` enum('0','1') NOT NULL DEFAULT '0',
`user_not_kickable` enum('0','1') NOT NULL DEFAULT '0',
`user_can_change_name` enum('0','1') NOT NULL DEFAULT '0',
`user_enter_full_rooms` enum('0','1') NOT NULL DEFAULT '0',
`user_enter_any_room` enum('0','1') NOT NULL DEFAULT '0',
`user_can_read_whisper` enum('0','1') NOT NULL DEFAULT '0',
`user_room_staff_pick` enum('0','1') NOT NULL DEFAULT '0',
`cmd_global_refresh_permissions` enum('0','1') NOT NULL DEFAULT '0',
`cmd_user_can_give_currency` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_read_chatlog` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_send_alert` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_ban_user` enum('0','1') NOT NULL DEFAULT '0',
`modtool_can_kick_user` enum('0','1') NOT NULL DEFAULT '0',
`user_control_any_room` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`rank`),
UNIQUE KEY `rank` (`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of permissions_ranks_copy
-- ----------------------------
INSERT INTO `permissions_ranks_copy` VALUES ('1', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('2', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('3', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('4', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('5', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('6', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('7', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `permissions_ranks_copy` VALUES ('8', '30', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully
Click to expand...
Same here
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
🌙  Switch to Dark Theme

Latest posts

Top