Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

New member registration

Started by Karmalakas, January 12, 2005, 04:17:00 AM

Previous topic - Next topic


while trying to register i get this:

and this:
Notice: Duplicate entry '0' for key 1 in /***/***/***/includes/database.php on line 184

i've read alot of posts here and couldn't understand anything and almost all the posts are about login module :(

any suggestions? please
and could it be so that i can't access com_smf_registration config? it just takes me back to mambo backend homepage

P.S. How to make that while registering there were no agreement?


What version of Mambo?




i've downloaded the latest smf bridge version and now it works fine ;) exept login module (i can't login or logout through it) so i think i'll have to search for the solution in the forum:(


the same again when i enable the account activation in Mambo
if i disable it, then it shows "you can login now" or smth like that, but i want that users should confirm their e-mail addresses

and i noticed one more thing. When registering, it writes in mos_users an entry with ID "0" and when registering other member it again does the same thing and the second member isn't registered because of the duplicate entry ID "0"


Did you have the PhpBB component installed previously? 

The PhpBB component removes the activation row from Mambo's user table, among other things.


yep, i had phpbb component :(
so what should i do now?
i'm new to all this stuff so pls could you help me?
maybe it's possible to add it using phpmyadmin?


Orstio you are telepathic! This was one of my problems, that resulted in difficulties (the failed user registration due to phpBB component). Is it just the mos_users database that lacks the field "usertype" or do you have powers of the Oracle (the Greek kind) to know if other tables/field are affected? I have an invalid login (whom I can delete, but do not know which function to use)

When I removed the phpBB bridge modle from Mambo, people were properly registered SUBSEQUENT to the removal of the phpBB component/module.

Paul Earley


any ideas about duplicate entries ??? :(


First, make sure phpBB component has been uninstalled.  That should restore the activation row.

For the duplicate entries, you could delete them from the database, or give them their own unique ID, though either of these may have strange consequences.  Deleting probably would be safe, but I'm not sure if you used an ID, if it would work out correctly, or if it might try to use that ID again when it's its turn sequentially.


i've tried deleting all users and tried assigning other ID but it again and again registers new user with ID "0" :(


I don't know what kind of damage is done by installing and uninstalling the phpBB component.

Here are some things to check in PhpMyAdmin:

In your mos_users table, Field "id" should be set to auto increment.

In your mos_core_acl_aro table, Field "aro_id" shuold be set to auto increment

In your mos_core_acl_groups_aro_map table, Field "aro_id" should be set to auto increment.

The tricky part is that aro_id in both mos_core_acl_aro and mos_core_acl_groups_aro_map must be set to the same value, so that when they auto increment, they are always the same.  You may need to add some dummy rows to get them back in synch.


Hmmmm, aro_id seems to be autoincrement in mos_core_acl_aro, but does not appear to be autoincerment in mos_core_acl_groups_aro_map. I searched out the table definition from mambo, and it is:
# Table structure for table `mos_core_acl_groups_aro_map`
CREATE TABLE `mos_core_acl_groups_aro_map` (
  `group_id` int(11) NOT NULL default '0',
  `section_value` varchar(240) NOT NULL default '',
  `aro_id` int(11) NOT NULL default '0',
  UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)


Quote from: CRONUS on January 12, 2005, 04:17:00 AM
while trying to register i get this:

Notice: Duplicate entry '0' for key 1 in /***/***/***/includes/database.php on line 184

what to do ,I use mambo 4.5.1a and the latest mambo bridge 2.11 stable
Greetz Locatorr