texts:
I'm using the Data Processor extension to generate a report and dashlet showing recent new signups through Drupal, for our staff to follow up with an e-mail or phone call.
I'd like to get an indicator against the search results for those users who have ticked 'Do not e-mail' or 'Do not call' so staff don't have to click into each card individually to find out whether or not to contact them. Obviously I could make another column using the relevant fields, but is there a way to get Data Processor to display the little graphical privacy flag that appears in standard CiviCRM search results?


texts:
I'm trying to run CiviCRM v.5.34.0 with Wordpress v.5.6.1 on a local server. Unfortunately the installation of CiviCRM crashes with the following error:
Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE `civicrm_address_format` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Format Id', `format` text [...]

The server is running via xampp v3.2.4:

Server-Typ: MariaDB
Server-Verbindung: SSL wird nicht verwendet Dokumentation
Server-Version: 10.4.17-MariaDB - mariadb.org binary distribution
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/8.0.2
Datenbank-Client Version: libmysql - mysqlnd 8.0.2
PHP-Erweiterung: mysqli Dokumentation curl Dokumentation mbstring Dokumentation
PHP-Version: 8.0.2

The mysql user has all privileges and GRANT access.
I really would like to test CiviCRM to see if it satisfies my needs, which it promises to do.
Hope someone can help me.


texts: 4.7.15 breaks civimail styles and templates (fullPage doesn't help)

texts:
Since upgrading to Civi 4.7.15 CKEditor is stripping out the email headers and style tags on three Drupal 7 sites. One site is hosted on a shared/multi-site and the other two on AegirVPS.

This problem may have first surfaced in 4.7.14. (See this similar post about Joomla)

I have set both config.fullPage and config.allowedContent to true using the configurator, and the changes are reflected in the config files in files/civicrm/persist (crm-ckeditor-civimail.js and crm-ckeditor-default.js).

The changes aren't reflecting in the editor (I also removed some buttons which also still appear in the editor).

I have cleared Drupal, Civi and browser caches, deactivated JS aggregation, and tested on Chrome and Firefox without joy.

When I click the source button the full email flashes briefly but then strips out the tags.

Is there something I'm missing? / Can anyone suggest another solution? @Coleman?


texts:
I have a solution for non-profit organizations here in Sweden and looking for a solution regarding registration of members (persons) on the organisation's website.

On the organisations webpage there shall be a registration page connected to CiviCRM.
When the new person has filled in their information they shall have a response mail.

I want the following information from the new person.

First name
Surname
Street
Zip code
Town
E-mail

And if I can get the following information I will be glad:

Mobile phone
Birth date

Do anybody have a solution for this and in what economic level are we talking about?


texts: MySQL errors when transferring database from one server to another

texts:
I am shifting my server for my DRUPAL7 + Civicrm website.
I followed the process outlined here
I have the drupal site working fine and a fresh install of Civicrm working fine. Now i just need to transfer my data from old server to new. When i try to import the data - i get following MySQL error
Error
SQL query:
CREATE TABLE IF NOT EXISTS civicrm_acl ( id int(10) unsigned NOT NULL COMMENT 'Unique table ID', name varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ACL Name.', deny tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Is this ACL entry Allow (0) or Deny (1) ?', entity_table varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)', entity_id int(10) unsigned DEFAULT NULL COMMENT 'ID of the object possessing this ACL', operation varchar(8) COLLATE utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?', object_table varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'The table of the object controlled by this ACL entry', object_id int(10) unsigned DEFAULT NULL COMMENT 'The ID of the object controlled by this ACL entry', acl_table varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?[...]
MySQL said:
1215 - Cannot add foreign key constraint
pl help.


texts: CiviCRM component pointing to different database than Joomla CMS

texts:
We have a little bit of a strange issue and could use some input.

We are using CiviCRM on Joomla.  Started on Joomla 1.5 years ago, then upgraded to J2.5/CiviCRM 4.4 a couple years ago, then a few weeks ago upgraded to J3.4/CiviCRM 4.7.1.

Somehow, somewhere along the way over the past couple years during multiple Joomla and CiviCRM upgrades, the site got configured so that Joomla was using one database (deafhhny_jmlprod) and CiviCRM was using a different database (deafhhny_jmlnew).  It seems to have been working fine all this time and nobody noticed.  Then during the latest upgrades, the CiviCRM config file got updated to point to the same DB Joomla uses (deafhhny_jmlprod).  We noticed in the CiviCRM dashboard that we were missing the last couple years of data.  I poked around and figured out that the data is in the deafhhny_jmlnew database, and that the civicrm.settings.php file had changed during the upgrade.

Before I just change the CiviCRM config file to point to the deafhhny_jmlnew database like it was before, I wanted to check with the community to find out if there could be any adverse effects to doing that.

If not, then I should be able to just update the database strings in civicrm.settings.php to point to deafhhny_jmlnew like it was before, right?  Although, I'm not sure if that DB got upgraded during the 4.4 to 4.7.1 upgrade process or what will happen if I point CiviCRM to it now.  Any ideas?

If there are potential issues with pointing to a different DB, can I get some help with how to get the data from the _jmlnew database into the _jmlprod database properly without breaking anything?

Thanks.


texts: CiviReport's and CiviContribute Charts not displaying

texts:
We are using civi 5.3 on Wordpress 4.9.
Using CiviReports or CiviContribute, I am selecting Charts, and clicking the view button.  The chart is not loading.   I saw the other answers suggesting that I enable flash in chrome for this site, but this is happening on Chrome, Explorer and Safari. Could the paths for these graphs be wrong?  Where would I check that?
The charts have never worked for us, even before upgrading to 5.3.


texts: How to communicate with the users of an extension?

texts:
We are discussing about which version(s) to maintain compatibility with, and would like to be able to discuss that with the users of that extension. Is there an easy way to do that?

Eg. civicrm.org has already several ways to display a message to the civicrm users (eg. community message), would it be possible to plug into that and add a special message only visible to those that have a specific extension enabled?


texts: How display event for anonymous user with Rendered Entity

texts:
In drupal a have added a field event to display a event in a web page. When I'm connected I see my Event field. The problem is when a anymous see my page he don't view my rendered entity.

If I change the format of my field to 'label', I can select the option 'Show entity labels regardless of user access' and with this configuration everybody can see my field. Where can I find the same option with the "Rendered Entity" format?

I use CiviCRM 4.6, Drupal 7 with modules CiviCRM Entity, Entity Reference and Display Suite.

Thanks


texts: CiviCRM uses mail server account address as sender

texts:
I log in as a user of CiviCRM.
I then go to a contact and send an email as activity. Even if my mail address is shown as sender in the mail, when the mail is recieved - the sender is the account used to log in to the mail server (GMail). It seemingly does not use "By default, CiviCRM uses the primary email address of the logged in user as the FROM address when sending emails to contacts. "

How do I keep my CiviCRM user mailaddress as the sender on the recieving end?


texts:
WordPress 5.2.2, Civi 5.15.1

I just created a custom profile containing custom Membership fields, and want to get its URL so I can add it to the Navigation Menu. However, the Use button does not appear on the profile's field list page. In the past I have created other custom profiles containing all Contact fields, and never encountered this problem. Is there something special about Membership profiles, or am I doing something wrong?


texts: Translate Custom Profiles not appearing translated in Drupal

texts: When creating a Custom Profile in CiviCRM and attaching that to the Drupal Registration and/or Drupal user account the translations for Portuguese, French, and Spanish are not appearing based on the Inherit CMS value set


texts:
I'm looking to set up a membership for a concert band. Each member is assigned a folder number (2 digits plus an instrument name such as Flute 2). I'm too new at this to see how to set this up. Could someone please point me in the right direction?
Cheers, DHDa


texts: I don't find how to change the font size when I print labels (I have a CiviCRM Spark account). The default size is far too small and the Post office don't accept it...


texts: Questions for using civi as part of a election campaign

texts:
So we are looking at CiviCRM to help run my campaign. We have been using votebuilder which is very good but it has some drawbacks as well. one of the big drawbacks is that you can not see people outside of your district.

So i have downloaded the files for all of the voters in PA. I have some questions

Have other people loaded these types of files into Civi before and if so
a. How do you keep track of things like if the person is a dem or rep or other
b. How do you keep track of the times in which they have voted
c. How do you keep track of the multiple districts that they live in
d. How can you search on all of the above so that you can find all of one party who has voted in the primary and general of x year and is in District Y
I saw a note back in 2014 that they were working on the ability to "cut turf" does anyone know if that was completed, and if so do I need to download anything else
If you can cut turf is it done visually? So on a map and i can draw on the map to cut the turf? if so is there a demo somewhere
Is there a way to print by street (or turf) odd and even street numbers?
If you can not cut turf, is there a way to create a list of people then go out and meet with those people, then somehow pull the same list up and quickly enter data?
If you do go out and lets assume you are giving out pampletts, where would you store the information like ... not home..took pamplet...agreed to have lawn sign..agreed to volunteer..so that we keep track of that as part of a date related item..so when we run for office again we can look back see who did it last time and then capture if they will do it again this time
Becuase the campaign has a limited life, can this be hosted on a shared server at godaddy or hostgator or something that is inexpensive. I need to keep the costs down but I never want to lose the data

thanks for your help.
Mark


texts: When I accepted sample data on install I did not realize there would be 200 contacts added with no clear way to get rid of them. How do I delete these contacts?


texts:
Noting Tim Otten's answer here which pointed to his blog post, I'd like to know the best pattern to allow injection of CiviCRM services into extension classes and other things (ie to support unit testing).

The kind of services that it would be most useful to inject are those that have external impacts or a generally slow:

database access layer
email system
logging
API3
API4
payment processing

I'm stuck on 4.6 for a month or two, and I'm guessing the answer will be different in 4.7, but happy for a "In 4.7..." answer.


texts:
Using Joomla 3.6.2 and CiviCRM 4.7.11 and experiencing duplicate emails in CiviMail. We've tested with contacts with same email address + in same group, resulting in 2 emails received. We've also tested with contacts with same email address though in separate groups, resulting in 2 emails received. Attached image demonstrates 2 separate groups, each with 2 contacts in each group (different first/last names, though same email addresses... so 2 unique email addresses).

CiviMail component settings includes "CiviMail dedupes email addresses by default" as checked.

Edit: Connections

Also just tried to use the connections to provide a site profile assuming that might help troubleshoot this. Noticed in the image that the site url contains "administrator" twice. Perhaps this is a separate issue or maybe it's related?


texts: What are best practices for deploying changes?

texts:
I'm looking to set up best practices for a development workflow (i.e. dev > staging > production)

In Drupal there is features, which allows you to export your configuration into code and then deploy it.

What are people using when doing this in CiviCRM?


texts: condition on count from chained api call

texts:
I am trying to use the api to get all contacts without an address with locationtype billing. For this I use the contact get api, and do a chained address get call. Is there a way to put a condition on the number of results from the chained call?

This is a non-working example of what I am trying to do.

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'api.Address.get' => array('location_type_id' => "billing"),
  'api.Contact.get.count' => 0,
));


texts: Recurring Direct Debit Donation Amount Changes Not Reported on CiviCRM Bank Reconciliation

texts:
We encountered an issue that when changes are made to a donor's contribution amount before a ACH/EFT run, the amount is reflected by the bank, but is not updating when running a bank reconciliation report in CiviCRM for that given run.

Example:

Donation is $10
Donor requests a change to $20
When the donation is processed, the bank shows that $20 was indeed processed, but the CiviCRM bank reconciliation report shows the donor's contribution as $10.
The tax receipt amount, however, is showing $20.

Any thoughts on what would cause this? Has anyone encountered this? Do we have to re-enter the recurring donation every time a change needs to be made?

Thank you for any assistance!

David


texts: Profile Fields disappear while using hook_civicrm_buildForm

texts:
I am using hook_buildForm as follows:

function custom_changes_civicrm_buildForm($formName, &$form) {
  if ($formName == 'CRM_Member_Form_Membership'){
    $form->_elements[2]->_label = t('Client');
    $form->_elements[4]->_label = t('Consultation Type');
  }
}

I have added Profile fields associated with Membership,when I alter the membership form as given above, the profile fields disappear


texts: "API permission check failed" for admin user

texts:
(I'm using version 4.7 based on Wordpress)

When making a REST api call to retrieve a ContributionPage instance, the response tells me that I "require administer CiviCRM". However, the API key is associated with a user in the Administrators group of CiviCRM (this was configured as such using the "group" dropdown in the "New Individual" form of the CiviCRM contacts menu) . For other entities such as "Contact" the call works.

    # get contribution page
    resp = requests.get(
        url,
        params=dict(
            entity='ContributionPage',
            action='getsingle',
            api_key='xxxxxxxxxxxxxxxx',
            key='xxxxxxxxxxxxxxx',
            json={"id":1}
        )
    )
    print(resp.text)

{"error_code":"unauthorized","entity":"ContributionPage","action":"getsingle","is_error":1,"error_message":"API permission check failed for ContributionPage\/getsingle call; insufficient permission: require administer CiviCRM"}

Does anyone know what could be the problem?


texts: Can't translate year(s)word for recurring contributions

texts: in CiviContribute Recurring Contributions I can't translate the Year(s) word. I don't find it in PoEdit files. Word replacing doesn't work. Any ideas?


texts: Can't change individual nickname via profile

texts:
Trying to update the contact nickname for individual contacts via update multiple contacts doesn't work. You can go through the whole process, but in the end nothing will actually be changed in the contact records. However, organizations can be updated with this method.

Steps: Select individual contacts, update multiple contacts, select a profile with nickname, change nicknames as desired, submit.

Result: Process appears to complete as normal. No change to nicknames. Tested on 5.7.3 on Drupal and Drupal demo (5.12.alpha1)

Note that you can still change the nickname on the contact profile.

It's a very small thing, but can be a bit frustrating because there is no error, so you don't know that your changes haven't taken effect. Does this seems like a bug that should be reported?


texts: Member Since and Start Date aren't being recorded in membership details

texts:
This issue has been going on for quite some time and I was hoping I just needed to upgrade the CiviCRM but I am on 4.7.27 now and am wondering if I have possibly set something up incorrectly.

Our users are able to pay for a membership via a CiviContribute page. The membership is for an online training subscription and I use Drupal's CiviMember Role Sync module to then give users with active memberships of this kind a special role to access other parts of the website.

When users submit payment and subscribe, an end date to their membership is recorded but not a start date or a member since date.

Things to note:

users must renew manually and are not on any kind of auto-renew
the membership is good for one year
some users use a discount code, but the bug seems to affect anyone that signs themselves up
if we sign someone up through the back end, it records everything correctly

Edit: Here is a sample of the membership date fields of an entry in the civicrm_membership table;

                   id: 4942
           contact_id: 131490
   membership_type_id: 1
            join_date: NULL
           start_date: NULL
             end_date: 2018-10-23

Edit2: The civicrm_membership_log entries for this id shows:

select * from civicrm_membership_log where membership_id=4942 \G
*************************** 1. row ***************************
                id: 12498
     membership_id: 4942
         status_id: 5
        start_date: NULL
          end_date: NULL
       modified_id: 131490
     modified_date: 2017-10-23
membership_type_id: 1
       max_related: NULL
*************************** 2. row ***************************
                id: 12499
     membership_id: 4942
         status_id: 1
        start_date: NULL
          end_date: 2018-10-23
       modified_id: 131490
     modified_date: 2017-10-23
membership_type_id: 1
       max_related: NULL
*************************** 3. row ***************************
                id: 12518
     membership_id: 4942
         status_id: 2
        start_date: NULL
          end_date: 2018-10-23
       modified_id: 2
     modified_date: 2017-10-23
membership_type_id: 1
       max_related: NULL
3 rows in set (0.00 sec)

Important to note that memberships status are updating correctly and access is appropriate and doesn't seem to be affected by this bug. In fact, it's not causing any noticeable issues because the mechanism that updates memberships is based on the end date, which is being recorded.

Edit 3: The effects seem to have started a couple weeks after I upgraded from a 4.3 system to 4.7.15, however, I don't think the upgrade did it because it was a couple weeks after. It seems to coincide with this issue, when I had to modify some code in packages/Net/SMTP.php to accommodate a startTLS issue, however, not sure if this is related. Also I noticed that the packages/Net/SMTP.php doesn't exist anymore after my upgrade so it's probably not that.

Edit 4: I'm on 5.14.0 now with Drupal 7.69 and still having this issue but even more frequently.


texts: Manual registration not being recorded into workshop (price set) count.

texts: We have an event that has workshops (configured as a price set). When we do a manual (not member / user driven) registration of any person, that information is not being tracked in the workshop reports (price set count for workshop). Can anyone help tell us why this might not be being recorded?


texts:
One of my CiviCRM instances database has the table civicrm_install_canary, another has not. In code it is marked as a mechanism that check whether the install has run before. But how does this mechanism work. Does it mean that the installation has been failed irreparable, and that the backup must be restored. Is er een method to fix it, or can it maybe restored (or ignored)?

The installation canary is part of the current code base (CiviCRM 4.7.12).


texts: Membership details search, view, edit by staff in frontend

texts:
I am trying to build membership system for a table tennis business store. Owner want to store his members info with civicrm. He dont want to use online membership sign up system now. His staff will add members info and assign members to various membership manually.

Staff wont have access to backend. So staff need to have frontend feature so they can search, view, add, edit, update, delete members membership.

Its easy to do that in backend. But I can not figure out how to have this membership features in frontend.

So wondering, is this possible what I am looking?

I am using joomla.

Thanks
Julash


texts: How to convert a STOP message sent to an SMS provider into the "Do not SMS" privacy preference in CiviCRM?

texts:
Most SMS providers allow you to respond with STOP to indicate that you no longer want to receive SMS messages. If we try to send another message to a phone number that has replied with STOP, it won't go out.
However, it's not clear how this information gets back to CiviCRM, if at all. Does this have to be handled on a per SMS provider basis? Or should we be building a more generic framework to support all SMS providers? Or is there a way I haven't figured out?
For reference - here's how Twilio handles it: https://support.twilio.com/hc/en-us/articles/223134027-Twilio-support-for-opt-out-keywords-SMS-STOP-filtering-


texts: CiviCRM mail sent 200% of intended recipients. Why?

texts:
It is CiviCRM 4.6.14. The mailing was scheduled via the api as per this stackexchange question.

It appears to have sent all the messages twice. Any ideas why? See report.


texts: Membership renewal start date doesn't update?

texts:
This behaviour has been observed on a live CiviCRM 4.5.8 site as well as the current demo site which is 4.6.6

When renewing a membership offline, the start date doesn't update to reflect the current membership term. An example (using UK date formats)

Membership type term = 1 year
Membership Since Date = 01/07/2011
Membership Start Date =  01/07/2014
Membership End Date = 30/06/2015

So as of today, the member is in "Grace".

When you click "Renew" the membership start date doesn't update to reflect the new membership term, only the end date does. So the new dates are

Membership type term = 1 year
Membership Since Date = 01/07/2011
Membership Start Date =  01/07/2014
Membership End Date = 30/06/2016

which would suggest this person has 2 year membership and doesn't reflect that they renewed this year, making membership dashboard data incorrect.

Is this expected behaviour or a possible bug?

Heather O.


texts: Mailchimp Sync CiviCRM Extension: Two-way sync is not working

texts:
When running a sync between Mailchimp and CiviCRM, I only get added to CiviCRM the new subscribers in MailChimp, but the new contacts/members or changes in CiviCRM never migrate into Mailchimp.
I've got installed CiviCRM 5.21.1 and I've tested it with Mailchimp Sync CiviCRM extension that can be found in https://lab.civicrm.org/extensions/mailchimpsync
https://docs.civicrm.org/mailchimpsync/en/latest
Any help will be very much appreciated.


texts: How to set user permission for a particular user?

texts:
I have two accounts. One is admin and another is observer.
I want only read-only permission for demo account.
Please help.
If I logged in by observer account then that CiviCRM option not showing on dashboard.


texts:
I've been working with CiviCRM for almost a year now. One problem we have is we frequently see the Internal Server Error 500 white screen of death. In particular, we cannot use the contact de-dupe tools. When we try to use them, the page runs for about a minute, then we get the error 500.
Does anybody know how to diagnose what is actually failing when the error 500 happens?
We are running CiviCRM 4.6.9 within Drupal 7 on Windows Server. Thanks for your help!


texts: Batch Update the current relationship in CiviCRM

texts:
I need your help. I need to disable a current relationship for 4000 records in the import process without using SQL command line.

There is no field for set active/inactive or expiry date of the current relationship in basic import process in CiviCRM.

Then I found this extension here https://civicrm.org/extensions/api-csv-import-gui,I've installed the extension and tried to inactive the current relationships.
I used contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file.
But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)". I'm going to update this relationship but this extension tries to create a relationship and fails because this relationship is already existed.
Do you have any idea how to solve this?

Or do you have any other solution for this?

CiviCRM version is 5.13.5.
And the relationship type is between two organization.

Edit: My requirement is:

Currently I have around 5000 records with a type of relationship in CiviCRM (organization to organization -one to many). Some of these records (relationship, name, email,...) have been updated in another system (A government system) and they gave the current list to me to update our current records in CiviCRM. I've updated contact details successfully but stuck in updating relationship, Because the CiviCRM basic import creates a new relationship not overwrite the existing one. If a relationship between 2 organization has changed in new file I need to disable the one that we have in civicrm and import the new one. So in future I know which records used to be in relationship but not any more. There is no option in CiviCRM import to do this (I couldn't find any). So I was thinking to find a way to disable the current one in CiviCRM and import new list. So if the relationship is no longer available in the new file, this has been disabled already in CiviCRM and if there is still a relationship between two records, it enables that again when I'm importing.

Thanks in advance


texts:
On a fresh Ubuntu system when running the command

  curl -Ls https://civicrm.org/get-buildkit.sh | bash -s -- --full --dir ~/buildkit

as requested on the document on the repository, i get the following error

  bash: line 1: unexpected EOF while looking for matching `''
  bash: line 2: syntax error: unexpected end of file

and the download fails to proceed.


texts: CiviCRM Profile / new contact: is there a way to automatically update the Source Field?

texts: I set up a Profile which collects contact information for new supporters. It automatically creates a new contact record, but I'd like the CiviCRM Source field to be automatically filled in (e.g. Petition Signer). Also, it would be nice if it automatically triggered a thank you email. Is there a way to do these things? Thanks much for a great product!!


texts: How do I store old leads so they don't bother the current leads?

texts: Is there a module like "leads" and "contacts" for un useful leads?


texts:
B"H
Hi
I'm trying to install CiviCRM with a local Drupal 7 installation on windows 7, with XXAMP etc.
I have drupal 7 working fine, I downloaded the source code for civicrm (file name civicrm-5.35.1-drupal), extraced it to C:\xampp\htdocs\yidpool\sites\all\modules\civicrm (yidpool is my drupal folder), then in the drupal modules section I see:

So as you can see it's all there except for the rules and the OG sync. OK fine, so I save it, then I go to http://localhost:777/yidpool/civicrm/dashboard after clicking on a link that appears on one of the blocks on the home screen, then I'm greeted with this page:

And I'm not able to do anything else, if I click on the "Confirguration..." it opens a new tab to the same exact page, and the standard install page that the docs said I should see don't appear.
Any idea how to procede?


texts: Nothing happens on selection of “Actions” dropdown options

texts:
Can someone offer me some insight as to the possible cause of the Actions drop-down not working?

Here is my setup:

CiviCRM 5.13.3
Drupal 7.67
PHP 7.2.16
Bootstrap subtheme set to use JQuery 3.1

When I execute a search from the advanced search form, I get the following JS error:

TypeError: f is undefined
    mysite.org/misc/jquery.ba-bbq.js:19:115
Warn: could not find module util

When select contacts from search results, I get the following errors:

TypeError: $(...).val(...) is undefined
    mysite.org/sites/default/files/civicrm/civi_extensions/org.civicrm.shoreditch/js/main-menu.js:66:41
    Ember 2 (errors)
        isQuickSearchOnGoing
        removeCustomClassOnOutsideClick
    jQuery 2 (errors)
        dispatch
        handle

When I select an item from the "Actions" dropdown, I get the following errors:

TypeError: $(...).val(...) is undefined
    mysite.org/sites/default/files/civicrm/civi_extensions/org.civicrm.shoreditch/js/main-menu.js:66:41
Ember 2 (errors)
    isQuickSearchOnGoing
    removeCustomClassOnOutsideClick
jQuery 8 (errors)
    dispatch
    handle
    trigger
    trigger
    each
    each
    trigger
    b
<anonymous> Ember
jQuery 7 (errors)
    dispatch
    handle
    trigger
    trigger
    each
    each
    trigger
Ember 5 (errors)
    triggerChange
    onSelect
    selectHighlighted
    init
    bind
jQuery 2 (errors)
    dispatch
    handle

I am able to execute actions options from a contact's individual record, but not from any search results. Changing Bootstrap's settings to use a lower version of JQuery has no effect. Disabling the Bootstrap sub theme and base theme has no effect. It happens in Firefox and Chrome.


texts:
I am creating some custom directory screens to display a table of contacts with associated email addresses and any tags (just a simplified directory for non-admin staff to view/sort basic CRM data).  I am using the API version 4 and can't figure out the correct way to grab both the contact AND related tag data.

When using the API4 query builder, only the "tags" table (Join to Tag) is present, and adding "tags.name" to the query does not retrieve anything:

$contacts = \Civi\Api4\Contact::get()
  ->setSelect([
    'id',
    'first_name',
    'last_name',
    'job_title',
    'display_name',
    'tags.name',
  ])
  ->addWhere('id', '=', 865)
  ->setLimit(25)
  ->execute();

yields (though this user definitely has a tag):

[
  {
    "id": "865",
    "first_name": "Sean",
    "last_name": "Kirkpatrick",
    "job_title": null,
    "display_name": "Sean Kirkpatrick",
    "tags": []
  }
]

This seems to be pulling info just from the table civicrm_tag instead of both civicrm_tag and civicrm_entity_tag.  In SQL, I can get the data I want with this query:

SELECT b.id, b.display_name, c.name
FROM civicrm_entity_tag a
  join civicrm_contact b on a.entity_id = b.id
  join civicrm_tag c on a.tag_id = c.id

In API3, getting this data is fairly simple:

$result = civicrm_api3('Contact', 'get', [
  'sequential' => 1,
  'return' => ["id", "first_name", "last_name", "tag"],
]);

yields:

{
    "is_error": 0,
    "version": 3,
    "count": 25,
    "values": [
        {
            "contact_id": "1",
            "first_name": "",
            "last_name": "",
            "contact_is_deleted": "0",
            "tags": "",
            "id": "1"
        },
        {
            "contact_id": "2",
            "first_name": "Sean",
            "last_name": "Kirkpatrick",
            "contact_is_deleted": "0",
            "tags": "Individual Artist",
            "id": "2"
        },
        {
            "contact_id": "3",
            "first_name": "Test",
            "last_name": "Subject",
            "contact_is_deleted": "0",
            "tags": "Volunteer,Individual Artist,Newsletter",
            "id": "3"
        },...

Any ideas on what I'm doing wrong with API4?  I'd rather not have a random v3 call among all of the other v4 calls, but maybe that doesn't matter.


texts: "Make Mailing Labels" not working for Bosnia language

texts:
Im trying to "make mailing labels" with contacts with names in Bosnian and CiviCRM cannot create it.

Example:

Correct: Antolović
CiviCRM prints: Antolovi?

Instead, CiviCRM shows it correctly in most parts of the CRM, for example
print/merge document in actions of contact summary view.

Any suggestions?

Tx!


texts: How can I report a bug caused by an extension?

texts: CiviCRM.org has a page on reporting bugs, but my bug is in an extension.  How should I report it?


texts: Public Autocomplete on Drupal User Registration

texts:
I've been testing the Public Autocomplete extension with the hope of using it to prevent duplicate contacts being created if I expose the current employer field in forms. I've got it working for anonymous users on an event registration page but, using the same profile, it doesn't seem to work on the Drupal User Registration form.
Is this be design, or am I doing something wrong? Is there a way to get it working?


texts: Logged out periodically for unknown reason and word replacement not working

texts:
On one of the CiviCRM sites I've set up, it keeps logging me out every 30 minutes or so. I have set the cookies in the default.settings.php file so that I'm logged out when I close the browser but it's exactly the same as my other sites, where there's no problem. Same hosting as well. Any ideas why it's throwing me out all the time??

I'm on Drupal 7.53 and CiviCRM 4.7.16.

EDIT: This is still ongoing, I've restored all settings across the site that I can think of that may trigger an issue. Just today, I've had the following error message (usually it just logs you out with no warning) but I thought it may throw some light on the issue?

And this is my cookie session settings in the default.settings.php file:

----- THE FOLLOWING ISSUE HAS BEEN RESOLVED SO CAN BE IGNORED -------

Also, same site, different issue. I've done word replacement and changed the name from Organization to Organisation but when I search for Contact Type, it's still showing Organization - regardless of whether I specify exact match or not for the word replacement?


texts: How to get Participant Fee as Part of the Total Contribution, using Webform Integration

texts: Using Webform to register Event Participants, how can I get the Partipant Fee (and any other amount part) displayed as a Contribution Item of the "Total" in the Contribution page, like here-under (copied from Webform Event Fees in Combination) ?


texts: Timestamp mismatch between MySQL and PHP

texts:
Every time I log in to CiviCRM I get the following error message:

  Timestamps reported by MySQL (eg "2015-11-06 13:44") and PHP (eg "2015-11-06 11:44" ) are mismatched.

I am using CiviCRM 4.6.10 and Drupal 7.41.

The host (CiviHosting) has said that the MySQL server timezone is set to "Europe/Sofia" and can't be changed.

I have set the PHP timezone via php.ini to match this:

date.timezone = "Europe/Sofia"

However, I am still getting this error message.

The date section of phpinfo shows the following:

date/time support   enabled
"Olson" Timezone Database Version   2013.3
Timezone Database   internal
Default timezone    Europe/London

Directive   Local Value Master Value
date.default_latitude   31.7667 31.7667
date.default_longitude  35.2333 35.2333
date.sunrise_zenith 90.583333   90.583333
date.sunset_zenith  90.583333   90.583333
date.timezone   Europe/Sofia    Europe/Sofia

(Note that the 'Default timezone' is different to the 'date.timezone'.)

Any idea how I can fix this?

Thanks for your help.


texts:
We take Contributions and Event registrations via our website, and I'm hoping to add a simple eCommerce facility for resources we sell.

Just wondering what options might exist for adding this facility. We would want eCommerce customers to become CiviCRM contacts, but we're open to whether this happens at the front-end or via a back-end function (we're not anticipating large volumes of sales).

Our current toolset includes: CiviCRM 4.7, Drupal 7, CiviCRM Webforms, Entity Forms.


texts: Creating your own tokens page content gone

texts:
Has anyone else noticed the content of this post no longer shows?

https://civicrm.org/blogs/colemanw/create-your-own-tokens-fun-and-profit

I'm trying to write a token to use the contribution note as a smarty variable but would like to review the tutorial. ..


texts: Online Membership Renewal, without login

texts:
Our members do not login to the website. There is no member only content in it. But we want our members to be able to renew online. All members have a unique member number. We put their number on the label of the magazine we mail them, so they have it. It's stored in CiviCRM as Individual: External Identifier.

When we starter with CiviCRM we did not have email addressees for most members, so the email address in the CRM is often not real.

Is it possible to make a custom renewal form that accepts the member number and email address, and have a dedupe rule based on the member number? The email address should then be added (updated?) to the member record.

I tried making a copy of the New Member Form, and changed the profile to one that only asks for email and member number. But upon the form submit it returns this warning:

  Please correct the following errors in the form fields below:
  External ID already exists in Database.

Any ideas what we should try next?

The environment is:
Joomla: 3.9.14
CiViCRM: 5.21.1


texts: How to set up basic CiviCRM access for a user in WordPress?

texts:
I created a basic WordPress user with Author role.
I sync'ed the user to CiviCRM and checked the corresponding Contact was created
I edited the WordPress Access Control to grant some permissions to the Author role

However when my user logs in to WordPress there is no CiviCRM menu item...

What else needs to be done?
Note that access works fine for Administrators -- but I would prefer not to give full admin rights to everyone.
This has to be something really simple -- but I'm not seeing it.... Pointers would be much appreciated


texts: Real-time dashlet of contacts without certain activity

texts:
I would like to create a dashlet listing contacts who do not have a certain type of activity scheduled.

I've tried a comnbination of smart groups and include/exclude search, which works but does not update in real time.

Volunteers need to see the immediate result if they make an appoitment for a client, the client needs to disappear from the list. Otherwise they will be worried that they haven't done it correctly, and it won't inspire confidence in the system.

I've looked at Views but if I create a view with Contact as the main entity, I try to add a relationship to Activities but Activities does not come up as an option.

I'm about to write a hook that tags and untags contacts when the appointments are made, completed or cancelled. Do I really have to do this? It seems there must be another way!


texts: CiviCRM Upgrade from 4.5beta6 to 4.6.8 - CiviCRM Menu is not displaying/functioning

texts:
Stepped upgrade from 4.5beta6 to 4.50 stable to 4.60 to 4.68. Was as beautiful and eventless an upgrade process as I've experienced. Congrats and thank you team.

My only QA issue is with the civicrm admin menu. It is busted.

I can confirm menujs script is loading.
I can confirm html for the menu is present.
I can confirm there are no js errors.
I can confirm resource urls are fine.
I have cleared the caches like a maniac.

So all I can think of is some crazy css conflict, but I can't even...

Clicking on a link causes it to expand its LI's but incredibly broken-like.

Any ideas would be incredibly appreciated.

Thank You!


texts: cron job stops running after upgrade to 5.17.4

texts:
After upgrading to CiviCRM 5.17.4 under Joomla the cron jobs that had worked happily before stopped.  They didn't seem to be giving any error, but CiviCRM reported that they had failed to run.  We using Cpanel and have the following command line:

php <path>/administrator/components/com_civicrm/civicrm/bin/cli.php -s https://<url>-u <user> -p <password> -e Job -a execute

Any suggestions. We have tried running cron.php, but that, in its current form, doesn't handle parameters when run from the command line.

Has anyone else seen the issue?


texts: I am setting up a new Price Field for a Webform I am creating and none of the Finincial Types in the drop down menu suit the Contribution so I need to create a new Financial Type. I cannot work out how to do it.


texts:
Is there a good (and simple :) way to have CiviCRM flag up when contacts may need to be handled with care (as a way of forestalling situations where we can never contact them again, ever)?

Obviously the 'No bulk emails' setting stops us from spamming people who want more of a personal touch, but I'm thinking more about situations where someone books on to an event, and they might need a more specific response than just an e-ticket, or we might want to flag up with the event coordinator that they're attending. There might be different reasons for this - e.g. they booked on to an event which was cancelled, and they missed the email about the cancellation, so we need to let them know by phone if there's any changes to events; they have specific access needs and may not be comfortable sharing this with new people; they're connected to funders and we want to impress them; and so on.

We can use tags or custom fields to record issues to be flagged but I'm not sure how to get those flags to appear in a useful way in upcoming activity lists or event participant listings. Or, indeed, how they could be displayed clearly in contact searches. Is there a way to set css classes in reports that relate to tags or custom fields?

ETA: Some of this flagged information may be confidential or sensitive and should only be seen by staff (and not the volunteers who do data entry for us) - but those contacts should not be completely hidden from volunteers.


texts: Can I access/create InnoDB tables in the database

texts:
I have a WordPress website on my server. I have installed CVCRM plugin on that site. I have configured database name, MySql server, and user credentials. When I click on check requirements button in the connection setting page I am getting an error like this " Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server ". We installed CiviCRM WP Plugin version 4.1.0. Can anyone help me with this issue?

Thanks & Regards
Surya


texts: CiviCRM and PayPal Pro's Transparent Redirect

texts:
We are looking into PayPal Payments Pro for payment processing. PayPal mentions "Simplified PCI Compliance" as a benefit and explains that the client can use Transparent Redirect to help with PCI compliance.

The Payflow Gateway Developer Guide and Reference explains the Transparent Redirect this way:

  PayPal Payments Pro and Payflow Pro merchants who want PCI compliance
  while maintaining full control over designing and hosting checkout
  pages on their website can use Transparent Redirect. Transparent
  Redirect posts payment details silently to the Gateway server, so this
  sensitive information never goes through the merchant’s website.

Per Eileen in CiviCON Denver- Adventures in Payment Processing: 360 View from around the Globe, it sounds like there is a way to get Civi to allow for transparent redirect.  Per this comment, it sounds like transparent redirect was being worked on for 4.7.

How would one implement Transparent Redirect in CiviCRM for PayPal Pro? Do the recent payment processing changes in 4.7 allow for it?

I've looked at PayPal Website Payments Pro and Express Configuration, but didn't see anything in there.  I've checked the demo for 4.7 to see if there is a setting in there, but didn't see anything in the payment processor setup.

We use Drupal and are currently on Civi 4.6.6, but looking to upgrade to 4.7 within a month or so.

Thanks!


texts: Recommended upgrade for my civiCRM with Drupal 6

texts:
I'm currently using civiCRM 4.4.2 with Drupal 6.

I would like to know if I should upgrade it first to another version, or upgrade it directly to 4.7.5.

What do you recommend?

Thank you!


texts: Set the Webform-CiviCRM Contribution Amount to a parameter value

texts:
A client is using webform-CiviCRM for a contribution page.  Due to pro-rating and other factors, each contributor needs to pay a unique amount - and thus the webform has the exposed "Contribution Amount" element that can accept an amount from a user.

How can I pre-fill this Contribution Amount using a custom field value?  The webform Default Value can't be set to a token for a custom field that has the amount (returns "This is a CiviCRM currency field. Default value must be a number.", even if the field is an integer or a number.

It might also be possible to attach the $ amount to the URL as a parameter?


texts: civimobile too old , while I've the latest version

texts:
I've got the message civimobileapi to old, please install a recent version

That's what I did....No result

FYI:

I've downloaded the latest recent software versions from github
Both: civomobileapi and CiviCRM WP REST API

I've use 'com.agiliway.civimobileapi' without any extra as :master or version number.

I've the latest civicrm version

yes, I've cleaned the catch

I've install the civimobileapi in different dirs (for sure in the ext)

But nothing happens. Still ....civimobileapi is to old please use a ne version

Any solution, will be much appreciated!


texts: Contact Summary Editor Extension Question

texts:
I am using CiviCRM 5.19.4 and Drupal 8. I need to customize the Contact Summary page - installed the extension Contact Summary Editor successfully. All is good, added all the contact information that I want displayed. However, I need to add events and contributions for the contact to the summary page, but this information isn't displaying on the fields that are available to select from when creating a new block.

Thanks for your help!


texts: Error when trying to view profile list on frontend by public

texts:
I suspect this issue is one of a single configuration not being set properly, but I am at my wit's end to figure out which one...

I am trying to create a public directory of a CiviCRM group of contacts.

I have set up a profile and indicated it to be used for form & list as well as search. Each field of this profile is set to "Public User Pages and Listings" and visible.

In the CiviCRM configuration in the backend of Joomla, I gave permission to public users to view all contacts, view their (my) contacts, profile view, access all custom data.

I created a Joomla Menu defined as public and of the CiviCRM profile list type (associated to the correct profile).

When I try to open the menu, I get an error stating that the "the contact ID parameter to see the contact registration with a profile was not found" (free translation as it is written in French in my DB)

A registered user, on the other hand) can see the directory, so it has to do with a public user not having a contact ID...

What am I missing? How can I have the system overcome this?

Thanks in advance for your help!

Related question (I assume), when a registered user goes to this page, the first thing he sees is his own profile and need to click the "Return to contact list" to view all contacts. Is there a way to make this directory direct so the user sees the table right away?

Follow-up after June 15th comments:
Registered as a test school and when to the URL:

Clicked "Return to contact list" and copied the URL for that list:
https://voile.qc.ca/fr/?option=com_civicrm&task=civicrm/profile&Itemid=1046&force=1&gid=14

Closed session and copied list link public site. Arrived directly at the list w/o the registered user profile data.

It thus seems that the option to view the contact profile needs to be turned off somehow.

But how?

Thanks!


texts:
Anyone else getting there menu at the bottom after updating to CiviCRM 5.13.2? Any ideas?

Drupal: 7.66
PHP: 5.6.40
MYSQL: 5.5.62

Thanks


texts:
I feel like I've run into these issues before but for the life of me cannot remember the solution.

I have a front-end profile listing, when you go to view the full profile, all the fields are clickable but the actions after the click are inconsistent. For example:

Click on a website URL - goes to the website
Click on an email link - goes back to the profile list search results for that email address.
Click on a custom field (note type) - goes back to the profile list search results for that field.

Obviously, the problem with the Bio field is the worst, and even though the field is set to NOT be searchable, you're able to click on it and search by it. Setting it to View Only didn't do anything.

Wordpress 4.3x
CiviCRM 4.6.10


texts: How to query "delivery status = unknown" on CiviMail report

texts:
I am trying to see all the emails, where the delivery status was "unknown". I have been trying to change the URL parameter "delivery_status_value" to "unknown", but that gives a fail as a response. Which value should I use for querying? Or is there another way of filtering the recipients, which's delivery status is unknown? I would have downloaded the excel/CSV file, but that does not seem to work on our system.
The version we use is 4.6.36.
Thank you very much for your help!


texts: Contribution Amounts Section does not work

texts:
On Civi 4.7.27 and Wordpress 4.9.1

On the contribution pages, if I have Membership section enabled AND Contribution Amounts section enabled, everything works fine. If I have just Membership section enabled, everything work fine. However, if I have just the Contribution Amounts section enabled, after submitting the contribution, users will land on an error 500 page. The contribution will be completed and the record will be stored in civi, but the confirmation email will not be sent.

After hours of trouble shooting I have narrowed it down to: this only happens when the Contribution Amounts section is enabled by itself. Everything was working fine, until the recent upgrades. The error logs I can find are not giving me any useful information.

Also I just installed the same version of Civi on another server and everything works fine, including the Contribution Amounts section.  All the settings are the same on both pages.  Both Servers are on the same host, so I don't think it is a hosting problem.  I think there is something broken is civi, but I don't know how to find out where to look.
Does anyone have any ideas?

Thank you.

Errors from Logs

1 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Mail/EmailProcessor.php(104): CRM_Core_Error::fatal("No mailboxes have been configured for Email to Activity Processing")

2 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/api/v3/Job.php(401): CRM_Utils_Mail_EmailProcessor::processActivities()

3 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_fetch_activities((Array:1))

4 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(169): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))

5 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(100): Civi\API\Kernel->runRequest((Array:7))

6 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("job", "fetch_activities", (Array:1), NULL)

7 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(145): civicrm_api("job", "fetch_activities", (Array:1))

8 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(79): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))

9 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/api/v3/Job.php(99): CRM_Core_JobManager->execute(FALSE)

10 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_execute((Array:2))

11 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(169): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))

12 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(100): Civi\API\Kernel->runRequest((Array:7))

13 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("Job", "execute", (Array:2), NULL)

14 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.class.php(113): civicrm_api("Job", "execute", (Array:2))

15 /home/oursite/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php(32): civicrm_cli->callApi()

( [message] => Could not connect to MailStore for civicrm_bounce@ouremail.org
Error message:
An error occured while sending or receiving mail. The POP3 server did not accept the password: -ERR [AUTH] Authentication failed. .

 [code] => ) –


texts:
I want to apply a CiviDiscount to an event that uses a Price Set, but it doesn't seem to work the way I want.

The Administer CiviDiscount / New Discount Code form includes 2 fields ...

'Events'
'Price Field options'

The on-screen help for the Price Field options says 'If your form uses a price set, the discount will be applied to all options in the set by default. However, if you want the discount to be applied only to specific price options - select those options here.'

The implication is that I can just specify the Events for which I want the code to be valid.

But that's not how it works. I can only get the Discount Code to work if I specify both the Event and the Price Field. Am I missing something here?


texts: Removing avaliable languages from Localization

texts: I have added some 5 to 6 languages, I want to remove few of them how can it be done.


texts:
I am trying to use PHP on the Command Line to import 90,000 contacts to Civi 5.0. It seem like there is a memory like when calling:
civicrm_api3('Contact', 'create', $usrArray);

Does anyone know what code in the api could be causing this?

The looping of the CSV has been written not to use up more memory than the line being read, this has been tested alone with memory_get_usage();

Best,
Joel


texts: My question is, can the Member get an automatic invoice directly from CiviCRM once he renewals his membership even if he didn't pay online, or he chooses to pay via bank transfer?


texts: When reinstalling CiviCRM, it will not allow connection to a database with preexisting data

texts:
I am reinstalling CiviCRM on Wordpress after Civi quit quit working.  I deleted the folder civicrm in /plugins and also in /uploads.  This allowed me to upload the new plugin version of Civi and took me to the CiviCRM Installer.  However, I get this message "CiviCRM data from previous installation exists in 'database_april'" which is the name of the database from my previous installation.  How can I get the Installer to allow connection to the prior database?
Thanks for your help!


texts: In the user workflow I currently have, parents sign up for tuition payment plans for the program their children are attending. These are processed as pledges with varying numbers of installments, attached to the parent contact. Is there any way for me to assign those pledges to multiple people? For example in a two parent household, I would like both to get reminder emails. I feel like this is somewhat similar to giving soft credits to household members for contributions, but I'm not sure how to do it for pledges as well. Ideas?


texts: What does it mean to "configure your MySQL server for utf8mb4 support" when my database charset and collation are already utf8mb4?

texts:
I am about to run the CiviCRM installer, but I get the following warning:
CiviCRM MySQL utf8mb4 Support: It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true
However, my database configurations are already as follows:

So what exactly is "MySQL utf8mb4 Support" and what are the steps to configure it properly? (e.g. what do I do with this exactly? "innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true")


texts: How can I expose event creation fields on Drupal 8 front end without CiviCRM Entity?

texts:
A key feature and service of our Drupal 8 site (in development) is to allow users to create their own events. I want to expose some of the event creation fields to them on the front end. Is there a way to do this in Drupal 8?

When I research, I see solutions that involve CiviCRM Entity and Webforms, but Entity does not appear to have a stable Drupal 8 release (the latest is 8.x-3.x-dev, updated on August 14th).

If the event creation fields were available when creating a profile, I would do it that way. Since I don't have sufficient programming experience to properly build an extension, my backup is to style the admin interface and CiviEvent creation form to look as much like our public-facing site as possible, but that's a last resort.

I apologize if this question has been answered already, and I missed other proposed solutions. Thank you in advance for any help you can provide.


texts: Where did the standard HTML window go on mailings with mosiaco installed?

texts:
I'm testing an upgrade to 5.9.1 and have installed mosaico (versions listed below) and have a few issues with mailings.

Try to create a new mailing.  I don't see the standard HTML window with the wysiwyg editor.  I see one for Design which has the mosiaco templates in it.

If I select a standard (non-mosaico) template, I don't have anyway to see it nor edit it.

If I select a mosaico template, I get that editor and can edit it no problem.

Another issue that may be a clue, is if I hit preview HTML either from the main screen or from within the mosaico editor, nothing happens.  I get a db error with FK constraint on civicrm_mailing_trackable_url.  The sql is doing an insert and doesn't have the mail id.  It is only trying to insert url.

Clearly this works else where so I must have something basic wrong.

Versions:

civicerm 5.9.1

mosaico 2.0-beta4.1528762072

FlexMailer 1.0-beta1

Shoreditch 0.1-alpha30  I could never get this work.  It says it's optional so I skipped it.  In playing with this, the not working could be related.  It might work, in the mailing screens I wasn't getting the options for regular template and it looked like things weren't necessarily in the right place.


texts: How can I export civicrm contribution along with its price set fields?

texts:
I want to export the civicrm contributions. I want the priceset fields to be included in the report. I am trying to export them in Contributions->Find Contributions->Export Contributions
While selecting the fields I want all the priceset fields in the option. How can I achieve this? Any help would be appreciable. Thanks in advance.


texts: What's the story behind the name 'CiviCRM'?

texts:
Last week, we finally deployed CiviCRM in our organisation. Hurray! :-)

One of the questions I get from our users, is 'what does the civi in CiviCRM means'? And I have no idea.

Does anybody knows something about the name CiviCRM, about where it comes from?


texts: Removing the contact search on a contribution page

texts:
I am making a donation page in wordpress using civicrm (latest version for wordpress). For someone who comes to the page for the first time I would like to give them the option of signing up for a newsletter.

The issue is that at this stage they have not signed up yet so they are not in the database. I have a profile attached to the bottom of the donation page to allow them to put in their details. Another issue with the search bar is it allow you to find anyones email address just by searching for their name which is also not what I want.

I was wondering how to remove this search bar asking to select someone else. I would prefer for it to go to an anonymous form that doesn't let you search for contacts. See picture below of the yellow bar containing the form.


texts: Why won't data entered into CiviCRM profile html snippet save?

texts:
I'm using Joomla 3.4.1 with CiviCRM 4.6.3 on a demo site as part of a re-design. I've used the CiviCRM profiles html snippet to create a Joomla signup module. See here for example.

It worked once - storing the name and email into CiviCRM and even re-directing to the proper page and giving a thank you message after it stored the data.

However, now when you hit "save" in the module, this time nothing is saved and it kicks you back to the front page. I've read the manual, searched the forums, and tried a bunch of stuff, but nothing works. What am I missing?


texts: CiviDiscount of 100% create zero amount payment

texts:
I have a set up where events carry a fee, but using CiviDiscount a 100% discount is offered to logged in members. This basically works fine, BUT it still creates a payment/contribution for each member registration, with a paid sum of zero.

Is there a way of preventing the creation of a zero contribution altogether?


texts: Custom data sets, search and display in CiviCampaign

texts:
I am currently setting up CiviCRM for the small NGO I currently work for, and I am having a lot of trouble with CiviCampaign.

We use CiviCampaign to record every fundraising campaign the organization is running and to relate contributions, events and activities to it. As the organization is active in different countries, we have one coordinator in charge of each geographical sector we work in. Therefore, he is responsible for the fundraising campaigns of the projects located in the countries he's in charge of. Those projects can also include a local partner and one or several volunteers working locally.

I created a campaign for every project we have in the organisation, as donators can specify they want their money to be used for a specific project. I also added custom data sets to record the person in charge of the project, the volunteer affected, and the local partner that benefits from the projet.

However, it seems there is no way to see the details of a campaign (when I go to the dashboard, I only see the ID, the title, the description, start and end dates, campaign type, status, and if it is active or not). I cannot click the campaign to see all the information I have recorded, and I must click edit to see the custom data sets. I cannot find a way to use those custom data fields as criterias for the search engine either.

Basically, those issues make my custom data useless, as I cannot use it as search criterias and I can't even consult it.

Is there a way to achieve what I want?

Thank you in advance for your help.

wedYa


texts: How did my import result in the State for a different country to the one intended

texts:
How could a CiviCRM database have 2 Marylands with 2 different state_province_codes but both be identified with the same country_code?

1019 = Maryland
3497 = Maryland
1228 = United States

I only was alerted to this when my newly inherited client created a Smart Group to display all records with postal_code between 20601 and 21930.

Is my CiviCRM instance corrupt or has a bad import caused this? Can I manually adjust the offending records without cascading problems? How would you suggest a fix for this?


texts: CiviMail - Error 500 when tracking clickthroughs

texts:
We have recently upgraded to CiviCRM 4.7.0, and we have Drupal 7.41

As part of the upgrade process, I upgraded PHP to 5.6.17

Most things work brilliantly, but when we have link tracking enabled on a CiviMail email we get this error:

  Fatal error: Call to undefined function drupal_add_http_header() in
  /home/ace/public_html/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php
  on line 789

An example URL is https://acenterprises.org.uk/sites/all/modules/civicrm/extern/url.php?u=1535&qid=864040

There's nothing recorded in the HTTP Error Log - can anyone give me any clues on debugging this error?

Thanks!


texts: Session invalidated after returning from PayPal CiviCRM v 4.7.31

texts:
I've just upgraded to CiviCRM 4.7.31 from 4.7.30 on Drupal 7 and we've identified an issue which wasn't there previously.  After being redirected to PayPal from a contribution form, the session is invalidated once you return to the site.  I've checked the qvKey from the form to the "return page" (which throws an error) and it is correct. Payments are lodged correctly. Any ideas?

Error log is

$backTrace =
#0 /www/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(833): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(853): CRM_Core_Controller->invalidKeyCommon()
#3 /www/sites/all/modules/civicrm/CRM/Contribute/Controller/Contribution.php(74): CRM_Core_Controller->invalidKeyRedirect()
#4 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(312): CRM_Contribute_Controller_Contribution->invalidKey()
#5 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(204): CRM_Core_Controller->key("CRM_Contribute_Controller_Contribution", TRUE, FALSE)
#6 /www/sites/all/modules/civicrm/CRM/Contribute/Controller/Contribution.php(55): CRM_Core_Controller->__construct("CiviContribute", "null")
#7 /www/sites/all/modules/civicrm/CRM/Core/Invoke.php(304): CRM_Contribute_Controller_Contribution->__construct("CiviContribute", TRUE, "null", NULL, "false")
#8 /www/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15))
#9 /www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#10 /www/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:3))
#11 [internal function](): civicrm_invoke("contribute", "transact")
#12 /www/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#13 /www/index.php(21): menu_execute_active_handler()
#14 {main}


texts: Is it possible to downgrade or upgrade a membership created on CiviCRM?

texts:
Is it possible to downgrade or upgrade a CiviMember membership?
(upgrade = more access, more expensive / downgrade = less access, less expensive / both options need to be able to change joomla user group)
If yes, how? I can only find information about renewing the current membership.


texts: Why do reminders not go out to some of the contacts who should receive them

texts: Situation is that having ruled out contacts with no emails, blocked, etc there are still some contacts that are not having reminders created/sent


texts: I am using Joomla 3.8.8 stable and CiviCRM 4.7.25 New or copied live event and payment links are being redirected to the homepage. Existing events work and go to forms.


texts: Is there any hook that can be used for logging contact views? We need to create report for that and first of course need to put that information to database.


texts: Civisualize: Creating Your Own Visualization concept question

texts: Is CiviVisualize and the CRM API designed so that when someone wants to create their own visualizations, they only have to create a template in templates/dataviz/? Then, using the CRM API they can call a SQL Search Query in the template.tql file to customize which data they want to represent. Or, is there more files that must be created?


texts: Multilingual contribution and registration pages in Wordpress

texts:
I have a couple of forms on my multilingual website (French and Dutch, Wordpress + WPML plugin).
I translated signup profiles and contribution pages in both languages.

I can succesfully call the original (Dutch) page with an url like domain.com/nl/?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=1 but I can't figure out how to display the French version.

Can anybody help me here?


texts: Guidance Request : SSO between CIviCRM & WordPress!

texts:
We've been using CiviCRM for a number of years and also running a blog on WordPress.

I can't find much information on setting up SSO / OAUTH / SAML / or even just custom CiviCRM | WP API to handshake and achieve a better user experience.
(I checked the CiviCRM API Doc and don't see user authentication)
I once setup SSO between Vanilla Forums 2 and a custom C# asp.net site and just don't see something like that available.

I did find this: (I wouldn't use Facebook SSO because of privacy offneses)
https://civicrm.org/sites/civicrm.org/files/SingleSignOnAccess-for-CiviCRM-Facebook-case.pdf

WordPress has alot of options for SSO plugins:
https://wordpress.org/plugins/tags/single-sign-on/


texts: We recently updated CiviCRM to 5.13.5 and have noticed that the date picker for memberships and relationships have stopped working. It is working for events and  other areas. Can anyone help please.


texts: New Website Users Connecting to Existing Member Record

texts:
Is there a way to use an ID provided to members by our organization so that they may enter it (and say their last name) to create a new account by themselves and automatically assign the account to their membership record?

We're importing our membership records from a csv file to our contacts and adding them to the CiviMember data manager, but it is not likely that we'd want to create website user accounts for every member.

Is this possible, or is there a better way for me to handle the membership and user creation on our website? I'm new to CiviCRM and am still trying to get my head wrapped around it. Thanks in advance!

To separate this question from the duplicate question.

Basically, we want to host all membership management using CiviCRM. Some of the members will want to signup for website accounts to manage their information, and some will not (aka our 80+ year old individuals). But since our membership will already be hosted on our website, I want members to assign their membership details to their account automatically by entering in their Membership ID (and say, their last name) which would connect to the "External ID" in the membership record.

Or is there a better way to do this? I'd like to do this automatically, but if there was a way to do the above and manually approve it, that'd work too for the time being.


texts: Can anyone tell me where I can find the php or css that affects how search profiles are formatted? I want to alter how it looks on the webpage because it clashes with the flow of the website. Any suggestions on a plugin that allows you to search and pull contact information from civi is also appreciated! Thank you very much for your time!


texts:
I am getting this error " [nativecode=1442 ** Can't update table 'civicrm_contact' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.]" after both migrating my database to another server and upgrading to the 5.19 security upgrade.

I have attempted multiple times to run the trigger rebuild URL for Drupal and to use
cv php:eval "CRM_Core_DAO::dropTriggers('civicrm_contact');"
 cv php:eval "CRM_Core_DAO::triggerRebuild('civicrm_contact');"
cv php:eval "CRM_Core_DAO::dropTriggers('civicrm_contribution');"
 cv php:eval "CRM_Core_DAO::triggerRebuild('civicrm_contribution');"

Any ideas of what else to try I would appreciate it.

Thanks,
Josh


texts: Need clarification on switching CiviCRM hosting from a host/consultant

texts: We are currently hosting with a company that also assists us with are CIVI Crm. We are interested in moving our site to a new host and would like to know if the CIVI will move with it? Without having in-depth knowledge of the "back-end" of Joomla/CIVI... I would like to speak with a representative to get a clear understanding of how we can continue to use CiVI and yet obtain a new hosting company. Please, could somebody call me and help us through this transition? Thank you, Tacey Martinek-978-772-2787


texts: What does the membership automatic renewal interface look like?

texts:
Where do I get the option to choose whether to renew a membership automatically? Secondly, how does it only apply to the initial membership?

I have

installed a recurring payments processor (agileware eway)
in the membership type configurations page I've made auto-renew optional
I've tried the page, both logged in and not logged in.

Where should I see this choice?


texts: How to show by default Contributions Tab in Contact Summary Page?

texts:
If I want to access to a Contact Summary Page, I go to url:

http://<my_site>/civicrm/contact/view?reset=1&cid=<contact_id>

Is there any parameter I can add to url (or other way) where I can access to this Contact Summary Page but showing the Contributions Tab by default?


texts: Civi Event scheduled reminders error - missing date causes DB syntax error

texts: Event scheduled reminder is not executing.  The error log for scheduled jobs shows failure DB syntax error.


texts: How do I make "on behalf of" user proof?

texts:
There is no nicer way to say this. My client's end users couldn't follow instructions if they were tattooed on their hands.

It's time to renew memberships. All members are organizations, so all contributions are "on behalf of." The users can't be trusted to enter the names of their member organization correctly. Is there any way to make the "organization name" into a drop down based on relationship?

I can't think of another way to keep users from entering initials instead of the proper organization name. I swear, they will be so creative with input that I can't even design a dedupe rule clean up afterwards.

Help and guidance is greatly appreciated.


texts: Drupal to Wordpress Migration - Can we keep/recreate our forms?

texts: As our tiny organization only has me as our volunteer web developer (and I am far from an expert) we think it may be prudent to migrate over to Wordpress, where things are a little less technically difficult so others will be able to lend a hand. My only hesitation is that we currently make havy use of Drupal's Webform CiviCRM Integration module. We use it for memberships, for event signups, and to collect payment on both of those items. Does Wordpress have comparable capabilities, or would we be leaving that behind?


texts: Why do my buttons keep becoming numbers?

texts:
After updates our Civi installation (which is within WordPress in case it matters) often switched all buttons to numbers instead of their labels.
I presume this might have something to do with translation or templating? It tends to go away when I do all the usual post-upgrade things like clearing caches etc, but no amount of fiddling is fixing them this time.
Can anyone suggest what could be related? What can I try? What might cause this?
It's happening to all Civi buttons on the frontend and the backend, but not any non-Civi buttons.


texts: How to disable all scheduled jobs in civicrm.settings.php?

texts:
Similar to e.g.:

$civicrm_setting['Directory Preferences']['extensionsDir'] = '/Applications/MAMP/htdocs/Louise/git-7/sites/semper-it.local/civicrm/extensions';

Can I do something that sets all scheduled jobs to => disabled?


texts: Search builder operators do not work for Preferred Communication Method

texts:
You can reproduce this yourself on the demo site:

Search Builder > Contacts > Preferred Communication Method = Phone

Returns the exact same results as

Search Builder > Contacts > Preferred Communication Method != Phone

See the screenshots:

and then:


texts: Your database settings don't appear to be correct. All green, but still error!

texts:
trying to install CiviCRM with Wordpress and I get the red DB error BUT all the line items are green.

Any suggestions?

Thanks!

WP: 4.9.10
CiviCRM: 4.7.30 Wordpress
Mysql: 5.7 on Azure

Added comment:

I also ran this:

<?php
echo "* SQL CONNECT TEST **";
include('./config.php');
// print_r(get_defined_constants(true));
#phpinfo();
$dbcnx = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!$dbcnx)
{
          print ("

Param(s): " . DB_HOST ." / ". DB_USER ." / ". DB_PASSWORD ." / ". DB_NAME . "
\n");
          die ("

Error:" . mysqli_connect_errno() . "
\n");
}
echo "
Connected to the database server!
\n";
echo "
\n";
echo "
End of script!
";
?>

Came out clean, connected and all (config.php is a copy of the Wordpress config file)

So I checked to see if somehow CiviCRM was using mysql_connect() instead of mysqli_connect(), but it's not.

Really at a loss here :-|


texts: The action Remove contact from group not working in Civirules

texts:
I'm using CiviCRM 4.7.23 version.Using civirules, For the trigger-"Contact of any type is restored" , Action -"Remove contact from group" .If any contact is restored from trash, it should be removed from the group.This is not working for me. The contact is not removed from the group.
Any help?


texts: Unable to access volunteer functionality

texts:
With Drupal 7.64 CiviCRM version 5.10.4 & civivolunteer version 4.7.31-2.3.1
Created a new event. Under the Volunteer tab in event configuration, there are three buttons Log Volunteer Hours button is working and other two buttons Define Volunteer Opportunities, Assign Volunteers not working after clicking on those buttons nothing happens.
Anyone facing the same issues?


texts: Any OTHER way to disable DB logging (CiviCRM 4.6x)?

texts:
Enabled logging to a DB caused "TABLE log_xxx doesn't exists" similar to this issue ; Extension installation (which should re-create LOG_ tables) has failed by the same reason. A sneaky trick from here hasn't worked either, due to a missing MySQL/MariaDB ARCHIVE engine, which by default is being used for LOG_ tables.

Any other options of disable logging, apart from messing with MySQL installation and temporary DB tables re-creation code insertion?

Thank you!


texts: How do I print the "received date" on an invoice?

texts:
I have an urgent problem with invoices. For our finance department, I have to print out all invoices we generated this year.
On the invoice, it HAS to display the date the invoice was issued, but instead it displays the date that I print the invoice.

In the template, the line

  {ts}Invoice Date:{/ts} {$invoice_date}

gives me the CURRENT date, not the date the invoice was issued.

I have looked for other variables I could use, but I had no luck finding anything.

Does anyone have a solution for this?


texts: How to get max_amount, min_amount from Contribution Page

texts:
Issue: Coding wordpress plugin for civicontribute widget, I need to get some variables in order to build the progress bar.

When I use civicrm_api3('contribution_page', 'getfields'); it returns a lot of information which does not seem to be accessible when using civicrm_api3('contribution_page', 'get', $params);.

May some of you put a bot of light on how to get this data?

PS. May it be easier to code an alternative template for the widget?

Thanks!


texts: Cron Invalid username and/or password, After 4.2.9 to 4.2.20 Joomla Upgrade

texts:
Very grateful if anyone can tell me where to start debugging this issue.

I had cron working fine in 4.2.9

I've cleared all, caches, templates, sessions, logged in and out as the cron user who is Super Admin. Key was also restored from backup settings files.


texts: Missing extension "moregreetings" after upgrade to CiviCRM 5.36

texts:
I am running CiviCRM with the extension Moregreetings.
After upgrading CiviCRM to version 5.36 without other problems, I got two notifications:

Unknown extension: de.systopia.moregreetings
Warning: Error loading module file (). Please restore the file or disable the module.

I am wondering how I have to solve this issue. I would like to know if it is safe just to reinstall the extension. I fear to loose the huge work for setting up this extension.


texts:
A client of ours wants to have badges that have 2 fields on one line and would also like to have the state be the full name vs the abbreviation.  I'm pretty certain it would require custom code but posting here to be sure I haven't overlooked anything.

We are using 4.6.4 with this client.  And Drupal latest.


texts: How do I use the API to access protected custom data in a hook?

texts:
I have custom data for events that is not visible to anonymous users (it's for internal use only).

I want to access that data from my implementation of hook_civicrm_post().

When I call the API "get" from within the hook, the API doesn't return this custom data, since it's protected.

I guess I want my implementation of the hook to run as if it's a logged in user. How do I do that within the hook, but not in a way that opens up visibility once the hook completes running?

Here's a cut-down sample of my code, where 'custom_25' is the custom field which is not returned as part of $event ...

function xxxxxx_civicrm_post( $op, $objectName, $id, &$params )
{
  if ($objectName == 'Participant') {
    switch ($op) {
      case 'create':
        $event = civicrm_api3('Event', 'get', array(
            'sequential' => 1,
            'return' => 'custom_25',
            'id' => $params->event_id,
        ));
        break;
    }
  }
}


texts: Membership issues when people have two different emails

texts:
Given how difficult it is to merge two contacts, each with memberships (as detailed in
How can I merge two memberships in the same contact (without losing contribution info, etc)?) we are anxious to avoid this situation when members renew.  But how?
Contacts who are already members but have a new email address since joining will try to renew with the new email address.  Their name is the same, but a new contact record gets created and their new membership goes into that contact.
Our membership renewal reminder emails contain a link that will let them renew properly, but we can't FORCE users to only use that link.  Ideally members could ask us to change their email address first, THEN renew.  But we can't force them to do that either.
Any tips or suggestions?


texts:
I have civi crm 4.7.8 on wordpress 4.5.3 and I've changed my website domain name.
When I go to wp admin, i can see civicrm icon and go the taskboard, but I haven't civicrm menu.
I supposed there are some changes to do in database to set new domain name ?
Can you hep me ?


texts:
Viewing some Smart groups (not all) causes DB error.

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

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => INSERT IGNORE INTO civicrm_tmp_e_gccache_554616ac5a2e5773984de236f4af031e (group_id, contact_id)  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
[type] => DB_Error
[user_info] => INSERT IGNORE INTO civicrm_tmp_e_gccache_554616ac5a2e5773984de236f4af031e (group_id, contact_id)  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT IGNORE INTO civicrm_tmp_e_gccache_554616ac5a2e5773984de236f4af031e (group_id, contact_id)  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]"]
)

I think, this error is since the last, 5.26.1 update.

Has someone this problem, too?


texts:
Is anyone doing any work on Contribution widgets?  We use them all the time, but they have problems on our end - specifically they do not update immediately when new donations are made - we have to personally clear browser cookies in order to see updated information. (this is likely a local issue - not civicrm)

Is anyone working on a Contribution Widget plugin for core or wordpress (our current setup) - paid or otherwise? Something more visually appealing or dynamic than what we have now?

Many thanks!


texts: New account creation during profile sign-up not creating Backdrop (Drupal 7) Account [SOLVED]

texts:
I am using the latest CiviCRM 5.18.4 and Backdrop 1.15.x-dev all up to date.

I am new to CiviCRM, but have used Drupal 6,7 and 8 over the years.
I have been following the excellent documentation, I am sure I have done everything correctly to create a Contribution Page with a profile to allow a visitor to create a CiviCRM Account in the 'host' Group I have created, because when I add a user he/she appears with all the correct data from the profile and in the correct Group, but the user is not added as a Backdrop User.

In the Profile I have 'Drupal User Registration' and 'View/Edit Drupal User Account' checked, so it should work.
I have looked all over this forum, and searched extensively on the internet, but cannot find an answer.

I have enabled debugging but there are no errors in the CiviCRM or Backdrop logs.
I can add a new user as a visitor in Backdrop, I have tested that. Works fine.

Any help much appreciated.
Is it something to do with the Backdrop Permissions? IF so what should those be?


texts: How to send "thank you" emails to donors?

texts:
We want to send emails to our donors of the previous week. This email needs to be customised, as it's an opportunity to tell them what has happen in the week or what's the plan to the week ahead.

I tried to use the thank you letter feature, but I haven't been able to customise much of the email (eg. the subject line) easily for each mailing.

If I do a "normal" mailing from an advanced search on donors, I haven't found an easy way to set the "thank you" date on the contribution, and only filtering on the contribution date isn't robust enough, and I'd like to use that field to know as well when the donor has received the thank you email.


texts: How to remove the dummy contacts from the default contact DB

texts: How can we remove the dummy contacts from the default contact database?


texts:
After upgrading from 4.7.31 to 5.2.0 the system status page is blank. I made sure the Directory and Resource url settings match; I cleaned up caches and reset paths; I disabled the Asset Cache; no luck. Anything I'm missing?

EDITED TO ADD:

I have since upgraded, and when I go to the status page I get an error that CiviCRM is unable to retrieve an extension. After I update paths, then it just goes to a blank page. The console says: Error: Syntax error, unrecognized expression: #/status


texts: I am not looking to be first on this - just wanted to see if anyone is running J3.8 and current release of Civi.


texts: Is it possible to prevent a certain role from changing the activity status in a case activity?

texts: The use case is that every user should see their cases and their activities, but only certain users (based on their Drupal roles and permissions) should be able to change the status of some activities. The build up of the activities in the case summary form/page is not done in advance and does not show up in the buildForm hook. It is a jQuery datatable with a source url that is linked to CRM_Case_BAO_Case::getCaseActivity. What I have done is create a page in my extension and replace the sourceURL in the datatable with one in my extension, and in the callback replace the core method CRM_Case_BAO_Case::getCaseActivity with my own specific one. Any suggestion for another / better method?


texts: Are extensions that work with CiviCRM 4.7 also compatible with 5.x?

texts: Most of my extensions are marked as compatible with 4.7 but do not explicitly say they will work with 5.0, 5.1, etc. Can I safely upgrade CiviCRM and continue to use the extensions?


texts: Command failed (cv php:boot --level=settings) when trying to run tests

texts:
I'm trying to run CiviCRM's unit tests, but I hit on this error when running scripts/phpunit AllTests:

RuntimeException: Command failed (cv php:boot --level=settings) in ...tests\phpunit\CiviTest\bootstrap.php

This is on the master branch of CiviCRM on a local development machine.

Using Windows 7 with a XAMPP stack
PHP Version 5.6.15
The civicrm-core directory is up to date with the master branch


texts: I have an existing email template I have made and now I want to repurpose it for another use while keeping the basic layout. How can I duplicate my original template please?


texts: Email address is missing on Thank You page where it says "An email confirmation with these payment instructions has been sent to"

texts: Noticed this on a couple of sites - not sure if this is a bug yet. When I tested on dmaster it fills correctly so perhaps this is a bug/regression that has been fixed between 4.7.27 and 4.7.30/31


texts: Search Builder Smart Group with Latitude, Street Address criteria 1292 Truncated DB Error

texts:
CiviCRM 5.9.1. Issue has occurred since an upgrade from version 4.7.17. The Smart Group/Contact Group in question is built on two simple search builder criteria:

Contacts Primary Street Address is NOT EMPTY
Contacts Primary Latitude IS EMPTY

We can edit the criteria, and go to the initial list of contacts. But trying to run the search/query, view the contacts, or update the group creates a hard DB error. I have attempted to re-create the group and encountered the same exact issue.

This is the query in question (FYI the ID of the group is 58):

CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache1621 (
    SELECT 58 as group_id, contact_a.id as id
    FROM civicrm_contact contact_a
    LEFT JOIN civicrm_address ON (
        contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1
    )
    WHERE((
        (NULLIF(civicrm_address.geo_code_1, '') IS NULL)
        AND(NULLIF(civicrm_address.street_address, '') IS NOT NULL)
    ))
    AND (contact_a.is_deleted = 0)
    AND contact_a.id NOT IN (
        SELECT contact_id FROM civicrm_group_contact
        WHERE civicrm_group_contact.status = 'Removed'
        AND civicrm_group_contact.group_id = 58
    )
);

The resulting error is:

[nativecode=1292 ** Truncated incorrect DOUBLE value: '']

However, when I run the SELECT query alone in PhpMYAdmin without the "CREATE TEMPORARY TABLE" bit, the query works fine and displays results.

EDIT: When I try to run a Search Builder with the same criteria outside of a group, I am actually able to retrieve the results, yet the LOG is still showing a DB Error:

Ignoring exception thrown by nullHandler: -1, DB Error: unknown error

And I can't get a query in the logs because they are hidden in the traceroute.

EDIT: I put this in the answer as well, but I find it somewhat important to note now that whenever I attempted to edit this existing Smart Group's search criteria, I always had to re-select the operator.


texts: What is required to run CiviCRM on Pantheon?

texts:
pantheon.io is a managed hosting service & devops infrastructure with support for Drupal and WordPress.

What additional considerations are there for hosting CiviCRM on Pantheon?
Are there any specific configurations or patches required?
Is there any functionality which differs from hosting CiviCRM on a "standard" LAMP stack?


texts:
I have a search page set up with a shortcode like this:

[civicrm component="profile" gid="18" mode="search" hijack="0"]

Everything seems to be working except that searching on a custom data field, "Certification," generally isn't working.

None of the other search fields are custom fields. Don't know if that relates to the problem.

------ new material below, added in response to comments -----

"Certification" is a text field and is set to "Searchable."

Some examples of content for the "Certification" field are shown below. I would expect that I could search on any string within any of these (e.g. Curr or Curriculum or Teac or Teacher). None of those work. Even searching on a complete entry like Coach, Trainer/Teacher, Curriculum Instructor doesn't work. The only one I've found that works is Coach -- I'm guessing because that is a complete entry with no commas? Perhaps the commas are causing the problem?

I'm realizing that this data was imported into a CiviCRM text field from a multiple-select field in another database. There were four options in the other database: Coach, Trainer/Teacher, Curriculum Instructor, and Mediator. I'm thinking I need to change or move this into a multiple-select field in CiviCRM. Not sure what the best/easiest way to do that is.

Wordpress 4.7.5 CiviCRM 4.7.17


texts: How do I install the "Birthday by Month" extension in CiviCRM 4.7.31

texts: I am a newbie and here's my first question - how do I install the Birthday by Month extension in my CiviCRM? It is not showing up in my list of available extensions. I am on CiviCRM 4.7.31


texts: How to prevent public use of profile, while still allowing use via HTML snippet

texts:
I would like to disable access to specific profiles via their public URL, while still allowing HTML snippet access, i.e. I'd like to allow POST only. Is this possible?
We have fake spam contacts entering our database from https://secure.wildsight.ca/civicrm/profile/create?gid=56&reset=1. This profile is only used via HTML snippet on our other website and there is no need for it be available at this URL.
Disabling use of the profile for Standalone Form or Directory prevents any submissions from the snippet. ReCaptcha doesn't seem to be preventing these submissions.


texts: I understand I need to convert a table into a csv file, but the contact table in question has both an individual and their spouse in the same record.  Now I can build a query that would only show me the individual's information, but once I import that information into civicrm how would I then import a list of spouses and get them to setup relationships, or will I just have to manually enter those in after importing the primary contact information?


texts: Unable to add or edit profiles on contribution pages

texts:
I am unable to add, edit or delete profiles from my contribution pages.  I am not sure what is happening.  I decided to not modify reserved profiles and create a custom profiles and trying to change that is no longer possible.  Am I doing something wrong?  On one of my pages there is a text box, though it does nothing, on the other, there is nothing.

Also occurs when I try and make a new contribution page.  Using Wordpress 4.7.5, CiviCRM 4.7.16 - Occurs in Chrome, Firefox, even in incognito mode.


texts: Performance Warning: Missing Indices. Mismatched Index Key

texts:
Just upgraded to 4.7.23 and am receiving a Performance Warning: Missing Indices.

The warning states:

The following tables have an index key with a mismatch in value. Please delete the key indices listed from the below table and then click on 'Update Indices' button.

Then the following is listed

Table Name - civicrm_case_contact

Key Name - UI_case_contact_id

Fields - case_id, contact_id

I found the Table in my database with phpMyAdmin. Nested inside are Columns and Indexes. Inside Indexes is what looks like the Key Name of: UI_case_contact_id, and also something labeled: FK_civicrm_case_contact_id.

Will simply deleting UI_case_contact_id resolve this issue?

Or, do I need to delete the Field: FK_civicrm_case_contact_id?

Or is there another approach?

My Civi is definitely slower so looking to see resolving this would help.

Attached an image of the Table from PhpMyAdmin

Thanks in advance

Tim


texts: Mattermost not sending verification email (but does send password reset)

texts:
So I can reset my password but never get the verification emails. I tried the old link I got months ago, but that doesn't work anymore.

Username is


texts: Get date in CiviCRM default date format in custom Drupal module

texts:
Preamble

I write a Drupal7 module which allows CiviCRM event registration form design alter.  While getting a list of events from CiviCRM, the module performs some checks against events properties.

Code

  /* Get today in PHP  */
  $dt = new DateTime();
  $now = $dt->format('Y-m-d');

 $event_arr = civicrm_api3('Event', 'get', array(
'is_active' => 1,
'is_online_registration' => 1,
'return' => array("id", "title"),
'is_template' => 0,
  /* FTW??? */'event_registration_end_date' => array('>=' => $now),

));

Problem

There are two websites with different locales, hence different default date formats (Y-m-d and Y-d-m) and one of this gives  "Fatal error: Unsupported operand types " ( perhaps because of date in a wrong format, if it's not an API error).

Question

How to get "today" in CiviCRM  default date format (defined in /civicrm/admin/setting/date?reset=1)  in Drupal module

Thanks!


texts: How to export multiple relationships of contact

texts:
i am confusing how to show all relationship in the exported report, there's a example below.

Company A have 3 representatives in the relationship field.

and using following method to export.

find membership -> select Company A -> export members -> Select fields for export (Field Mapping).

The exported report show 1 representative of comapny A only. Any advance or solution ?

i have tried multiple columns on Using Field Mapping during "Select fields for export" phase. it doesn't work.


texts:
I'm setting up a vew of cases of type "x" and using views relationships to pull in cases relationships such as "Case Worker for" Client- as well as client details.
If, I have a client who has had more than one case with the organisation. With a number of "Case Workers". how can I filter the view to only show the case relationship for the listed case?
Currently will now show duplicate lines or each case, 1 per case worker.
If I use views aggregator plus module, I can compress  the view down to one line per case- but it is normally the first added case worker shows not the one for the specific case.
See screenshot for example- 1 client, 1 case, but 5 caseworker relationships to the client