texts:
After years of no issues with MySQL backups we are suddenly getting these errors. I can't sort out any way to delete the tables. There shouldn't be any permissions issues. MySQL 5.7.
Error: Couldn't read status information for table civicrm_tmp_e_xggroup_2177743371563e34f834c0d9790552b4 ()
mysqldump: Couldn't execute 'show create table civicrm_tmp_e_xggroup_2177743371563e34f834c0d9790552b4': Table 'civi.civicrm_tmp_e_xggroup_2177743371563e34f834c0d9790552b4' doesn't exist (1146)
Error: Couldn't read status information for table civicrm_tmp_e_xggroup_443d27af19bdb52809e75d4b181eab24 ()
mysqldump: Couldn't execute 'show create table civicrm_tmp_e_xggroup_443d27af19bdb52809e75d4b181eab24': Table 'civi.civicrm_tmp_e_xggroup_443d27af19bdb52809e75d4b181eab24' doesn't exist (1146)
Error: Couldn't read status information for table civicrm_tmp_e_xggroup_5fd70ef5bada19f2de97b3c92f38746f ()
mysqldump: Couldn't execute 'show create table civicrm_tmp_e_xggroup_5fd70ef5bada19f2de97b3c92f38746f': Table 'civi.civicrm_tmp_e_xggroup_5fd70ef5bada19f2de97b3c92f38746f' doesn't exist (1146)
Error: Couldn't read status information for table civicrm_tmp_e_xggroup_7ce7ce5c41d286dd8dd07ba9eaa34b75 ()
mysqldump: Couldn't execute 'show create table civicrm_tmp_e_xggroup_7ce7ce5c41d286dd8dd07ba9eaa34b75': Table 'civi.civicrm_tmp_e_xggroup_7ce7ce5c41d286dd8dd07ba9eaa34b75' doesn't exist (1146)


texts: Different Result in Code Than API Explorer

texts:
I am trying to get data out of the API and when I look at it in API explorer I find what I am looking for but the data is incomplete in my module.

For example, I am using civicrm_post($op, $objectName, $objectId, &$objectRef) and I know this is working because I have if ($objectName != "Case" || $op != "create") and my code in the if is firing.

    civicrm_initialize();
$result = civicrm_api3('Case', 'get', array(
          'sequential' => 1,
          'id' => $objectId,
          ));

Here is the result from the API call in my module:

Array

(
    [is_error] => 0
    [version] => 3
    [count] => 1
    [id] => 352
    [values] => Array
        (
            [0] => Array
                (
                    [id] => 352
                    [case_type_id] => 5
                    [subject] => Test Case Subject
                    [start_date] => 2017-07-24
                    [status_id] => 4
                    [is_deleted] => 0
                    [contact_id] => Array
                        (
                        )

                [client_id] => Array
                    (
                    )

                [contacts] => Array
                    (
                    )

                [activities] => Array
                    (
                    )

            )

    )

)

Here is the result from the API Explorer:

{

"is_error": 0,
"version": 3,
"count": 1,
"id": 352,
"values": [
    {
        "id": "352",
        "case_type_id": "5",
        "subject": "Test Case Subject",
        "start_date": "2017-07-24",
        "status_id": "4",
        "is_deleted": "0",
        "custom_70": "IL",
        "custom_72": "Peoria County",
        "custom_76": "1",
        "custom_78": "2",
        "custom_92": "Farmers",
        "custom_100": "1500943386-26151211",
        "custom_95": "Test",
        "custom_96": [
            "1"
        ],
        "custom_97": [
            "1"
        ],
        "custom_98": [
            "1"
        ],
        "custom_99": [
            "1"
        ],
        "contact_id": {
            "1": "9025"
        },
        "client_id": {
            "1": "9025"
        },
        "contacts": [
            {
                "contact_id": "9025",
                "sort_name": "Applications , Test",
                "display_name": "Test Applications",
                "email": "test@aplications.com",
                "phone": "",
                "birth_date": "1919-04-04",
                "role": "Client"
            }
        ],
        "activities": [
            "21781",
            "21782"
        ]
    }
]

}

Any help is appreciated.

Thanks,
Josh


texts: Use custom field in front end of website

texts:
We are testing your application CiviCRM and we tried to create a custom field as contact reference for all kind of contacts.

However though in the preview on the back end this field works fine, when you try to use on the front ebd (chrome, IE, Mozilla) the active search does not work (it doesn't allow to search for the contacts in database).

Example:

Front end (Custom Profile Field “Visita à Loja” - It is a Contact Reference Field - It was suppose that when you select the field, active search was functional. But it’s not!)

When you see the back-office profile and you select “Preview all fields” of this profile, everything works properly:

“Data da Prospecção” - It has a Calendar Icon that when you select, a popup calendar appears so you can select date (in front office the icon doesn’t appear)
“Visita à Loja” - Active search is functional, allowing you to search for contacts in database. However in front office this doesn’t work (as you may see above)

Can you help
best regards
JSousa


texts: Data Protection / GDPR - deleting from logging tables

texts:
With the new GDPR legislation taking effect in a matter on months, it dawns on me... how can we delete people permanently from the logging tables? My understanding is that the table types are a special archive type that don't allow for deletion of individual rows.

Is that right?


texts: I've just created a new field with a 'yes/no' answer.  Can I auto-fill all records with a specific answer?


texts: Blank screen when using versafix-1 templates

texts:
This weekend I migrated my site from one server to another.  The htdocs remained the same, just the infrastructure was upgraded.  I backed up my sql database and files and restored them in the new location.  No paths locally or via the internet changed.  Only the IP address of the server.  PHP and MySQL were upgraded but only by point releases (ie. 7.3 and 8.0 were the core).
After the migration it seems that I cannot create any new mailings in Mosaico using the versafix-1 template nor can I reuse existing emails based on this template.  What is weird is I can use the template tedc15 and tutorial.  When I select versafix-1 it goes to a blank grey screen.
Console errors:
TODO error!!! Trying to set a new default value for bodyTheme longTextStyle.linksColor while it already exists (current: #3f3f3f, new: #ccc)

declarations.js:130 Model ensure path failed undefined name -ko-color value @longTextStyle.linksColor default #ccc element undefined

parser.js:403 Exception while parsing the template Exception parsing expression @longTextStyle.linksColor TypeError: Cannot read property 'longTextStyle.linksColor' of undefined

parser.js:403 Uncaught Exception parsing expression @longTextStyle.linksColor TypeError: Cannot read property 'longTextStyle.linksColor' of undefined

admin.php?page=CiviCRM&q=civicrm/mosaico/iframe&snippet=1:1 Uncaught ReferenceError: pagespeed is not defined
    at HTMLImageElement.onload (admin.php?page=CiviCRM&q=civicrm/mosaico/iframe&snippet=1:1)

Here's what I've done to troubleshoot:
Reinstalled Mosaico:

Uninstalled Mosaico
Deleted the Mosaico directory from the ext folder
of my server
Downloaded a fresh copy of Mosaico from the CiviCRM
website
Installed Mosaico

Upgraded to the latest version of ImageMagick (also made sure the extension was not commented out)
Verified file permissions (I actually set everything to 777 inside the wp-content/uploads/civicrm directory for testing)
Disabled Asset Caching
Verified Resource URLs and Directories (both set to [civicrm.files]/ext/)
Can anyone help shed some light on what's going on here?
Many thanks for your help!


texts: Upgrade CiviCRM 4.6.20 to 4.7.10 on Drupal - db error

texts:
I'm upgrading a CiviCRM 4.6.20 install to 4.7.10. I'm on Drupal 7.50. I've tried the updgrade several times. My Drupal database updates are all executed. Before running the upgrade, the civicrm_action_schedule table has an INDEX with the name, FK_civicrm_action_schedule_mapping_id. But when I execute SQL to list all foreign key constraints, there are none. I don't know if this makes a difference, but the table is empty. I don't have any rows in civicrm_action_schedule.

What could I be missing here? Thanks!

[Error: Upgrade DB to 4.7.alpha1: SQL]
Error Field Error Value
Type    DB_Error
Code    -4
Message DB Error: not found
Mode    16
UserInfo    ALTER TABLE civicrm_action_schedule DROP FOREIGN KEY FK_civicrm_action_schedule_mapping_id [nativecode=1091 ** Can't DROP 'FK_civicrm_action_schedule_mapping_id'; check that column/key exists]
DebugInfo   ALTER TABLE civicrm_action_schedule DROP FOREIGN KEY FK_civicrm_action_schedule_mapping_id [nativecode=1091 ** Can't DROP 'FK_civicrm_action_schedule_mapping_id'; check that column/key exists]


texts: Why is 4.7.7 CiviMail failing trying to insert a row into civicrm_mailing_recipient?

texts:
To reproduce ...

Create a mailing that includes contact X as a recipient
Delete the email address of X
Send mailing

The job fails trying to send an email to X. Each time the job runs it queues emails to send to the same set of contacts (those 'before' X). Job never completes.

I suspect it's a side-effect of https://issues.civicrm.org/jira/browse/CRM-18345


texts: CiviCRM Webform : Select field used to use autofill

texts:
I want to use 3 fields (name, surname, phone number) to search existing contact and then autofill other fields.
I don't find how to specify how to map the CiviCRM field to search, nor how to define 3 fields used to search.

Is it possible? And how ?

Thank you for your help.

Regards.

Olivier.


texts: Does class autoloading not work in standalone phpunit testing?

texts:
I'm following civix's upgrade instructions to enable unit tests to be executed with standalone phpunit.

I've got my code in a work-in-progress git branch. The first commit captures the civix-generated boilerplate phpunit.xml.dist and bootstrap.php. The second commit captures my attempts to adapt an existing test to the new way of doing things.

With these changes in place, I do:

$ cd /path/to/webroot/sites/all/modules/civicrm/tools/extensions/civivolunteer
$ phpunit4 tests/phpunit/api/v3/VolunteerProjectTest.php

... and get:

PHP Fatal error:  Class 'VolunteerTestAbstract' not found in /path/to/webroot/sites/all/modules/civicrm/tools/extensions/civivolunteer/tests/phpunit/api/v3/VolunteerProjectTest.php on line 6
PHP Stack trace:
PHP   1. {main}() /usr/local/lib/civicrm-buildkit/bin/phpunit4:0
PHP   2. PHPUnit_TextUI_Command::main() /usr/local/lib/civicrm-buildkit/bin/phpunit4:545
PHP   3. PHPUnit_TextUI_Command->run() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/TextUI/Command.php:100
PHP   4. PHPUnit_Runner_BaseTestRunner->getTest() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/TextUI/Command.php:123
PHP   5. PHPUnit_Runner_BaseTestRunner->loadSuiteClass() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/Runner/BaseTestRunner.php:67
PHP   6. PHPUnit_Runner_StandardTestSuiteLoader->load() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/Runner/BaseTestRunner.php:123
PHP   7. PHPUnit_Util_Fileloader::checkAndLoad() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/Runner/StandardTestSuiteLoader.php:39
PHP   8. PHPUnit_Util_Fileloader::load() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/Util/Fileloader.php:38
PHP   9. include_once() phar:///usr/local/lib/civicrm-buildkit/bin/phpunit4/phpunit/Util/Fileloader.php:56

Any suggestions?


texts: Can a Scheduled Job using mail_report send Reports as HTML in the e-mail body, rather than as a PDF attached to the e-mail?

texts:
We're on CiviCRM 4.6.19 and Drupal 7.50 .

I'm having problems with six daily Scheduled Jobs to send reports using Job and mail_report and instanceId=x. Three of the reports get sent successfully, and three do not. There's an error reported with DOMPDF when executing the three failures manually as well. It's not an error with the e-mails being blocked as spam.

So: Is there an option to send a report as HTML in an e-mail as a Scheduled Job, rather than as an attached PDF file? Is there a parameter for mail_report to send as HTML?

Or: Is there another API option to do this besides mail_report?

Thanks!


texts: How can I specify quantity of tickets on event participant import?

texts:
I'm trying to figure out if there is there a way to specify quantity of tickets? Like a person bought 2 tickets but civi participant import processes doesn't seem to let me specify that.

Any suggestions?


texts: How to update multiple records with API?

texts:
For doing updates to multiple contacts using the API, is there a better way than this?

$res = civicrm_api3('Contact', 'get', $params);
foreach ($res['values'] as $contact) {
  civicrm_api3('Contact', 'create', array('id' => $contact['id'], ... ))
}

For a large number of contacts, this is slow and eventually runs out of memory.


texts: Does Extension Relationship Permissions as ACLs work on CiviCRM 5.2.3?

texts:
The Extension says it is Compatible with CiviCRM 4.7.

It seems to work with CiviCRM 5.2.3, but am I safe using it?

I did notice one side-effect - when this extension is enabled I can't edit the permissions on existing Relationships.  The little AJAX spinner never stops.  Is this a known effect, or is it related to the CiviCRM version?


texts: Can a user removed from smart group manually be added back automatically if criteria is satisfied?

texts:
I have a requirement,
 where I need to Limit Scheduled Reminders to Only Members with Active and Grace Status(which is a smart group)
But
If I remove a user manually from
Member with Active And Grace Status Group,
will he stop getting Scheduled Reminder even though
 he/she is an Active Member or Grace Status Member, also is there a possibility when he pays again for membership, will smart group add him back or once removed from smart group manually, he/she will not be added at all


texts:
recently I've encountered a strange issue when sending mass mailings by CiviMail. E.g. I have a mail list of 100 people and I send them a newsletter. Later, in the mailing summary, I can see how many people received the mail and how many emails bounced. Due to the issue I am seeing:

- Intended recipients 78
- Mailings delivered 74 (94.87%)
- Transmission 0
- Answers 0
- Rejections 0 (0.00%)
- Requests for discharge 0 (0.00%)
- Requests for resignation 0 (0.00%)

As you can see, I had 78 recipients of this mailing but only 74 received the message. I've traced those 4 recipients (I've created groups based on the Intended recipients and delivered mailings and looked for those 4 recipients) - but when I've tried to send the mail to those 4, the mail status is finished but the mailing summary states:

- Intended recipients 4
- Mailings delivered 0 (0.00%)
- Transmission 0
- Answers 0
- Rejections 0 (0.00%)
- Requests for discharge 0 (0.00%)
- Requests for resignation 0 (0.00%)

I can't find out why the system is not allowing me to send those mailings. The logs are empty. I'm on Drupal 7.69, CiviCRM 5.20 and I'm using PHPMailer + Mosaico.

Has anyone encountered this kind of issue?


texts: How can I add a "Recurring" filter to core "Repeat contribution" report?

texts:
I need a particular type of report which I could not find in core or extended reports.
So I thought of modifying the core report PHP and place it in custom PHP directory. I have manage to add "payment instrument" filter to this particular report.
        'payment_instrument_id' => array(
        'title' => ts('Payment Instrument'),
        'type' => CRM_Utils_Type::T_INT,
        'operatorType' => CRM_Report_Form::OP_MULTISELECT,
        'options' => CRM_Contribute_PseudoConstant::paymentInstrument(),
      ),

However, I need to add another item to the group to filter the result limited to recurring contribution. It could be a checkbox or a Yes/No. Can anyone suggest how can I add it please? Thanks


texts: After upgrading to 4.6.18, cannot enter credit card details in event registration

texts:
We just upgraded our site at www.fremantlechamber.com.au to the latest version of Drupal and CiviCRM 4.6.18

Now when we try to register for an event, the credit card details are not appearing and noone can pay for registration.

Please help

Thanks


texts: If no valid price set is found for an event, CiviCRM fires a fatal error, shouldn't this be prevented?

texts:
If I have a event with a price set field date set so that it is expires, when it expires but event signups are still active it cause a fatal PHP error and logs 'No Fee Level(s) or Price Set is configured for this event.'.

This should fail more gracefully, e.g. we should be preventing users from being able'register now' otherwise users can try to register for the event and be greeted by an error?

Steps to reproduce:

Create event and add price field to the price set and set it to expire via the 'expire on' field. Once expired, clicking register now will cause a fatal error.

CiviCRM version 5.11


texts: WordPress plugins and themes incompatible with CiviCRM

texts:
I am looking for a way to find which plugins incompatible with CiviCRM without deactivating them and install one by one.
And if you have any experience with your WordPress website please share here.
I fond this (https://docs.civicrm.org/sysadmin/en/latest/integration/wordpress/incompatibilities/) link but I am looking a way to know which my plugins incompatible with CiviCRM.


texts:
Is it possible to use the latest and greatest Civivolunteer to allow a user to see their own assignments on a dashboard or view?  Found this (https://github.com/aghstrategies/civivolunteer_views) but it appears lightly dated (still appreciative!)

Reasoning: people are not satisfied with just getting an email, we want to encourage them to login and review their assignments in their /user or ???page.


texts: In prior versions, you used to be able to 'exclude' certain groups when creating bulk mailings. Where is this function now in 4.7.9 drupal civicrm? I'm not seeing a way to exclude groups now.


texts: CiviCRM on Drupal begins Install and then reverts to "Page not Found"

texts:
The Title pretty much sums it up. 2 databases, each is correct, I'm running on a Bluehost dedicated server. It has it's own Cpanel account for static IP and SSL (eventually). But first I have to get it installed.
The installer runs for 30-40 seconds and then goes to: "The requested page "/sites/all/modules/civicrm/install/index.php" could not be found."
Does anyone have any ideas????


texts:
I have civicrm 4.7.27 installed on Wordpress 4.9.1
Everything was fine yesterday when I created new contribution pages.  Then this morning I noticed that the Introductory and Footer message textareas of the Title and Settings tab of the Contribution pages are not loading the WYSIWYG Editor.  As far as I can tell, this is only happening in this area, and not any other area that relies on ckeditor/WYSIWYG, but I am concerned that because this came out of nowhere, that it will show up in other parts of the install.  Does anyone know what is going on?  Is it possibly a known bug with 4.7.27?  See screen shot for error messages.

Thank you


texts: I've disabled certain activities that we do not want to keep track of (Record merged, for instance). Yet, when I merge a record, the activity is still automatically created. How can I prevent this from cluttering up our Activities tab in the future?


texts: Upon installing the extension and then changing the settings so that 'Collapse this set on initial display' and 'Collapse this set in Advanced Search' are marked with yes, the follow warning of "Custom group 'Areas' already exists in Database' appears. How do I fix this error?  We're using Civi 5.0.0


texts: Donor access to edit recurring donations

texts:
WP 4.8
Civi 4.7.21
iATS Payments 1.6.0

Our donors have very limited ability to edit recurring donations. Ie. if their card expires they cannot update the expiry date. Or if the card number is changed, they cannot update to a new card number.

As admin, I can see an update card info but the donor cannot.

I have looked at ACL but have not seen anything there that looks like would give/restrict that ability.

Is there something I am missing in the ACL or is this an iATS Payments setting?


texts: Title says it all really. Just trying to verify if there are known breakages, or if we just need to update the Extension info page


texts: How to skip confirmation screen upon contact deletion

texts: When I do a search and select to permanently delete a batch of contacts, I am taken to a confirmation screen that asks me to confirm the deletion. I would like to (at least temporarily) skip/disable that confirmation screen so that when I select the Permanently Delete option, Civi would start deleting the contacts right away. How can I do that?


texts: Custom Top Donors (Contributions) report with the name of Relationship Managers

texts: Followed the instructions on civix and built an extension, copied the Top Donors report and set up the new template. Now I see the original report. Need to modify the php so that I can pull in the name of the Relationship Managers from Relationships. Any pointers on this? Thanks much.


texts: How do I embed a CiviCRM page into a wordpress page?

texts:
I'm new to this and trying to get my head around the integration with wordpress.
I'm having problems using CiviCRM to integrate with wordpress. I set up a civicontributions page with membership dues etc but when i try to follow the documentation to embed the contribution page into my wordpress page. The documentation asks me to "Click on the CiviCRM icon next to Upload / Insert" but no such icon is available for me, nor do I see an Upload/Insert button.

I've installed WordPress 5.1.1 and CiviCRM 5.13.1
i've disabled all plugins except for CiviCRM and tried different themes.

Any help would be very much appreciated.
Thank you very much
best regards,
David


texts:
Big picture:  I'm working on a module that will display view-only custom data on a specific contribution page.

Please understand, if you're not aware of this already, view-only custom data is not available to smarty templates automatically.

I have successfully put my custom-data in a variable and have displaying in a debug message on my specific contribution page.

Now I want to display it for the user.  Some folks seem to be using the hook buildform for this.  I've looked at he buildform reference, and can make a form field appear on my contribution page.

In my template, I've tried using {$variable_name}, but it seems that's not enough to display my variable.

I've also tried:
$form->setVar( 'my_var', $variable_name); //in the module

and

{$my_var} // in the template

or

{$form.my_var} //  in the template.

Still nothing.  How do I pass a variable to a smarty template?

Can someone reply with some source code for the module and accompanying template help illustrate this for me?

Thanks much


texts: Complex multiple Selects in Custom Coded Reports

texts:
Following on from my query  here How to write custom report SQL

(CiviCRM 4.7 on WordPress)

I built the SQL I needed as step 1, which works fine in mysql / phpmyadmin.

I have used civix, to generate a module and to clone the 'empty' report from 101 and register the report - so far so go, if I want a report that says 'hello'.

Next step slot in my SQL and test ....  and within civi it gives sysntax errors.

Debug shows that it is inserting SQL_CALC_FOUND_ROWS all over the SQL, where as I need it only on the final select.

Although my requirement is simple my SQL is complex, and I can't achieve it in one SELECT statement ( maybe possible by a SQL wizard ), as it requires contact relationships in two directions and a 'pivot' of contributions, it builds 3 temporary table and joins them up in a final select.

My main question is 'can CiviReport only handle a single select?'  and the second question is is there something I can do, or should I just resort to coding outside CiviReport structures?

Thanks so far for the help given, it has been fantastic.

Eaxmple issue

CREATE TEMPORARY TABLE tmpcontrhist AS
   SELECT SQL_CALC_FOUND_ROWS house_id,
     YEAR(contr.receive_date) memb_year,
        contr.total_amount memb_amount
FROM
   tmpareareps,
   civicrm_contribution contr
WHERE
   house_id = contr.contact_id;

Database Error Code: 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    'CREATE TEMPORARY TABLE tmpcontrhist AS SELECT SQL_CALC_FOUND_ROWS house_id, ' at line 21, 1064


texts: I have a problem in word replacements as well. It is not getting replaced in all places. Tried replacing "contributions" with "donations". the change is not getting reflected in CiviReport, while in other places it has changed


texts:
I face difficultly validating individual contacts to a group who must be a member of its parent group.
For Example I have groups such as sales executive-north, sales executive-east,sales executive-west. All these have Sale Executives as there parent group.

Case 1 : Whenever I add new individual contact to any of the three subgroups, the system have validate/notify  that the  contact have to a member of Sale Executives group first.

Case 2: Whenever I  remove a member from Sale Executives group then they have to be removed from its subgroups also.

Is there way to control this through Civirules ?


texts:
Years ago we tried out CiviHR and it added something which looks like a set of custom fields, called "Extended Demographics". We uninstalled the extension but this did not go away. I can't find anywhere in Civi settings how to disable or remove it. I've ignored it till now but we are about to give a lot more people access to Civi and it will confuse people having irrelevant (and very personal!) fiends on there.

I suspect it was a bug in CiviHR that caused it to be left behind. If I want to remove it from the database using MySQL (which I am very familiar with) then is there anything I need to know so I don't break anything? We have backups, but the less blindly I can bash at the live site the better.

Obvs if there is a setting I've missed that would be much better


texts: How do I find the ID of a custom field, contribution, option value, etc.?

texts: Many answers posted here involve finding an ID number for a custom field, or a group, or something else.  How do I do that?


texts:
We are still evaluating CiviCRM 5.4.1 and CiviCase on Wordpress 4.9.8

Most of our requirements can be filled by CiviCRM and CiviCase.

But one requirement is to have invoices listed and followed up in case summaries.

I found that we can generate invoices in Contributions and Events which would suit our need to generate invoices.

But I can't get them listed in a case summary/activities.

Does anybody know how I could get this to work?


texts:
Failure installing CiviVolunteer ver 4.6-2.1.1 on CiviCRM ver 4.7.6.

I'd previously had CiviVolunteer1.4, (pretty much just playing with it) then attempted 2.0 install several weeks ago.  Nothing happened, and then learned that it was incompatible with 4.7.   Newest release was supposed to fix, but, on attempting install -> I'm getting: message:

Sorry but we are not able to provide this at the moment.
   Field: name must be unique. An conflicting entity already exists - id: 104

   Return to home page.

On return to Civi dashboard, lots of msgs get displayed for just a few sec re: found title, found field name...

Also including image of extensions screen, if that's interesting...

Thanks!


texts: Unsubscribe Token for Subscription Reminders

texts:
What's the best way to allow members to unsubscribe or opt out from Renewal Reminders?

Thanks!


texts:
I hope you can help. I am new to CiviCRM and writing a custom Summary Field.

I have written the new field and the trigger, but I am confused about how this will count all of the values for before today. Is there a place in the extension I need to include another query? Is there other magic I am missing?

Thanks,
Penny


texts: How can I create a public-facing search with mapped results when using Wordpress as the host CMS?

texts:
Using Drupal Views and the contributed module CiviCRM Contact Distance Search
I was able to create a search tool to enable unauthenticated users to find contacts and show them on a map based on proximity to a target location, and also via other exposed parameters. Drupal Views enabled me to show a name and some other data from the individual contact record and address data and org name from related org records.

The built-in proximity search function looks to be based on a profile and so won't let me mix fields from different record types.

Now I need to find a solution, or a developer who can build a solution, with Wordpress as the CMS. Has anyone created anything like this?


texts: Cividesk Sparkpost extension aggressively marking contacts "On Hold"

texts:
I have the Sparkpost extension working great, but after 3 months of weekly mailings, 225 of my 2000 mailing list contacts have been marked "On Hold."  This is a much higher attrition rate than with our old Mailchimp setup.

The Suppression list in Sparkpost only has 25 addresses in it.  The other 200 seem to have been set to "On Hold" by the extension because of block bounces - cases where the recipient mail server automatically deemed our email unworthy of delivery, but the actual recipient never asked to be unsubscribed.

I don't want block bounces to permanently remove someone from our mailings.  I could use the Sparkpost suppression list to remove our contacts who have actually opted out (marked our email as spam, or clicked the Unsubscribe header in their email client).  Then I could re-enable all the other "On Hold" addresses.  But it seems tedious to have to do this every month or so.

I found the logic in the extension code where block bounces immediately trigger "On Hold" status, but it's mixed up with enough other bounce cases that it doesn't seem trivial to change how block bounces are handled.

Has anyone else encountered this?  Has anyone found a solution, or have any ideas?  Thanks!


texts: Mailing summary doesn't display - says that mailing not complete

texts:
Updated to CiviCRM 5.19 - ran one of our biweekly mailings last night and I wanted to check the open count.  But Civi says that the mailing isn't completed,
even though it shows on the mailing summary that it completed at 5:45 AM.

Does anyone else have this issue?


texts: Dashboard problem after installing reverse proxy server

texts:
We recently tightened up the URLs on the server so that everything now goes through https://domain_name.com. There was initially a problem with the dashboard widgets not loading (just hanging on "Loading..."), so I installed nginx reverse proxy, which stopped the "Loading..." issue, but now I get the following displayed where each widget would be:

Not Found
The requested URL /administrator/ was not found on this server.
Apache Server at domain_name.com Port 443

Everything else is working fine. It's just a problem with the dashboard widgets. Any ideas where to start looking for a solution? Thanks.

CiviCRM 4.6.8, Joomla 3.4.3.


texts:
I've set up a custom file field in CiviCRM and exposed it on a Webform. Uploading a file works fine. Coming back to the form after submitting it, the file field displays a "Change" button instead of a "Remove" button, and clicking it seems to clear out the file. However, the file does not go away.

Is there a step I'm missing on how to delete a file that was previously uploaded through webform_civicrm or is this a bug?

Screenshots:

Before

After Upload / Before Submission

After Submission / Returning to Form

On the last step, clicking "CHANGE" will appear to remove the file, but then clicking "Submit" again does not save the removal. Visiting the form again, the file is still there.


texts: Users with 'view own cases' permission can't access resolved cases

texts:
I have noticed that users with the 'view own cases' Drupal permission are getting an access denied error when they try to access their own resolved cases. They can access open cases no problem.

Users with 'view all cases' can access resolved cases as normal.

Is this intentional? I've tried to replicate on the demo site, but wasn't able to create a user with that set of permissions. Unfortunately, while I've tried to make sense of the code referenced in the backtrace, it's beyond me.

Running CiviCRM 5.19.1 and latest Drupal.

Nov 16 00:39:28  [error] $Fatal Error Details = Array
(
    [message] => You are not authorized to access this page.
    [code] =>
)

Nov 16 00:39:28  [debug] $backTrace = #0 .../public/sites/all/modules/civicrm/CRM/Core/Error.php(385): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 .../public/sites/all/modules/civicrm/CRM/Case/Page/Tab.php(72): CRM_Core_Error::fatal("You are not authorized to access this page.")
#2 .../public/sites/all/modules/civicrm/CRM/Case/Page/Tab.php(188): CRM_Case_Page_Tab->preProcess()
#3 .../public/sites/all/modules/civicrm/CRM/Core/Invoke.php(290): CRM_Case_Page_Tab->run((Array:4), NULL)
#4 .../public/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#5 .../public/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#6 .../public/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:4))
#7 .../public/includes/menu.inc(527): civicrm_invoke("contact", "view", "case")
#8 .../public/index.php(21): menu_execute_active_handler()
#9 {main}


texts:
Is there anyone who can help me with some customised data for my CiviCRM (for wordpress)

I need the fields from New Contact to be replaced with my own.

It will be included a start date.

I need to have reminder with 30 days before expiring the "start date" - custom email template

I need to have reminder with 7 days before expiring the "start date" - custom email template
I need to have reminder with 1 day before expiring the "start date" - custom email template

The dashboard should show only some columns that I choose, not everything - with sorting, searching and filtering.

That's it.
I will pay, just tell me who can do that for me.
Thank you


texts: I'm familiar with Drupal / Drush / Civicrm Starter Kit but is there a Starter Kit or sample theme for Wordpress?  I've used WP-CLI and stumbled on civicrm wp-cli but basically looking for a quick start to customize...


texts: How to automatically generate a csv file?

texts:
I need to daily update a list of members between civicrm and an external website on an other web server.
Is there a way/extension to do so from a smart group ?
First step would be to automatically generate a csv file.
It seems that I can't do this with CiviRules.
Second step, would be to export to a certain folder on an external web server.
Any experience or ideas?


texts:
I would like to change two aspects of the Activities table on the Civicase summary screen.

Change the default number of rows to be shown from 10 -> 100
Also have a filter to automatically hide the actvity 'edit custom data' which is created whenever any custom data relating to the case is updated.  This is especially relevant as i'm using Multiple case clients and this seems to create 3 instances of the activity 'change custom data' (if there are 3 clients) for each single edit of the data.

For number 1,
I've looked into the templates and have so far found the template . /CRM/Case/Page/CaseDetails.tpl is being called.  I think the bit concerned is
{foreach from $rows item row} ,

I've not got to point 2 yet.

Any answers or guidance very much appreciated.


texts: What should I do if an issue is marked as fixed in JIRA but it is still occurring?

texts: What should I do if an issue is marked as fixed in JIRA for a particular version, but it is still occurring in a later version?


texts:
I am running CiviCRM 4.6.8 on Drupal 7.

I am using the "Event Calendar" extension to expose a calendar view. The extension works well, with one problem: it only displays the calendar to users with the "Access CiviCRM" permission.

I have had to enable this for anonymous users, which isn't ideal to begin with, but I can manage it by restricting their access to everything else. However, as a result, they can access the CiviCRM Home and Dashboard (despite not having permission to it in Drupal permissions). The Dashboard shows every available dashlet with a bit old "ACCESS DENIED" under it. I'd rather avoid this altogether, and get them to an Access Denied page if they try to access CiviCRM home. Is this possible?


texts: what happened to saving reports as dashlets?

texts:
A long while ago, you could save reports as dashlet.

On the latest version of civi (both clean installs and upgrades), the report still has the option "Available for Dashboard?" but it doesn't seem to have any effect, or any way to save as a new report/dashlet (my memory is a bit unclear on how it worked in the past)

Am I missing something obvious or has that feature gone missing?


texts: Is sandbox the way to try out certain extensions now (instead of Cividemo)?

texts:
CiviDiscount isn't among the extensions configurable in demo, is that b/c 1) it isn't stable enough now (4.6), or 2) there's another way to test it, besides installing it locally (e.g sandbox)?
A second question - there's code in CiviEvent registration relating to some other form of discount, is that functional code and if so, how is it configurable?


texts: How can I synchronize civimail and my microsoft outlook mail program?

texts:
As response mails arrive in my "normal" outlook account, I'd like to see them automatically on civicrm in order to have a better overview. Is there a possibility to create a folder in outlook that updates mails in civicrm?

thanks a lot for your help!


texts: How can I limit CiviDiscount codes to be used for a maximum number of participants rather than amount of times?

texts:
For some of the events we host we want to give our sponsors a certain number of free/discounted tickets. We allow them to purchase tickets for multiple participants at the same time.

We have set up discount codes for each of the sponsors that can be used a limited number of times. but this doesn't prevent them signing up 10 people at one time and therefore purchasing 10 tickets but only using up one discount code.

Is there a way to limit the number of participants a discount code can be used for rather than limiting by the number of times it is used? or is there another way we could achieve this?

Ideally if the sponsor wanted to purchase 10 tickets all at the same time but only get 5 discounted tickets they would get the first 5 for the discounted price and the next 5 they would need to pay full price for.


texts: How to send receipt for previous event sign ups?

texts:
I set up an event registration form without enabling confirmation emails. We just got a request for a receipt from a registrant. I can't find a way to send a confirmation/receipt email to them a day after they signed up. Or a way for the user to access a receipt on our site. (I have since changed our sign up form to include the auto confirmation email.)

CiviCRM 4.5.6, WordPress 4.1.1


texts:
I attempted to enable the Stripe payment processor in CiviCRM 4.6.4 by going to Administer > Administration Console > Manage Extensions > Add New. From there I click the Download link next to Stripe. After doing so I get the following error message:

"Sorry but we are not able to provide this at the moment.
Unknown extension: com.drastikbydesign.stripe"

This message appears when attempting to download other extensions as well.

My CiviCRM Extensions Directory is: /home/sitename/www/www/sites/default/files/civicrm/upload/
My Extension Resource URL is:
http://sitename.org/home/sitename/www/www/sites/default/files/civicrm/upload/

As a possible lead, I get the following error message when entering the Extensions screen: "WARNING: The downloader may be unable to download files which require HTTP redirection. This may be a configuration issue with PHP's open_basedir or safe_mode." If this error message is related, I'm still not sure how to proceed.

Thank you.


texts: Slow exports when 'groups' field included - trying to debug

texts:
I'm having trouble with extremely slow exports when the 'groups' field is included, in 4.6.17. I tracked it down to the main export query, and taking out the irrelevant stuff it breaks down to:

SELECT
    *
FROM
    civicrm_contact contact_a
LEFT JOIN civicrm_group_contact ON civicrm_group_contact.contact_id = contact_a.id
LEFT JOIN civicrm_group_contact_cache ON civicrm_group_contact_cache.contact_id = contact_a.id
LEFT JOIN civicrm_group ON (
civicrm_group.id = civicrm_group_contact.group_id
OR civicrm_group.id = civicrm_group_contact_cache.group_id
)

The problem is the 'OR' in the final JOIN. With the 'OR' it takes 400s, but reduce it to either of the two conditions and it's 10s. This is with 140k contacts.

I've hacked a fix by manually removing 'groups' from CRM/Export/BAO/Export.php. Because I don't actually need to export groups, and they're included by default in the 'primary' fields.

But I'm confused about why this isn't happening to everyone (I figure people would be shouting about this one, but I can't see anything). I'm worried I'm missing an index somewhere, or my db is otherwise broken.

Could someone else with a large db please try the above query, and let me know if it takes a long time?

In our case civicrm_group_contact_cache is empty, and civicrm_group_contact has 232k rows.


texts: How do I add a 'CiviCRM ID' column to an activity report?

texts:
I want to add the CiviCRM ID to the csv report to allow for reloading the activities once some amends have been made? The problem is it is not an option anywhere within the create a report area.

Can anyone please help?

William


texts: Civisualize - getting data from a report into dataviz

texts:
I'm seeing in notes on Civizualize that some work has been done in getting reports data into a form where civisualize can deal with it.

Anyone give me a pointer to where that is?


texts:
When testing the waitlist feature for an event the ticket selections are greyed out and listed as sold out.

The waitlist is dependent on the status and in my test scenario the max number of participants is 3. In my dashboard I have two participants that are attending, one participant that I changed the status to Registered but then canceled, and finally one participant that has a status pending from waitlist.

When looking at my dashboard everything is displayed correctly: I have two registered guests and again my max count is 3. When I go to complete the registration for my waitlisted guest all of the ticket options are greyed out and listed as sold out even though I have room for one more participant to register.

Does the price set option override the status if the ticket selection is counted towards the max participant number?

The status for my cancelled guest is class negative and is counted. (I did test having it not counted as well)

How do I fix this waitlist issue?


texts: now that mosaico has 3 base templates for people to choose from - we don't want our users choosing any of those and only want them to use the custom template we created. Is there something I can do?


texts: Unable to create label format for membership card

texts:
I'm trying to configure printing of a membership card directly from Civi using a custom mailing label format. Here's what I've done so far:

Created a custom label format with the parameters for Avery Label 5371 (business card)
Tried to get the data to print as a mailing label on the card stock (which is pre-printed with the org logo) by creating a message template using tokens for member name, membership expiration date, and membership type (Membership Card Data).
From member search results, performed the action "Create Mailing Label" and selected the custom label format I created in step 1.
Result is a nicely printed list with the name and address of each person, not the information specified in Membership Card Data.

I am guessing that the custom label format controls the size and number of each entry on a page, and the Membership Card Data message template is ignored and replaced by the specs in Localization>Address Settings/Mailing Label. I can't find anywhere to add a new mailing label format that contains the tokens I need for membership cards.

I've combed the boards and have seen discussions, but none seem to address my particular problem. Any thoughts?


texts:
Notice: Undefined variable: alreadyInstalled in
  /var/www/vhosts/casem-acmse.org/subdomains/test/httpdocs/wp-content/plugins/civicrm/civicrm/install/index.php
  on line 274

Luckily this was on my sandbox site. I forgot that I was no longer logged in and tried to run:

  http://mysite/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

Now it wants to reinstall CiviCRM.

May I suggest that someone fix this before it happens on a live site.

Update 1: Looks like I forgot to copy back the civicrm.settings.php file. After changing the version in civicrm_domain back to 4.7.16, I ran it again and it died in 4.17.17.mysql.tpl trying to add the card_type.

ALTER TABLE civicrm_financial_trxn
  ADD card_type INT( 10 ) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to accept_creditcard option group values' AFTER payment_instrument_id,
  ADD pan_truncation INT UNSIGNED NULL COMMENT 'Last 4 digits of credit card.' AFTER check_number;

After adding the card+type manually with no errors, Civicrm refuses to continue.

A copy of civicrm.settings.php could reside in ../uploads/civicrm. Then part one of the upgrade process would be to copy this file and stick in ../uploads/civicrm then copy it back as part one of the install if it exists?

Either that or dump the information in the wp_options table in WordPress and either reload them each time or recreate the file as part of the upgrade.

Given that I'm not emotionally attached to this sandbox database I'm going to get another one


texts:
I installed the Transactional Mail Extension and after adjusting a needed Drupal CiviMail permission got it working.

After testing, I deleted the Transactional Mail pseudo mailing, to start fresh, but find that after doing that I get the yellow-screen-of-death and a missing ID error when an event registration or contribution is submitted.  I disabled the extension for now-- how do I fix this?

Also, oddly in my tests, each sent email had a duplicate record with an unknown status.  Anyone know why?  Thanks.


texts: Do you support SmsGatewayCenter SMS API Module?

texts:
I am a customer of https://www.smsgatewaycenter.com/ from past 1 year and definitely like their service and would want to stick to them.

I have seen one of your plugin for sms with different provider, can I replicate this to smsgatewaycenter.com API?
https://github.com/osseed/com.osseed.sms.mysmsmantra

or do you have it ready with you? Please update. Thanks


texts:
Just updated to Civi 4.7.22, running WP 4.8, [edited] now running php7.0 [/edit] php 5.5.26

After the upgrade CiviEvent will no longer register contacts for events via the backend. After filling out the details and pressing the ok button, everything greys out - I get a 'processing' but nothing happens.

The green CiviCRM logo isn't turning, the page tab isn't updating, nothing. If I move away from the page I get a warning that things aren't saved (which is correct) but even after 5min it hasn't completed.

I'm about to roll back to CiviCRM4.7.17 which will throw a load of security complaints but at least folks will be able to register for events.

Any thoughts before I roll back?
[added]With payment recording unchecked


texts: Issue importing multiple contributions for same contact

texts:
I am trying to import multiple contributions for a contact.  I am using the following fields for the import:  contact ID, total amount, date received, and financial type.

Civi will only import the first row, and after that it says the contact ID is not valid.  I don't understand, I know I have to use the same contact ID for each row because all contributions are from the same contact.

Can anyone help me?


texts: Display custom contact dashboard only to certain Contact subtypes

texts:
Drupal 7.78
Civi 5.28.2
I am setting up a custom contact dashboard following Demerit's answer using UserDashBoard.extra.tpl and smarty's crmAPI.
But I only want it to be for contact sub-type = Student. How would I write an IF statement for that?
Here is my best guess but it does not work.
    {crmAPI var='result' entity='Contact' action='get' id=$contactId sequential=0}
{foreach from=$result.values item=contact}
  {if $contact.contact_sub_type = 'Student'}

Student Demographics

{crmAPI entity='Contact' action='get' var='result' id=$contactId return="birth_date,gender_id,custom_108,custom_107,custom_109,custom_110" sequential=0}
{foreach from=$result.values item=contact}

Date of Birth	Gender	Student Status	 Marital Status	Anniversary	# of Children

{$contact.birth_date}
  {$contact.gender_id}
  {$contact.custom_108}
  {$contact.custom_107}
  {$contact.custom_110}
  {$contact.custom_109}

{/foreach}

Class Info

{crmAPI var='result' entity='Contact' action='get' id=$contactId return="custom_118,custom_112,custom_113,custom_111"}
{foreach from=$result.values item=contact}

Class of	Campus	CG Leader	 Met Spouse at RI

{$contact.custom_118}
  {$contact.custom_112}
  {$contact.custom_113}
  {$contact.custom_111}

{/foreach}

{/if}
{/foreach}

Thanks


texts: CiviMail > New Mailing > No recipients Error

texts:
We've recently installed CiviCRM 4.6.6 and we're on WordPress 4.3. I'm experiencing the same issues as shown in this thread: CiviMail Mailing - Unable to select group, getting error of No recipients
When I go into New Mailing, No Recipients shows up on the right. I can't enter email addresses, I can't select a group, I'm stuck. If I use Search and select a group, and pick the Action to Send a Mass Mailing, the Mail screen has Recipients = Search Results, but still says No Recipients. I'm stuck. Since Mail won't work Debug and Backtrace can't either. I don't know what Ajax is, I'm not that techie. We're on DreamHost, no cpanel, but I can use FTP. Send Mail works and there's no one opted out or anything in my test group. This looks like a bug that's been around for a few months? How can I fix this??? Thanks, in advance...jim


texts: Is there a CiviCRM User Actions Log Feature?

texts:
I need a log of user actions due to a security breach (theft of User Information). However, according to my knowledge and research, CiviCRM does not have such a feature.
How can I access a user's User Actions Log data in CiviCRM. The information I want is as follows. Whenever the user logged into the system, opened a new individual and activity record, and made a search, what is the IP address of my site. Like. There is a feature like this in Joomla but I can't use it either. I wrote the reason in the Joomla form. I think he should keep a diary like this for security breaches and similar issues. The system below is used by Joomlan. Is it possible to adapt this for CiviCRM? Can you help me with this.


texts: How to identify and report on donor anniversaries?

texts: We'd like to acknowledge donors who have given continuously for (say) 5 years. Let's say 'continuous' means at least one donation in a year. How could these contacts be identified and reported?  I've looked at all the contribution reports, including the Powerbase report extension, and thought about smart groups but I can't see a way of detecting these.  There is the 'Recurring contributions' report but that doesn't do it as these donations may not necessarily be defined as recurring contributions.  We're using Drupal so could use Drupal Views, but I'm not sure that would be able to do it.


texts: How does CiviCRM handle https requests to a mutually authenticated SSL server?

texts:
I first ran into this because I was experiencing the issue described at this post: forum.civicrm.org/index.php?topic=6090.0

I'm getting an error when I use the simple curl request script " Connected to example.org (xxx.xxx.xxx.xxx) port 443 (#0) * Initializing NSS with certpath: sql:/etc/pki/nssdb * skipping SSL peer certificate verification * NSS: client certificate not found (nickname not specified) * NSS error -12227 (SSL_ERROR_HANDSHAKE_FAILURE_ALERT)

So, does CiviCRM rely on NSS for a client PKI cert (our server verifies client  certificates before allowing access)?

Thanks!


texts: Why doesn't custom search enable "Actions" items for selected records after upgrade to 4.6.3?

texts:
I have a custom search extension and it was working fine in 4.4.14.
Since I have upgraded to 4.6.3, "Actions" items only enabled for All records. But if I select certain records from result it does not enable "Actions" items. My custom PHP & a screenshot is shown below.

    <?php

/**
 * A custom contact search
 */
class CRM_Guestsearch_Form_Search_Guestsearch extends CRM_Contact_Form_Search_Custom_Base implements CRM_Contact_Form_Search_Interface {

  function __construct(&$formValues) {
    parent::__construct($formValues);
  }

  /**
   * Prepare a set of search fields
   *
   * @param CRM_Core_Form $form modifiable
   * @return void
   */
  function buildForm(&$form) {
    CRM_Utils_System::setTitle(ts('Registered Guest (Unassigned)'));

  /**
    $form->add('text', 'name', ts('Name'), TRUE
    );

    $form->setDefaults(array(
      'name' => '',
    ));
     */
    /**
     * if you are using the standard template, this array tells the template what elements
     * are part of the search criteria
     */
    $form->assign('elements', array('name'));
  }

  /**
   * Get a list of summary data points
   *
   * @return mixed; NULL or array with keys:
   *  - summary: string
   *  - total: numeric
   */
  function summary() {
    return NULL;
    // return array(
    //   'summary' => 'This is a summary',
    //   'total' => 50.0,
    // );
  }

  /**
   * Get a list of displayable columns
   *
   * @return array, keys are printable column headers and values are SQL column names
   */
  function &columns() {
    // return by reference
    $columns = array(
      ts('Contact Source') => 'source',
      ts('Name') => 'sort_name',
      ts('Phone') => 'phone',
      ts('Email') => 'email',
      ts('Date of visit') => CIVICRM_GUESTSEARCH_CUSTOM_COLUMN_NAME,
    );
    return $columns;
  }

  /**
   * Construct a full SQL query which returns one page worth of results
   *
   * @param int $offset
   * @param int $rowcount
   * @param null $sort
   * @param bool $includeContactIDs
   * @param bool $justIDs
   * @return string, sql
   */
  function all($offset = 0, $rowcount = 0, $sort = NULL, $includeContactIDs = FALSE, $justIDs = FALSE) {

    return $this->sql($this->select(), $offset, $rowcount, null, $includeContactIDs, NULL);
  }

  /**
   * Construct a SQL SELECT clause
   *
   * @return string, sql fragment with SELECT arguments
   */
  function select() {
    return "
      contact_a.id                  as contact_id,
      contact_a.source              as source,
      contact_a.contact_sub_type    as contact_sub_type,
      contact_a.sort_name           as sort_name,
      phone.phone ,
      email.email  ,
      date.
    " . CIVICRM_GUESTSEARCH_CUSTOM_COLUMN_NAME;
  }

  /**
   * Construct a SQL FROM clause
   *
   * @return string, sql fragment with FROM and JOIN clauses
   */
  function from() {
    return "
      FROM      civicrm_contact contact_a
      LEFT JOIN civicrm_activity_contact a ON (a.contact_id = contact_a.id)
      LEFT JOIN civicrm_phone phone ON (phone.contact_id = contact_a.id)
      LEFT JOIN civicrm_email email ON (email.contact_id = contact_a.id)
      LEFT JOIN " . CIVICRM_GUESTSEARCH_CUSTOM_TABLE_NAME . " date ON (date.entity_id = contact_a.id)
    ";
  }

  /**
   * Construct a SQL WHERE clause
   *
   * @param bool $includeContactIDs
   * @return string, sql fragment with conditional expressions
   */
  function where($includeContactIDs = false) {
    $params = array();

    $where = "contact_a.contact_sub_type = 'Guest' AND contact_a.source = 'Guest Greeter Signup' AND activity_id IS NULL ORDER BY date." . CIVICRM_GUESTSEARCH_CUSTOM_COLUMN_NAME . " ASC ";

    return $where;

  }

  /**
   * Determine the Smarty template for the search screen
   *
   * @return string, template path (findable through Smarty template path)
   */
  function templateFile() {
    return 'CRM/Contact/Form/Search/Custom.tpl';
  }

  /**
   * Modify the content of each row
   *
   * @param array $row modifiable SQL result row
   * @return void
   */

}


texts: Can a Profile have hidden fields with preselescted or predefined values?

texts:
I'm trying to create a profile to be used as a form, but rather than having the user populate certain fields, have the form populate them automatically. An example of what I'm trying to do:

The profile form is only presented to people that are registering as guests, therefore I want to pre-select the Membership Type as Guest rather than allowing the user to select the membership type. In fact, I don't even want the user to see the membership type field.

I'm running CiviCRM 4.7.6 on WordPress 4.4.2.


texts:
I am creating a button using php pear.

  Button (php code)

 $this->addButtons(array(
  /**
   * Array for 'next' button
   */
    array(
    'type' => 'next',
    'name' => E::ts('Next'),
    'isDefault' => TRUE,
  ));

  Template code

<div class="crm-submit-buttons">
 {include file="CRM/common/formButtons.tpl" location="bottom"}
</div>

I want to add a id attribute to that


texts: Customers Recieving Error Code on Renewal

texts:
When customers try to renew their membership through our normal form, they recieve this:

"Payment Processor Error message: 1: 103 This transaction cannot be accepted."

Not sure what this means or how to fix it, but many of our customers can't renew their memberships because of this.

I wonder if this has anything to do with the technical updates that Auth.net did in mid-August?

Any help would be appreciated.


texts: How can I show groups in membership report columns?

texts:
I've got the request to display (certain) groups in the membership detail report. A lot has been written over time about customizing reports, and I'm not sure what info is up-to-date. This looks good:
https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/

I think roughly, I would need to

set up the paths for custom templates and php files at setting/path
create a custom template with just a single {include file="CRM/Report/Form.tpl"}
create a custom php file copied from CRM/Report/Form/Member/Detail.php
register both using Administer –> CiviReport –> Manage Templates
in the php file, append stuff to _columns and from()

is that correct ? Has anyone already done something like this for groups .. ?


texts: Pay Now on Dashboard - too many redirects

texts:
Not sure what the issue is - but if someone tries to pay an unpaid registration for an event or membership - or incomplete contribution - we get the issue of too many redirects. I have posted about this before - the issue was the contribution page was disabled or no longer there - but this time - the contribution page is active.

Here is an example of how a link is being parsed: (### are numbers)

https://org.org/membership/member-dashboard/?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&page=CiviCRM&reset=1&id=&ccid=###&cs=&cid=###

Looks like the page ID is missing - but I could be reading this wrong.


texts:
I am using CiviCRM 4.6.7 installed on CMS WordPress version 4.3.1 and I'd like to install the extention CiviVolunteer. From Administer > System Settings > Extentions, I choose CiviVolunteer version 4.5-1.4.1 but the system shows me this error: "Sorry but we are not able to provide this at the moment. Multi-select is not valid option for field html_type

Can you help me?


texts: How to model and report on unintentional underpayment and overpayment?

texts:
The type of underpayment or overpayment I have in mind is as follows. An organisation signs up for a membership valued at £100, opting to pay later. So there's a pending pay-later contribution for £100. They send a cheque for £90 or £110. This is not an intentional extra £10 donation or partial payment: they just sent the wrong amount.

The common-sense solution might be to tell the member they sent an incorrect payment and ask for a correct one. Sadly the membership organisation doesn't want to do that, they want to record that an underpayment or overpayment was made and carry this forward.

They also want to be able to report on a set of contributions, seeing the amount due and the amount received.

I know that there have been relevant changes to Civi core as part of the CiviAccounts project, e.g. Phase 1 Implementation - Data Structure Changes, aimed at distinguishing 'commitments to pay' from 'payments'. I understand that some parts have been implemented, e.g. partial payment for events, but others not.

What isn't clear to me is whether or how this infrastructure can be made use of in current Civi 4.6 for the above scenario. Or whether, as things stand, we need to use an alternative approach such as...

Add a custom field on Contribution for Amount Received.
Add a custom field on Contribution for Amount Over/underpaid.
Record a separate positive or negative contribution for over or underpayment.
Suggest that this information is best recorded outside Civi, in an accounts package.

This section of the CiviContribute documentation sounds relevant:

  For example, a fund raising dinner that charges $100/person may now
  allocate the true costs toward the relevant accounts i.e. $75 donation
  posted to the Income account named "Donations" and the $25 Cost of
  Sales account to "Event Fees".

However I'm not clear whether that is the right thing to do in this case or how the person recording the payment would do it.

CiviCRM 4.6, Drupal 7.

Edit 31 July 2015: adding relevant details of the use case, which I foolishly omitted to keep things simple...

Each contribution may actually cover several items: 2 memberships, donation, fees, recorded with different financial types via price sets. The membership organisation wants a report showing, for each contribution, the membership, donation & fee elements as well as total due, amount received and amount of any over/underpayment.

I like the idea, in @JoAnne's answer, of changing the contribution amount from e.g. £100 to £90 when the £90 cheque is received: looked like this might allow a custom report to compare amount due (from line items) with amount received. Sadly the contribution edit form doesn't allow changing the contribution amount when the contribution has line items. I tracked this down to templates/CRM/Contribute/Form/Contribution.tpl, line 97:

{if $action eq 2 and $lineItem and !$defaultContribution}
  (...then view total instead of showing edit field...)

I assume this was done for good reason: Civi wants to keep the contribution amount consistent with the line items and it wouldn't know which line item to alter. So for underpayment, looks as though the admin would need to record an additional negative contribution for the amount underpaid.


texts: civirules extension -- send an email, SMS or PDF actions not available

texts:
I've installed the CiviRules extension but I am missing some actions that I thought to be built in.  Send an email, SMS or PDF actions are not available.

Linked Trigger: Address is changed
Linked Conditions: None

See screenshot.

Drupal version - 7.41
CiviCRM - 4.6.10
CiviRules - 1.1


texts: How do you pronounce civicrm when speaking to others? Is it "civi" or "civik-c-r-m?


texts: Search view profile to show only the primary phone number

texts:
Is there a way to set up a search view profile so that it shows the primary phone number for a contact regardless of what type of phone it is?  When setting up this profile, I am required to indicate a type of phone.  I want to be able to see results that show the primary phone regardless of type.  Thanks.

We are using version 4.7.24


texts: Is it possible to search for a list of records for which a specific field has not been completed?  For example, if the options in the custom field are 'yes' or 'no', is it possible to find which records have not had either of these selected?


texts: Email signature is set but does not appear in messages I compose

texts: This question: Customize a User's Signature indicates that it should be possible for CiviCRM to automatically include an email signature if one is set for the sending user. I have set a signature set for the sending user, but nothing appears when I compose a message. I know that I can include it in the message using a template or manually insert a token into my email, but this is harder for my users to remember to do. They expect it to "just work" as shown in the above question. What is going wrong here?


texts:
Can you please tell me if you can set the default localisation to one country, so that language/currency/address country are already set?

Many thanks

Paul


texts: CiviCRM API: How to get event by custom multiselect field option?

texts:
I have an event with a custom field custom_1 which is a multi select or checkbox list with two options Category A and Category B:

"custom_1": [
  "category A",
  "category B"
],

Now I'm trying to get all events which have at least option category A:

CRM.api3('Event', 'get', {
  "sequential": 1,
  "custom_1": "category A"
}).done(function(result) {
  // do something
});

With this request I just get the events, which have category A, but not category B:

"custom_1": [
  "category A"
],

But I need all events with category A, regardless if they have another category. So events with this custom field values should also be returned:

"custom_1": [
  "category A",
  "category B"
],

Is it possible to make an API request like "Get all events which have at least one of this custom field options."?


texts: Use Email Templates instead of Automated Messages

texts: Need your help...I'm trying to send a custom email automatically when a contact is created via the 'Sign Up' page...I'm using a profile in the page with 'Add To Email Group' enabled and I've also enabled the Double Opt-In to send an email back to the newly signed up contact....I see that the message comes from the Automated Messages section...I want to use an email template instead so that I can include the Contact information in the email...Is there any way I can do this?


texts: Email Location Type in Scheduled Reminders

texts:
I am wondering if anyone has started work of made an extension to enable the selection of the location type to send the email to in the scheduled reminders?

I think by default the primary email adres is used but we have some use cases where we want to use work or home email for the reminder.

I hope some other people share the wish to develop this or can attribute a starting point to code this.

Regards,
Richard


texts:
I've just upgraded a test site from 4.7.15 to 4.7.21 on Drupal before going live. The System Status page isn't showing as expected and the console has this log:

GET failed for
..../sites/mysite/files/civicrm/persist/contribute/dyn/angular-modules.33b51763aa1098ba_etc_etc.js

This file doesn't exist.  Note the Drupal site is not in sites/default/ but I have set the Civi Resource URLs correctly (hopefully) and cleared the Drupal and Civi caches. Any suggestions?

I've previously (and now) done some messy tweaking of $filesURL in CRM_Utils_System_Base to cope with not being in "default".

TIA Chris


texts: Prevent contact from unsubscribing from a mailing list?

texts:
I have a case where we have optional mailing lists for our members, but also a mandatory list that members must not be able to unsubscribe from (a smart group that looks for active members -- our master list of members -- which we use to contact them about urgent issues). A condition of membership is that they need to remain on this list.

But, when I send a mailing with the {unsubscribe} placeholder, members see all the lists they are on, including the master list, which they can then unsubscribe from.

Is there a way to prevent a mailing list from being displayed on the Unsubscribe page?


texts: Timezone not correct even after setting php.ini

texts:
Timezone difference cause my civicrm site showing wrong membership date.

For example:

Payment Date: Today 10am
Membership start date: Yesterday

I made below timezone setting in drupal (admin/config/regional/settings):

Default Timezone: Asia Kuala Lumpur
Uncheck tick box of  "Users may set their own time zone"

In php.ini, I added below line:

date.timezone = "Asia/Kuala_Lumpur"

But the timezone problem still occurs. Am I missing any configuration? Or is there any place I can force timezone to be Asia/Kuala_Lumpur ?


texts: Payment processor, avoiding payments being rejected due to 'transaction is a duplicate'?

texts:
Are other people seeing the error message:

  Payment Processor Error message: 9003: It appears that this transaction is a duplicate. Have you already submitted the form once? If so there may have been a connection problem. Check your email for a receipt from eWAY. If you do not receive a receipt within 2 hours you can try your transaction again. If you continue to have problems please contact the site administrator.

We are using the Eway Payment processor and CiviCRM.

We had a donation and a membership submitted at the same time and we had the donation go through but not the membership. The membership seemed to fail regularly so I rebuilt the form with profiles and captcha. We are still getting this error.

I can see the error message in the code. https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/Payment/eWAY.php. It looks as though it is checking for a unique invoice id. Is there a way to manage the way invoice id's are created that we are not managing correctly? Is it a race condition?

CiviCRM 4.7.17.

The http server logs (cleaned up) from this IP address are:

[06/Apr/2017:16:02:32   +1000]  POST /civicrm/contribute/transact HTTP/1.1  200 16030   https://www.colongwilderness.org.au/civicrm/contribute/transact?reset=1&id=1
[06/Apr/2017:16:05:07   +1000]  POST /civicrm/contribute/transact HTTP/1.1  200 15965   https://www.colongwilderness.org.au/civicrm/contribute/transact
[06/Apr/2017:16:05:36   +1000]  POST /civicrm/contribute/transact HTTP/1.1  200 15947   https://www.colongwilderness.org.au/civicrm/contribute/transact
[06/Apr/2017:16:06:05   +1000]  POST /civicrm/contribute/transact HTTP/1.1  302     https://www.colongwilderness.org.au/civicrm/contribute/transact
[06/Apr/2017:16:06:34   +1000]  POST /civicrm/contribute/transact HTTP/1.1  302     https://www.colongwilderness.org.au/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=d30c3a51b960fea81a73d70d656af1a9_8907

It is referring back to itself which I can't explain.

A working test (form 4 not form 1)

[07/Apr/2017:05:10:25   +1000]  POST /civicrm/contribute/transact HTTP/1.1  302     https://www.colongwilderness.org.au/civicrm/contribute/transact?reset=1&id=4
[07/Apr/2017:05:10:59   +1000]  POST /civicrm/contribute/transact HTTP/1.1  302     https://www.colongwilderness.org.au/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=37ea51cf5a1e3f5197f136c5801cba2f_4643

The log does show that the contribution was being made on an old form that I had replaced.

This form only uses the inline options for donations and memberships. Thew new form uses price sets.

Old form configuration

With a membership section


texts: Date Format in CiviEvent Widget is not in German Format

texts:
The date format in the CiviCrm event list widget switch not to german format. I administer all known format settings to the german settings. But only in the event list widget it shows no effect.
Is there an option that I not found?
I use wordpress 4.9.1 with Tortuga and CiviCrm 4.7.27


texts:
When adding all of the address fields in a PDF letter i am getting a blank line for supplemental address line 1 if that user does not have that field populated. Is there any way to avoid having a blank line? i am doing a large mail merge using this and it does not look professional to have a blank line in the address block. Here is how i have the tokens setup.

{contact.display_name}
{contact.current_employer}
{contact.street_address}
{contact.supplemental_address_1}
{contact.city}, {contact.state_province} {contact.postal_code}


texts: How to expose employer on individual dashboard without view/edit permissions?

texts: On Joomla 3.9.1 running CiviCRM 5.8.1. When users are logged-in to the website, we have a page that displays their member dashboard. Under the Your Contacts/Organizations, most people have nothing showing because they do not have a permissioned relationship with their organization. Only certain individuals should have a permissioned relationship that allows them to view and/or edit the organization information; however, I would like everyone to be able to see what organization they are connected to in this area. If I set it to view only, the individual can see the organization's profile, and I just want them to see the organization name and no other information, essentially to remove the hyperlink to the organization profile and remove the "Edit" and "Dashboard" links. What's the best way to accomplish this?


texts: How can I send mass email to all contribution page pcp owners?

texts: I have a contribution page that has pcp enabled. I want to send out a mass email to all the pcp owners. I can display a list of all the pages with owners, but I can't do any actions on them. Is there an easy (or even a hard) way to do this?


texts: Subscription confirmation "from" address is "do-not-reply@EXAMPLE.ORG"

texts:
I don't see any place to change this - it looks pretty bogus, IMO.

Any ideas? Thanks!


texts: Error when upgrading to 4.6.9 on Drupal 7

texts:
I received a string of nine similar error messages when trying to upgrade to version 4.6.9.  There is also a smarty error message.  Please dan you help?  This is the first time I have attempted an upgrade.
Regards
Graham

•   Warning: opendir(/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/xml/Menu/): failed to open dir: No such file or directory in CRM_Utils_File::getFilesByExtension() (line 428 of /Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/civicrm/CRM/Utils/File.php).
•   Warning: opendir(/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Event/xml/Menu/): failed to open dir: No such file or directory in CRM_Utils_File::getFilesByExtension() (line 428 of /Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/civicrm/CRM/Utils/File.php).

User warning: Smarty error: unable to read resource: "CRM/common/success.tpl" in Smarty->trigger_error() (line 1094 of /Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/civicrm/packages/Smarty/Smarty.class.php).


texts: Why does setting "CVV required for backoffice" to 'NO' also unrequire it on front facing forms

texts:
I just ran in to this issue on a site - namely setting "CVV required for backoffice" to 'no' results in it CVV fields showing as 'not required' site wide, ie on all public facing contribution pages.

I found a question about this here https://forum.civicrm.org/index.php?topic=34624.0

If this was the intended and desired outcome then at least the help text and label should be updated.

Noting that on 4.6 this is at civicrm/admin/setting/url?reset=1

At 4.7 it is at civicrm/admin/setting/preferences/contribute?reset=1

What should next step be? Have it perform as described, or describe how it performs?


texts: Can't Edit CiviContribute Pages after URL Change

texts:
Our website is being hosted by CiviHosting, but our Domain and Email are with another hosting company. The other hosting company just changed the DNS to point to CiviHosting, so that our domain would work with the CiviHosting account, and now I can't edit the contribution pages I made (or create a new contribution page). Specifically, I went to contributions >> manage contribution pages and then chose "configure" and then "Title and settings" for one of the pages and it redirected me to the /wp-admin Wordpress dashboard.

I tried a different page same thing.

I tried creating a new page and it let me type everything in but when I hit "save" it took me back to the /wp-admin page.

I tried deactivating and reactivating the plugin. Didn't work.

I tried removing all the files from the server through FTP, and reinstalling a brand new installation of CiviCRM. Didn't work.

I removed the new installation and put my old civicrm files back. Didn't work.

I have been Google Searching for a while and I tried finding config.settings.php as many sites suggest, but the only thing I could find was config.settings.php.template which I did attempt to modify in the way they described (changing the base URL) and that didn't work either. I changed it back to the original and re-uploaded it via FTP.

I looked through civicrm.config.php in case that was the file I was supposed to modify, but couldn't find a place to change the URL.

I tried going through the settings menu of CiviCRM, specifically the resources and directories paths and they all look like relative references (see attached) so I'm not sure what I'd change.

If you go to the actual pages, they do work, but I have no way of modifying them... (here's an example live page: http://sweetfields.org/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1)

Any idea what broke and how to fix it?

Thanks!

UPDATE: I just noticed that when you click on the link I provided in this post, it is referencing an old version of the site... I removed the black login bar at the top of the page. If you go to sweetfields.org now you'll notice the black bar is gone but for some reason it's there for the CiviContribute page... the plugin must be somehow referencing old files?

UPDATE 2: Found the file! But, it already has the correct URL in it for the base_url: "  define( 'CIVICRM_UF_BASEURL'      , 'http://sweetfields.org/');" so I'm guessing that's not the problem?

UPDATE 3: Should I delete all tables in the database that start with "civicrm_" and delete all files and then try re-installing?


texts: Contribution page - the field labels are missing

texts:
I have installed civicrm and created a new contribution page. But the field labels are missing. Below is the link:

http://ny.missionaryfamiliesofchrist.us/index.php/donate

I would appreciate any help to fix this.

Ron


texts: Can we remove or hide the Volunteer subclass in CiviVolunteer?

texts:
We have implemented CiviVolunteer to manage our 30 projects across 118 volunteers.

The positives:

Projects are linked via Activities in sympathy with the overall CiviCRM design philosophy.

Once two bug fixes were applied, it now works as specified - all good.

The negatives:

The Volunteer subclass of Individual has popped up but is not used by CiviVolunteer for the actual volunteers. This is a bit confusing and instructions in our User Guide (thank you Echo Plugins for Knowledge Base for Documents and FAQs) are the way that we have dealt with this.

The Volunteer reports don't expose the two relationships (Owner or Manager).

The overall reporting system of CiviCRM doesn't appear to support (out of the box) summarisation of rows (e.g. a count of rows, a sum of values from a row, etc.).

Sounds like a lot of negatives, but we are using CiviVolunteer and are achieving a deal of acceptance from our users.

As requested in the guidelines, that's our story.

Now the questions is, can the Volunteer subclass be removed safely or safely hidden?

Regards,

Rob.

CiviCRM 5.4.1 PHP 7.1.24 CiviVolunteer 4.7.31-2.3.1 WordPress 4.9.8


texts: How far is the CiviSocial integration under implementation?

texts:
I am able to see some talks on CiviSocial.

https://wiki.civicrm.org/confluence/display/CRM/Social+Media+Integration

How far is it implemented? How can I integrate my organization's Social Media initiatives with CiviCRM? If not CiviSocial is immediately available, what is the workaround?


texts: can events be linked to bookings without creating custom fields?

texts:
I have just activated civibooking and would like to link into an events calendar so that staff can see what resources have been booked for meetings etc.  I can pull the bookings into their own calendar which links to the booking, using booking id and primary contact, but can't see how to join this to the event - tried adding custom fields to event entity to take a booking id but wondering if will need to use rules, just hoping someone already done this before and could give some advice.

Many Thanks
Claire


texts: after upgrade civicrm dashboard missing 5.23.1 drupal

texts:
I have just upgraded to 5.23.1 from 5.15.2 (Drupal 7.69)
The upgrade screen was a bit "mumbled" but I assumed it worked ok.
When I went back in to Civicrm I first get a message:

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

When I return to home page and click on my record I can see it in Civicrm but there are no menus and I cannot see anyone else or anything else.


texts: Error adding new new contact: getaddr info?

texts: Suddenly I started getting error when trying to save any new contact using web version of CiviCRM 4.5.3. Persisted for several days now, across 3 different browsers. Looks like this, any advice?:


texts: seeking information on CiviCRM 4.1 version of "CRM/Core/BAO/PaymentProcessor.php" file

texts: The Vanco Payment Processor module uses a core file (CRM/Core/BAO/PaymentProcessor.php) in CiviCRM 4.1 that I'm unable to find in CiviCRM 4.4.  Does anyone have knowledge of the file and might know if it has been renamed or moved within the file structure?


texts: Is CiviCRM compatible with OU Campus (OmniUpdate) CMS

texts:
I have a client currently using civiCRM and Drupal. They are interested in migrating their site content into OU Campus while still maintaining use of CiviCRM. Has anyone had any success with getting these two working. Is it possible?

Thank you,
-n


texts: CiviCRM does not have permission to write temp files

texts:
Two users are trying to access the temp files (where, for instance, the compiled templates are stored): www-data (when it's accessed from the website) and the sysadmin that run drush commands

By default, all these temporary files can only modified by the user that created it, so sometimes it's the sysadmin, sometimes it's the webserver user

Is there a way so all the temp files can be created/modified/deleted by only the admin user(s) and www-data?

One possible fix is a patch on drush, so it uses a separate templates_c folder than the one used by www-data. Could you test if it works in your environment/workflow?

https://github.com/civicrm/civicrm-drupal/pull/286


texts: How to start contributing for GSoC 16 : Email sending framework?

texts:
I am Pulkit Bhatia , a third year Computer Science student from USICT,GGSIPU,DELHI and aspirant for GSoC 2016.I was going through community idea list and I am very much interested and excited in working with Email Sending Framework with civiCRM.

I was responsible for backend development during my previous internship where I developed RESTful API using PHP , CodeIgniter Framework and MySQL database.As idea list says , this project involves cronning/scheduling mail services with more robust library such as PHPMailer etc and supporting external mail services through API or plugins, which supports my interest and my previous experience and thus will certainly help me in extending my knowledge and experience in server coding.I am really excited to be part of this organization.

I have already setup my development environment and  successfully integrated civiCRM with drupal.I also started looking into documentation and experimenting around with it. Assistance regarding Project specifics would be a great help.

I am keenly looking forward to hear from the community and mentors who can guide me to proceed further.

Regards  :)


texts: Restricting field options in a profile on a contribution page

texts:
I have a Contribution page for Membership Registration. In this form users create their Drupal account and made payment off-site, so using the Contribution page is the best option for me - webforms doesn't have everything I need :)

Membership is only open to UK residents and we don't want them to be able to choose another country.

However, database contact are from other countries. So we do need to have additional countries enabled.

Is there a way we can restrict the available option on this profile / contribution without disabling all on the site?


texts: Can hook_civicrm_links create links beside rows of a contact's Events tab?

texts:
I've looked at CRM/Event/Selector/Search.php to see it creating the View/Edit/Delete links, but am just unsure how to make this work. Can someone advise what the appropriate $objectName and $op should be? I'd like to do something like this:

function testmodule_civicrm_links( $op, $objectName, $objectId, &$links, &$mask, &$values ) {

  switch ($objectName) {
    case ???:  //Event or Contact perhaps?

      switch ($op) {
        case ???:  //a participant selector perhaps?

            $links[] = array(
                'name' => ts('Send Invoice'),
                'title' => ts('Send Invoice'),
                'url' => 'civicrm/activity/email/add',
                'qs' => 'action=add&reset=1&cid=%%cid%%&selectedChild=activity&atype=3&pid=%%id%%'
              );
          break;
      }
  }
}

Where %%id%% comes in from the context of that row in the grid. If I can't get there with a hook, would it be prudent to extend CRM_Event_Selector_Search and override the links function with my own?


texts:
I've just found this on one site. I have some (not all) cases of a given case type. There case status is set to a "closed" status. But the case does not have an end date.

I cannot find a way to update the case end date from the manage case screen.

This seems to effect cases where status was changed between July 17 and October 18
Cases amended before and since have an end date recorded

Cases with other closed statusses all have end dates as expected.

I guess I can find the related case status change activities, and then manually adjust the case end dates from cpanel (only a dozen or so cases affected).

Just left scratching my head, is all.


texts:
I m attempting to install CiviCRM 4.7 in Wordpress.  I have all green bars, and have verified multiple times that the database password and user are correct.  When I click the "Check Requirements and Install CiviCRM" button, the request processes for about two minutes then returns a 404 error.

I've reached the limits of my knowledge regarding solutions and would appreciate any help you can give.  I'm able to poke around under the hood, with clear instructions and step-by-steps, but don't have any specific knowledge/training.

Thanks.


texts: Getting permission error when installing CiviCRM under Drupal

texts:
I've recently set up a subdomain of mine on a VPS, installed Drupal 7.56, and managed to download the civicrm module but when I go to http://mysite.net/drupal-7.56/sites/all/modules/civicrm/install/index.php

It give me this:

You don't have permission to access this page

I was logged in as the admin before I tried the install.  Not sure if this is file permissions or what.

PHP 7.0
Drupal 7.56
CiviCRM 4.7.28

Thanks in advance,
John


texts: Beyond provide a profile of an instance's stack, what is the purpose of Connections?

texts:
I am seeking information about the Connections admin area (Administer>System Settings>Connections):

I have seen in one instance that there is something that can be set up here to generate a site profile that provides info about the instance without exposing sensitive info like filepaths. I can see how this is useful but it seems oddly placed and like there could be more to it.

Is there anything else that can be set up using this function? I have searched in documentation and not found any info. I am very curious (on behalf of a client) about what this is and what its uses are.


texts: Upgrading to 4.7.7 gives Error "The website encountered an unexpected error. Please try again later."

texts:
I am trying to upgrade from 4.6.16 to 4.7.7, although the upgrading process completes, and drupal site works perfectly fine, as soon as I go to civicrm URL i receive this error message. This happened when I tried to upgrade to 4.7.0 too.

Error: The website encountered an unexpected error. Please try again later.

I have followed upgrade instruction perfectly, all file permission is fine. Anyone knows where the problem may be?

Update: Log from civicrm

Feb 04 08:57:46  [info] $Fatal Error Details = Array
(
    [message] => Your database is not configured for version 4.7.1
    [code] =>
)

Feb 04 08:57:46  [info] $backTrace = #0 /www/demo/sites/all/modules/civicrm/CRM/Core/Error.php(366): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /www/demo/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(191): CRM_Core_Error::fatal("Your database is not configured for version 4.7.1")
#2 /www/demo/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(81): CRM_Upgrade_Page_Upgrade->runFinish()
#3 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#4 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#5 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:2))
#6 /www/demo/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:2))
#7 [internal function](): civicrm_invoke("upgrade")
#8 /www/demo/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:1))
#9 /www/demo/index.php(21): menu_execute_active_handler()
#10 {main}

UPDATE 2: Log when visited the upgrade url after the error message. Now i have Tried with 4.7.7, but still no luck.

 backTrace

#0 /www/demo/sites/all/modules/civicrm/CRM/Core/Error.php(367): CRM_Core_Error::backtrace()
#1 /www/demo/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(98): CRM_Core_Error::fatal("Your database has already been upgraded to CiviCRM 4.7.7")
#2 /www/demo/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(73): CRM_Upgrade_Page_Upgrade->runIntro()
#3 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#4 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#5 /www/demo/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:2))
#6 /www/demo/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:2))
#7 [internal function](): civicrm_invoke("upgrade")
#8 /www/demo/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:1))
#9 /www/demo/index.php(21): menu_execute_active_handler()
#10 {main}

PHP Error message is quiet large one so its on pastebin
http://pastebin.com/wTZyNEf6


texts:
I'm using GoCardless 1.9.2 on my CiviCRM 5.2.3 install on Drupal, to handle membership subscriptions.

When new membership payments are created via GoCardless, they're set to "Pending". We would like to assume that the payments will go through and treat them as an active member from the time they set up. Unfortunately, our only option is to manually change the payment from "Pending" to "Completed". "In Progress" would be a better option but there is no way to change a "Pending" payment to one "In Progress".

Is there a way to have new membership payments go to "In Progress" rather than "Pending" to start with?


texts:
We are using Civi 5.0.1 on Wordpress 4.9.1

Recently I asked if anyone is using Payflow as your payment processor.  Not a single person could answer.  So I don't believe anyone is using Payflow on their civi install.    Also after a lot of troubleshooting, I have come to the conclusion that Payflow is no longer compatible with Civi.

OUr organization needs a reliable payment processor that can process credit cards and recurring payments.  We are a U.S. based non-profit.   Can anyone tell me what is the most popular processor to use with Civi?  I looked into IATS Payments.  Are they a reliable options?

Thank you.


texts: How can I hide specific tabs in member view regardless of viewer permissions?

texts:
We have two different user permission groups: Finance team who can see the Contributions tab, and Personnel, who can't.  We wanted to hide some custom field tabs for both groups, and mimicked the documentation on the civicrm_tabs hook, simply using

unset ($tabs[12]);

However, the index 12 corresponds to different tabs for the two types of users, because the count changes depending on whether or not the Contributions tab is visible.

How do we hide tabs in a manner independent of the user group and the other tabs they see?


texts:
I have just added some custom fields to grants but they dont show in reports - what have I missed? How do I get them to show up and be available in reports?

Cheers - Phil


texts: CiviCRM Groups Sync Plugin for Wordpress - No access to Settings

texts:
I installed the CiviCRM Groups Sync Plugin after finding the CiviCRM Member Sync plugin is not currently syncing to the WP Groups.

It was all working and I set up a 'Guests' group in CiviCRM to sync to WP and it created the group 'Guests' in Wordpress. So that worked.

However, I registered as a Guest user via CiviCRM profile (which includes a create WP user account form) and was added to the Civi Guests group but not the WP Guests group.

I was just added to the default 'Registered' Group.

And now I've discovered I cannot access the CiviCRM Groups Sync plugin's Settings page. I get the dreaded 'Sorry, you are not allowed to access this page.'

This is the page being accessed https://somesite.com/wp-admin/options-general.php?page=civicrm_groups_sync_parent

I'm logged into WP as Administrator.

I'm not seeing any errors in the PHP error log, and have WP DEBUG on but not showing any errors.

Help!

Cheers,
Tracy

UPDATE:

UPDATE: Also, this plugin does not really help with removing the user when their Civi Membership lapses. So really the member sync plugin would be ideal as it works with the differing Civi Membership states.


texts: Add membership start and expire date in contact report

texts:
Is there a standard way to add membership start and expire date (filterable) in contact report summary page?

I was trying to get into each row and run custom query to get corresponding data but doesn't work.
I also tried to create a custom field and sync the field with real date but the filter is a problem. And need to set up proper hook to sync data.

Thanks


texts: Importing contacts through Kettle and CiviCRM data integration

texts:
I am importing legacy data into a CiviCRM instance, and I am stuck. Using Kettle I am able to import the contacts, but the address data isn't being imported. When I use a sample of the data in the CSV I can import it into CiviCRM through import contacts with the same field mapping, without any problems.

Is there a way to debug API output generated by CiviCRM Output in Kettle?
Am I missing a necessary address field of something? What would be a minimal example of API code to create contact with a country address field?

EDIT
This is the warning I get.

{"is_error":0,"undefined_fields":["country","state_province","city"],"version":3,"count"

Although these fields are avaliable for contacts entity in CiviCRM Output.


texts:
When I cancel a Drupal user, I get an error from the OG Sync Bridge:

$backTrace =
#0 /home/myuser/domains/mydomain.nl/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/myuser/domains/mydomain.nl/public_html/sites/all/modules/civicrm/CRM/Bridge/OG/Utils.php(116): CRM_Core_Error::fatal()
#2 /home/myuser/domains/mydomain.nl/public_html/sites/all/modules/civicrm/CRM/Bridge/OG/Drupal.php(221): CRM_Bridge_OG_Utils::contactID(0)
#3 /home/myuser/domains/mydomain.nl/public_html/sites/all/modules/civicrm/drupal/modules/civicrm_og_sync/civicrm_og_sync.module(241): CRM_Bridge_OG_Drupal::og((Array:4), "add")
#4 /home/myuser/domains/mydomain.nl/public_html/sites/all/modules/civicrm/drupal/modules/civicrm_og_sync/civicrm_og_sync.module(68): _civicrm_og_sync_node_action(Object(stdClass))
#5 /home/myuser/domains/mydomain.nl/public_html/includes/module.inc(957): civicrm_og_sync_node_update(Object(stdClass))
#6 /home/myuser/domains/mydomain.nl/public_html/modules/node/node.module(1180): module_invoke_all("node_update", Object(stdClass))
#7 /home/myuser/domains/mydomain.nl/public_html/modules/node/node.admin.inc(327): node_save(Object(stdClass))
#8 /home/myuser/domains/mydomain.nl/public_html/modules/node/node.admin.inc(355): _node_mass_update_helper("140", (Array:1))
#9 /home/myuser/domains/mydomain.nl/public_html/includes/batch.inc(284): _node_mass_update_batch_process((Array:11), (Array:1), (Array:4))
#10 /home/myuser/domains/mydomain.nl/public_html/includes/batch.inc(161): _batch_process()
#11 /home/myuser/domains/mydomain.nl/public_html/includes/batch.inc(80): _batch_do()
#12 /home/myuser/domains/mydomain.nl/public_html/modules/system/system.admin.inc(2384): _batch_page()
#13 /home/myuser/domains/mydomain.nl/public_html/includes/menu.inc(527): system_batch_page()
#14 /home/myuser/domains/mydomain.nl/public_html/index.php(21): menu_execute_active_handler()
#15 {main}


texts:
I'd like to add a custom field to the "core" demographics fieldgroup: the place of birth. I created a custom field, but I can't figure out, how to put it into demographics fieldgroup. Is it possible to do somehow?

Thanks.


texts: Do I need to edit or delete action.cronjob.php to get Scheduled Reminders e-mails sent?

texts:
Using CiviCRM 4.6.11, Drupal 7. I've gone through all the steps to set up a couple of test scheduled reminders. I'm triggering the tests manually. I've enabled the Scheduled Job for sending scheduled reminders.

Yet, e-mails are not being sent.

Even though the Managing Scheduled Jobs page says that action.cronjob.php is a deprecated bin script, is that bin script still installed with 4.6.11 and do I need to edit or delete it?