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


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.

[Yellow Slider]

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.

so how should he know which table he needs to change? it seems that after the upgrade most of his DB had converted to different collations, what do he need to do in order to fix his forum?

[Marco van Herwaarden]

I suggest opening a support ticket to resolve this issue.