texts: Cannot create or edit events - server was reset while the page was loading

texts:
I have installed CiviCRM version 4.7.7 as a plugin to WordPress version 4.5.2 The server is WAMPSERVER for windows 64BIT (Apache 2.4.17 PHP 5.6.16, MySQL 5.7.9.) Everything seems to be working except for creation and editing events.

When the "New Event" button is pressed or the dropdown "info and settings" from the events dashboard or manage events pages is chosen, the server (almost immediately) returns with "The connection to the server was reset while the page was loading."

The URL string is the same as in the online demo.

I can use the API to create events and also copy the demo events so permissions are probably not an issue.

Apache log file says

[Tue May 31 23:45:20.622363 2016] [mpm_winnt:notice] [pid 5568:tid 288] AH00456: Apache Lounge VC14 Server built: Oct 11 2015 11:49:07

[Tue May 31 23:45:20.622363 2016] [core:notice] [pid 5568:tid 288] AH00094: Command line: 'C:\wamp64\bin\apache\apache2.4.17\bin\httpd.exe -d C:/wamp64/bin/apache/apache2.4.17'

[Tue May 31 23:45:20.622363 2016] [mpm_winnt:notice] [pid 5568:tid 288] AH00418: Parent: Created child process 5632

[Tue May 31 23:45:20.840764 2016] [auth_digest:notice] [pid 5632:tid 156] AH01757: generating secret for digest authentication ...

[Tue May 31 23:45:20.856364 2016] [mpm_winnt:notice] [pid 5632:tid 156] AH00354: Child: Starting 64 worker threads.

Any tips?


texts: Is there a way to export contacts (to a csv) as they are displayed without having to create a field mapping?


texts: How to generate a report on VAT collected (HST in my case)

texts:
I'm sure I'm missing something obvious since I'm not an accountant or bookkeeper. I think I have everything set up to collect HST using the information at https://docs.civicrm.org/user/en/latest/contributions/sales-tax-and-vat/

The correct rate is charged and the receipt the constituent gets all look good. However the bookkeeping transaction report shows everything except the HST part of the transaction. I've tried playing with filters and columns to no avail.

Any thoughts?


texts: So I just updated CiviCRM to 5.0 and I keep getting the error DB Error: no such field when I try and view/edit a contact. It doesn't allow me to view any contact but I can search and find my contacts. I am not sure what is going on but this happened even before I upgraded Civi and it was 4.7.


texts: How to have a Detailed Membership Report filtered/sorted by pertaining Organization

texts:
I have several Organizations

I need a Report which displays the following columns :
Organization, Membership Type, Member (first and last name), email, Phone, Status

I would like this Report sorted by the 3 first columns, and/or filtered by Organization.

How can I ?


texts:
I have summary report and a membership of active members report. When I look at the active members, for 2019 I get about 7 people. When I look at the summary of memberships (grouped per month) I get only 3 people. The only difference in the persons is their status. It seems only the new people are showed in the summary. However, I want to show all the people that have renewed their membership.
I've already tried filtering the summary on status 'New' and 'Current', but that doesn't do anything


texts: We're running Joomla 3.6.2 and CiviCRM 4.7.11, however we recently made some adjustments that prompted us to uninstall the Summary Fields extension. Essentially, it was installed in a different directory than the default settings. We reset the paths and that cause problems. So, we uninstalled and reinstalled, so extensions are now in the default directory. The problem is that when we configure summary fields and set it to update "when the form" is submitted, we receive the error "Error adding custom field 'contribution_amount_last': DB Error: already exists" (same error for other fields as well, like "last donated", etc.). Is there a way to do a complete uninstall of this, or is there a better way to handle this error?


texts: Why is there a hyphen following the postal code with this address format?

texts:
The token {contact.postal_code}{contact.postal_code_suffix} is returning an extra hyphen at the end of the string: 10023-7890- not 10023-7890.

The actual content shown in the Settings - Addresses is as follows

{contact.addressee} {contact.street_address}
{contact.supplemental_address_1} {contact.supplemental_address_2}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}{-}{contact.postal_code_suffix}
{contact.country}

How can I get rid of it?
Thanks,
K.

Sorry - the cut & paste I did had the extra hyphen after country. However, the actual content shown in the Settings - Addresses is as follows:
{contact.addressee}
{contact.street_address}
{contact.supplemental_address_1}
{contact.supplemental_address_2}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}{-}{contact.postal_code_suffix}
{contact.country}

The extra hyphen after {contact.country} does not appear in the mailing label or address display format, but it is still appearing everywhere.

I've tried editing the address settings by adding each token but the problem remains. Any other thoughts?


texts: Should participant custom fields be available under events on webform

texts: Custom fields for participants in Civi are not being presented for addition to Drupal Webform.   Event registration is selected and working but the custom field set for participants are not showing up for placement on the webform.   Is there a reason that they are not included for webform usage?


texts:
Long time ago, we had created event and template for event.
We give permission to user to register multiple participant with same email address.

Now we have problem with a lot of question link to participant.

At this time we receive this error :
"Allow multiple registrations from the same email address requires a profile of type 'Individual'"

I think problem is comming from dedupe rules but I can resolved it.
I have create new one but it change nothing. I received this error

But I receive error when I was creating new user more detailed error like this :

#0 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Core/Error.php(187): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /usr/share/php/PEAR.php(890): call_user_func((Array:2), Object(DB_Error))
#3 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: constraint violation", -3, 16, (Array:2), "DELETE FROM civicrm_dedupe_rule_group  WHERE (  civicrm_dedupe_rule_group.id ...")
#4 /usr/share/php/PEAR.php(531): DB_Error->DB_Error(-3, 16, (Array:2), "DELETE FROM civicrm_dedupe_rule_group  WHERE (  civicrm_dedupe_rule_group.id ...")
#5 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -3, NULL, NULL, "DELETE FROM civicrm_dedupe_rule_group  WHERE (  civicrm_dedupe_rule_group.id ...", "DB_Error", TRUE)
#6 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-3, NULL, NULL, NULL, "1451 ** Cannot delete or update a parent row: a foreign key constraint fails ...")
#7 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("DELETE FROM civicrm_dedupe_rule_group  WHERE (  civicrm_dedupe_rule_group.id ...")
#9 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB/DataObject.php(2438): DB_common->query("DELETE FROM civicrm_dedupe_rule_group  WHERE (  civicrm_dedupe_rule_group.id ...")
#10 /home/username/etuc/docroot/sites/all/modules/civicrm/packages/DB/DataObject.php(1449): DB_DataObject->_query("DELETE FROM civicrm_dedupe_rule_group  WHERE (  civicrm_dedupe_rule_group.id ...")
#11 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Core/DAO.php(519): DB_DataObject->delete(FALSE)
#12 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Contact/Page/DedupeRules.php(218): CRM_Core_DAO->delete()
#13 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Contact/Page/DedupeRules.php(123): CRM_Contact_Page_DedupeRules->delete("1")
#14 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Contact_Page_DedupeRules->run((Array:3), NULL)
#15 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#16 /home/username/etuc/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#17 /home/username/etuc/docroot/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#18 [internal function](): civicrm_invoke("contact", "deduperules")
#19 /home/username/etuc/docroot/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#20 /home/username/etuc/docroot/index.php(21): menu_execute_active_handler()
#21 {main}

Sorry but we are not able to provide this at the moment
"Supervised rule for Indivual does not exist"

How have the same problems? What are solutions?

Thanks a lot.

NI


texts:
When I go to Administer > CiviCase > Case Types, that page has no content on it and the breadcrumb link at the top just says 'CiviCRM'.

In the web console, I get this error when loading that page (I've removed the domain and added spaces to keep links from showing in the post):

GET h ttp :// **.******.org/go/wp-content/uploads/civicrm/persist/contribute/dyn/angular-modules.a136d84bc8cc935bcae2e81386c212ea.js net::ERR_ABORTED 404

admin.php?page=CiviCRM&q=civicrm/a/:198

GET h ttp ://**.******.org/go/wp-content/uploads/civicrm/persist/contribute/dyn/angular-modules.a136d84bc8cc935bcae2e81386c212ea.js 404

VM6993 admin.php:199

Uncaught Error: [$injector:modulerr] h ttp ://errors.angularjs.org/1.5.11/$injector/modulerr?p0=crmApp&p1=Error%3A%20%5B%24injector%3Anomod%5D%20http%3A%2F%2Ferrors.angularjs.org%2F1.5.11%2F%24injector%2Fnomod%3Fp0%3DcrmApp%0A%20%20%20%20at%20http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A6%3A426%0A%20%20%20%20at%20http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A25%3A235%0A%20%20%20%20at%20b%20(http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A24%3A282)%0A%20%20%20%20at%20http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A25%3A20%0A%20%20%20%20at%20http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A40%3A17%0A%20%20%20%20at%20q%20(http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A7%3A371)%0A%20%20%20%20at%20g%20(http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A39%3A382)%0A%20%20%20%20at%20fb%20(http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A43%3A381)%0A%20%20%20%20at%20c%20(http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A21%3A19)%0A%20%20%20%20at%20Gc%20(http%3A%2F%2Fgo.mediationla.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3DQcNK7%3A21%3A332)
    at angular.js:38
    at angular.js:4692
    at q (angular.js:325)
    at g (angular.js:4653)
    at fb (angular.js:4575)
    at c (angular.js:1809)
    at Gc (angular.js:1830)
    at se (angular.js:1715)
    at HTMLDocument. (angular.js:32616)
    at i (jquery.min.js?r=QcNK7:2)
(anonymous) @ angular.js:38
(anonymous) @ angular.js:4692
q @ angular.js:325
g @ angular.js:4653
fb @ angular.js:4575
c @ angular.js:1809
Gc @ angular.js:1830
se @ angular.js:1715
(anonymous) @ angular.js:32616
i @ jquery.min.js?r=QcNK7:2
fireWith @ jquery.min.js?r=QcNK7:2
ready @ jquery.min.js?r=QcNK7:2
K @ jquery.min.js?r=QcNK7:2

angular.js:38


texts:
I'm doing tests on a test server, but when I make changes using test data, the test data is hidden. I know this is by design, but it makes it impossible to actually check if things are working.

I have a membership that was entered as a test, so it doesn't show up for the user.

Now, that would be fine if it was a live server. But I'm running a test server, so I would like to be able to just turn test data on across the whole install.

OR, ideally, be able to turn test data on for my user.

So no one else sees the test data...

Either solution is fine.

IS there a way of doing something like this?

Thanks


texts: How can I search for all contacts without email?

texts: To find offline members or incomplete records, I would like to list all contacts that do not have an email address set. Is there a way to search for this?


texts: How to get all active states & provinces from one api call?

texts:
I would like to get all active (i.e., in countryLimit) states & provinces available in my site for use in HTML tag. Can I query for that with a single JavaScript call to CRM.api3?
I've tried:
CRM.api3('Setting', 'get', {

"sequential": 1,
"return": ["countryLimit"],
"api.StateProvince.get": {}
but that just gives me two unrelated arrays. Can I join them somehow?


texts: How can I make civibuild use "Seven" as the default Drupal theme instead of "Bartik"?

texts:
Every time I run civibuild create or civibuild reinstall to create a local Drupal/CiviCRM development site, I find myself running drush vset theme_default seven afterwards so that I get the "Seven" theme instead of "Bartik" (which I find makes CiviCRM easier to use on smaller screens). This step is easy, but I find myself running civibuild frequently enough that I'd like to avoid the extra step in order to make my workflow more efficient.

Is there a way I can configure my local buildkit installation to run this drush command after running civibuild? Or some other way to set the default theme?


texts: Linking events participants and contributions

texts:
We are currently batch importing data from our previous homemade event management system.

So far, we've managed to import contaributions and event's registrations for each user but we are stucked in the process of matching those contributions (event fees) with each event and updating the registration (paid status).

How could we proceed ?

We are running CiviCRM 4.6.2 on WP 4.2


texts: CiviMember Sync with Wordpress usernames

texts:
How can I add a bulk operation to give certain individuals a membership on CiviCRM? for example, from a group
I want to sync those who are given memberships to give them a wordpress user accesss (already configured that).
BUT when I sync them now, the username would the individual's prefix, first name, middle name, last name (ex. Mr-john-joe-smith), which is too long. how can I make the format for the usernames?
what would the default password be for the synced membership users afterwards?
CiviCRM syncs wordpress users to another individual that doesn't have to do anything with their name, email, phone number. How can I fix that before making the bulk operation.


texts:
I am trying to merge 2 contacts (individuals). I search for the contact, select both contacts and select merge. Go through the options. A message saying: Contacts Merged, Name has been updated. Contact ID 1951 has been deleted.

The contacts are not merged and no contacts are deleted.

The log file in ConfigAndLog has this message:

[error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

[code] => -5
[message] => DB Error: already exists
[mode] => 16
[debug_info] => UPDATE  civicrm_account_contact  SET contact_id = 1951 , accounts_contact_id = '2bd64d12-13b0-4188-a708-430aa0bb8f5b' , accounts_display_name = 'Neil T - 1501' , last_sync_date = 20191018151509 , accounts_modified_date = 20191018000000 , accounts_data = 'Array' , accounts_needs_update = 0 , connector_id = 0 , plugin = 'xero' , do_not_sync = 0   WHERE (  civicrm_account_contact.id = 2598 )   [nativecode=1062 ** Duplicate entry '1951-0-xero' for key 'contact_id_plugin']
[type] => DB_Error
[user_info] => UPDATE  civicrm_account_contact  SET contact_id = 1951 , accounts_contact_id = '2bd64d12-13b0-4188-a708-430aa0bb8f5b' , accounts_display_name = 'Neil T - 1501' , last_sync_date = 20191018151509 , accounts_modified_date = 20191018000000 , accounts_data = 'Array' , accounts_needs_update = 0 , connector_id = 0 , plugin = 'xero' , do_not_sync = 0   WHERE (  civicrm_account_contact.id = 2598 )   [nativecode=1062 ** Duplicate entry '1951-0-xero' for key 'contact_id_plugin']
[to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="UPDATE  civicrm_account_contact  SET contact_id = 1951 , accounts_contact_id = '2bd64d12-13b0-4188-a708-430aa0bb8f5b' , accounts_display_name = 'Neil T - 1501' , last_sync_date = 20191018151509 , accounts_modified_date = 20191018000000 , accounts_data = 'Array' , accounts_needs_update = 0 , connector_id = 0 , plugin = 'xero' , do_not_sync = 0   WHERE (  civicrm_account_contact.id = 2598 )   [nativecode=1062 ** Duplicate entry '1951-0-xero' for key 'contact_id_plugin']"]

)

Using latest version of Drupal + Civi


texts: Word Replacement won't replace deceased on contact profile

texts:
We are using the deceased function for both contacts that are deceased or no longer employed. In word replacements we changed "Deceased" to "Terminated or Deceased" - however, on the contact profile page (deceased) still appears, so we added a word replacement that makes "(deceased)" replaced by "(Terminated or Deceased)" but that still didn't change it. I was able to replicate on the D7 Demo Master.
Thoughts?


texts: Contributions: Error Cancelling Contribution The recurring contribution could not be cancelled

texts:
When our users go to the cancel contribution link in their confirmation email and select "Cancel Contribution" they get the following error: Error Cancelling Contribution The recurring contribution could not be cancelled.

Furthermore, if I am logged in and try the same link, I am able to cancel to contribution, but only if I deselect "Send cancellation request to PayPal Pro ?". Otherwise I get the same error.

Any ideas?

CiviCRM 4.7.14 / Drupal 7.53


texts: How to delete/reorder a Contact from a Webform

texts:
I have developped a complex Webform with 4 Contacts.

I want to delete Contact #2 :
I can delete it in the "Webform" Tab, but it remains in the "CiviCRM" Tab : how can I delete it also in the CiviCRM Tab ?

I also would like to create a New Contact #1 (just before the current #1) : How can I do that ?


texts:
I have installed the extension to work with IParl. I am at the stage in the intructions where I want to test whether the API is working.
The instructions https://github.com/artfulrobot/uk.artfulrobot.civicrm.iparl
The instructions you can test it using curl or http. Where would I actually write this script? I do have access the command line on the server but I'm not overly familiar with it yet. Would I create the script in a small file and run it from the command line?
curl -k -L 'https://yoursite.org/civicrm/iparl-webhook'
-d secret=helloHorseHeadLikeYourJumper
-d name=Jo
-d surname=Bloggs
-d email=jo@example.com
-d actionid=1
or, with httpie
http --verify no -f POST 'https://yoursite.org/civicrm/iparl-webhook'
secret=helloHorseHeadLikeYourJumper
name=Jo
lastname=Bloggs
email=jo@example
Thanks for your help.


texts: Confirmation email - providing a WYSIWYG so users can add HTML-ified content?

texts:
How do you go about having HTML in your confirmation email? I don't mean the part that you can edit under Message Templates. I mean the part that you can customized on each event's "Online Registration" tab. It shows as just a plain text box. I need to be able to add some html in that field so that there are some bolded headers in there.

I've included a screenshot of the spot that I mean.

Thanks!

EDIT: I mean a WYSIWYG editor like pretty much every other email box within CiviCRM has. Not hand coding since most people have no idea how to code HTML.

UPDATE: Ok, so I hit another snag on this. On the event's settings page for the confirmation email, I can manually input html. That's not great since the people using it don't know HTML, which means I have to do all the changes. But now I've found a second part of the problem - that same text is copied into the field when a registration is manually entered by an admin or where they finish a registration (like taking a payment over the phone and then marking an incomplete registration as complete). However, that field can't have HTML in it. Any text there gets sent out as plain text, even though the email it is inserted to is HTML. So people see the html written out for that section instead of it being in HTML.


texts: How can I suppress parts of the date in a report

texts:
I am modifying the activity report for use in a dashlet.

The activity date ('civicm_activity_activity_date_time') is currently displayed as November 18th, 2015 2:00 PM

I can change the format of a date using CRM_UTILS_DATE::customFormat, but since this is a report of this current week's activities, what I really want to do is shorten it all by suppressing the month and the year altogether - (and even converting the date to a day)

Is there a CiviCRM way to do this?


texts: How to speed up CiviCRM 4.7 php execution time

texts:
Anyone have an idea of how to speed up CiviCRM PHP execution time ?

I'm an administrator of CiviCRM on Wordpress production set-up, and I find it too slow. I've conducted a little investigation using NewRelic and the whole execution time of (around 2,000ms per request in average) is due to Php execution. All the requests below are CiviCRM's (all URLs are of this type /wp-admin/admin.php?page=CiviCRM)

I'm running an SSD server with 2CPU@3.1Ghz + 7G RAM, with only one Wordpress&CiviCRM running on an Ubuntu 16.04, Php5.6, MariaDB, Nginx, Memcached, and FPM with 25 workers. The whole system is using under 40% of RAM, 10% CPU, for an average load of around 0.3. I find it hard to believe that the server is under-sized.

Thanks for any input on that issue !


texts: "Unsupported html-element" error when trying to create or edit a contact record after upgrading to 4.7.13

texts:
I upgraded from 4.5.4 to 4.7.13 (on Drupal); I didn't receive any errors during the upgrade process, but now when I try to create or edit a contact, I get an unsupported html-element, similar to what was reported at After upgrade to 4.7 on Drupal 7, Can't edit a contact.

The backtrace looks like this:

#0 /var/www/drupal/sites/all/modules/civicrm/CRM/Contact/Form/Edit/Individual.php(77): CRM_Core_Form->addField("prefix_id", (Array:3))
#1 /var/www/drupal/sites/all/modules/civicrm/CRM/Contact/Form/Contact.php(755): CRM_Contact_Form_Edit_Individual::buildQuickForm(Object(CRM_Contact_Form_Contact))
#2 /var/www/drupal/sites/all/modules/civicrm/CRM/Core/Form.php(548): CRM_Contact_Form_Contact->buildQuickForm()
#3 /var/www/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#4 /var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Contact), "display")
#5 /var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Contact), "display")
#6 /var/www/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#7 /var/www/drupal/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#8 /var/www/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(286): CRM_Utils_Wrapper->run("CRM_Contact_Form_Contact", "New Contact", (Array:1))
#9 /var/www/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#10 /var/www/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#11 /var/www/drupal/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#12 [internal function](): civicrm_invoke("contact", "add")
#13 /var/www/drupal/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#14 /var/www/drupal/index.php(21): menu_execute_active_handler()
#15 {main}

Additionally, when I disable displaying the prefix (in Administration -> Option Groups -> Contact Edit Options) the top error line becomes:

#0 /var/www/drupal/sites/all/modules/civicrm/CRM/Contact/Form/Edit/Individual.php(77): CRM_Core_Form->addField("first_name", (Array:0))

Obviously, I don't want to disable the first name as well.


texts: DB Error: IP address hard-wired with MySQL user?

texts:
I have a local windows "mirror" using XAMPP of my live Wordpress 4.7.2 + CiviCRM 4.7.14 setup. I wanted to use the windows version to test exactly how deduping worked using Contacts > "Find and Merge Duplicate Contacts". I tried a supervised merge of just one contact (name and address dedupe rule) to see exactly how it would work. I got a DB error when I pressed "Merge and View Results." Complete error shown in ConfigAndLog is:

Feb 03 12:56:20  [info] $Fatal Error Details = Array

(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => UPDATE IGNORE civicrm_value_community_planning_area_5 SET entity_id = 1702 WHERE entity_id = 3238 [nativecode=1449 ** The user specified as a definer ('sdcbc'@'173.236.128.0/255.255.128.0') does not exist]
[type] => DB_Error
[user_info] => UPDATE IGNORE civicrm_value_community_planning_area_5 SET entity_id = 1702 WHERE entity_id = 3238 [nativecode=1449 ** The user specified as a definer ('sdcbc'@'173.236.128.0/255.255.128.0') does not exist]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE IGNORE civicrm_value_community_planning_area_5 SET entity_id = 1702 WHERE entity_id = 3238 [nativecode=1449 ** The user specified as a definer ('sdcbc'@'173.236.128.0/255.255.128.0') does not exist]"]

)

The error seems to be that the MySQL user 'sdcbc' does not exist. The odd thing is the IP address associated to the MySQL user 'sdcbc'. In my local setup, this should be 'sdcbc'@'localhost' or at least it should show 127.0.0.1 instead of 173.236.128.0 with a mask. Not coincidentally, I suppose, the IP address for our live MySQL server is 173.236.135.189. How is that hard-coded address getting into my local version? All the mysql pointers in my local civicrm.settings.php point to sdcbc@localhost. Whenever I update my mirror (live .> local), I'm also careful to clear cache (delete templates_c/ folder ConfigAndLog/Config.IDS.ini) and  and update paths, etc via i.    http://sdbikecoalition.localhost:8080/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1 and iii.  http://sdbikecoalition.localhost:8080/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1. Note also, that the table that is generating an error is a custom field, 'civicrm_value_community_planning_area_5', if that is also a clue.

As a postscript, I ran the merge on this one contact on our LIVE instance and it worked just fine. Somehow, some setting or file is retaining the 173.236 from our live MySQL database. I completely searched our MySQL database for the string '173.236' and could not find it anywhere. This seems to be an issue with trying to mirror one site to another.


texts: CiviVolunteer permissions to allow registered (Drupal) users to view assignment details

texts:
I've just set up CiviVolunteer, and set permissions for both anonymous and authenticated users to sign up for volunteer opportunities. (That is, they have Drupal permissions for Access AJAX API and CiviVolunteer: Register to Volunteer.) I have set up the user Dashboard to show "Assigned Activities" and authenticated users can see their volunteer assignments listed. So far, so good!

The "Your Assigned Activities" section begins with the message, "Click on the activity subject for more information." However, when I click on an assignment subject while logged in as a non-administrator role, I get the "Access denied. You are not authorized to access this page." error.

Where can I set the permissions for users to view more information about the assignment, as suggested by the note and obvious links?

Also, is there any way for authenticated, non-administrator users to change their assignments? (Either through the Dashboard list of assigned activities, or through returning to the CiviVolunteer sign-up page and seeing a list of assignments that they already have?) This doesn't seem to be part of the CiviVolunteer permissions, but I'm wondering if there is something else that would do. Note that my users already have Access CiviCRM permissions.

Thanks!


texts:
I have created an email template for when I send out my invoices. I can't seem to integrate it into the invoice email.

When I send out my invoices by email in CiviCRM I have the option to add email content as in the body of my email. I would like to use a template that I have created for this email being sent out with the invoices. The templates as you know can be added when a person has registered for an event but I can't seem to use a template for sending out my invoice. The invoice is an attachment, so I don't want to write the body of the email every time.


texts: The contribution payment verification page has lost the site theme styling

texts:
In general, what would cause a contribution verification page to lose the current theme styling? This is the page that appears after our initial membership contribution page when the user presses Submit after selecting PayPal or Pay by Check. The verification page has completely lost the header, footer, everything related to the current wordpress theme. The page still functions, but looks really strange compared to the first page.

Edit: In fact the confirm.tpl template based page is being rendered without head or body tags, it's just an html fragment. This is obviously why there is no theme on the page. As a test I switched to another theme and the page renders correctly -- so it has something to do with the theme.

I was able to get some generous support from the theme vendor. So far there is no fix for this. Confirm.tpl doesn't load the page header, and the vendor needs to know where this usually occurs. Quote:

  Ok do you have any support with this plugin [CiviCRM]? Because the template you
  spoke of doesn't add the header. I assume they are using some kind of
  wrapper but looking at the files in the plugin they are doing this in
  a non-traditional way. What I would need to know is how they are
  forcing in the template and on what hook? For example if they are
  using a template redirect to force their template in - where is the
  template that calls in the normal wordpress functions like getting the
  header.


texts:
I'm upgrading an installation from Drupal 6.37 to Drupal 7 and also the associated civicrm module(3.3.5).  My problem is I'm not sure of a reasonable upgrade path. I've looked through the version documentation, which I find quite confusing and at times contradictory.   I have full command line access to both the database and the ubuntu server via ssh.

I've found these instructions useful, although a little dated now.

If I were to use 4.2.8 a choice exists between a version for Drupal 6 and Drupal 7.
With the impending demise of Drupal 6 I suspect I won't be the only person facing such a decision.

Can anyone advise on a reasonable upgrade path?


texts: Problem with CiviCRM registering a new Wordpress user

texts:
I'm running WP 4.9.7 Multisites, CiviCRM 5.3

I've created a profile with the information I want to gather from people. I've enabled the option to create a Wordpress user.

I go to the contribution page containing the profile, and it shows me all the appropriate fields to create a new WP user, as well as all the other profile fields.

I go through the process, and it all seems to work. It inserts an entry in CiviCRM. But it doesn't create the Wordpress user... Not even a pending user.

Have I missed something somewhere?

Thanks


texts: How do I get csv file of Gmail contacts to import?

texts:
I am trying to import a Google Apps Contacts list in csv file format. I go through the steps; it goes through the motions of importing the file, but no contacts are added.
We're running CiviCrm 4.7.8. It's a trial run on a friend's Wordpress account. We get a System Status:Error message that everything's not configured yet e.g. No Cron Running.
Any ideas?


texts: Retrofitting languages into English-based Install

texts:
I've been trying to work with CiviCRM 4.7 on Wordpress 4.7 in Bahasa Indonesia, and have been struggling a bit. I came across this post: localization on wordpress, which was somewhat helpful.

My quandary is this: I (like a lot of folks it seems) installed CiviCRM in English, and later went back to make it a multi-lingual site, and added the l10n and sql files for local languages. After doing some research, it seems as though the consensus is to install it in the local language from the get-go. However, now that I've already installed in English, and want to add a language, what is the best way forward?

I understand that one reason behind starting localization from the install is that the sql files help to populate option groups, message templates, etc. when CiviCRM is freshly installed. Is there some way, short of a total reinstall to essentially do a "refresh" so that these settings can be copied into the database?


texts: Our website is hosted on Drupal 7 but is tied to our database in civi 5.14. We are experiencing a surge in new registrations which require people to fill out a full page of information that then gets tied into our database. This is causing massive delays on our site. How can we optimize civi to improve the speed of our site or reduce the strain?


texts: How to Remove Old Events from the Managing Events Tab

texts:
I have eight events under my "Manage Events" Tab on Civi. Three of them are upcoming, but five of them are left over from 2012. When I try to put an end date to the event, so they will be cleared from my this page, but not deleted, I am given this error blocking message:

"Sorry an error occurred
We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.

Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.

Error type: Could not find a valid session key."


texts: How can Members download their own Membership Certificate/Card?

texts: This is a request I get quite often. Below is my favourite solution for it.


texts: non-asci characters ending up in database

texts:
Today we spent about 2 hours bashing our heads trying to get a string compare to work so we could run a query against contact sub type while setting up a new participant public listing.

We started realizing what was going on when the string length getting returned was 7. When it should have been 5, for Child. Took a look at it in the command line and saw this:

Anyone know why they might have ended up in the database? And how to avoid them showing up again?

Thanks!

I think this was also the problem behind another question I asked here previously.

drupal 7
civicrm 4.6.11


texts: Where to report Gitbook error (Problem loading page)

texts:
When I try to visit CiviCRM's GitBook I am forwarded to https://docs.civicrm.org/user/en/4.6 with the following error:

Who should I report this to?


texts: Supplemental address should be searchable

texts: I want the supplemental address fields to be searchable under at least "advanced search". Right now the text entered in "supplemental address" can never be used for searching and retrieving. how do i go about it?


texts: Report Plus: Issue with filtering campaigns

texts:
We've found an issue with Report Plus. The extension doesn't show the choosed campaign (via filters) in the results. So if we choose to filter for Campaign A, it shows another different campaign. This happens for all campaigns.
We use the latest version of Report Plus.

Does someone else have the same issue or has any idea how to solve it?
Thanks in advance!


texts: Rounding differences between Contribution and Bookkeeping reports

texts:
I am using Drupal 7.66 and CiviCRM 5.10.4. There is a small difference between the total of a Contribution report and a Bookkeeping report using the same filters and therefore intended to produce an identical result. However under certain circumstances there are small rounding errors between the two reports.

Take the following example. A payment of $155.00 is paid via a payment gateway in three monthly instalments. The first instalment is $51.68 and shown in the contribution report correctly (as an aside the next two payments will be $51.66).

However in the Bookkeeping report the first payment is shown as $51.67 which is the rounded up value of $155.00 divided by three which gives $51.66 recurring. In the following month the contribution report will no doubt show the payment to be $51.66 and the Bookkeeping report will display $51.67.

This error also finds its way into the Extended Reports extension. I realise that this is not a big issue but it would be nice if the reports displayed identical totals.


texts: How can I create a mailing report with drupal views?

texts: I would like to give access mailing report to one of my user that was sent to specific GROUP. from drupal permission I am not able to figure out an option to facilitate that. Therefore drupal views might be a way to go. Has anyone tired to create a drupal views for mailing report?


texts: Authorize.net not recording processor fees

texts:
I noticed today that Authorize.net is not recording the payment processor fees. Is there a way to get the civiCRM payment processor to record such a fee so that we can record the data? I have found some information for paypal, but nothing for Authorize.net

I found this odd since the Authorize.Net is a core supported payment processor.


texts: How to register for event without an email address?

texts: Sorry for such a brain dead question but we have people that want to register for our events that have no email address. Hard to imagine in this day and age but it happens. A lot of our contacts are old and not up with all the newfangled internet stuff. I have set up an event registration form that works very well for most, but requires email address. I have googled "civicrm register event email address" and not found anything specific on this issue.


texts: Is there a way to migrate the saved Import/Export Mappings to a different CiviCRM installation? It seems there is no way to export them. I already tried copying the .php files located at /bin/migrate, but the settings did not show up when I tried to import something in the new installation.


texts: Navigation menu is displayed under footer

texts:
There was Drupal update (7.67) and CiviCRM update (5.13.5), main navigation menu got lost and it is now in the footer...

I've already did cashe cleaning and menu rebuild. Nothing changed.
Did any one have similar problem?


texts: Contribution report set up to email weekly, I have added CC email adresses and need to check if this works now and not wait a week


texts: Deleting the Upload Folder at Specific Times

texts:
When we create an activity, we sometimes add files to these activities. The added files are mostly jpg, png or pdf files. However, these files have a single use. In other words, I do not need to keep the attachment of the file after reaching the assigned activity by e-mail.

For this reason, I want all the data in the folder to which the files are added to be deleted automatically at certain times. Can I do this from the Scheduled Tasks area? If so, how can I do it. Can you give detailed information.


texts: DB Error: constraint violation on anonymous user contribution/membership registration after 5.8.2 -> 5.9.0 update

texts:
I upgraded two Joomla sites from 5.8.x to 5.9 and one of them now gives an error for anonymous contributions or membership registrations:

Error:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`zzz`.`civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_acl_contact_cache ( user_id, contact_id, operation ) VALUES(0, 0, 'View') [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zzz`.`civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_acl_contact_cache ( user_id, contact_id, operation ) VALUES(0, 0, 'View') [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zzz`.`civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_acl_contact_cache ( user_id, contact_id, operation ) VALUES(0, 0, 'View') [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zzz`.`civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]

)

This matches a similar issue after 5.9.0 upgrade: DB Error: constraint violation on anonymous user event registration after 5.8.2 -> 5.9.0 update

I have Mail enabled. The error doesn't occur when logged in so I've matched and then enabled more permissions than the other site which works, but it makes no difference.


texts: Webform: recommended permissions handling when using existing contact feature

texts:
I'm wondering how other developers configure permissioning for webforms where related contacts are shown. Here's the setup:

webform is configured to display two contacts -- the logged in user and a related org
the "existing contact" element is used for both contacts. the issue arises for the related org contact
we are using the static widget and the option to use contact id from url

However, when cid2=# is passed in the URL, it doesn't load the organization contact unless the logged in user has the "edit all contacts" permission. I understand I could flag the relationship as permissioned and use the relationship ACL extension, but I don't really want to universally grant the user the ability to edit the related contact -- just grant access in this webform. And I definitely don't want to grant the edit all contacts permission.

Any suggestions on ways to handle this? Should I just modify permissions via hooks on this form? It seems like this would be a common use case so I'm wondering if there's something in the webform integration that I'm missing.


texts: How to add and remove tag based on the value of a custom field using civirules

texts:
I have a YES/No radio Custom field for individual.
When the custom field is set to Yes, I would like to tag the contact. And when NO is selected, I would like to remove the tag.
I have managed to update tag to YES by following rule:
Linked Trigger: Custom Data on Contact (of any Type) Changed
Linked Condition(s):Field Value Comparison  Contact.custom_273 = 1 (basically saying when YES is selected)
Linked Action(s): Add Tag to a Contact
But when I use the similar pattern of rules with "Contact.custom_273 = 0" I never managed to get this working. Did anyone managed to get similar rule to wok? Thanks in advance.


texts: Error loading module file () - Wordpress

texts:
I have just upgraded a CiviCRM install on Wordpress. Went from Civi 4.5x to 4.6.5. The site uses L10n (EN / FR).

I had two error messages when I first finished the upgrade. One was:

"civicrm Unknown extension: net.ourpowerbase.sumfields"

That one seems to have resolved itself.

The other is:
"Error loading module file (). Please restore the file or disable the module."

This error appears both in the admin area of CiviCRM and on the front end where profile forms are used.

I have no idea where to start looking to fix this! I found one post about drupal, but that didn't help.

Any assistance would be greatly appreciated.

Thank you.


texts: CiviMail Reports is not tracking email opens

texts:
I am using civi 4.7.29 on Wordpress 4.9.4

I noticed that civimail reports is not tracking the email opens after multiple sends.  It is just showing "0". In the screen shot, you can see where it is showing click-throughs but not opens.

The checkboxes for tracking opens and click-through are set.

In the email source, I found this URL  https://mysite.org/wp-content/plugins/civicrm/civicrm/extern/open.php?q=66

That URL takes me to 404 Error Page.

The permission are:

open.php 755

civicrm/civicrm/extern/ 777

civicrm/civicrm/ 755

civicrm/  755

Does anything look wrong here?
Thank you.


texts: How to check if a contact has an active membership in a smarty template?

texts: Is there a variable that one can use in smarty in a message template to simply determine if a contact has an active membership?


texts:
I'm working on a file upload of an image with a registration form. The file is being passed to PHP correctly, and I can check its properties in the $_FILES variable. I used the API Explorer to get the code example below. This question (Uploading files through the API) touches on this, but the answer just directs the person to the API Explorer.

$result['attachment'] = civicrm_api3('Attachment', 'create', [
    'name' => $name,
    'mime_type' => $_FILES['image']['type'],
    'entity_id' => $result['contact']['id'],
    'field_name' => 'custom_3',
    'content' => $_FILES['image'],
]);

The error I receive is:
Mandatory key(s) missing from params array: 'id' or 'content' or 'options.move-file'
but I have no idea what this means. content is set in the params. This API call happens after a working sequence of creating a Contact, Address, Email, Websites, and more for the signup. I can find no other guidance on completing this.


texts: Install CiviCRM Buildkit on windows xampp

texts:
how to install buildkit cvcrm on windows?
I've set up xampp, drupal 7.x and civicrm 5.2.x

i just have no clue what to do with the buildkit zip file which I've downloaded from here https://github.com/civicrm/civicrm-buildkit

please advice

thanks


texts:
on Drupal 7.67 + CiviCRM 5.32.2 I do can see the dashlets but I lost ability to add and suppress them, so I guess Ajax doesn't work any more. It stopped working with the upgrade to 5.32.2 before it was functioning.
Clicking on the cross also has no impact but I can move them once added on the dashboard.
Changing the jquery version in theme settings doesn't help (I've tried various versions from 1.4 to 3.1).
Is there a special setting in CiviCRM or is it a bug in 5.32.2?

These are the message in the javascript console:
Uncaught SyntaxError: expected expression, got '}' js_tirzwVKQe_kXpvFPxNVA-vmv7H54qthEMinEoehf1m8.js:12:51
else this._+='L'+(this._x1=t)+','+(this._y1=n);else},arc:function(t,n,e,r,i,a){t=+t,n=+n;var l=(e=+e)*Math.cos(r),f=e*Math.sin(r),u=t+l,c=n+f,s=1^a,o=a?r-i:i-r;if(e<0)throw new Error('negative radius: '+e);null===this._x1?this._+='M'+u+','+c:(Math.abs(this._x1-u)>1e-6||Math.abs(this._y1-c)>1e-6)&&(this._+='L'+u+','+c),e&&(o<0&&(o=o%Ua+Ua),o>Dp?this._+='A'+e+','+e+',0,1,'+s+','+(t-l)+','+(n-f)+'A'+e+','+e+',0,1,'+s+','+(this._x1=u)+','+(this._y1=c):o>1e-6&&(this._+='A'+e+','+e+',0,'+ +(o>=Fa)+','+s+','+(this._x1=t+e*Math.cos(i))+','+(this._y1=n+e*Math.sin(i))))},rect:function(t,n,e,r){this._+='M'+(this._x0=this._x1=+t)+','+(this._y0=this._y1=+n)+'h'+ +e+'v'+ +r+'h'+-e+'Z'},toString:function(){return this._}};function ri(){};function gt(t,n){var r=new ri;if(t instanceof ri)t.each(function(t,n){r.set(n,t)});else if(Array.isArray(t)){var a,e=-1,o=t.length;if(null==n)for(;++e<o;)r.set(e,t[e]);else for(;++e<o;)r.set(n(a=t[e],e,t),a)}


texts: Pay later option on 4.7.2 using Stripe doesn't work - throwing error

texts:
Have events set up - working fine in 4.6.x updated to 4.7,2

Getting the following error - when hitting continue on event registration
Payment Error Response:
Error: The card object must have a value for 'number'.

Thoughts - Suggestions ?

Drupal 7.4.3


texts: How to remove the "Second name" field in the billing form, I can not find the path to reach this form and modify it. Thanks


texts: Mailing only works when executed manually, not scheduled

texts:
I am trying to executed a job to send out a mailing via CiviMail. This works when I do this manually, but fails when scheduled:

permission check failed for Group/get call; insufficient permission: require access CiviCRM

What permission should I add to which user?
I am using Drupal 7 cron.


texts: Autofill price field based on last selected option

texts:
I have a membership form which uses a price set with membership types and a donation price field. I want the donation price field to be auto-filled based on the last selected price field option (just like how the membership field is auto-filled depending on which membership the user purchased last).
Before I look into how the memberships field does it, has anyone made an extension for this? Or maybe, has a piece of code that I can copy to make this happen?


texts:
I need to find out in php if 'the current user' has recently renewed membership (or just signed up as a new member).

I don't think I can get data about renewal from the Membership entity. The 'Join date' seems to be the same as the 'Start date'. So for renewal, I'd have to look at Activities of the type renewal.

I hoped I could do this with the ActivityContact entity, but it
doesn't allow me to filter on activity type.
I hoped I could do this
with the Activity entity, but it doesn't allow me to filter on the
'target_contact', or 'assignee', or whatever it's called.

So .. do I need to join api calls - how would I do that ? - or is there another way ?


texts: What is the review process for automatic distribution of Extensions?

texts:
Some extensions are eligible for being distributed automatically, which means that you can add them via the CiviCRM UI.

This page lists the criteria that needs to be meet for automated distribution and we have an extension ready for review.

Will I need to ask a CiviCRM site administrator to do the (manual) review? Or will they automatically be noticed?


texts:
How can I delete all CiviCRM Campaigns without having to delete one at a time?
I have over 500 of them.
Is there a way to do this with the API explorer?


texts: Error during event registration linked to GDPR extension

texts:
As per title, after a user registers for an event and goes through the confirmation screen, they are treated to the following error:

  Notice: Undefined index: comm_pref_in_thankyou in
  /opt/bitnami/apps/wordpress/htdocs/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.gdpr/CRM/Gdpr/CommunicationsPreferences/Utils.php
  on line 507

  Notice: Undefined index: comm_pref_in_thankyou in
  /opt/bitnami/apps/wordpress/htdocs/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.gdpr/CRM/Gdpr/CommunicationsPreferences/Utils.php on line 508

As you can see in the screenshot, their details are registered and it goes through fine in Civi's backend, we are just getting this error as well which is seemingly linked to the GDPR extension.

Due to running a hosted system, I am unable to check the PHP file but I am speaking to our host regarding this as well. I am asking here in the hopes someone has seen this before and knows what the error is expecting.

Running on Wordpress 5.3.2 with CiviCRM 5.21.1
The GDPR extension is version 2.8


texts: Can I configure Contribution Dashboard so that it summarizes / shows only specific payment types (e.g. Donations, Membership fees), but not the others (Event Fees etc.)?


texts: I wonder if there's a way to get a report on a mailing list's subscription activity, showing signups and unsubscriptions.  I don't see this option on the activity report and none of the Mailing report templates come close.  I know that the information is available by looking at contact records.


texts: Trouble understanding how Profiles and Smart Groups are supposed to work together

texts:
Fist off, I think CiviCRM is awesome!  As an erstwhile systems software programmer from the nineties who saw the birth of the World Wide Web while working for major corporations and governments it is truly heartwarming to see how far the OpenSource movement has come!

I'm working to set up CiviCRM for a new food Co-op, and I admit that despite reading the User Guide pretty thoroughly I'm struggling to understand how Profiles and Smart Groups are supposed to work together.  I've set up profiles for Donors, Volunteers, Newsletter recipients, Members, and Founders (members who also sign up for contributing founders' credit to help open the co-op.)

I'm probably missing something glaringly obvious (note I said systems software programmer, user interfaces have a tendency to escape my understanding,) but I guess I'll just describe what I'm trying to do and how, and hopefully some kind soul will speak up and say "Whoa, whoa you're way overthinking this, this is how it's done..."

I am trying to set up smart groups so that our community outreach people can email the various groups as appropriate.  On the surface it sounds like I need a Founders SG, a Members SG which is a parent of Founders, a Volunteers SG, and a Newsletter SG which is a parent of Volunteers and Members.  That way, an email to the Newsletter group will go to everyone, but an email to the Volunteers SG will only go to volunteers.

However, I've already learnt the hard way that SGs, unless they are defined via clear search criteria, aren't as "authoritative" as they could be.  Twice now I've discovered that all my contacts have somehow ended up being members of a SG.  This may have something to do with the parental inheritance thing, however if I define a SG with a clear rule, it does seem to stick in a meaningful way.  Of course, if I do that, then setting the "add to smart group" field of, say, the Volunteer profile to "Volunteers" will only remain valid until the Volunteer smart group (which selects based on a relinfo::Volunteer = Yes criteria) updates itself, which is to say, not very long.

Also, I can't seem to figure out how to associate profiles with automatically set fields.  It feels awkward to create a volunteer signup profile with a "check this box to signup to volunteer" field as opposed to just having a hidden field with the value automatically set.

So my current thinking is, that I need also to also create SG's for Volunteer Signup, Founders Signup, Newsletter Signup, and have the associated profiles add new contacts to those groups.  Then I can periodically run a cron job to set the appropriate relinfo:: fields for contacts in the signup groups (thence they will be members of the non-signup groups) and remove them from the signup groups.  This already is starting to seem a bit complex, thus my request for input :)

However, because the update job will likely only run once a day, there's a period where someone can have signed up as a volunteer, for instance, and yet not be in the Volunteer SG.  Given the slight oddness around group parentage stuff, I'm concerned just making Volunteer the parent of Volunteer Signup will muddy the waters, and that it would be clearer to create Volunteer Email SG, parent of both Volunteers SG and Volunteer Signup SG, etc. for the Newsletter and Founders' Credit SG's  Members seemingly isn't as much of a concern because if people submit that profile they are automatically marked as Members, and when people sign up as Founders they also are completing the Members Profile and will thus satisfy that criterion.  However, Founders it is the resulting Founders' Credit contribution that they would be the basis for adding them to the Founders SG.

So, is this the way it's done, or am I missing something?  From my perspective this would be many times easier if I could just silently set fields as part of profiles.

Thanks for your attention :)


texts:
I am on Civi 4.7.6 / Drupal 7.5

I have not been able to record any new phone numbers for some days (via Webform Integration).

I realize that I have lost a number of log_civicrm_... tables (those alphabetically beyond ..._payment_processor_type), and this can be the reason why.

Thus, I would like to disable logging (via Administer > System Settings >Misc (...) > Logging), but I get this error : "Save failed : DB Error : unknown error".

I assume that this error is due to those missing tables.

How can I get out of that ? (I am not a programmer)

...

As a matter of fact, I have an other Test Civicrm, where logging is disabled, and when I want to enable it, I get the same error, and there is no enabling.

Anything in relationship with Drupal ?

BTW, I have all privileges on thoses DBs


texts: "Empty needle" error when exporting from Advanced Search results

texts:
I get the following Warnings when export contacts after performing an advanced search:

Blockquote Warning: strpos(): Empty needle in /home/iskcohdx/public_html/crm/wp-content/plugins/civicrm/civicrm/CRM/Export/BAO/Export.php on line 600
Blockquote Warning: Cannot modify header information - headers already sent by (output started at /home/iskcohdx/public_html/crm/wp-content/plugins/civicrm/civicrm/CRM/Export/BAO/Export.php:600) in /home/iskcohdx/public_html/crm/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php on line 833

What could be the cause of this and how to fix this issue?
I'm using CiviCRM 4.5.3 on Wordpress.


texts: How do I rename an activity used in CiviCase?

texts:
I have this problem on CiviCRM 4.6.8 with Joomla, and reproduced on the demo server.

If I rename an activity (from Administer->Customize Data->Activity Types) used for a Timeline within CiviCase, I can't figure out how to get the activity label to update in the backend or frontend of CiviCase.  Even if I remove the activity from the timeline and try to re-add it, it uses the original name.

Is there any way to rename it without deleting the Activity type and creating a new one?


texts: When exporting data from CheckBox field, can value of be different from what is displayed?

texts:
When exporting data from a custom CheckBox field, can the value of the data exported be different from what is displayed?  For example, the checkbox Multiple choice is labeled "Asked"  but I would like the data value exported to be 1.  I tried to change the Value to 1, but it is still exporting "Asked"

Thanks!!


texts: Fixed - Why can't I display some Civi contact fields through CivCRM Entity in Drupal 8?

texts:
I've got a development site running using Drupal 8.7.7/Civi 5.17.5 and CiviCRM Entity. I want to set up some Views to display Civi data. Some fields are being displayed fine (e.g. first name, last name), but other fields from the contact record appear to be empty, when I know, by looking at the CiviCRM contact records, that these fields are populated.

As an example, I want to display the Birth Date field. I have nearly 200 records where this field is populated.

If I look at the CiviCRM Entity display of the contact record (e.g. www.example.com/civicrm-contact/xxx (where xxx is the contact ID) I can see some of the fields in the contact record but not Birth Date, despite the fact that www.example.com/admin/structure/civicrm-entity/civicrm-contact/display indicates that this field is not disabled.

How can I get CiviCRM Entity, and Views to display this field correctly?


texts: Disable select fields in a drupal webform

texts:
I've created a webform for reviewers to make a decision on a scientific abstract which is a CiviCRM activity.

Their review is a second activity in CiviCRM, all linked within a case.

All is working as needed using the activity1=[id] parameters in the url.

However, I want reviewers to be able to see the details of the abstract activity to make their review decision, but not change them. Text fields / areas are simple as webforms allow you to disable (see image below), but select fields, this option doesn't appear.

Is there a way I can disable select fields / make them uneditable but visible?


texts: Webform-CiviCRM and the "my billing address is the same" checkbox

texts:
On a core contribution page, if you add an address profile at the top of the page, a checkbox appears allowing the user to indicate that their billing address is the same:

On a Webform-CiviCRM form, my understanding is that the payment page is always a separate page and this box is not automatic. Is there any way to include a checkbox like this?


texts: "API error: DB Error: constraint violation" when installing Stripe extension

texts:
With debugging and back tracing turned on, I receive the following error on our Drupal 7.38 and CiviCRM 4.6.8 site when trying to install the CiviCRM Strip 1.9.1 extension:

Exception: "API error: DB Error: constraint violation"

#0 …civicrm/CRM/Core/ManagedEntities.php(265): CRM_Core_ManagedEntities->onApiError("Dashboard", "create", (Array:6), (Array:4))
#1 …civicrm/CRM/Core/ManagedEntities.php(168): CRM_Core_ManagedEntities->updateExistingEntity(Object(CRM_Core_DAO_Managed), (Array:4))
#2 …civicrm/CRM/Core/ManagedEntities.php(141): CRM_Core_ManagedEntities->reconcileEnabledModule(Object(CRM_Core_Module), (Array:3))
#3 …civicrm/CRM/Core/ManagedEntities.php(122): CRM_Core_ManagedEntities->reconcileEnabledModules()
#4 …civicrm/CRM/Core/Invoke.php(403): CRM_Core_ManagedEntities->reconcile()
#5 …civicrm/CRM/Extension/Manager.php(246): CRM_Core_Invoke::rebuildMenuAndCaches(TRUE)
#6 …civicrm/CRM/Admin/Form/Extensions.php(195): CRM_Extension_Manager->install((Array:1))
#7 …civicrm/CRM/Core/Form.php(345): CRM_Admin_Form_Extensions->postProcess()
#8 …civicrm/CRM/Core/StateMachine.php(164): CRM_Core_Form->mainProcess()
#9 …civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Extensions), "next", "Next")
#10 …civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Extensions), "next")
#11 …civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "next")
#12 …civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("next")
#13 …civicrm/CRM/Core/Page/Basic.php(395): CRM_Core_Controller->run()
#14 …civicrm/CRM/Core/Page/Basic.php(174): CRM_Core_Page_Basic->edit(1, NULL)
#15 …civicrm/CRM/Admin/Page/Extensions.php(125): CRM_Core_Page_Basic->run()
#16 …civicrm/CRM/Core/Invoke.php(312): CRM_Admin_Page_Extensions->run((Array:3), NULL)
#17 …civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#18 …civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#19 …civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:3))
#20 [internal function](): civicrm_invoke("admin", "extensions")
#21 /home/oursitename/www/www/includes/menu.inc(519): call_user_func_array("civicrm_invoke", (Array:2))
#22 /home/oursitename/www/www/index.php(21): menu_execute_active_handler()
#23 {main}

On the extension page, it appears as if the CiviCRM Strip extension has installed, but Stripe is not available as a payment processor.

Is anyone able to give guidance on next steps to troubleshoot?


texts: Adding popup info via CRM.help() - doesn't quite work

texts:
I am trying to add some end user popup help text for some fields in a profile.  I have looked at several examples in core and extensions and have tried to follow them as examples.  I have an extension already loaded where I am (attempting) to manage the code.  I have added the anchor html and "onclick" javascript into the field's pre-help text for the custom field.

The popup works, of sorts.  The popup appears, along with the title supplied in the anchor tag, but the actual content of the popup does not.
    &nbsp;

The .hlp file has IDs named correctly AFAIK, as what-is-this-title and what-is-this.  What am I missing?


texts: How to get list of memberships whose start date is between a date range?

texts:
I am trying to filter a list of memberships based on start dates. My filter consists of From date and To date. I want to get a list of memberships whose start date is between From and To date.

I am using a angular page with wordpress setup. Here is what I have tried so far with no success.

var membership = crmApi('Membership', 'get', {
          status_id: 2, // get memberships with status Current
          start_date_low: "2016-08-13",
          start_date_high: "2017-08-12",
          return: ['contact_id', 'membership_name', 'start_date', 'end_date', 'source']
        });
return membership;


texts: CIVICRM Create API for event participate

texts:
I create an event. I need to create an API for Event Participate(Registration) page. I also retrieve all participates users data via API too. Please let me know .
I just go API v3 . And see there is Event in Entity fields. I choose it. I choose get .I see there is return form too.I need all participates information . what their address,nationality and some customs fields too. I see there is create function but I don't know how can I add fields.please let know.


texts:
I recently installed Civi on WordPress 4.8. Upon wanting to manually upload an extension to the extension directory, I saw that the "files" directory is empty.

In the installation guide it said to create a files folder within /plugins/files.

I see the resource URL for extensions is where this should be. I've not seen this happen on other installs of mine, so wondering if others have seen this.

Also, I have downloaded the native extensions and they are working; where are those located?


texts: Activities are not showing under Activities tab in contact record

texts:
I'm not sure exactly when this happened but the activity list has stopped showing up in the Activities tab for all of my contact records. The number of activities seems to be accurate and I can add activities but they simply do not show up.

I ran patched the Activities.php file and unchecked 'Enable CiviMail to create activities on delivery' as per this page. I also emptied the contents of template_c and then emptied the Drupal cache but none of the steps helped.

I'm running Drupal 7 and CiviCRM 4.4.3. Any thoughts on what might be happening?


texts: How to avoid a duplicate membership for same contact

texts: When I connect a contact to same membership type, the system displays a warning message that it is a duplicate membership for the same contact, but still allows to to perform the action. Then I get two active records for the contact with same membership. How can I avoid it in such way that the system will block the ability to create more that one active record for same membership type?


texts: Minimum permission set to enable Manage Contribution Pages?

texts:
What is the minimum set of permissions that I need to grant to a user to allow him to access 'Manage Contribution Pages'? The only permission that seems to grant access to this page is 'administer CiviCRM', but that then enables administration of essentially the entire application.

Thank you.


texts: Using CIVICRM to manage a Fundraising Dinner

texts:
We run a fundraising dinner once a year, approx 400 people, mainly couples.
what would be the best way to
a: set up an event that we can enter couples as contacts (we have to write to them post dinner)
B: is it event or campaign
C: report that shows total raised, amount outstanding and amount paid
D: report as C but showing names

Thank you and sorry if its simple as new to this


texts:
We have a smart group which returns 1,521 records.  One contact which ought to be appearing in it isn't.  When I go in to the smar group settings there is an unfinished selection line, when I delete this the search then gives 1,552 records, including the one that we saw was missing.  I then take the action of updating the smart group but when I go back into the manage groups and click on contacts it is once more back at 1,521 with the one we want missing.  It is very possible that there is a step that I should be taking which I am not.  Can someone point me in the right direction?

I am running Civicrm 5.13.4


texts: When you have two items with tax, the total tax amount is calculated for the last item only. Has anyone faced this issue? Is there any configuration I am missing?


texts: Statement violates GTID consistency error when creatng new user account in Drupal

texts:
I’m running CiviCRM 5.16.2 against Drupal 7.67 on 1&1 Ionos hosting. MySQL version is 5.7.27.

When I create a new account in Drupal via the “Create New Account” button on the login screen, once I’ve completed all the fields and press “Create new account”, I get a yellow panel with the following error.

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error

Then this in the white section underneath:

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /xxxxxxxx/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

The user account appears to have been created when I go to the People section in Drupal. I have tried this on a completely fresh installation/database and the same thing happenes.
I’ve turned on debugging and have got the following further info…

Database Error Code: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions., 1787
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE `civicrm_tmp_e_dedupe_97911c832652885b9b1c932dfbe6530d` (id1 int, weight int, UNIQUE UI_id1 (id1)) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE `civicrm_tmp_e_dedupe_97911c832652885b9b1c932dfbe6530d` (id1 int, weight int, UNIQUE UI_id1 (id1)) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE `civicrm_tmp_e_dedupe_97911c832652885b9b1c932dfbe6530d` (id1 int, weight int, UNIQUE UI_id1 (id1)) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]"]
)

What is causing this and how do I go about solving it?
Many thanks.


texts: CiviVolunteer (2.1.2) doesn't show the opportunities in the frontend on Wordpress (4.6) with CiviCRM (4.7.10)

texts:
I was looking today and yesterday into installing CiviVolunteer on our CiviCRM installation (civicrm 4.7.10 on Wordpress 4.7) and when I try to navigate to the volunteer opportunities page from an event info page I only get a blank page with the header set to CiviVolunteer but no form loading.

There are no Javascript errors and all Wordpress roles have AjAX API as well as Register as Volunteer permissions.

You can see for yourself on a test instance at: https://piraten.lu/crm/civicrm/?page=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=2

What could be the issue?


texts: Impossible to insert Membership type column in a View for Display Contacts

texts:
I will try to be as schematic as possible:

I have a specific group (our Member Organizations);
We have 4 different types of membership (Full, Associate, Specialist, Applicant);
I want to display these types of membership in the list of contacts of the group.

I tried to:
- create a profile with Membership types and status, but CiVi gives me back the following errors:

[![enter image description here][2]][2]

Before you ask, I managed to change the default views from here: /civicrm/admin/setting/search?reset=1, so my only question is:

HOW CAN I DISPLAY THE MEMBERSHIP TYPES AND STATUS AS A RESULT COLUMN FOR PROFILE SEARCHES?

Thanks to everyone who will help me.


texts:
I've had a good search and not seen anyone asking a similar question - I'm testing out the mail merge function to see if it will work for our next mailing. I'm able to export labels as a PDF from an advanced search without any issues. However, any tests I do trying to export a .pdf, .odt, or .docx mail merged document produces a corrupted file - PDF readers all say the document is "damaged" and .docx and .odt produces a file with an awful lot of nonsense in it!

Anyone faced anything similar and found a solution?

Edit

After a bit of googling and messing around, I managed to get it to export the text I wanted in a HTML format. .docx and .odt documents are corrupted, pdfs won't open. At the top of the HTML and .docx documents there is a message saying "Notice: No file uploaded in Unknown on line 0". If I work it out I'll post here, but I can't find any others with similar problems. I've tried on multiple browsers and machines.

I've also tried to export contact data as a .csv file, again without luck. The file is corrupted with just a huge quantity of unintelligible symbols.

Edit 2!

We are running version 5.5.1


texts: eWay Recurring - Which extension is the best?

texts: One of our clients would like to use eWay for recurring payments in CiviCRM. We have installed and are our testing the eWay recurring extension by ChrisChinchilla. However, while researching other options we also came across the eWay recurring by Agileware and Omnipay extension. It seems the Agileware and Omnipay extensions are receiving more support and updates as the last update for the eWay recurring extension was 2016. Does anyone have any recommendations which is the best option to use for autorenewals for memberships and if any are better for PCI compliance?


texts: What is the correct way to work with custom data in the API?

texts:
I always seem to struggle to find a concise way of working with custom data via the API. I know that something like...

$updateParams = array('version' => 3, 'contact_id' => $contact_id, 'custom_160' => $badges);
$result=civicrm_api('contact', 'update', $updateParams);

...works for some but not all entities, so I presume that I'm meant to be using the CustomValue API, but whenever I do, my code looks v. clunky / doesn't work / I resort to SQL in frustration.  If anyone has a concise example or two of CustomValue in use that would be most appreciated.


texts: Fee amount (percentage) of each contribution

texts:
I'm using drupal 7 with CiviCRM 4.4.6, and PayPal Standard as payment processor.

When I visit CiviContribute dashboard, click "view" of one of the contribution records, it shows:

From: xxx
Financial Type: Member Dues
Payment Amount: 25.00
Fee Amount: 3.10
Net Amount: 21.90

How is this fee amount calculated?  I'm observing other records paid using same payment processor, and it shows different percentage of payment amount as its fee amount.

Is there any way I can set the percentage of fee amount? As I will be using other payment processor, and I need to figure out how this fee amount is working.


texts: GDPR Civicrm Bug when attempting to forward to another thank you page?

texts:
On the Communications Preferences settings page (of the GDPR extension) the option to Display a message on the form page works fine, but when attempting to forward to another thank you page

https://peoples-press.com/thank-you

and I put either relative or absolute (which the extensions says I can) the page it sends me to is

https://peoples-press.com/index.php?option=com_civicrm&task=https://peoples-press.com/thank-you

Have no idea how to tackle

Civicrm 5.1 - Joomla 3.8.7


texts: Do the localisation files change between releases, as a rule?

texts:
Do the files named .I10n (localisation files) change from (say) 4.6.4 to 4.6.5?
Or do they only change with major updates, say 4.5 to 4.6?


texts: How to set a contact's gender using API?

texts:
If I do a civicrm_api3('contact', 'getsingle', ['id'=>123]) I get lots of data, including gender.

However when I try to set the gender like:

civicrm_api3('contact', 'create', ['id'=>123, 'gender'=>'Male'])

It reports no error, but neither does it do anything(!).

(Nb. I'm using v4.4.16 LTS)


texts: Where to hire CiviCRM consultants or developers

texts: Is there a directory of CiviCRM companies or freelancers to make CiviCRM features that we need?


texts: Issue of membership contribution recorded but no membership created

texts:
Drupal 7 / CiviCRM 4.6.10

We are noticing this issue with this pattern:

A Drupal User has existed for many years with a corresponding CiviCRM record
Has never had a Membership record in CiviCRM
Used a Contribution Page with a Membership Price Set to Become a Member without being logged in to their Drupal account
Our Contribution page has the user account creation required

The pre-existing Drupal account / Civi Record, which they did NOT appear to login to, is receiving the contribution, but NO membership record is created.

I am thinking through all the options here - for a record we reviewed their linked Drupal record says this:

Last seen: 4 years 3 months ago
Joined: 11/14/2011 - 7:31am

So - how is this even possible? It seems like maybe they forgot they had an existing Drupal username, created an entirely new one, but then Civi didn't update their record to it, and then the membership is lost?

Thanks for your help.

I've seen this issue: Contribution recorded but no membership created when account creation is used

We are using LoginToboggan (but not a rule) and it is redirecting members to a page after account creation, is it the same issue?


texts: How can I split a group into subgroups of 5,000 contacts each?

texts: I saw an extension a while back that does this, but can't recall its name.  Can anyone tell me the name, or suggest another viable path to doing what I'm requesting?


texts: Form Submissions Overwriting Existing Contacts

texts:
Our form is overwriting existing contacts when a new submission is made.

All of our dedup rules are related to same names and emails; I do not see any dedup rule that would overwrite a (seemingly random) contact record with a new contact's information.

How can I prevent this in the future?

This issue began with my question here.The suggestion was excellent, and helped me get to a better understanding of what happened. But I'm still missing precisely where the overwrite is happening. (To be fair, the full suggestion is to check the logs, but I lack the ability to write a query that pinpoints what I want to understand)


texts: Error trying to upload an image in civimail on wordpress

texts: We are getting a "Failed to write file" error popup when attempting to upload an image in civimail using KCfinder.  This worked until about a month ago, and I don't what has changed.  The files in the ~/wordpress/wp-content/plugins/files/civicrm/persist/contribute/images folder are visible in KCfinder, and can be inserted into the email.  When I manually copy new image files into that directory, they appear in KCfinder and can be used.  The permissions on the directory are 775, the images have 644, and the file ownership is correct.  So I don't see anything wrong with any of that. Any ideas?  This is on PHP 7.0.28, WP 4.9.5, Civicrm 4.7.30.


texts:
I noticed recently under my Drupal "recent logged messages", I've been getting errors logged with the message:

"Deprecated function, use CRM_Core_PseudoConstant::getKey Array ( [civi.tag] => deprecated )"

AND

Error: [] operator not supported for strings in CRM_Utils_Recent::del() (line 173 of C:\xampp\htdocs\sites\all\modules\civicrm\CRM\Utils\Recent.php).

What does this mean? I am on Drupal 7 and CiviCRM 4.7.22. I think this seems to appear when I'm trying to delete a case or delete any activities. I see the spinner keep running forever and just hangs.


texts: Scheduled job mail_report fails [500 error] when adding instanceId paramter

texts:
Our scheduled job for sending a report fails when adding an instanceId. It works when removing that parameter.

We are on the latest version of joomla and latest civicrm.

Thanks


texts: Add fields in Matching CiviCRM fields on Import Contact

texts:
We are importing contacts into our CRM.  Our CSV file contains a District column, but while importing contacts, there's no such field present in CiviCRM--we need to add the district field.

URL: example.com/?option=com_civicrm&task=civicrm/import/contact&_qf_MapField_display=true&qfKey=7d325df8cb7e6a31c5c05551375c8292_1176

Screen Shot: http://screencast.com/t/lDQAjxPXlJsJ

So as shown in the screenshot, we want to add district under the state in the drop down. So there should be a column called "district" when we view the contact list.

Also, when we're importing contacts, it is showing mismatched files. Is there any way to put all my contacts in a file to import without interruption?

On the last step, it is importing only 145 contacts out of 250.  It is generating an Import Error CSV file with second column (Reason) containing "Invalid value for field(s) : Addressee must be one of the configured format options. Check Administer >> System Settings >> Option Groups >> Addressee for valid values."

As I do not have enough experience in programming, please guide me on the simplest way to proceed.


texts: Is CiviHR an extension or a separate application?

texts:
Hello I am interested in CiviHR. Is this an extension of CiviCRM or should this be a separate instance?

I see here it has to be a separate installation. https://forum.civicrm.org/index.php?topic=33429.0

I tried to find the demo, but all of the links to the demo sites I have found do not go anywhere. Is there a live CiviHR demo available somewhere?


texts: Scheduled reminder linked to deleted event is not deleted: bug or feature?

texts:
Create an event with a scheduled reminder (e.g. to send a confirmation 1 day before the start).
Then delete the event.
==> the scheduled reminder is not deleted (see Administer > Communication > Scheduled reminders)
I would expect the scheduled reminder would be deleted as well.
Is this a bug or a feature?
What would be your expectation?


texts: My client frequently needs to record  partial payments for events and memberships. When I open the transaction history, I  don't see a way to record the partial payment. In fact, all registrations seem to get recorded as completed by default. Any suggestions for a workflow which better records the transactions and the status of payments?


texts: Upgrade to version 5.37 - Database error

texts:
I have avoided upgrading for quite a while, but went ahead finally. Here is the error received below, and am completely unsure where to go to edit the field length. Or is the solution to rollback and re-install my backup and resolve it from there.
[Error: Expand internal civicrm group title field to be 255 in length]
Error Field Error Value
Type    DB_Error
Code    -1
Message DB Error: unknown error
Mode    16
UserInfo    ALTER TABLE civicrm_group CHANGE title title varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
DebugInfo   ALTER TABLE civicrm_group CHANGE title title varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
Here is the screenshot:


texts: Does CivicCRM let you manage members as companies rather than individuals?

texts: I run a Brewers Guild and the companies are the members, not the employees. I need to have the Brewery as the member and then have different employees listed as different positions (marketing, primary, accounting, etc.) and associated with that brewery.  So I can send an e-mail to everyone at a specific brewery or all "marketing" employees across all brewery members. Is this possible out of the box with CiviCRM?


texts: CiviMobile: Can't log into CiviCRM using CiviMobile

texts:
I installed:

CiviMobile extension in CiviCRM;
CiviMobile app on Android.

When I try to login using mobile browser, CiviCRM works. Loging in with same credentials in CiviMobile app does not work, it says: Sorry. We were not able connecting your CiviCRM server.

Logging into the demo server works.


texts:
upon upgrade from 4.7.31 to 5.3 the site could not load any civi pages, it would give a generic error message.

in the log I see:

Civi\Payment\Exception\PaymentProcessorException: CRM_Core_Payment_PayPalImpl: Payment processor type is not defined! in CRM_Core_Payment_PayPalImpl->__construct() (line 73 of /var/www/xxxxxx/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).

but this site does not use paypal, it uses authorizenet so I have no idea why this is causing a fatal error

my temp workaround was to just comment out line 73 of PayPalImpl.php but I'll need to verify that payments still work. Anyone else have a similar issue with 5.3?


texts: HOWTO: provide log-in (uid and pass) to Civicrm Contact - NEW or Existing

texts:
Is it possible to assign contacts created in Civicrm with Drupal UserID and Password during either CIVICRM contact creation or contact editing process with new, existing or imported contact?

I believe one can create "users" in Drupal and then export/sync the drupal user into CiviCRM contacts.  But, can it be done in reverse?

Help Appreciated

Thnks


texts: Is is possible to import cases into Civi

texts: A client has many cases in spreadsheets, and Civicase looks very suitable.  I cannot see any facility to import cases into Civi via the UI.  Is this possible? I guess the alternative is to import directly into the database. Any suggestions?


texts: How can I create a contribution page that allows the user to select the currency they wish to use?

texts: CiviCRM provides the ability to have more than one currency "available". But when I set up a contribution page I have to select the currency that the page will use. If I want to give the user the choice of which currency to use to make their payment, do I have to create a different contribution page for each currency option, or is there a simple way of letting the user select their preferred option on the payment page itself?


texts:
I am trying to test the Mosaico email template plugin however I am getting an error saying that Imagemagick is not install.

I checked with my hosting provider (Siteground) and they say that the PHP library is already install and that the path is /usr/bin/.

However i am not sure how to make Mosaico see that.

Does any one have this plugin working or any advice on how to fix my issue?

Zeak


texts: Can Attendees Modify their Registration?

texts: Can attendees access their registration and make changes after they've submitted a completed registration?


texts: CKEditor can only edit user driven message templates

texts:
If I edit a user driven message template, then CKEditor works nicely. If I try to edit a system message template, the template fills only into a textarea, without CKEditor.

Since it's done as site admin having all the permissions, and these symptoms are the same on dmaster.demo.civicrm.org for system templates and for user templates, I guess this is a bug.

Do you have any workaround here?

My install is on Aegir 3.17.3 with Drupal 7.64 and CiviCRM 5.10


texts: Problem with loading (jqery / css) CiviCRM files in Joomla 3.4.8

texts:
Jqery / css etc. CiviCRM files from the folder: components/com_civicrm are not loaded.

In another site they are loaded well, see links below.

Both sites are in Joomla 3.4.8 with CiviCRM 4.7.3.
Both sites use the latest version of admin tools to protect the site.

Thank you for your help!

http://www.cecsweden.org/cms/registration-festival-sweden-2016
http://tools.pingdom.com/fpt/#!/gP8gq/http://www.cecsweden.org/cms/registration-festival-sweden-2016

https://www.srivast.org/en/register
http://tools.pingdom.com/fpt/#!/eaOYc7/https://www.srivast.org/en/register


texts: CiviEvent - capturing billing information, interaction (or not) with contacts

texts:
I may be missing something obvious, but what is the best way to capture billing information for an event registration, including for a registration of multiple people?

What I mean is, in addition to providing a credit card option, we allow optionally providing billing name, address, fax, and email.

Currently we are using a profile for the additional billing information (billing name, address, fax, and email), which gets attached to registrant #1. This caused a problem at first - an email address supplied for billing would overwrite the email address on registrant #1. "Solved" by replacing the email field in the billing profile with a new text field that is just for the profile (but unfortunately is not an email field, so is not validated for email).

Is there a better way, to collect this information and have it attached to the event registration itself, not to one of the contacts?


texts: How to store (and import) historical data (date, integer#1, integer #2, etc.)

texts:
I want to store data (date, integer #1, integer #2, integer #3) for an organizational contact in CiviCRM. Each month a new record record with the same format will be created for each contact, but with new data.
What is the best way to do that in CiviCRM?
I also want to import that data (historical data from past dates).  Can that be done?


texts: Civi isn't finding matching contacts when importing contributions

texts:
I'm trying to import contributions from another source, and Civi gives me a "no matching contact found" error for each record. I've checked my csv data, my Civi data, my field mapping, and my unsupervised dedupe rule (all of these are individuals).

I can copy the email address text from the csv file, search for it in civi, and find the correct person and only the correct person. But, when my unsupervised dedupe rule is set to email only, I still get "no matching contact found for ([email address that is in fact in the database] )" when I import.

What else should I check?


texts:
Our menu bar is currently missing. We are on WP 5.2.3 and Civicrm 5.15.1
I managed to get CiviCRM Admin Utilities installed and that makes the site workable, but i would like to get the menu working. This is what I currently see.
I am not sure if I am on the correct track, but I saw on some forums that this could be related to the resource url.

My resource url currently is .
Is that correct?

I have tried cleaning up the Caches and resetting the paths, but when i reset the paths it says that my civicrm userFrameworkResourceURL is overriden in civicrm.settings.php

My Resource URL is pointing to wp-content/plugins/civicrm/civicrm. My civicrm.settings.php file is sitting in /wp-content/upload/civicrm/civicrm.settings.php.

Is my resource url correct? or what should the Resource url point to?

Sorry for what is probably a silly question, i'm not even sure if this is part of the issue.


texts: It is possible to deduplicate contacts entered in a Webform?

texts:
I haven't found this issue in any other topic, sorry if it's been already asked.

I'm trying to automatically deduplicate contacts which enter to Civi from a registration Webform, but I haven't found a way. Is it possible?

Thanks in advance


texts: How to install CiviCRM patch (5.7.2 to 5.7.5) on Drupal 7.64 - is my file directory writeable?

texts:
Currently running Drupal 7.64 and got a notification that I need to install a security patch on CiviCRM. Currently running CiviCRM 5.7.2 and need to install 5.7.5.

Apologies in advance if this question seems a bit unintelligent - but completely beyond my scope!

I read through the instructions in the CiviCRM Documentation and had one question in particular:

Ensure that your Drupal files directory is writeable by the webserver.

Is there a way of doing this through cPanel? I have no idea how to access anything command line-related...

I've updated Drupal before (e.g. from 7.61 to 7.64), not sure if that gives an indication of whether my file directory is writeable?

The rest of the instructions seem pretty straight forward... but is there anything else I need to be wary of? Always a bit hesitant with installing updates for the first time, so just making sure!


texts: Has anyone used the AUTHORIZE.NET ECHECK.NET extension with Civi 4.4

texts:
We've tried installing it but the field snippet always displays the credit card field not the appropriate fields for an ACH transaction.

I've posted an issue on github but nothing positive yet.
https://github.com/donordepot/com.donordepot.authnetecheck/issues/11#issuecomment-168675840

Thanks


texts: After upgrade to 5.0.1 - anonymous users can't see any events

texts:
The upgrade, in Drupal 7.58, was done some months ago. We have an annual event so I'm only noticing this after trying to set up the new event, but anonymous users can no longer view any events. The error is the following:

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
API permission check failed for Event/get call; insufficient permission: require access CiviCRM and access CiviEvent and view event info

There were no changes to permissions, and this worked before. I double checked, and the anonymous access via CiviEvent is still on.


texts: Wrong Authnet transaction key entered, memberships pending, event registrations complete?

texts:
We use the payment processor Authorize.net. The incorrect transaction key was entered, and for about 4 weeks people paid for memberships and registered for meetings on our website. The memberships in Civi show up as "pending", the event registrations show up as "complete", but nothing shows up in Authnet as having gone through... because it hasn't.

I've since fixed the transaction key and did a test run, so I know online transactions work smoothly now. The issue is with the others who paid during the interim... is there a way to put their payments through again now that it's working? Or will these people need to completely re-register?


texts: Bulk mail still listed under Activities tab

texts:
context: I'm upgrading from an old civicrm 3.4.5 (d6) to 4.7.22 (d7) and have done so apparently successfully..

I see reference that bulk emails are no longer listed in the activities tab by default from 4.4.4, but mine are still there.

i've "solved" this by unticking "Enable CiviMail to create activities on delivery" in CiviMail Component Settings, which makes a nice mailing tab, and then deleting all previous bulk email activities - but i'm confused as to why they are not hidden.. and slightly concerned it's some legacy from my upgrade and other things might be affected too.


texts:
I deleted an activity and would like to re-add it. Please help!
I can't seem to find a search bar that would help me find the right steps to correct.


texts: The standard contribution form for signing up for household memberships doesn't allow the person signing up to add additional people to the membership. It would be nice if the form had a page (or other affordance) after the initial information form to allow them to add additional names and email addresses. This page would fit between the initial page and the verify page. How is this typically handled? Right now the workflow forces an admin to manually edit the relationships tab for a household contact. I could add custom fields (name, email) to the member sign up for this, but how would you pass this data along to the database as relationship contacts?


texts: Where do you put human contacts on the Organization entry?

texts: When you create a new contact for an organization on CiviCRM, there does not seem to be any place to add the name of a human contact. Am I missing something?


texts: ER diagram for the latest Civicrm , Foreign key in Structure, test cases/plans

texts:
Where can I get the ER diagram for the latest CiviCRM? I need it for internal reporting purposes in our organization.
I am able to download the Table structure from phpMyAdmin. However, it does not give details about foreign key references. Can I get it automated? Or I have to manually get it done?
Is there any Test plans/ Cases written, which I can catch hold off?