Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » Language_id error after upgrade to 1.91.0
Language_id error after upgrade to 1.91.0 [message #5157] Thu, 19 November 2015 11:19 Go to previous message
htManager is currently offline  htManager
Messages: 344
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_NAME: localhost
HTTP_HOST: localhost
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?
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Error: This application has encountered an unrecoverable error
Next Topic: Logon / pass recovery not working after fresh installation
Goto Forum:

Current Time: Wed Jan 26 15:36:00 EST 2022

Total time taken to generate the page: 0.01130 seconds