3.8 To 3.7.4 (Downgrade)

[sbarbz]

hello

Downgrade 3.8 to 3.7.4 ..
possible ??

[vB Tree]

Sorry, can't be done. The database changes when you upgrade.

[sbarbz]

so... is not be dwongrade the database ?

and here yes to give me support in 3.8 ?
in vB.org ....

[vB Tree]

I don't know of a way to downgrade the database, when you upgrade, vBulletin provide you with a script to make the changes. Without this, you would be making the changes by hand. Maybe you can downgrade manually but you would need a lot of experience in php/MySQL and a lot of time.

Why do you want to downgrade anyway?

[sbarbz]

I Upgrade To 3.8 And Sql Error IN NEW Thread

PHP Code:

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:

            SELECT prefix.*
            FROM forumprefixset AS forumprefixset
            INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
            INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
            WHERE forumprefixset.forumid = 2
            ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Sunday, December 21st 2008 @ 10:30:38 PM
Error Date    : Sunday, December 21st 2008 @ 10:30:38 PM
Script        : http://www.mastul.co.il/newthread.php?do=newthread&f=2
Referrer      : http://www.mastul.co.il/forumdisplay.php?f=2
IP Address    : 84.109.178.47
Username      : Bar
Classname     : vB_Database
MySQL Version : 5.0.51a-community-log 


[Lynne]

You should always backup your database prior to an upgrade. That way, the way to 'downgrade' is to restore the backup database. That is the only way to do a 'downgrade'.

[sbarbz]

is not to me backup

[alghat]

<a href="http://www.vbulletin.com/forum/showthread.php?t=195137" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=195137</a>

[sbarbz]

i have a 198 tabels ..
approximately 50% is latin1_swedish_ci and 50% more is latin1_general_ci .
which exactly(name), to change

Thank you very much for your post

[Lynne]

He says "this was only an example you have to figure which table you have to change its Collation". Although, it would be nice if the pictures were still there since I think those would help out.