Back to CRM Pro Support

prema770
prema770

Hi Weigo Thanks very much for what is looking to be a great tool Just wondering if we can have some comments on a tangled installation. Here's what happened

  1. The installation site has an existing CRM plugin. https://octobercms.com/plugin/ideaverum-crm
  2. Went through the normal installation procedure -- Added your CRM to the project
  3. Update process seemed to install just fine
  4. CRM Pro did not appear
  5. Removed ideaverum CRM
  6. Updated. Both CRM Pro and ideaverum CRM installed
  7. Created a new project and transferred CRM Pro to that project
  8. Installation did not appear.
  9. Clear cache / update - still no CRM

Any tips very much appreciated. Looking forward to getting this going Kindest regards Mike

prema770
prema770

Notice this error in the log Symfony\Component\Debug\Exception\FatalThrowableError: Cannot use object of type Illuminate\Http\Response as array in /var/www/prema/modules/backend/classes/BackendController.php:163 Have tried multiple installs

Briddle
Briddle

Hi Mike,

Thank you for your interest in my plugin. I am sorry to hear the installation is giving you some trouble. Let's try and get you sorted.

  1. Are you running the latest version of OctoberCMS?
  2. My CRM Pro plugin has some dependencies. Did you install those? (the OctoberCMS dashboard should indicate any issues in the System Status Widget). This would be the most likely problem.

Please note that RainLab.User, RainLab.UserPlus, RainLab.Translate are required for this plugin and that the RainLab.UserPlus plugin now requires RainLab.Location and RainLab.Notify

  1. Make sure you allow short_open_tag in your PHP configuration (default)

If none of these do anything for you:

  • You can also try if disabling your other plugins changes anything (in case any of those is somehow creating some conflict).
  • Any errors in the logs?

Please do let me know if this helps! If not, please supply the following additional information:

  • What version of OctoberCMS are you using?
  • What version of PHP?
  • What database?

Last updated

prema770
prema770

We tried an install on a separate instance which has been upgraded. On the associated database this query fails as having a syntax error

create table `briddle_crm_log` (
  `id` int unsigned not null auto_increment primary key,
  `user_id` int not null,
  `description` text not null,
  `created_at` timestamp not null,
  `updated_at` timestamp not null
) default character set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB

Error: SQLSTATE[42000]: Syntax error or access violation

System: MySQL version mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper Distributor ID: Ubuntu Description: Ubuntu 18.04.2 LTS Release: 18.04 Codename: bionic

Last updated

prema770
prema770

Have done quite a lot to check out this issue. Turns out that the crm log schema is trying to set two timestamp fields in the log table, which is apparently illegal in our version of MySQL - see above. ver 5.7

We're looking forward to using this CRM but will be forced to move on if we can't resolve this Any ideas please anyone?

prema770
prema770

This required a fresh OCMS / CRM installation to clear the issue. Maybe plugin contention

1-6 of 6