[Help] RealityRP Client

[Skux]

Ok, so I know I have posted a few threads on this, but not this specific problem.

Ok, so I have Facebooks SWF's, RealityRP CMS, and RealityRP EMU.

I have everything configured properly. The swfs, client, emu, and cms. And the client loads fine, it even shows my connection. But then it gets to Hotel View and then a split second later it redirects to a 404 page. Here are some screenies to show what i'm talking about.

This is the link that it gives of the 404 page

http://127.0.0.1/account/disconnected?reason=logout&origin=popup

Now, on the Setup Thread for RealityRP I read through some of the comments and found someone had the same problem. They told him to run this in his DB.

-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 01, 2012 at 08:06 PM
-- Server version: 5.5.25a
-- PHP Version: 5.4.4
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
 
--
-- Database: `reality`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `rights`
--
 
CREATE TABLE IF NOT EXISTS `rights` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `set_id` int(10) unsigned NOT NULL,
  `right_id` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
 
--
-- Dumping data for table `rights`
--
 
INSERT INTO `rights` (`id`, `set_id`, `right_id`) VALUES
(1, 0, 'login'),
(2, 100, 'moderation_tool'),
(3, 100, 'enter_locked_rooms'),
(4, 50, 'enter_full_rooms'),
(5, 10, 'club_regular'),
(6, 20, 'club_vip'),
(7, 100, 'room_rights'),
(8, 200, 'room_rights_owner'),
(9, 200, 'hotel_admin'),
(10, 100, 'moderation_tickets'),
(11, 100, 'cannot_ignore'),
(12, 100, 'mute'),
(13, 0, 'trade');
 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

So I ran that into my DB and I get this back.

Error
SQL query:
 
--
-- Dumping data for table `rights`
--
INSERT INTO  `rights` (  `id` ,  `set_id` ,  `right_id` )
VALUES ( 1, 0,  'login' ) , ( 2, 100,  'moderation_tool' ) , ( 3, 100,  'enter_locked_rooms' ) , ( 4, 50,  'enter_full_rooms' ) , ( 5, 10,  'club_regular' ) , ( 6, 20,  'club_vip' ) , ( 7, 100,  'room_rights' ) , ( 8, 200,  'room_rights_owner' ) , ( 9, 200,  'hotel_admin' ) , ( 10, 100,  'moderation_tickets' ) , ( 11, 100,  'cannot_ignore' ) , ( 12, 100,  'mute' ) , ( 13, 0,  'trade' ) ;
 
 
MySQL said: Documentation
 
#1062 - Duplicate entry '1' for key 'PRIMARY'

Anyone have any idea on how to fix?

 

[Find]

try truncating rights table then running it again

 

[Skux]

try truncating rights table then running it again

Fixed.

Someone please close thread.

 

[Weasel]

Problem solved, thread closed.