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: 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.
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:
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)
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)
The table briddle_crm_pipeline has a field "sort_order" that should be ->nullable(); for PostgreSQL (a fix is not implemented)
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:
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.
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 : 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.