kustosz
01-06-05, 07:52 PM
I have problem for upgrade from 1.0.2 to 2.0.1.
After upgrade, when I tried to login for "admin" user this page is displayed:
[...]
ERROR: /home/https/www.ka.com.pl/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 /home/https/www.ka.com.pl/dotproject/includes/db_adodb.php:61 dprint('/home/https/www.ka.com.pl/dotproject/includes/db_adodb.php',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 /home/https/www.ka.com.pl/dotproject/includes/db_connect.php:93 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 /home/https/www.ka.com.pl/dotproject/includes/db_connect.php:67 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 /home/https/www.ka.com.pl/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' => 'pl',
'TABVIEW' => '0',
'SHDATEFORMAT' => '%d/%m/%Y',
'TIMEFORMAT' => '%H:%M',
'UISTYLE' => 'default',
'CURRENCYFORM' => 'en_US',
);
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 /home/https/www.ka.com.pl/dotproject/index.php:143 login('admin','xxxx')
Unknown column 'user_contact' in 'on clause'
[...]
In php.log this is logged:
[...]
[01-Jun-2005 11:44:46] /home/https/www.ka.com.pl/dotproject/includes/db_adodb.php(61): Error executing: <pre>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'</pre>
[...]
On install screen (/dotproject/install/) there is no premision problem or other problem raported.
I think there is something wrong with database convert, becouse when I install dotproject 2.0.1 from begining (not upgrading) there are no problems.
Can anybody help me?
Regards
/Michal
After upgrade, when I tried to login for "admin" user this page is displayed:
[...]
ERROR: /home/https/www.ka.com.pl/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 /home/https/www.ka.com.pl/dotproject/includes/db_adodb.php:61 dprint('/home/https/www.ka.com.pl/dotproject/includes/db_adodb.php',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 /home/https/www.ka.com.pl/dotproject/includes/db_connect.php:93 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 /home/https/www.ka.com.pl/dotproject/includes/db_connect.php:67 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 /home/https/www.ka.com.pl/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' => 'pl',
'TABVIEW' => '0',
'SHDATEFORMAT' => '%d/%m/%Y',
'TIMEFORMAT' => '%H:%M',
'UISTYLE' => 'default',
'CURRENCYFORM' => 'en_US',
);
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 /home/https/www.ka.com.pl/dotproject/index.php:143 login('admin','xxxx')
Unknown column 'user_contact' in 'on clause'
[...]
In php.log this is logged:
[...]
[01-Jun-2005 11:44:46] /home/https/www.ka.com.pl/dotproject/includes/db_adodb.php(61): Error executing: <pre>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'</pre>
[...]
On install screen (/dotproject/install/) there is no premision problem or other problem raported.
I think there is something wrong with database convert, becouse when I install dotproject 2.0.1 from begining (not upgrading) there are no problems.
Can anybody help me?
Regards
/Michal