[Fix] MySQL Duplicate Column Error On Fresh Install

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

See http://www.ravenphpscripts.com/postt15086.html and http://www.ravenphpscripts.com/postt15094.html for background on this issue.

I now know the full story on this issue. Only upgrades are/were affected by the original posting issue at http://www.ravenphpscripts.com/postt15086.html. 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 due 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

!