wCMS Problems

[Trillx]

Hello,

I am having problems with Wabbo CMS. I like the design of the old wCMS so yes, I am using the one that has been released. Now onto my problem, when ever I register it gives me this error Duplicate entry '2' for key 'PRIMARY'. The '2' is changed to the user id that is registering, does anyone have a fix for this?


Now my second question is, does anyone know where to change the security questions when registering as shown here a3f8f33a765a87493fef28419dc3f49c.png. If so please tell me!


Thanks, Trillx

[MentaL]

[The General]

Set the column id in the users table to auto_increment.

[Trillx]

Set the column id in the users table to auto_increment.

It is on auto_increment.

[Trillx]

Bump.

[Bxthy]

Is there perhaps a error in the edit?.. if its not working i personally would choose a new CMS <3

[iRetro™]

Maybe its because the auto_increment already has a value for example if you using a old database and deleted all user rows the auto_increment will still have the value.

[Trillx]

Maybe its because the auto_increment already has a value for example if you using a old database and deleted all user rows the auto_increment will still have the value.

So how would I resolve this?

[Trillx]

If anyone could help me?

[iRetro™]

-- ----------------------------
-- 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 'defaultuser@meth0d.org',
`auth_ticket` text NOT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`credits` int(11) NOT NULL DEFAULT '50000',
`vip_points` int(11) NOT NULL DEFAULT '10',
`activity_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_last` varchar(120) NOT NULL,
`ip_reg` varchar(120) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '0',
`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',
`volume` int(3) NOT NULL DEFAULT '100',
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

P.S this user table is from UberCMS. I'm not to sure it'll work, but worth a try.

Run that query, it'll delete all accounts but to be honest I'm not 100% sure this will be the fix.

[Trillx]

P.S this user table is from UberCMS. I'm not to sure it'll work, but worth a try.

Run that query, it'll delete all accounts but to be honest I'm not 100% sure this will be the fix.

It didn't fix it, but thanks anyway