Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2008, 06:13 PM
sbarbz sbarbz is offline
 
Join Date: Oct 2007
Location: israel
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 3.8 To 3.7.4 (Downgrade)

hello

Downgrade 3.8 to 3.7.4 ..
possible ??
Reply With Quote
  #2  
Old 12-21-2008, 06:18 PM
vB Tree vB Tree is offline
 
Join Date: Dec 2008
Location: England
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry, can't be done. The database changes when you upgrade.
Reply With Quote
  #3  
Old 12-21-2008, 06:23 PM
sbarbz sbarbz is offline
 
Join Date: Oct 2007
Location: israel
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so... is not be dwongrade the database ?

and here yes to give me support in 3.8 ?
in vB.org ....
Reply With Quote
  #4  
Old 12-21-2008, 06:27 PM
vB Tree vB Tree is offline
 
Join Date: Dec 2008
Location: England
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #5  
Old 12-21-2008, 06:30 PM
sbarbz sbarbz is offline
 
Join Date: Oct 2007
Location: israel
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
.displayorderprefix.displayorder;

MySQL Error   Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  1267
Request Date  
SundayDecember 21st 2008 10:30:38 PM
Error Date    
SundayDecember 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 
Reply With Quote
  #6  
Old 12-21-2008, 06:34 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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'.
Reply With Quote
  #7  
Old 12-21-2008, 06:40 PM
sbarbz sbarbz is offline
 
Join Date: Oct 2007
Location: israel
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

is not to me backup
Reply With Quote
  #8  
Old 12-21-2008, 06:43 PM
alghat alghat is offline
 
Join Date: Dec 2005
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="http://www.vbulletin.com/forum/showthread.php?t=195137" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=195137</a>
Reply With Quote
  #9  
Old 12-21-2008, 08:26 PM
sbarbz sbarbz is offline
 
Join Date: Oct 2007
Location: israel
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #10  
Old 12-21-2008, 08:37 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:19 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04249 seconds
  • Memory Usage 2,242KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete