search

compucorp / uk.co.compucorp.civicrm.prospect

Other
1 stars 1 forks source link

Uninstall/Install causes fatal error #51

Open artfulrobot opened 4 years ago

artfulrobot commented 4 years ago

One of these needs fixing:

chumkui commented 3 years ago

CiviCRM 5.40, Drupal 7.82

I get a DB syntax error and this is what is in the Drupal log:

$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -2 [message] => DB Error: syntax error [mode] => 16 [debug_info] => ALTER TABLEcivicrm_dev.log_civicrm_value_prospect_financial_information ADD [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] [type] => DB_Error [user_info] => ALTER TABLEcivicrm_dev.log_civicrm_value_prospect_financial_information ADD [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="ALTER TABLEcivicrm_dev.log_civicrm_value_prospect_financial_information ADD [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]"] )

After this, subsequent attempts to install cause an issue as the Custom Group 'Financial Information' has been created along with several fields. Manually running the uninstall via CV does not remove these (even though it is not of course intalled).

artfulrobot commented 3 years ago

By the way, here's my newer solution to this problem https://docs.civicrm.org/pelf/en/latest/

chumkui commented 3 years ago

That's really useful - thank you. Not quite sure how I had not come across this!

deb1990 commented 3 years ago

@artfulrobot Thanks for reporting. We will look into this shortly, and fix the issue in the upcoming release.

deb1990 commented 3 years ago

@chumkui Thanks for reporting, we will look into it.

It's not currently very clear in the read-me but currently we pin all Compucorp extensions to a specific (secure) version of CiviCRM for better management of the extension compatibility with CiviCRM core (and the other dependant versions).

Currently that is CiviCRM v5.35 and as such there might be some issues with newer or older versions.

We are working to update the repository readme soon with much clearer details on this.

If you have any issues with the v5.35 then please do let us know but the extension should be stable and is supported for that version.