Announcement

Collapse
No announcement yet.

Moving EspoCRM to another domen

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving EspoCRM to another domen

    Доброго дня
    Перемістив на інший домен EspoCRM та налаштував його згідно інструкції


    config-internal.php:

    database connection settings:
    'database' => [
    'driver' => 'pdo_mysql',
    'dbname' => 'YOUR_DATABASE_NAME',
    'user' => 'YOUR_USER',
    'password' => 'YOUR_DATABASE_PASSWORD',
    'host' => 'localhost',
    'port' => '',
    ],

    data/config.php

    siteUrl - if your domain name (URL) is changed:
    'siteUrl' => 'https://new-link.com',​

    Після чого видало помилку 500
    В логах зявилася наступна інфо
    Раніши робив такі операції, все було гаразд, але змінював url ще в базі через phpMyAdmin, зараз в phpMyAdmin такої функії не спостерігаю


    [2022-10-31 06:18:57] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 06:18:57] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 06:19:04] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 06:19:04] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:37:27] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:37:27] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:38:13] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:38:13] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:47:24] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:47:24] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:47:25] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:47:25] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:48:42] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:48:42] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:49:32] ERROR: (1045) SQLSTATE[HY000] [1045] Access denied for user 'u373868063_crm'@'localhost' (using password: YES); GET /Settings; line: 97, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2022-10-31 08:49:32] ERROR: (1045) SQLSTATE[HY000] [1045] Access denied for user 'u373868063_crm'@'localhost' (using password: YES); GET /I18n; line: 97, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2022-10-31 08:50:40] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:50:40] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /I18n; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:50:58] ERROR: (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u373868063_crm.user' doesn't exist; GET /Settings; line: 70, file: /home/u373868063/domains/ovkgroup.site/public_html/crm/application/Espo/ORM/SqlExecutor.php [] []
    [2022-10-31 08:50:58] ERROR: (42S02) SQLSTATE[42S02​

  • #2
    Доброго дня, Олег!

    Скажіть, будь ласка, чи робили Ви ребілд через командний рядок (CLI)?
    https://docs.espocrm.com/administrat...mands/#rebuild.

    Comment


    • #3
      Should not have been posted in bug reports. https://forum.espocrm.com/forum/bug-...o-report-a-bug
      Last edited by yuri; 10-31-2022, 09:45 AM.

      Comment


      • #4
        Зробив ребілд і все запрацювало
        Дякую за допомогу

        Comment


        • #5
          Але тепер неможу зайти під своїм логіном та паролем адміністратора

          Comment


        • #6
          -bash-4.2$ php command.php set-password [md@ovk.group]
          User '[md@ovk.group]' not found.
          -bash-4.2$ php command.php set-password [admin]
          User '[admin]' not found.​

          Спробував два логіна, md@ovk.group - це справжній логін адміністратора
          каже що не знайдено жодного

          Comment


          • lazovic
            lazovic commented
            Editing a comment
            Будь ласка, спробуйте забрати квадратні дужки:
            php command.php set-password md@ovk.group
            Last edited by lazovic; 11-01-2022, 02:36 PM.

        • #7
          Є спосіб як добавити нового адміністратора або переглянути логін та пароль існуючого?

          Comment


          • #8
            Насправді помилка була в іншому, при імпорті бачи через phpMyAdmin імпортувало не усі таблиці, здійснив імпорт через SSH, імпортувалу усі таблиці і все запрацювало.
            Дякую за допомогу

            Comment

            Working...
            X