News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

1.1.x > 2.0.2 upgrade problems

Started by SnowmanDK, June 12, 2012, 06:59:29 AM

Previous topic - Next topic

SnowmanDK

Restored backup yet again...

This time I extracted the 2.0.2 upgrade package into the forum.

Edited the two files suggested and ran the upgrade.php.

Now this error comes up:
ORDER BY ignored as there is a user-defined clustered index in the table 'tss_boards'

I wonder if these lines should be removed to resolve that error?:
ALTER TABLE {$db_prefix}categories
ORDER BY catOrder;

emanuele

Do you have some " (double quotes) or ; (semi-colon) or ' (single quote) in the database password or in the database user name?


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

Password have a punctuation mark. that's it.
I'll try and remove it and return with result.

SnowmanDK

That didn't change anything. Same error.
I'm gonna try something else and return.

SnowmanDK

Was hoping I had a glitch in my admin software, but didn't.
BOTH phpMyAdmin AND HeidiSQL agree that the user have FULL rights to the database.

SnowmanDK

Update: I even tried making a new account with full privileges. Same sad result as before.

kat

I'm not ignoring you, Snowy, honest!

It's just that, as I said, I'm not familiar with the self-hosting thing. :(

emanuele

I'd suggest you to convert the boards table to MyISAM at that point...


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

That's ok K@. People have lives I know  8)

Now... I converted boards as suggested emanuele, and got ONE step further.
But there still seem to be "something rotten in the state of Denmark"  :o (I live there)  ;)

Upgrading...
Updating Settings.php... Successful.
Backing up old table data...
   Backing up "tss_attachments"... Unsuccessful!
This query:
CREATE TABLE backup_tss_attachments (

PRIMARY KEY (`ID_ATTACH`),

UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`ID_ATTACH`),

KEY `ID_MSG` (`ID_MSG`))

TYPE=InnoDB

SELECT *

FROM tss_attachments;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB

SELECT *

FROM tss_attachments' at line 5


I also noticed when converting that all tables are encoded as "latin1_swedish_ci".
Not sure if it will have any effect, but gonna do another restore and convert all tables to "utf8_general_ci" and MyISAM just to test... Will return with result...

SnowmanDK

Ahhh... NOW we are getting somewhere  8)
As said earlier, fresh from backup, and add 2.0.2 upgrade, AND converted all tables to "utf8_general_ci" and MyISAM.

Ran upgrade.php from forum homepage:
+Database backup completed without errors...

Next:
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 2.
Executing: "Updating and creating indexes..." (1 of 19 - of this script)

Updating indexes on "messages"...done


and then:

!!Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again


I retried this a few times with the same result.
I even tried waiting for 20 minutes just to see, but again in vain.

emanuele



Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

Not that many... 1155 messages according to the database.

emanuele

(sorry for the late reply)

mmm...can you try disabling javascript in your browser?


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

I am affraid the last attempt messed up my database.
I disabled javascript as you suggested, but now I just get this message:
Duplicate key name 'IP'
If it's any help then it comes with this message at this point:
<my server address>/forum/upgrade.php?step=1&substep=0&data=YTo2OntzOjc6ImN1cnN0ZXAiO2k6MTtzOjQ6ImxhbmciO3M6MTI6ImVuZ2xpc2gtdXRmOCI7czozOiJyaWQiO2k6MTA0MTtzOjQ6InBhc3MiO2k6MTE4MztzOjU6ImRlYnVnIjtpOjA7czoyOiJqcyI7aTowO30=
Also, when I wanted to restore from the database backup, then I couldn't find it.
It DID say that the backup of all tables finished with no errors.
Where are they saved?

emanuele

Quote from: SnowmanDK on July 20, 2012, 03:44:23 AM
I am affraid the last attempt messed up my database.
I disabled javascript as you suggested, but now I just get this message:
Duplicate key name 'IP'
Okay, that's not a big problem.
Are you familiar with phpmyadmin?
If so, enter into it and find the table smf_log_errors (the prefix "smf" could be different), go to "structure" (top menu), at the bottom you'll see a table named "indexes" (it could be collapsed), under "keyname" you should find an entry called "ip", simply remove it, it will be regenerated next time (and if not I'll tell you how to do that at the end of the upgrade).

Quote from: SnowmanDK on July 20, 2012, 03:44:23 AM
Also, when I wanted to restore from the database backup, then I couldn't find it.
It DID say that the backup of all tables finished with no errors.
Where are they saved?
Who is "It"?
Usually the backups are files saved on your computer.


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

Well the backup I talked about was the one made at the beginning of the upgrade, but I found it  ;)
I thought it made a new database, but I see it just made tables in the existing one :)

Removing the "ip" entry worked like a charm :)

Now this happens:
Updating indexes on "messages"...done
Updating table indexes......done
Reordering boards and categories...done
Updating indexes and data on "smileys"...done
Updating indexes on "log_boards"...done
Updating indexes on "log_mark_read"...done

and then it does a timeout again:
!!Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again


I am ever greatful for your help so far, expecially as I see progress *thumbs up*
An idea for the next step? :)

emanuele

If you are comfortable with phpmyadmin I'd suggest you to manually update the indexes and drop that part from the upgrade_1-1.sql.

If this is acceptable to you, I'll give you a more detailed answer (I know this is just a workaround... :()


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

Well, I have actually never used phpmyadmin before you mentioned it  ::)
So far I have always used the program HeidiSQL which have been working fine for me so far.

But I am a spare time .net programmer and have worked quite a lot with databases, so I'll have a go at it  :)

Hit me  ;)

emanuele

Ohh...I suggested phpmyadmin because is one that is usually available, but if you have other tools you are more comfortable with feel free to use them! ;D


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

SnowmanDK

oh ok :)
I'll try with the tool I know ;)

Advertisement: