Upgrade Problem

[schneeandi]

Hello,

after upgrade from 1.0.2 i get the following error after the login:

Thanks for the help

andi


ERROR: C:\web\dotproject\includes\db_adodb.php(61): Error executing: SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, user_department, contact_email as user_email, user_type FROM `users` LEFT JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = 'admin'
Backtrace:
0 C:\web\dotproject\includes\db_adodb.php:61 dprint('C:\\web\\dotproject\\includes\\db_adodb.ph p',61,0,'Error executing: SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, user_department, contact_email as user_email, user_type FROM `users` LEFT JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = \'admin\'')
1 C:\web\dotproject\includes\db_connect.php:96 db_exec('SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, user_department, contact_email as user_email, user_type FROM `users` LEFT JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = \'admin\'')
2 C:\web\dotproject\includes\db_connect.php:70 db_loadhash('SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, user_department, contact_email as user_email, user_type FROM `users` LEFT JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = \'admin\'',array (
))
3 C:\web\dotproject\classes\ui.class.php:681 db_loadobject('SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, user_department, contact_email as user_email, user_type FROM `users` LEFT JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = \'admin\'',class cappui {
var $state =
array (
);
var $user_id = -1;
var $user_first_name = '';
var $user_last_name = '';
var $user_company = 0;
var $user_department = 0;
var $user_email = NULL;
var $user_type = 0;
var $user_prefs =
array (
'LOCALE' => 'de',
'TABVIEW' => '0',
'SHDATEFORMAT' => '%d/%m/%Y',
'TIMEFORMAT' => '%I:%M %p',
'UISTYLE' => 'default',
'CURRENCYFORM' => 'es_ES',
);
var $day_selected = NULL;
var $user_locale = NULL;
var $base_locale = 'en';
var $msg = '';
var $msgNo = '';
var $defaultRedirect = '';
var $cfg =
array (
'locale_warn' => false,
);
var $version_major = NULL;
var $version_minor = NULL;
var $version_patch = NULL;
var $version_string = NULL;
var $last_insert_id = NULL;
var $project_id = 0;
var $user_lang =
array (
0 => '.utf-8',
1 => NULL,
2 => NULL,
3 => NULL,
);
})
4 C:\web\dotproject\index.php:143 login('admin','passwd')
Unknown column 'user_contact' in 'on clause'C:\web\dotproject\includes\db_adodb.php(61) : Error executing: SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, user_department, contact_email as user_email, user_type FROM `users` LEFT JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = 'admin'