CiviCRM PHP 7.3 Error

natselection

The CiviCRM plugin causes a broken page when trying to edit a newsletter. The page loads without any styling. Disabling the CiviCRM 1.2.0 plugin the edit newsletter pages open normally.

Dax

Hello,

I installed CiviCRM and the plugin on a J3 site running on a PHP7.3 server but didn't have any issue, do you have the latest version of CiviCRM installed on your site?
If so, do you have an error message when you turn On the Joomla debug mode + error reporting to "Maximum" that could point me in the right direction?

natselection

Lastest version of everything is installed. Joomla debug and error reporting turned on but the way the page is breaking it prevents any error messages or debug info from displaying.

Here's a screenshot: https://i.nswd.co/screencapture-charterforcompassion-org-administrator-index-php-2019-08-13-09_01_07.png

Dax

There's definitely a PHP error on the page, if activating the Joomla debug mode and error reporting doesn't show any error message, it means that an option in your server configuration is forcing the error messages to be hidden.
As I can't do anything without this error message, please take a look at your server's error logs file to find this error message.
If you don't find it you can also contact your host to ask them for it, just don't forget to give them the exact date and time when the error occurred as the logs file is sorted by date.

natselection

I finally was able to get a little further with this. The page is loading now. The issue now is if you try to do a Mass Action to assign users from a CiviCRM group to a mailing list I get:

1054 Unknown column 'civicrm_state_province.country_id' in 'on clause'

Dax

Hi, could you edit the file plugins / acymailing / civicrm / civicrm.php and invert the lines 1358 and 1359 then give it another try?
It should look like this:

elseif($table == 'civicrm_country'){
	if(!in_array('civicrm_state_province', array_keys($search->select_tables))) $query->leftjoin[] = $this->civiprefix.'state_province AS civicrm_state_province ON civicrm_state_province.id = civicrm_address.state_province_id ';
	$query->leftjoin[] = $this->civiprefix.'country AS civicrm_country ON civicrm_state_province.country_id = civicrm_country.id ';
}elseif($table == 'civicrm_worldregion')

natselection

Thanks, that appears to have fixed it.