by eVolpe Consulting Group

Are you facing difficulties trying to coordinate efforts between marketing and sales? The SuiteCRM & Mautic Integrator by eVolpe is the best solution that will help you solve this issue. TRY IT NOW FOR FREE!

Cancel at any time!
Free Trial

#3351 - We are having issues installing the plugin

Closed Installation created by piesalud 3 years ago

Hello We are having an issue when installing the Suitecrm zip file. Attached a picture of the issue. db-error2.JPG

  1. eVolpe member avatar

    eVolpe Consulting Group Provider

    3 years ago

    Hello,

    First of all, I'm really sorry for delay. Our support team missed your first message.

    I need some more information: 1. What version of SuiteCRM do you have? 2. What version of Mautic do you have? 3. What version of our plugin do you use? 4. What version of PHP?

    Best regards, Maciej Jankiewicz

  2. piesalud member avatar

    piesalud

    3 years ago

    Hello

    PHP Version 7.2.24-0 ubuntu 18.04.7 Mautic 3.2.0 SuiteCRM 7.10.13 PLUGIN USED: Mautic Side: eVolpe_Mautic_CRM_4.0.118 SuiteCRM side: eVolpe_CRM_Mautic_4.0.241

  3. eVolpe member avatar

    eVolpe Consulting Group Provider

    3 years ago

    Can you send me logs (/suitecrm.log)?

  4. eVolpe member avatar

    eVolpe Consulting Group Provider

    3 years ago

    < instance_dir > / suitecrm.log

  5. piesalud member avatar

    piesalud

    3 years ago

    Can you provide an email I cannot attach suitecrm log here. I'm pasting here:

    THIS IS WITH ERROR LEVEL LOG:

    Tue Jan 26 17:13:01 2021 [14243][1][FATAL] Job cc62ab5b-4bb0-fd08-9c11-601093cd382a (PIESALUD - Actualizar estado de las citas planificadas hace 5 horas por incumplidas a las 8 AM) failed in CRON run Tue Jan 26 17:13:52 2021 [14225][53f18422-1506-3c37-a445-4edeb679b662][FATAL] Mysqli_query failed. Tue Jan 26 17:13:52 2021 [14225][53f18422-1506-3c37-a445-4edeb679b662][FATAL] Query Failed: ALTER TABLE pds_imagenfp modify COLUMN imagen text NULL : MySQL error 1406: Data too long for column 'imagen' at row 1 Tue Jan 26 17:13:52 2021 [14225][53f18422-1506-3c37-a445-4edeb679b662][FATAL] Exception handling in /home/soel/public_html/podosys.piesalud.com/include/MVC/Controller/SugarController.php:400 Tue Jan 26 17:13:52 2021 [14225][53f18422-1506-3c37-a445-4edeb679b662][FATAL] Exception in Controller: Error de base de datos. Por favor, consulte SuiteCRM error .log para más detalles. Tue Jan 26 17:13:52 2021 [14225][53f18422-1506-3c37-a445-4edeb679b662][FATAL] backtrace:

    0 /home/soel/public_html/podosys.piesalud.com/include/database/DBManager.php(353): sugar_die('Error de base d...')

    1 /home/soel/public_html/podosys.piesalud.com/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', 'Error with MySQ...')

    2 /home/soel/public_html/podosys.piesalud.com/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', 'Error with MySQ...')

    3 /home/soel/public_html/podosys.piesalud.com/include/database/MysqlManager.php(616): MysqliManager->query('ALTER TABLE pds...', 'Error with MySQ...')

    4 /home/soel/public_html/podosys.piesalud.com/include/database/DBManager.php(764): MysqlManager->repairTableParams('pds_imagenfp', Array, Array, true, NULL)

    5 /home/soel/public_html/podosys.piesalud.com/modules/Administration/repairDatabase.php(119): DBManager->repairTable(Object(PDS_ImagenFP), true)

    6 /home/soel/public_html/podosys.piesalud.com/modules/Administration/QuickRepairAndRebuild.php(138): include_once('/home/soel/publ...')

    7 /home/soel/public_html/podosys.piesalud.com/modules/Administration/QuickRepairAndRebuild.php(120): RepairAndClear->repairDatabase()

    8 /home/soel/public_html/podosys.piesalud.com/cache/upgrades/temp/1Gc2Mh/scripts/post_install.php(38): RepairAndClear->repairAndClearAll(Array, Array, true, false)

    9 /home/soel/public_html/podosys.piesalud.com/cache/upgrades/temp/1Gc2Mh/scripts/post_install.php(17): repairAndRebuild()

    10 /home/soel/public_html/podosys.piesalud.com/modules/Administration/UpgradeWizard_commit.php(347): post_install()

    11 /home/soel/public_html/podosys.piesalud.com/include/MVC/View/SugarView.php(818): include_once('/home/soel/publ...')

    12 /home/soel/public_html/podosys.piesalud.com/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('cache/upgrades/...')

    13 /home/soel/public_html/podosys.piesalud.com/include/MVC/View/SugarView.php(211): ViewClassic->display()

    14 /home/soel/public_html/podosys.piesalud.com/include/MVC/Controller/SugarController.php(435): SugarView->process()

    15 /home/soel/public_html/podosys.piesalud.com/include/MVC/Controller/SugarController.php(375): SugarController->processView()

    16 /home/soel/public_html/podosys.piesalud.com/include/MVC/SugarApplication.php(113): SugarController->execute()

    17 /home/soel/public_html/podosys.piesalud.com/index.php(52): SugarApplication->execute()

  6. eVolpe member avatar

    eVolpe Consulting Group Provider

    3 years ago

    Thank you. I forwarded these logs to our developers.

    My e-mail: maciej.jankiewicz@evolpe.pl

  7. eVolpe member avatar

    eVolpe Consulting Group Provider

    3 years ago

    Hello,

    According to the received logs, the problem is related to the modification of the "imagen" column in the "pds_imagenfp" table. This is why an error occurs while we want to do quick repair and rebuild.

    Installing our package requires do quick repair and rebuild.

    Therefore, it is not our integrator's fault. The error of the SuiteCRM caused that you can't install our integrator.

    When you manage to rebuild correctly (Administration -> Repair and Rebuild -> Quick Repair And Rebuild) then you will be able to install our package.

    Best, Maciej Jankiewicz eVolpe Support Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Install and first test worked like a charm (well documented). Except for one little thing: In my environment there was an issue with database table cr..." - Endymion

    Read More Reviews