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.
Just install MySQL 5.0
There is an option to install MySQL5.0 in the 1and1 administration panel.
(2008-10-26, 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.
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
(2008-10-25, 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
(2008-11-09, 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:
$db->error_reporting = 0;
Replace 0 with 1 and rerun installer.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1193 - Unknown system variable 'NAMES'
Query:
SET NAMES 'utf8'
blub
In your inc/config.php find
$config['database']['encoding'] = 'utf8';
and replace it with
// $config['database']['encoding'] = 'utf8';
Alternatively, ask your host to upgrade you to MySQL 5.1
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
It's empty because it hasn't been installed I guess. Put this code in:
<?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.