[Fix] Registration Error

Raven · Posted: Thu Feb 14, 2008 10:30 am

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

Only registered users can see links on this board!
Get registered or login to the forums!

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 to the forums!

Doulos · Involved Joined: Jun 06, 2005 Posts: 309

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.

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

Raven · 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 to the forums!

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

!