vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Forum unusable. Where to use SET NAMES? Or do you have any other suggestions? (https://vborg.vbsupport.ru/showthread.php?t=198099)

DR_GIGGULS 12-05-2008 09:06 PM
Forum unusable. Where to use SET NAMES? Or do you have any other suggestions?
 
Hello

I would like vbulletin to fetch my databases using SET NAMES utf8
YES, I DO know about the config.php option, but I need it to be done elsewhere and to be hard-coded.

Where should I put this line? I can't find the mysql connect function...

I'll post my problem anyway.
Using the default option in the config.php:
Code:
$config['Mysqli']['charset'] = 'utf8';
I get the following error (and the forum says I'm banned when there are no bans at all):

Code:
Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/includes/functions.php on line 4107

Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 4107
When I comment out the $config['Mysqli']['charset'] = 'utf8'; line, I get no errors, but the forum is unreadable.


So I figured trying to hard-code it might help.

Any suggestions?

ringleader 12-07-2008 12:26 PM
There's a few things around this issue that I've seen.
Googling, and cut and paste, gives:

Code:
You need php 4.4+ and apache 2.0.x to properly support vBulletin in utf8 format
Code:
    * Perform this query with a MySQL client like phpMyAdmin.

      ALTER DATABASE `db_name` CHARACTER SET utf8;

      Where db_name is the name of the database.
    * The collation will be set to the default: utf8_general_ci
    * Open your config.php and find:

      // $config['Mysqli']['charset'] = 'utf8';

    * Make sure it looks like this:

      $config['Mysqli']['charset'] = 'utf8';

    * Save config.php and upload it.
    * Start installing your vBulletin as usual, and don?t forget to update your languages HTML charset via ACP.

Final note: MySQL versions prior to 4.1 don?t support charsets and collations.
Code:
Converter for 3.6.4+
https://vborg.vbsupport.ru/showthread.php?t=141591

Description: This script converts the database of vBulletin forums (from and to) any of the charsets that are supported by iconv. also it has the ability to convert the tables of hacks that you had installed.

vbulletin emails are sent with utf-8 encoding.
This hack made for  3.6.4 might fix this:
https://vborg.vbsupport.ru/showthread.php?t=144040
Hope that helps :)

DR_GIGGULS 12-08-2008 12:17 AM
Quote:
Originally Posted by ringleader (Post 1680201)
Code:
Converter for 3.6.4+
https://vborg.vbsupport.ru/showthread.php?t=141591
Hope that helps :)
Please send me your paypal. I want to buy you a beer.
Thanks a lot, you are an ass-saver :)


All times are GMT. The time now is 02:42 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02317 seconds
  • Memory Usage 1,719KB
  • 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
  • (6)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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