Need help with RevCMS!

[Harri]

When I try to register this happens...​

​

Help me please? :]​

 

[Alam]

Go to Navicat or phpmyadmin, then create a column called 'seckey' in the users table. Make it null and make the length any number.

 

[Lotus]

reccommend 99 for length ^.^​

 

[Harri]

I'm new to this, how do I create a new column?

Sorry, if I'm annoying you..

 

[Alam]

What are you using to manage your database? i.g PhpMyAdmin, Navicat..

 

[Harri]

PhpMyAdmin

 

[Lotus]

if your using Navicat in your db go to Queries then add query then copy this

this in if you don't want to fuck up your db
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT '[email protected]',
`auth_ticket` text NOT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`vip_points` int(11) NOT NULL DEFAULT '0',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`look` varchar(255) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) NOT NULL,
`account_created` varchar(50) NOT NULL,
`last_online` varchar(50) NOT NULL,
`online` enum('0','1') NOT NULL DEFAULT '0',
`ip_reg` varchar(120) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '277',
`respect` int(11) NOT NULL DEFAULT '0',
`daily_respect_points` int(11) NOT NULL DEFAULT '3',
`daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
`hide_online` enum('0','1') NOT NULL DEFAULT '0',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
`mail_verified` varchar(6) NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`seckey` varchar(999) NOT NULL,
`ip_last` varchar(120) NOT NULL,
`volume` int(3) NOT NULL DEFAULT '100',
`vip_time` varchar(999) NOT NULL DEFAULT '0',
`credits` int(11) NOT NULL DEFAULT '2000',
`activity_points` int(11) NOT NULL DEFAULT '50',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=67085 DEFAULT CHARSET=latin1;

and paste there it should work

 

[Sean]

Just add this to query

ALTER TABLE `users` ADD `seckey` VARCHAR(999)

 

[Harri]

Thanks, I put that in and it let me register