+ Reply to Thread
Results 1 to 7 of 7

Thread: error in update v4.7.2_to_v4.8.0

  1. #1

    error in update v4.7.2_to_v4.8.0

    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)

  2. #2
    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
    Viktor,
    Flynax technical department,
    Best wishes.

  3. #3
    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

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

  5. #5
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    2,582
    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

  6. #6
    in the screenshot you can see that it uses the correct prefix

  7. #7
    Master
    Join Date
    Apr 2017
    Location
    Tehran/Iran
    Posts
    489
    Quote Originally Posted by Juan Maya View Post
    in the screenshot you can see that it uses the correct prefix
    As Rudi said:
    Change
    Code:
    Only registered members can view the code.
    To
    Code:
    Only registered members can view the code.

+ Reply to Thread