View Full Version : error in update v4.7.2_to_v4.8.0

Juan Maya
April 13, 2022, 12:40 PM
Hello, I have the following error that arose during the update, how can I solve it?

Error: Unknown column 'JS' in 'field list'
Query: SELECT `Key`,`Value`,`JS` FROM `fl_lang_keys` WHERE `Module` IN ('admin','common') AND (`Target_key` = '' OR `Target_key` = 'home')AND `Code` = 'es' AND `Status` = 'active'
Function: preparePhrases
Class: rlLang
File: /mnt/web501/d0/12/54477112/htdocs/bublico.com/includes/classes/rlLang.class.php (line# 176)

April 13, 2022, 12:57 PM
Hello Juan,

Go to Admin Panel >> Database and put this line:
ALTER TABLE `{db_prefix}lang_keys` ADD `JS` ENUM('0','1') DEFAULT '0' AFTER `Module`;
and click 'Go' button

Juan Maya
April 14, 2022, 09:24 AM

it seems that my problem comes from behind and is that I am updating from version _v4.7.1_to_v4.7.2 and from there it apparently tells me that this table does not exist

Juan Maya
April 27, 2022, 10:06 AM
Hello, is there a solution for this problem or in my case it is impossible to update to the latest version?

April 27, 2022, 01:41 PM

If you use phpMyAdmin software, you need to replace {db_prefix} with the prefix from your database tables fl_ and run the query

or create a ticket if it doesn't help

Juan Maya
May 3, 2022, 05:32 PM
in the screenshot you can see that it uses the correct prefix

Bahram Soltanirad
May 4, 2022, 07:28 AM
in the screenshot you can see that it uses the correct prefix

As Rudi said:
{fl_prefix} To