Back to CRM Pro Support

norotaro
norotaro

I tried to install your CRM Pro plugin in an October instance that uses PostgreSQL as a database engine and the following error occurs:

"SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "time" cannot be cast automatically to type time without time zone HINT: You might need to specify "USING "time"::time(0) without time zone". (SQL: ALTER TABLE briddle_crm_tasks ALTER "time" TYPE TIME(0) WITHOUT TIME ZONE)" on line 664 of /home/vagrant/code/sds.oc.dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php

I can send the whole stack of the log if necessary.

Briddle
Briddle

Hello Norotaro,

Thank you for your purchase!

I am sorry to hear that PostgreSQL gave you an error during the installation. I am debugging the issue and will make a patch available tomorrow (Dutch timezone)!

Last updated

Briddle
Briddle

Hello Norotaro,

It is 23:00 here in the Netherlands but this bug annoyed me so here we go...

There was a minor issue with this plugin when using PostgreSQL:

  • a spelling mistake in updates/briddle_crm_tasks_6.php caused a bug during the installation when using PostgreSQL instead of MySQL: There is no column type time('time'), this should obviously be string('time') (this is now fixed)

However, when testing the installed system I encountered some additional minor issues:

  1. The config_list.yaml for the controllers Tasks and Deals uses the "<>" operator and this apparently results in an error inPostgreSQL for a value of true: replace it and the default value by 1 (a fix is not implemented)
  2. The table briddle_crm_log has a field "pipeline_id" and a field "deal_id" that should be ->nullable(); for PostgreSQL (a fix is not implemented)
  3. The table briddle_crm_pipeline has a field "sort_order" that should be ->nullable(); for PostgreSQL (a fix is not implemented)
  4. The table briddle_crm_tasks has a field "labels" that should be ->nullable(); for PostgreSQL (a fix is not implemented)

I stopped implementing these small fixes tonight because I also encountered a more serious issue:

Until this issue is fixed by October, using PostgreSQL for my CRM pro plugin will give you an error on the Tasks overview page (the default page for the CRM plugin).

I will run some additional tests using PostgreSQL to fix the minor issues in my CRM plugin mentioned above but until the string_agg() function is fixed by October you have the option to:

Please do let me know if you need additional support and I will also report back here myself.

Last updated

Briddle
Briddle

Hello Norotaro,

The 4 minor issues I encountered for PostgreSQL are now fixed.

The Tasks controller still gives an error that is related to October's use of the string_agg() function in PostgreSQL. As I mentioned earlier I have contributed to a forum post from a year ago that also mentioned an issue with this function and I reported this bug on GitHub but until this issue is fixed by October, using PostgreSQL for my CRM pro plugin will give you an error on the Tasks overview page (the default page for the CRM plugin). For now, you can apply my patch mentioned in the forum post.

Please do let me know if you need additional support or encounter additional bugs in PostgreSQL.

Any feedback is greatly appreciated!

Last updated

norotaro
norotaro

Thank you very much for your quick support and detailed report. As you mentioned, an error occurs related to the string_agg() function and it is solved with the patch you mentioned in the forum post.

Now we were able to test the plugin and found another error in the Report Widgets for the dashboard. When trying to add a widget to the dashboard, the following error occurs:

development.ERROR: PDOException: SQLSTATE [42601]: Syntax error: 7 ERROR: syntax error at or near " ` " LINE 4: briddle_crm_task_type.icon AS `type` ^ in /var/www/html/miaterra/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105`

I await your comments. Everything else seems to be working correctly.

Briddle
Briddle

Hello Norotaro,

Thank you very much for your feedback. Your feedback allows me to keep improving my plugins and create the experience I wish my customers to have when using them.

The issue you raised for the Report Widgets is now under review and I will provide a fix for it later today (it is 08:13 over here).

Please do let me know if you need additional support and I will report back here later today.

Briddle
Briddle

Hello Norotaro,

Thank you for your review!

The issue you raised for the Report Widgets is now fixed and you can update the plugin to version 1.7.8.

Please do let me know if you need additional support.

norotaro
norotaro

Thanks again.

Now we have another error in the dashboard: development.ERROR: ErrorException: Undefined variable: i in /var/www/html/miaterra/plugins/briddle/crm/reportwidgets/analytics/partials/_analytics.htm:26

We reinstalled the plugin but it continues with the same error.

Briddle
Briddle

Hello Norotaro,

My oh my, PostgreSQL is putting up a fight!

Please allow me some time to run tests with PostgreSQL and I will get back to you here.

Briddle
Briddle

Hello Norotaro,

Unfortunately I have been unable to reproduce this last issue. However, I am running additional tests that may yield some results.

I will get back to you here.

Briddle
Briddle

Hello Norotaro,

I have tested the plugin again on a clean install running PostgreSQL on System build 447 (and 446). Unfortunately I have been unable to reproduce this last issue.

Please try the following:

  1. Remove the plugin (Settings > Updates > Manage)
  2. Please make sure the tables were removed from your database
  3. Install the plugin again (the current version is 1.8.0)
  4. Make sure you have also installed all required plugins:
    • RainLab.User
    • RainLab.UserPlus
    • RainLab.Location
    • RainLab.Notify
    • RainLab.Translate

Does this solve your issue?

1-11 of 11