vb.org Archive - 3.8 To 3.7.4 (Downgrade)

Page 1 of 2

Show 40 post(s) from this thread on one page

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.

All times are GMT. The time now is 05:49 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00981 seconds Memory Usage 1,735KB 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)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: