error in update v4.7.2_to_v4.8.0

[Juan Maya]

Hello, I have the following error that arose during the update, how can I solve it?

MYSQL ERROR
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)

[Viktor]

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]

https://www.screencast.com/t/2iCoUYkfp9Y

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]

Hello, is there a solution for this problem or in my case it is impossible to update to the latest version?

[Rudi]

Hello,

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]

in the screenshot you can see that it uses the correct prefix

[Bahram Soltanirad]

in the screenshot you can see that it uses the correct prefix

As Rudi said:
Change
{fl_prefix} To
fl_