The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
Change Multiple DB Tables from UTF8 To Latin1
I keep getting this error and I know what it is, It just takes a long time to do this so im wondering can you do it all at once
Code:
Database error in vBulletin 4.1.10: Invalid SQL: SELECT block.*, blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle, blocktype.description as blocktypedescription, blocktype.allowcache, product.active as productacitve FROM block AS block LEFT JOIN blocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid) LEFT JOIN product AS product ON (blocktype.productid = product.productid) WHERE block.blockid = 1; MySQL Error : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' Error Number : 1267 Request Date : Thursday, February 23rd 2012 @ 07:31:46 AM Error Date : Thursday, February 23rd 2012 @ 07:31:47 AM Script : http://xxx.com/forums/admincp/plugin.php?do=productkill Referrer : http://xxx.com/forums/admincp/plugin.php?do=productdelete&productid= IP Address : xxx.xxx.xxx.xxx.xxx Username : Gav Classname : vB_Database MySQL Version : 5.1.56 Basically What I want to do is find a query that will change all of these at once from utf8_unicode_ci To latin1_swedish_ci Code:
`ad`, `adcriteria`, `advapp_applications`, `advapp_positions`, `advapp_questions`, `apiclient`, `apilog`, `apipost`, `attachment`, `autosave`, `bbcode_video`, `block`, `blockconfig`, `blocktype`, `customprofile`, `dbquery`, `glowhostspamomatic_log`, `glowhostspamomatic_remotecache`, `glowhostspamomatic_stats`, `infernoshout`, `infernoshoutlog`, `infernoshoutsessions`, `infernoshoutusers`, `skimlinks`, `tsx_server`, `vbplaza_category`, `vbplaza_deletionlog`, `vbplaza_gift_item`, `vbplaza_gift_user`, `vbplaza_item`, `vbplaza_item_history`, `vbplaza_lottery`, `vbplaza_lottery_history`, `vbplaza_lottery_ticket`, `vbplaza_lottery_winner`, `vbplaza_name_change`, `vbplaza_purchase_item`, `vbplaza_purchase_user`, `vbplaza_ribbon_item`, `vbplaza_ribbon_user`, `vbplaza_thread_purchase`, `vbplaza_track_item`, `vbplaza_track_user`, `vbplaza_user_history`, `vbplaza_user_inventory`, `vsa_ppdonate` Code:
REPAIR TABLE `ad`, `adcriteria`, `advapp_applications`, `advapp_positions`, `advapp_questions`, `apiclient`, `apilog`, `apipost`, `attachment`, `autosave`, `bbcode_video`, `block`, `blockconfig`, `blocktype`, `customprofile`, `dbquery`, `glowhostspamomatic_log`, `glowhostspamomatic_remotecache`, `glowhostspamomatic_stats`, `infernoshout`, `infernoshoutlog`, `infernoshoutsessions`, `infernoshoutusers`, `skimlinks`, `tsx_server`, `vbplaza_category`, `vbplaza_deletionlog`, `vbplaza_gift_item`, `vbplaza_gift_user`, `vbplaza_item`, `vbplaza_item_history`, `vbplaza_lottery`, `vbplaza_lottery_history`, `vbplaza_lottery_ticket`, `vbplaza_lottery_winner`, `vbplaza_name_change`, `vbplaza_purchase_item`, `vbplaza_purchase_user`, `vbplaza_ribbon_item`, `vbplaza_ribbon_user`, `vbplaza_thread_purchase`, `vbplaza_track_item`, `vbplaza_track_user`, `vbplaza_user_history`, `vbplaza_user_inventory`, `vsa_ppdonate` --------------- Added [DATE]1330007964[/DATE] at [TIME]1330007964[/TIME] --------------- Figured this out myself if you would like to delete it |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|