Enter database info, then blank page

[labrocca]

Can you tell us what version of mysql you are using?

perfora.net Was it you that I helped or someone else with that host? They are using mysql 4.0 which is currently having bug being fixed for next release. Search bug reports for a solution.

[eXecute]

Just install MySQL 5.0
There is an option to install MySQL5.0 in the 1and1 administration panel.

[pabut]

(10-26-2008 12:17 AM)eXecute Wrote:  Just install MySQL 5.0
There is an option to install MySQL5.0 in the 1and1 administration panel.

YUP 100% .... if you're on 1&1 change the MySQL database type to 5 .... worked for me.

[Teno]

i still have the same problem.
my database is hosted by all-inkl

MySQL client version: 5.0.27
PHP >= 4.4

i love this forum, plz help me

[Teno]

.

[Dennis Tsang]

(10-25-2008 11:39 PM)labrocca Wrote:  Can you tell us what version of mysql you are using?

perfora.net Was it you that I helped or someone else with that host? They are using mysql 4.0 which is currently having bug being fixed for next release. Search bug reports for a solution.

The 1&1 host uses perfora.net database hostname. Lots of people are on 1&1

(11-09-2008 07:36 PM)Teno Wrote:  i still have the same problem.
my database is hosted by all-inkl

MySQL client version: 5.0.27
PHP >= 4.4

i love this forum, plz help me

In install/index.php, find:

PHP Code:

$db->error_reporting = 0; 


Replace 0 with 1 and rerun installer.

[Teno]

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1193 - Unknown system variable 'NAMES'
Query:
SET NAMES 'utf8'


blub

[Ryan Gordon]

In your inc/config.php find

PHP Code:

$config['database']['encoding'] = 'utf8'; 


and replace it with

PHP Code:

// $config['database']['encoding'] = 'utf8'; 


Alternatively, ask your host to upgrade you to MySQL 5.1

[Teno]

my config.php is empty
i only found the following one in the install/index.php

$db_encoding = "// \$config['database']['encoding'] = '{$config['encoding']}';";

but it doesn't work.


ps: MySQL client version: 5.0.27

[MattRogowski]

It's empty because it hasn't been installed I guess. Put this code in:

PHP Code:

<?php
/**
 * Database configuration
 *
 * Please see the MyBB Wiki for advanced
 * database configuration for larger installations
 * http://wiki.mybboard.net/
 */

$config['database']['type'] = 'mysql';
$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'mysql-username';
$config['database']['password'] = 'mysql-password';
$config['database']['database'] = 'database-name';
$config['database']['table_prefix'] = 'mybb_';

/**
 * Admin CP directory
 *  For security reasons, it is recommended you
 *  rename your Admin CP directory. You then need
 *  to adjust the value below to point to the
 *  new directory.
 */

$config['admin_dir'] = 'admin';

/**
 * Hide all Admin CP links
 *  If you wish to hide all Admin CP links
 *  on the front end of the board after
 *  renaming your Admin CP directory, set this
 *  to 1.
 */

$config['hide_admin_links'] = 0;

/**
 * Data-cache configuration
 *  The data cache is a temporary cache
 *  of the most commonly accessed data in MyBB.
 *  By default, the database is used to store this data.
 *
 *  If you wish to use the file system (cache/ directory), MemCache or eAccelerator
 *  you can change the value below to 'files', 'memcache' or 'eaccelerator' from 'db'.
 */

$config['cache_store'] = 'db';

/**
 * Super Administrators
 *  A comma separated list of user IDs who cannot
 *  be edited, deleted or banned in the Admin CP.
 *  The administrator permissions for these users
 *  cannot be altered either.
 */

$config['super_admins'] = '1';

/**
 * Database Encoding
 *  If you wish to set an encoding for MyBB uncomment 
 *  the line below (if it isn't already) and change
 *  the current value to the mysql charset:
 *  http://dev.mysql.com/doc/refman/5.1/en/charset-mysql.html
 */

$config['db_encoding'] = 'utf8';
 
/**
 * Automatic Log Pruning
 *  The MyBB task system can automatically prune
 *  various log files created by MyBB.
 *  To enable this functionality for the logs below, set the
 *  the number of days before each log should be pruned.
 *  If you set the value to 0, the logs will not be pruned.
 */

$config['log_pruning'] = array(
    'admin_logs' => 365, // Administrator logs
    'mod_logs' => 365, // Moderator logs
    'task_logs' => 30, // Scheduled task logs
    'mail_logs' => 180, // Mail error logs
    'user_mail_logs' => 180, // User mail logs
    'promotion_logs' => 180 // Promotion logs
);

?>

Edit database details as needed as well as the fix Ryan mentioned.