Upgrade result : Undefined index: ID_MEMBER

[ducktape.go]

Hi there,
We just upgraded SMF from version RC 2.0 to version 1.1.12 and we are totally lock out of the forum area.

All we get is the following error message :

          8: Undefined index: ID_MEMBER
          Fichier: /home/acuq911/public_html/forum/Sources/Security.php
          Ligne: 215

Is it possible to correct this situation or should we revert to our backup?

If we need to revert to our backup, what is the procedure to follow (we are using Fantastico for installation and upgrade)

Regards,

Ducktape

[Kays]

Hi, it sounds like the files didn't get properly updated. ID_MEMBER is used in 1.x.

Download the large upgrade package from here. Using an FTP client upload all of the files from it to your forums replacing all the files which are there now.

[busterone]

Could you verify what you posted in your statement? Was it a typo, or is that what you actually attempted to do,  from RC2 to 1.1.12?
or 1.1.12 to RC2 ?

Hi there,
We just upgraded SMF from version RC 2.0 to version 1.1.12 and we are totally lock out of the forum area.

You can not go backwards from 2.0 series to 1.1.x series using Fantastico if that is what you attempted to do.

[ducktape.go]

Thank you for your reply,

For busterone, we when from RC 2.0 and updated to 1.1.12

For Kays, If I upload the files, will this procedure keep all message that where in the forum intact ?

Appreciate your help,

Ducktape

[busterone]

That is not an upgrade, but what you have is a botched downgrade attempt that will never work using the standard upgrade procedures or using Fantastico.   Do you have a backup of your forum and database from before you attempted the upgrade? If so, you can overwrite your messed up forum files with the backup files, and reinstate your original db backup to bring your forum back.

[ducktape.go]

Hi busterone,

I did a backup via Fantastico.

Is this still usable?

Ducktape

[busterone]

It should be, if it did a complete backup. I do not use Fantastico at all, so I cannot speak for the quality of backups it makes.  I would try it.

[ducktape.go]

Hi busterone,

What if I did a backup of the MySQL database and re-install it after a full new install, would this be an option?

Ducktape

[busterone]

There are crucial differences in the database between the 1.1.x series and 2.0.  The upgrade attempt probably botched your original 2.0 database. It can be manually repaired, but it will take knowing what the differences are and how to correct them manually. If you have a database backup from before the update attempt, it would be much easier.

[ducktape.go]

Hi busterone,

I will check if we have a older backup available (if I am not mistaken we do) and I will get back to you tomorrow.

If we do have a older backup, what whould be the best procedure to
a. re-install SMF properly and
b. re-install the backup ?

Appreciate your help,

Ducktape

[Kays]

Sorry I misread you original request. But that is not an upgrade and it confused me.

What version SMF were you using before?

If your database is still intact, You should be alright just re-uploading the files. Check that first. If the database is not intact, you will need to restore it then.

Restoring a Database

After you get your forum back and running, then look at upgrading it to 2.0 RC4. Which is basically what I stated in the first post and then running upgrade.php. Do uninstall any mods first. And create a fresh backup just in case.

Upgrading SMF

[ducktape.go]

Hi Kays,

If my memory serve me right, the original version that was replaced was version 1.1.5 (I have been told that this originally was version RC 2.0)

I hope that this clarify the confusion.

Please advise if I should change your fix-up procedure.

Regards,

Ducktape

[Kays]

By the error I'm suspecting that the database has been updated to some version of 2.0.

Is the database still intact? Using phpMyAdmin, look at the members table as well as the messages table. Are they still populated or empty?

If they are still populated, Just try restoring the files from your backup first.

[busterone]

I apologize, now I am confused here.    It was my understanding from reading the above posts that the OP had SMF 2.0 RC2 as a working forum, and attempted an "update" through Fantastico to SMF 1.1.12, which of course will not work, and most likely render the database unusable as it is, without some manual repairs to the database.

Sorry ducktape if I misunderstood you as well.   

[ducktape.go]

Hi Kays,

I just check the MySQL database (I exported it in Excel format) and yes it is full of data.

I will try to update the files (as per busterone suggestion with the «Large upgrade» file in the download area)

I will check back in a couple of hours and if there is no additional advice for me I will procede with the changes and I will let you know the result ASAP.

Regards,

Ducktape

[Kays]

If you do use the large upgrade package, you should also run upgrade.php to complete the upgrade. Do a proper backup of the database to a .sql file first.

@ busterone

Actually, you were correct. Fortunately, it looks like the database is intact so this looks like it's changed to an upgrade to 2.0 RC4 instead now.

[ducktape.go]

OK here is the promise update,

I have uploaded and replace the files in the forum folder with a new set of files by FTP.

All data was intact but the « CAPTCHA » function that permit a granted access to a new user is not functionning.

I suspect that this feature is a plugin and need to be re-install.

Please advise.

Regards,

Ducktape

[busterone]

Go to Admin - Configuration - Security and moderation-  Anti-Spam

Post count under which users must pass verification to make a post
(0 for no limit, moderators are exempt)

input the number of posts you want as the limit in the right hand box

[ducktape.go]

Hi busterone,

I will try your recommendation tomorrow and I will get back to you on this.

Appreciate your help.

Regards,

Ducktape

[JimM]

Is the registration captcha what is not working?  If you had a mod installed that enhanced this function, you will need to reinstall that mod as well as any others that you might have installed.