Błąd 1054 - Nieznana kolumna 'useragent' w field list po aktualizacji

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.

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

<?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';
?>

Snake_ napisał 14.09.2014, 20:15:
Poprawiam tytuł.

http://community.mybb.com/thread-158841.html

$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'] = 'CHOOSE A PINCODE';
?>

'CHOOSE A PLUGIN UPLOAD CODE' - co ma byc tu ?

Hmm.. ja u siebie tego nie mam, może jest to od plugin uploader? (plugin) - masz go?

nie mam, ale nawt go nie zainstaluje bo nie mam dostepu do acp.

Dodaj do tabeli mybb_adminsessions kolumnę useragent w phpmyadminie. Jeśli będzie płakać o następne, to też je dodaj. Ja miałem ten problem przy którejśtam kiedyś aktualizacji i ten sposób wystarczył.

Dałem sobie radę już, wszystko śmiga jak trzeba ; ) Do zamknięcia

Snake_ napisał 14.09.2014, 21:33:


Nie pisz zbędnych postów
Nie zamykamy wątków.