Major CRASH!

[babjusi]

This can be marked as solved. joelgomez contacted me at the smf site and I took care of the error. Now all is well

[joelgomez]

Thank you very much babjusi for your help!!!

[babjusi]

No problem, you are welcome joel

[G6Cad]

And it would be nice of you to fill all of us in about what the error was to 

[babjusi]

And it would be nice of you to fill all of us in about what the error was to 

Sure thing G6

Joel tried to run the repair tables operation at the phpmyadmin as per the advice that he was given here but that it didn''t work. When I checked out the database I saw something very strange that puzzeled me. The smf version at the smf_settings table showed as being at 1.0.7. I asked him how he performed the upgrade and according to what he told me it was done right, the files overwritten and then running the upgrader.

Anyway, I re-did the upgrade procedure once again from the begin and during the running of the upgrader I got some error messages like that mysql bug with the smileys error, some db tables being corrupted like the smf_seesion table and a couple of others, which I dropped and recreated again, after making a full backup first of course. That solved the issue. I ran the upgrader once more and this time it worked as it should. 

That was it more or less G6

[G6Cad]

Then more or less he skipped the upgrade step from the old 1.0.7 to the RC version of SMF and then to the Final version.
Thats what gave the errors. The upgrade needed to go through 3 steps with the DB and not just 2 

Anyway, thank you for taking the time and post up what you did.

[babjusi]

Yes, but I believe you can upgrade directly from a version of the 1.0 series to a version of the 1.1 series, or the 2.0 series for that matter without first upgrading to the RC versions . Anyway, what I found strange though, it was that inspite of him runing the upgrader with success the first time, the database didn''t get upgraded at all but it remained the same. I have never come across something like that. The upgrader is supposed to upgrade the db, I mean that is its role, right?

And you are welcome