[Fix] Registration Error

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

The best laid plans of mice and men ....

The USERS_TEMP table is missing a column that affects registration. You can fix the error in one of two ways.

If you are comfortable using phpMyAdmin then use the SQL tab in phpMyAdmin and execute the following statement replacing ????? with your $user_prefix setting in config.php. In most cases the value is nuke.

ALTER TABLE `?????_users_temp` ADD `requestor` VARCHAR( 25 ) NOT NULL;

If you prefer to have this done automatically then download Fix Users Temp

The original release files are in the process of being corrected, but until that is done you will need to use the directions in this post.

Thanks to Wolfseye for reporting this at [ Only registered users can see links on this board! Get registered or login! ]

Posted: Thu Feb 14, 2008 6:58 pm

I must have dl'ed it after it was fixed...

Quote:

MySQL said: Documentation
#1060 - Duplicate column name 'requestor'

.. identical to my RN2.10 install.

Posted: Fri Feb 15, 2008 6:53 am

Ezekiel, if you simply upgraded, it would not have been a problem. This was only an issue for new installs.

Posted: Sun Feb 17, 2008 2:03 am

I now know the full story on this issue. Only upgrades are/were affected by the original posting issue at [ Only registered users can see links on this board! Get registered or login! ] As Paul Harvey would say , 'and now, the rest of the story'.

The INSTALLER is designed for New Installs, not updates. So, the installer installs the Core tables first and the Resend Email table second. It's not really a table but an ALTER instruction to the USERS_TEMP table; it adds the REQUESTOR field.

However, If a person is doing an upgrade (regardless as to how he is upgrading), the current USERS_TEMP table may or may not have been altered. In the original post the USERS_TEMP table did not contain the field so it was erring out and the initial response to me was that the sql code was in error and we needed to fix it and repackage it. This was not exactly the case or better yet, it wasn't the complete fix.

What is now happening is that new installs are receiving an error on step 2 of the installation process when they try to load the Resend Email Table because the Core file load (step 1) already has added the REQUESTOR field!

The bottom line is that in the maintenance release do out in a couple weeks this will all be cleared up. For now, if you are doing a fresh install, please skip Step 2 - Load Resend Email Table as it is included in Step 1 - Load Core Tables. Nothing is harmed if you select it but you will receive a MySQL error. If you do, just skip it and go to Step 3.

Sorry for all the confusion around this Wink

!

Client Joined: Aug 14, 2005 Posts: 151

not true to my issue. I have the requestor field already and I am getting the registration error Sad

but my issue is on the final step of the registration process. enter the code and click submit to have the activation email sent and all i get is Registration Error on the page that comes up...

Posted: Thu Aug 14, 2008 5:37 am

manoe, isn't there another thread by you where we are discussing your specific issue? If so, let us continue there as I swear this sounds familiar and that it is a mail issue.