| Language_id error after upgrade to 1.91.0 [message #5157] |
Thu, 19 November 2015 11:19  |
htManager
Messages: 439
Registered: May 2014
|
Senior Member |
|
|
I upgraded to 1.91.0 and I can't login anymore. The following error appears when I try to login:
Fatal Error: MySQL: Unknown column 'language_code' in 'field list' (# 1054)
SQL query: SELECT SQL_CALC_FOUND_ROWS mnu_user.user_id, user_name, start_date, end_date, is_disabled, pswd_count, pswd_chg_date, language_code, email_addr, rdcaccount_id, external_id, party_id, user_timezone, mnu_user_role.role_id, mnu_role.start_task_id , CASE WHEN (SELECT count(ip_address) FROM mnu_user_ip_address WHERE user_id='JH') = 0 THEN true WHEN (SELECT count(ip_address) FROM mnu_user_ip_address WHERE user_id='JH' AND ip_address='::1') = 1 THEN true ELSE false END AS ip_address_valid, (SELECT GROUP_CONCAT(role_id ORDER BY role_id SEPARATOR ',') FROM mnu_user_role WHERE user_id=mnu_user.user_id) AS role_list, mnu_language.input_date_format, mnu_language.output_date_format FROM mnu_user LEFT JOIN mnu_user_role ON (mnu_user_role.user_id=mnu_user.user_id AND mnu_user_role.is_primary='Y') LEFT JOIN mnu_role ON (mnu_role.role_id=mnu_user_role.role_id) LEFT JOIN mnu_language ON ( mnu_language.language_id=COALESCE(mnu_user.language_code, 'en')) WHERE mnu_user.user_id='JH' AND user_password='HfTh<=8/62#FQ*mt' ORDER BY mnu_user.user_name asc LOCK IN SHARE MODE
Error in line 601 of file 'C:\xampp\htdocs\htm\radicore\includes\dml.mysqli.class.inc' .
Host Info: localhost via TCP/IP
Server Version: 5.5.27
Client Version: mysqlnd 5.0.10 - 20111026 - $Id: b0b3b15c693b7f6aeb3aa66b646fee339f175e39 $, Character sets - client: utf8, - connection: utf8, - database: latin1, - server: latin1
PHP_SELF: /radicore/menu/logon.php
CURRENT DIRECTORY: C:\xampp\htdocs\htm\radicore\menu
SERVER_ADDR: ::1
SERVER_NAME: localhost
HTTP_HOST: localhost
REMOTE_ADDR: ::1
REQUEST_URI: /radicore/menu/logon.php
I checked the tables mnu_language, mnu_user and mnu_user_alt and also the *.dict.inc files. They all had the column language_id.
I also copied all the new files in the dict, include and menu directory. Which files did I forget to copy?
|
|
|
|
|
|
|
|
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
