Hi,

I am trying to upgrade from 1.9.15 to 1.14.3,
i followed the upgrade steps but i'm getting these errors:
DB Error #1146 "ost_translation table is not existed " and another one
DB Error #1054 "Unknown column 'extra' in 'field list"

environment specifications:
Apache web server
php v7.4.9
mysql Ver 14.14 Distrib 5.7.31

Please your advice as soon as possible.
Regards,

    khadija94
    First error😃B Error #1146 "ost_translation table is not existed " and another one
    You may want to try upgrading without language packs

    Second, might be related to the first error, also your PHP version is higher then you might want to downgrade to 7.3, see
    Requirements: https://osticket.com/download/
    HTTP server running Microsoft® IIS or Apache, PHP version 5.6-7.3 (7.3 recommended), MySQL database version 5.5

        ramrajone

        Thank you for your help,

        actually i have tried a lot with the mentioned requirements (PHP 5.6) before positing here, on a test server ( where i have already working osticket with no problem ) but no point so i updated the php to the highest ver. and also no point as discussed above.
        For lang packs, i have never installed languages packs , neither tried to update with it.

        But after many tries i did it !!
        the solution for the second error was disabling SElinux as i'm running it on linux environment.
        the first error as i have read, it was said that ost_translation error is ok with it if it didnt affect any functionality on the system and in my case it didnt, so everything should be ok now especially i dont use any lang packs other than the default.

        FYI: i had other UI errors like could'nt create tickets it was showing only white screen when submit, it appeared that some of the forms where duplicated for some reason after upgrade ( same form_id with same form_type ) so i solved this by deleting them (ensuring that it wasn't used before)

        Thanks again
        Regards

        finally the update was done now with

            khadija94
            Great to hear your issues is fixed

            I did not which linux's version you were using
            I always been using Ubuntu flavor
            disabling SElinux is solution i read for many users who are having issues with Osticket

                khadija94 the solution for the second error was disabling SElinux as i'm running it on linux environment.

                So it's great to disable SELinux for testing to see if that is what is causing the issue... but you should probably look into writing rules to make it work with SELinux rather than just leaving it shut off.

                    ntozier

                    You are absolutely right, its security risk to disable SElinux, i will do this, but please can you help me telling me what exactly permissions are needed for the ticket system ?

                    Regards,

                        i forgot to say that I used PHP ver 5.6 in the upgrade following your advice

                        Mentioning that I faced the exact same errors aove with this version but it only worked with the mentioned solutions.

                        khadija94 please can you help me telling me what exactly permissions are needed for the ticket system ?

                        I have no idea. I do not and have never run SELinux.

                        I am running PHP 7.3 personally. 🙂

                          7 days later

                          Hello again,

                          I used the following commands in order to make it work with SELinux enabled:

                          chcon -t httpd_sys_rw_content_t include/ost-config.php
                          setsebool -P httpd_can_sendmail 1
                          reboot after the changes

                          The problem was solved, you can close the thread
                          Thanks

                          9 days later

                          Thanks for posting your solution.

                          ntozier changed the title to [resolved] Upgrade from v.19.15 to 1.14.3.
                          Write a Reply...