14.09.2014, 19:31
wersja skryptu MyBB: 1.8.
adres forum: http://frag-project.pl
na czym polega problem (screen, opis, komunikaty):
Podczas upgrade silnika z 1.6 do 1.8 wystąpił błąd logownia do ACP
Forum wygląda normalnie po zaimportowaniu bazy, a do acp nie mam dostępu. Proszę o pomoc.
config.php
adres forum: http://frag-project.pl
na czym polega problem (screen, opis, komunikaty):
Podczas upgrade silnika z 1.6 do 1.8 wystąpił błąd logownia do ACP
Forum wygląda normalnie po zaimportowaniu bazy, a do acp nie mam dostępu. Proszę o pomoc.
Kod:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Nieznana kolumna 'useragent' w field list
Query:
INSERT INTO mybb_adminsessions (`sid`,`uid`,`loginkey`,`ip`,`dateline`,`lastactive`,`data`,`useragent`) VALUES ('8cbecb569417679dd03b128e8a12965a','1','XQ3xjzNIBHUFElLaZTKgonp29lwqt2EEoFc8cklRxLkABI14BW',X'53178c5c','1410719090','1410719090','a:0:{}','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.120 Safari/537.')
Please contact the MyBB Group for technical support.config.php
Kod:
<?php
/**
* Database configuration
*
* Please see the MyBB Docs for advanced
* database configuration for larger installations
* http://docs.mybb.com/
*/
$config['database']['type'] = 'mysql';
$config['database']['database'] = 'forum';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'user';
$config['database']['password'] = '********';
/**
* 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, xcache, or eAccelerator
* you can change the value below to 'files', 'memcache', 'xcache' or 'eaccelerator' from 'db'.
*/
$config['cache_store'] = 'db';
/**
* Memcache configuration
* If you are using memcache as your data-cache,
* you need to configure the hostname and port
* of your memcache server below.
*
* If not using memcache, ignore this section.
*/
$config['memcache']['host'] = 'localhost';
$config['memcache']['port'] = 11211;
/**
* 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['database']['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
);
$config['pluginuploader_ftp_key'] = 'CHOOSE A PLUGIN UPLOAD CODE';
/**
* Admin CP Secret PIN
* If you wish to request a PIN
* when someone tries to login
* on your Admin CP, enter it below.
*/
$config['secret_pin'] = '1234';
?>