vb.org Archive - 3.8 To 3.7.4 (Downgrade)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - 3.8 To 3.7.4 (Downgrade) (https://vborg.vbsupport.ru/showthread.php?t=199448)

sbarbz

12-21-2008 06:13 PM

3.8 To 3.7.4 (Downgrade)

hello

Downgrade 3.8 to 3.7.4 ..
possible ??

vB Tree

12-21-2008 06:18 PM

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

sbarbz

12-21-2008 06:23 PM

so... is not be dwongrade the database ?:(

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

vB Tree

12-21-2008 06:27 PM

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

12-21-2008 06:30 PM

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

12-21-2008 06:34 PM

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

12-21-2008 06:40 PM

is not to me backup

alghat

12-21-2008 06:43 PM

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

sbarbz

12-21-2008 08:26 PM

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

12-21-2008 08:37 PM

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

12-22-2008 10:26 AM

Quote:

Originally Posted by Lynne (Post 1690596)

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

12-22-2008 10:36 AM

I suggest opening a support ticket to resolve this issue.

All times are GMT. The time now is 10:52 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01080 seconds Memory Usage 1,742KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (12)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: