wCMS Problems

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

Set the column id in the users table to auto_increment.

Quote:

---

Originally Posted by HillBilly

Set the column id in the users table to auto_increment.

---

It is on auto_increment.

Bump.

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

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.

Quote:

---

Originally Posted by 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.

---

So how would I resolve this?

If anyone could help me?

Quote:

---

-- ----------------------------
-- 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.

Quote:

---

Originally Posted by iRetro™

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