Habbo r63 retro HK/ase not working properly

[Sam_Otten]

Hey, I've got a problem with my r63 retro. When I log into my HK/ase it works then I want to add a news article, works fine too, but when I submit the article this happens:

I'm using PlusEMU and RevCMS.
I hope someone can help me with this.

 

[Lame]

Run this Query:

DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

[Sam_Otten]

Run this Query:

DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

I get this error:

 

[Joe]

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

[Sam_Otten]

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Thanks this worked! But now I get the same screen when I add an MOTD. I'll try to post a screenshot later today.
EDIT: ]I've made a list of pages that still not work:

Delete a news article (By ID):

Command logs:

Change welcome message:

Change the Credits & Pixels timer:

IP lookup:

Ban/unban a user:

add/delete a badge

And this is how it normally looks:

I hope someone knows what causes this problem because not all pages say what the error is

 

[Joe]

I would recommend using this if you're not sure what you're doing.

You must be registered for see links

 

[Haid]

Thanks this worked! But now I get the same screen when I add an MOTD. I'll try to post a screenshot later today.
EDIT: ]I've made a list of pages that still not work:

Delete a news article (By ID):

Command logs:

Change welcome message:

Change the Credits & Pixels timer:

IP lookup:

Ban/unban a user:

add/delete a badge

And this is how it normally looks:

I hope someone knows what causes this problem because not all pages say what the error is

The issue is whatever HK you're using will have had SQL queries to add the tables it uses; the errors are shown at the bottom, you're missing tables. You should probably do as JMG suggested and grab one that doesn't use it's own tables as it's unlikely you're going to manage adding them all from scratch.

 

[Sam_Otten]

I would recommend using this if you're not sure what you're doing.

You must be registered for see links

I installed it by backupping my old HK and replacing it with the new one (if that's the correct way). It works, but it still doesn't work on some pages.
It says this on some pages:
Table 'habbo.housekeeping_perms' doesn't exist
Table 'habbo.tmod' doesn't exist

And on the staff list page the php and css don't work.

 

[Altercationz]

I'll post the perms and applications table when I get home, everything is working for me as I'm using that exact same housekeeping on my hotel.

 

[Sam_Otten]

I'll post the perms and applications table when I get home, everything is working for me as I'm using that exact same housekeeping on my hotel.

Can you post them when you have the time?