texts: Why would CRM_Utils_Hook::entityTypes($entityTypes) return results with a non-civicrm table?

texts:
I've traced a crash in dedupe to a NULL entity. I've worked around that, but I should figure out why the entity is NULL. I've gotten as far as CRM_Utils_Hook::entityTypes($entityTypes)

it's return value seems to refer to a TEAM table that doesn't exist in CiviCRM. I may have created such a table in the same DB months ago, but I don't think it ever followed a naming convention that would have 'fooled' CiviCRM into categorizing it as a core table.

I plan to keep digging, but now seems like a good time to ask for advice. Anyone seen anything like this before?


texts: Links to a contribution page with checksum and contact ID generate a fatal error

texts:
I want to send email to members with a link to the membership renewal page profiled with their data. I create a suitable link including the contact ID and checksum, of the form
https://example.com/civicrm?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2&cid=xxx&cs=1ccf75cf22138bd255525af8c8c05dc4_1599646931_168
If I'm logged and the link is for me then it works. If I'm not logged a Fatal Error is generated, and the site (WP) presents the message "The site is experiencing technical difficulties".
Nothing appears in the CiviCRM log, but in the Apache log I see:

Sep 09 13:56:02 [Wed Sep 09 12:56:02.301893 2020] [php7:error] [pid
203] [client 172.18.0.1:41254] PHP Fatal error: Uncaught
CRM_Core_Exception: [0: One of parameters (value: ) is not of the type
Integer\n\n thrown in
/app/data/wp-content/plugins/civicrm/civicrm/CRM/Utils/Type.php on
line 470 Sep 09 13:56:02 172.18.0.1 - - [09/Sep/2020:12:56:01 +0000]
"GET
/civicrm?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2&cid=213&cs=1ccf75cf22138bd255525af8c8c05dc4_1599646931_168
HTTP/1.1" 500 3081 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15;
rv:80.0) Gecko/20100101 Firefox/80.0"

Using Civi 5.29 with WP 5.21. I had the same problem using Civi 5.25.0. I'm using a Cloudron LAMP stack, which makes things a little more complicated.
Any pointers most welcome.


texts:
I'm having some problems with Paypal Standards.
I was originally getting an error #40710 that my return URL was no good, so I disabled Auto return in paypal.
Now I am getting this error: Sending a relative URL to PayPalIPN is erroneous. Please make your resource URL (in Administer » System Settings » Resource URLs ) complete.
I even disabled the IPN feature in paypal but still get the error and unable to make a donation through paypal.

How do I get Auto Return and IPN features working?


texts: Too many tables - MySQL limitation - CiviCRM API errors

texts:
On CiviCRM 4.6.31

We have seen CiviCRM errors with SQL LEFT JOINs relating to custom data sets. It appears there is a MySQL limitation on how many tables can be joined.

This impacts on a number of CiviCRM features including CiviReport and Webform-CiviCRM integration.

In our case we were using webforms to update existing grants and could see an error like so in the Drupal log messages: -

The CiviCRM "grant getsingle" API returned the error: "DB Error: unknown error" when called by function "alterForm" on line 102 of wf_crm_webform_preprocess.inc with parameters: "Array ( [id] => 1202 [check_permissions] => [version] => 3 ) "

Looking further into this it appears anything that uses CiviCRM's API will also fall over when your system reaches this limit (I think it is 61 join tables).

At present, and having liaised with others in the community and core team members, the solution is to consolidate custom data fields. i.e. move fields and then delete some custom data sets.

In future, will there be another solution, or should we state this as a MySQL limitation, and therefore CiviCRM limitation?


texts:
I have been using events for a while and this just started happening - not sure if it is related to moving from one host to another since everything is functioning as expected.
When I select a template or edit an event, the date/time stamps change to 2 boxes with the calendar icon in one, but not usable.
So I added some events without a template and get the single box with a selectable date, but they don't show on my calendar now and when I select Events, Show Events Calendar it returns to the Civicrm admin front page.  Any suggestions on how to resolve??  I am on 4.7.18 and was going to upgrade to 4.7.23 but am hesitant with this error.  I did do the upgrade on my test environment and when I saw this error in production, I went back to the upgraded test environment and the issue is there too.


texts: How to reduce database bloat for faster upgrading?

texts:
In order to speed up slow upgrades, experienced folk (1
2) recommend reducing the size of the database to facilitate testing.

What is the best way to declutter the database?


texts:
I'm new to CiviCRM, just installed 4.6.5 on my Joomla 3.4.4 testsite.
Other software levels:

PHP: 5.5.18

MySQLi: 5.5.36

I tried to import contacts, 980 in total, using a .csv file. There are no duplicates in that file.

At the first try it imported some 250 contacts, then stopped. Second try it imported another 250 contacts, third try another 204 so now I have 704 contacts in my database. Everything that's in that database looks fine.

At the end of each import job it failed with the following message:

/administrator/components/com_civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107

Somewhere I read I should clear the CiviCRM cache, so I did. I thought maybe a cache problem with approximately 250 contacts. Wrong.  Result: now it fails immediately with this message.

My next step will be to upgrade CiviCRM to 4.6.8, but will that help?


texts:
Can I do a straight through upgrade or do I need to do incremental such as 5.16 to 5.17 then 5.18, 5.19, and finally 5.20? I ask as in pre 4.7 I encountered this as I recall when making a larger version jump.

Thanks!


texts: clickatell sms "Recipient phone number is invalid or recipient does not want to receive SMS"

texts:
wordpress 4.9.6 Clickatell 4.1
All was working fine until upgrade to Civi 5.22 and upgrade to SMS API 1.5
(yup in retrospect should have tested separately!)

phone is home-mobile-primary


texts: Drupal Views using over ride feature with civicrm fields - token

texts:
I am wonder whether someone can help explain how to use the Override feature for CiviCRM fields in views.  For example, I have a field in Civi which is a file field... when i add it to a view it shows the URL to the image... I assume I can select the field in question and then when it opens the configuration window for the field:

Select over ride and in the text area write something like

 <img src=['token for the field']>

for it to render the image is this correct and if it is how would i workout what needs to be placed in the ['token for the field'] portion of the string?


texts: Implementing a support ticket/help desk system?

texts:
I would like to implement a support ticket or help desk system through the CiviCRM. This way, all support requests and email responses are tracked in the CiviCRM as well as who handled it, or who it gets assigned to, whether it's open or closed, etc. I read that CiviCase could be modified to make this happen, but we also have several different types of support we need to provide and want to know what all my options are.

What would be the best way to make this happen?

Drupal 7.50 CiviCRM 4.7.15


texts: CiviCRM Dashboard not working on local Win 10 install; live server okay

texts:
I recently made a mirror on my laptop running XAMPP. Wordpress 4.6.1 + CiviCRM 4.7.14. Everything works fine on the front-facing site and everything seems to work fine in the back-end, except the dashboard that comes up. There is a message in the default image in the screenshot below that says
"The requested page "/welcome?prot=1&ver=4.7.14&uf=WordPress&sid=66b480f3fa29fea3920454ef21065ed5&lang=en_US&co=1228" could not be found."
Note that I also upgraded the Wordpress to 4.7 which is one of the reasons I created the local version - to uncover some upgrade issues that I resolved. The CiviCRM dashboard issue was there prior to the upgrade as well. I can easily restart with backups of our LIVE site where everything, including CiviCRM dashboard, is in good shape.

Anyone have an idea how to fix this? Thanks in advance...


texts: Importing localized content to Civicrm database

texts:
I have tried to use the import process in civicrm for importing my urdu data fields into civicrm. After I map the fields in my csv to fields available in civicrm db i get error file. I am attaching the image from my error file.
Please note that the data is in urdu. I want civicrm to display the data in its fields like first name will contain the name of my contact in urdu.
My import verification came like this

I appreciate any help from the community.


texts: Can CiviMail send multiple mailing jobs concurrently?

texts:
The CiviMail documentation and settings pages indicate that it is possible to have multiple mailer delivery jobs executing simultaneously.

See Settings - CiviMail (/civicrm/admin/mail?reset=1) :

Mailer Job Size: If you want to utilize multi-threading enter the size you want your sub jobs to be split into. Recommended values are between 1,000 and 10,000. Use a lower value if your server has multiple cron jobs running simultaneously, but do not use values smaller than 1,000. Enter "0" to disable multi-threading and process mail as one single job - batch limits still apply.
Mailer CRON job limit: The maximum number of mailer delivery jobs executing simultaneously (0 = allow as many processes to execute as started by cron)

I have not been able to get this to work in practice in CiviCRM 4.4.14 . I have tried various settings, e.g.

batch limit = 2500
throttle time = 5
job size = 2500
cron job limit = 2
civimail_server_wide_lock = off

Civi cron is running every minute. Mailings scheduler is the only scheduled job that runs on every cron run (others are hourly or daily). The mailing is correctly split into sub-jobs of 2500 mails, however these get processed consecutively. Each batch takes about 6 minutes to run. Every time a new instance of the scheduled job tries to start while an existing instance is running, we get an error like this:

Finished execution of Mailings scheduler with result:
Failure, Error message: lock aquisition for mydb.1.civimail.job.12415
attempted when mydb.1.civimail.job.12414is not released

Hence only one instance runs at a time.

The error message above is generated by CRM_Core_Lock::hackyHandleBrokenCode(), which was added for CRM-12856 and is called from CRM_Core_Lock::__construct(). It prevents multiple locks being created with names containing "civimail.job.". If this is attempted, hackyHandleBrokenCode() throws an exception and so the scheduled job exits. This appears to be what is preventing multiple mailer delivery jobs executing simultaneously.

Looking at CRM_Mailing_BAO_Mailing::processQueue(), the code for $config->mailerJobsMax > 1 seems to work on the assumption that a CRM_Core_Lock can be created independently for each of the mailerJobsMax cron jobs. But since CRM-12856, this is disallowed. I believe this may not have worked correctly in any case, given that each MySQL connection can only acquire one lock: acquiring a second, even if it has a different name, releases the first: https://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#function_get-lock.

However some users have reported this feature to be working correctly - can anyone confirm that mail jobs are indeed sending in parallel in their post-CRM-12856 Civi?


texts: Problem processing payment after CiviCRM Drupal to Wordpress migration

texts:
After migrating from Drupal to Wordpress, my payment processor is no longer working.

After having gone to the payment processor I am redirected to the URL:
?page=CiviCRM&q=civicrm/payment/ipn&processor_name=Sagepay.....

The error I get is: You do not have permission to execute this url.

Any help in getting to the bottom of this would be appreciated!


texts: Warning: count(): Parameter must be an array or an object that implements Countable

texts:
I am not a php/SQL programmer. I upgraded our Wordpress site to WP 5.6.1 and now get this error:
Warning: Cannot modify header information - headers already sent by (output started at /home/rembrand/public_html/wordpress/wp-content/plugins/civicrm/civicrm/packages/DB.php:793) in /home/rembrand/public_html/wordpress/wp-admin/admin-header.php on line 9
if (!count($dsn)) {
return $parsed;
}
Warning appears at top of screen when I enter Wordpress admin dashboard for our website and edit any page.
How do I fix this?


texts:
I am working for an international NGO with memberships. They want to be able to sell memberships in USD, EUR and GBP. The contribution forms will deal with this for donations, etc. The contributions form will also switch the membership currency to the one give in the Amounts page, but the value is the value given in the Membership type. Logical enough, but the membership type seems to be tied only to the default currency. Is there a way to define a membership prices set or even a separate membership in another currency?

Keith


texts: How to add/remove search fields from the search box dropdown in the navbar?

texts:
In the CiviCRM global menu there is a nice search box on the left. This box allows for targeting specific fields via radio buttons in a dropdown, like this:

Is it possible to remove or change the fields that appear here?

Can custom contact fields be added to these options?


texts:
I am using Drupal 7.56 and have just upgraded from CiviCRM 4.7.20 to 4.7.21 with a number of significant issues that will require that I revert to 4.7.20. When I try to display System Status - Warning nothing is displayed. When I try to continue to use a previous email, nothing displays.
I don't have the luxury of doing anything more to understand the issues since I now need to revert to 4.7.20.


texts: How to identify if the event is a repeat event?

texts:
I want to identify repeat events and mark it as not paid event programmatically and only if the user has paid for the main event, I want to allow them for repeat events
Right now I don't see any value in event array which indicates that the event is a repeat event
How can I implement it?

 "id": "49",
            "title": "Title",
            "event_title": "Title",
            "summary": "Summary",
            "description": "Description",
            "event_description": "Description",
            "event_type_id": "2",
            "participant_listing_id": "1",
            "is_public": "0",
            "start_date": "2019-01-15 20:20:00",
            "event_start_date": "2019-01-15 20:20:00",
            "end_date": "2019-01-17 00:00:00",
            "event_end_date": "2019-01-17 00:00:00",
            "is_online_registration": "0",
            "max_participants": "22",
            "event_full_text": "This event is currently full.",
            "is_monetary": "0",
            "is_map": "0",
            "is_active": "0",
            "is_show_location": "1",
            "default_role_id": "2",
            "is_email_confirm": "0",
            "is_pay_later": "0",
            "is_partial_payment": "0",
            "is_multiple_registrations": "0",
            "max_additional_participants": "0",
            "allow_same_participant_emails": "0",
            "has_waitlist": "0",
            "allow_selfcancelxfer": "0",
            "selfcancelxfer_time": "0",
            "is_template": "0",
            "created_id": "2",
            "created_date": "2019-01-07 20:22:38",
            "is_share": "0",
            "is_confirm_enabled": "1",
            "is_billing_required": "0"
        }


texts:
A few members have reached out to me to say that their account has been blocked. I have gone into their accounts to "enable" their user status and change their password. However, the member is still getting the "block" notice and when I re-enter their account, their user status is flipped back to "blocked".
How to I enable these users that are continuing to be blocked?


texts: Why are my Actions drop downs not working post civicrm security update?

texts:
After the CiviCRM security updates - some of our D8 sites are throwing blanks when selecting an Action -> on e.g. the Search -> Contacts Results screen.
Select Contacts -> Select Action -> Nothing happens


texts: Trying to use CiviCRM to take memberships for an event

texts:
I've been looking at CiviCRM to see if it would work for running an event in about 3 years time.

I'm pretty new to CiviCRM. The event is a convention and is a one off. People can join many years ahead and their membership is effectively lifetime.  I'm trying to set up a membership system that lets you join as one member type, then upgrade. Using a contributions page, I'm just adding the membership types for their prices. (I'm also using CiviDiscount to discount your upgrade). You can successfully upgrade, BUT it then keeps showing you the lower tier memberships. And you can choose them... Is there a way of not having them show up?

I'm glad to be pointed at educational resources. And glad to change code, but I'm not sure where.

I realise that this isn't really what CiviCRM is designed for. But the other features are so useful, that really if I can get past the membership problems I'm having, it may be worth it.

Thanks,
Norman


texts: Good tools for building a call for proposals in Civi?

texts:
I want to do a call for proposals for a conference. I can just use a profile and custom fields for people to enter the info, but I'd prefer for them to be able to save it in progress before eventually submitting, and also to track whether or not it had been approved.

I know there are other specialized tools for this, but I was hoping maybe there was a way to do it in Civi so I don't have to set one up. We're running Civi in Drupal.


texts: ACL settings for civicrm in Joomla cannot be reset anymore

texts:
Using CiviCRM 4.6.15 (and later 4.6.16) integrated in Joomla 3.5.1 I just found out that it is no longer possible to change ACL settings for CiviCRM. It is possible to change a setting, this change is ajaxified and will be shown immediately, however after saving the change it is rolled back to the setting before the change.

I see this in a site that I upgraded from an earlier Civi version, and also in an install of CiviCRM 4.7.6 in a Joomla 3.5.1 site.
The readme text with the ACL settings advised to set the value of 'max_input_vars' (defult 1000) higher. I reset this to 2000 and later to 8000.
This does not solve the issue with CiviCRM 4.7.6 (now 4.7.7) in Joomla 3.5.1 however.

This seems to be a longstanding bug, see: https://issues.civicrm.org/jira/browse/CRM-15841.


texts:
I'm looking for a software for a non-profit organization, which should cover some special functions in addition to the 'normal' CRM functionality and wonder whether CiviCRM is suitable. I've been working in software development for a couple of years, mostly Java, but have no idea about Drupal, PHP, etc. I've installed and looked at CiviCRM, read some documentation, but have no clue if this (see below) can be done with CiviCRM out of the box or maybe with some own develpment.

One can imagine the scenario as follows: A school has modeled students and teachers as contacts. Each student belongs to exactly one class (about 8-14 students per class), lessons take place once a week, the class on a certain theme runs longterm, the students and sometimes the teachers change after a few months. Students can participate sequentially in one of about 20 classes. At each lesson, the presence of students is checked manually by means of a list.

Is it possible to model and manage the classes in a UI form like e.g. contacts as own data structures (room, date, theme, ...), building a new structure that does not yet exist in CiviCRM?
How best to describe the affiliation of a student/teacher to a class? Is there a possibility except 'Tags'?
The registration and deregistration of a student/teacher to a class must be logged. It must be possible to determine at any time which student has been in which class for how long.
For the purpose of attendance control of the lessons, a form must be printed out with the names of the students in the lessons, the lesson dates, etc. of a particular period (e.g., a month or quarter). This is filled in manually during the lesson (present yes / no). For this, a database query must determine the participants of the class and submit this list to a print template. Is there an example for this procedure?

Thank you for your comments!


texts: custom fields not adding to Drupal views

texts:
I'm trying to build a drupal view and pull in rm custom data
For both contact (client) and case
(view for case contact, relationships include case contact id-case id, and case contact id- contact id)

From add fields- all the data sets I need are visible

After selecting fields and clicking add, I'm taken back to the views edit screen without the option to edit the field label etc. And the field does not appear in the field list.

This is not consistent... for example from data set "x"
fields, a, b c, d and e are all available to choose. Fields b and d, can be added to the view. Fields a,c and e fail to materialise.

Anyone seen anything like this? Anything else I should be looking at?

(Drupal 7.60, civi 5.3.1)

settings.php file has been updated

The views cache, drupal cache and civicrm cache have been cleared several times

One of the custom field sets in question

Selecting fields to include in view

Only 2 fields out of 7 end up in views table (end columns)
Other Details and Project


texts:
I created an event template years ago, and when I use this template to create a new event, it auto populates the start date with a very old date. If I edit this event template, the start and end dates aren't shown as something that can be modified.

Where is the auto populated start date coming from and how do I change it? Ideally it would show today's date so that I don't have to scroll through months and years to get to a future date.

We are running CiviCRM 5.8.2 on Drupal.


texts:
Not much doc on API and joined table fields... Any special reason I can't get the contact's primary address in a membership query... Basically this

$result = civicrm_api3('Membership', 'get', array(
  'debug' => 1,
  'sequential' => 1,
  'return' => array("contact_id.display_name", "contact_id.street_address"),
));

Only returns contact_id.display_name


texts: Setting default date value via civicrm_buildForm hook no longer displays date

texts:
I have a custom module that invokes the civicrm_buildForm hook to set the default date for a given field to today's date.

It is working - in part. When I examine the code I see that the default value is set. However, it is set in the input that is hidden. Whereas there is a second input that is displayed using what appears to be a randomly generated id (dp1479931180679) which seems to be created by the date picker widget.

If you leave the field blank, the default date is picked up and works. But it's a usability issue since it doesn't appear to be filled out to the user.

Anyone have a work around?

Here is what the html code looks like:

<span class="crm-form-date-wrapper">
<input id="custom_17" class="crm-form-text required crm-hidden-date" data-crm-custom="Constituent_Info__Individuals:Date_Started" data-crm-datepicker="{"date":"mm\/dd\/yy","minDate":"1986-01-01","maxDate":null,"time":false}" name="custom_17" value="11/28/2016" style="display: none;" type="text">
<input id="dp1480365364891" class="crm-form-text required crm-form-date hasDatepicker" style="" type="text">
</span>

The first input (which properly shows the right value) is hidden. The second one, which is the one displayed, doesn't have a value set.


texts:
experimenting with refactoring some old code and figured I would experiment with apiv4.
the first hurdle was figuring out how to use the ArrayObject that is returned.

in apiv3, for example I would look at the count value in the array.
in apiv4 there is no such value.

my api v3 call looks like this

  $result = civicrm_api3('Contact', 'get', array(
  'return' => array("custom_90", "custom_91", "custom_85", "custom_88", "custom_143"),
    'id' => $alum_cid,
    'custom_143' => $sal['id'],
     ));
  if ($result['count'] != 0) {
    do things
  }

my apiv4 call looks like this

$results = \Civi\Api4\Contact::get()
  ->setSelect([
    'Employment_History.Salary_Yearly_',
    'Employment_History.Currency',
    'Employment_History.Employer',
    'Employment_History.End_Date',
    'Employment_History.relationshipID'
  ])
  ->addWhere('id', '=', $alum_cid)
  ->addWhere('Employment_History.relationshipID', '=', $sal['id'])
  ->setLimit(25)
  ->execute();

how do I get the count of the results?


texts: Edit the financial type of an online contribution?

texts:
We have some online contribution transactions that we'd like to assign to a different Financial Type. E.g. they were assigned Donation rather than Member Dues. Is there a way to manually change the Financial Type of a completed transaction?
On a related topic, there are some combined transactions that we'd like to split: $20 -> Member Dues, $10 -> Donation instead of $30 -> Member Dues. Is it possible to edit and split these transactions across the correct Financial Types?
cheers ... :) gn


texts:
Is there a way to batch update relationships, specifically the type of relationship along with the start and end date?

I don't see the fields to add to a profile to do a batch update. I also don't see a way on import to add a start and end date to the relationship mapping.


texts: I have CiviCRM installed on my web site, and some answers on Stack Exchange tell me to change a file in CiviCRM, or to find my "civicrmroot".  I know how to access the files on my server, using FTP or SSH or my control panel's "File Explorer".  However, I don't know where to look for CiviCRM.  Where is it?


texts: Display different profile (in Drupal) based on CiviGroup (or tag)

texts:
Thanks in advance
Drupal 7 / CiviCRM 5.13

I am looking for a way to display different profiles, in Drupal, based on different groups that the contact belongs to in Civi (or based on different tags if that works).

Specifically, I have people to be appointed as members (they already have accounts both in Drupa and Civi), to be given a yes/no field (I accept the appointment) plus some extra bio stuff they need to fill in. I do not want users that are not members to see that under their profile, in Drupal.

I hoped to have to Civi profiles, one for "appointment to be" and one for everyone else and trigger which one is displayed, based on Civigroups (or tags).

Any ideas?

Best A.


texts: How to update membership status through importing

texts:
I am testing an import of a membership to update from "new" to "current".  I'm also trying to update the "end date" to be cleared.  Also the "membership type" to a different type.

When I do the import it overwrites only the membership type and nothing else.  I don't know what I am doing wrong.


texts:
we are creating two contribution pages for both new members and donnors and we are experiencing some problems with email receipts. We would be very grateful with any ideas on where to look or what to try next as we've ran out of them.

The issue is that receipts (emails) for donnors are not being sent when a donation is complete (new member emails are beign sent). We have checked the following:

Send receipt is checked on Thanks and Receipt emails on the admin page for contribution
It is not a problem of the payment processor (we've tried with 2 different ones, and the donation is marked as complete but the email is not beign send)
The log says no email is beign sent. Meaning, is not a problem of the email getting lost on its way, but rather, that it is not sent at all.
Email template is the default one.

Something odd is, new members who choose pay later get the New member email, where new members who use a payment processor get the Contribution mail.

Ideas? Thanks!


texts:
Using  Drupal  7.63
Using  CiviCRM 5.9.1

My system had been working fine and I'm not sure what happened except that something in server updates may have broken SMTP. My last bulk mailing went fine and nothing has been changed in CiviCRM since then but SMTP is not working either in CiviCRM or in Drupal (although Drupal is able to send me a message about needed updates).

Here are the log entries from CiviCRM:

    1407    Mar 08 13:43:13 [info] $backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(232):
    CRM_Core_Error::backtrace("backTrace", TRUE) 1389 Mar 08
    13:43:13  [info] $Fatal Error Details = Array 1367    Mar 08
    13:43:13  [info] $backTrace = #0
    /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(962):
    CRM_Core_Error::backtrace("backTrace", TRUE) 1365 Mar 08
    13:43:13  [info] Ignoring exception thrown by nullHandler: 10001,
    Failed to connect to ssl://smtp-relay.gmail.com:465 [SMTP: Failed to
    connect socket: Connection timed out (code: -1, response: )] 1342 Mar
    08 13:43:13   [info] $backTrace = #0
    /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(962):
    CRM_Core_Error::backtrace("backTrace", TRUE) 1340 Mar 08
    13:43:13  [info] Ignoring exception thrown by nullHandler: , Failed to
    connect socket: Connection timed out 1316 Mar 08 13:43:13 [info]
    $backTrace = #0
    /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(962):
    CRM_Core_Error::backtrace("backTrace", TRUE) 1314 Mar 08
    13:43:13  [info] Ignoring exception thrown by nullHandler: 110,
    Connection timed out

  Drupal says:    phpmailerException: SMTP Error: Could not connect to SMTP host. in PHPMailer->SmtpConnect() (line 810 of /var/www/html/sites/all/modules/smtp/smtp.phpmailer.inc).


texts:
Seeking advice on the best practice way to implement membership fees based on the custom field which contains organisation income. i.e. Membership fee would be 1% of income for type 'A' contact.

I understand custom development is likely to be involved, so would it be best to create a module & which hooks or classes to override? Something that is maintainable through releases without constant code changes would be good.


texts:
I can no longer upload docx or odt files to use as templates. Not sure when it happened but I'm running 5.6.0. I had uploaded files previously and even when downloading that same file and trying to upload again I get the error. Is it possibly a directory permissions issue? Confused... Not sure where to. Turning on debugging give no additional information. Thanks.

Attached is a screen shot of when I try to save and the

and a Link to the bare .docx (stripped tokens)

message template


texts: Membership on behalf of multiple organizations error

texts:
Our client is an association of Pension Funds. Several fund administrators manage multiple funds. The managers need to renew the memberships of each fund under their control. The funds are the members, not the managers. However, after a support call, I logged in as a fund manager and received the following:

  You already have a lifetime membership and cannot select a membership
  with a shorter term.

We have no lifetime memberships, but this fund administrator has 7 member funds in her portfolio. She renewed 2 before this error appeared. Also, one fund she tried to renew, was logged as one of her clients she had just renewed.

Essentially, she has clients A-F. She registered A and B, then C was assigned to B. Then I tried to login as her and got the error above. What have I done wrong or better yet, how do we fix this?

We are running 5.13.4 on Wordpress.


texts: Webform Civi Payment fields not showing up

texts: I just created a webform with a Civi contribution page enabled. When I save the form to test, the payment options are not showing as part of the form. Do I need to do something other then enabling the contribution section and assigning it a contribution page to get the credit card and billing address fields to show?


texts: Intermittent "Your browser session has expired and we are unable to complete your form submission" errors

texts:
In the midst of a fund drive and we're seeing intermittent instances of the message "Your browser session has expired and we are unable to complete your form submission. We have returned you to the initial step so you can complete and resubmit the form. If you experience continued difficulties, please contact us for assistance." on our contribution page.

This is on WordPress, CiviCRM 5.6, using the latest version of the Stripe plugin.

Nothing jumps out at me in the logs -- I do see some weird permission denied on wp-blog-header.php messages but those don't seem to be related in terms of the timestamp, and the site's behaving fine from what I can tell.

Any ideas on what might be causing this and how best to troubleshoot further? Thanks.


texts: Public CiviCRM forms not working for anonymous users

texts:
Public CiviCRM forms (contribution pages, registration for events, mailing subscriptions, etc.) works for logged users but when we try to use for anonymous users they don't work.

For example, if we submit a registration for event the form redirects to itself without any error message.

We run CiviCRM over Drupal 7.


texts: CiviMail mailing sometimes has 0 intended recipients

texts:
I'm creating some CiviMail mailings using the API. Sometimes my mailings get created and scheduled, but when they execute, they are marked as "completed" but show as having Intended Recipients: 0 in the mailing report, even though the recipient group is correctly populated:

When I create the exact mailing manually through the GUI, I get the proper intended recipients and the email is sent.

The code I'm using can be found in my CiviMail Tools Drupal module that provides rules integration for CiviMail using the CiviCRM API.

So, I have a rule component set up that creates a CiviMail mailing when a node is published. If I execute or schedule (rules scheduler) the rule component manually, the mailing gets intended recipients. However, if the component is scheduled automatically by an event trigger, then the CiviMail mailing is created and scheduled, but has Intended Recipients: 0 as in the above screenshot.

Any idea what might cause this? Again, it only happens when Drupal schedules my rule component based on an event trigger. If I schedule it manually, it all works. Very strange and difficult to troubleshoot!


texts: Blank System Status screen and invalid [civicrm.files] URL variable on fresh CiviCRM v.4.7.30 and WordPress v.4.9.4 install

texts:
I'm puzzled why, for a fresh CiviCRM install on WordPress, the URL variable [civicrm.files] is set incorrectly, resulting in some out-of-the-box broken behavior. Specifically:

I "successfully" installed CiviCRM v.4.7.30 on WordPress v.4.9.4. I got some pop-up warnings and jumped to the "System Status" screen, which was blank except for System Status: Error in the footer.

When I "inspected" the web page, I found "404 file not found errors" for some angular-modules... files, for example https://crm.staging.myorganization.org/home/myorganization/sites/staging/crm.myorganization.org/wp-content/uploads/civicrm/persist/contribute/dyn/angular-modules.e0e4119919ee72acc13134f3f09d77c0.js was  not found.

After some digging, the tip to go to Administer -> System Settings -> Debugging and disabling the "Asset Cache" (from https://civicrm.stackexchange.com/a/19597/5790) made the "System Status" screen work. Yay! But that's not a good production solution.

Digging further, I found that URL variables were set to the following. The [civicrm.files] value is incorrect.

  URL Variables
  [cms.root] https://crm.staging.myorganization.org/
  [civicrm.root] https://crm.staging.myorganization.org/wp-content/plugins/civicrm/civicrm/
  [civicrm.files] https://crm.staging.myorganization.org/home/myorganization/www/sites/staging/crm.myorganization.org/wp-content/uploads/civicrm/

However all of the Path variables were correct:

  Path Variables
  [cms.root] /home/myorganization/www/public_html/sites/staging/crm.myorganization.org
  [civicrm.root] /home/myorganization/www/sites/staging/crm.myorganization.org/wp-content/plugins/civicrm/civicrm
  [civicrm.files] /home/myorganization/www/sites/staging/crm.myorganization.org/wp-content/uploads/civicrm

On the Administer -> System Settings -> Resource URLs, the default values include the following:

  Image Upload URL [civicrm.files]/persist/contribute/
  Extension Resource URL  [civicrm.files]/ext/

It is the use of the invalid [civicrm.files] value here that resulted in the blank "System Status" screen. Once I changed these to the correct absolute URL, the "System Status" screen worked fine, even after I changed Administer -> System Settings -> Debugging -> Asset Cache back to the default "auto" setting.

Why is [civicrm.files] set to this odd incorrect value, when [civicrm.root] is perfectly fine? This is confusing for a CiviCRM newcomer (such as myself). Of all things, the "System Status" screen should be able to report the issues for the fresh install.

To clarify the installed folder structure:

The $_SERVER['DOCUMENT_ROOT'] is /home/myorganization/www/public_html, but I've created a folder structure under /home/myorganization/www/sites for test, staging, and production folders for various sites. The ~/www/sites folder is symlinked into /home/myorganization/www/public_html. I've created a custom __index.php__ file that gives the values of various PHP variables:

  Full URL= https://crm.staging.myorganization.org/index.php
  $_SERVER['DOCUMENT_ROOT']= /home/myorganization/www/public_html
  $_SERVER['PHP_SELF']= /sites/staging/crm.myorganization.org/index.php
  $_SERVER['SCRIPT_NAME']=   /sites/staging/crm.myorganization.org/index.php
  $_SERVER['SCRIPT_FILENAME']=   /home/myorganization/www/public_html/sites/staging/crm.myorganization.org/index.php
  realpath( $_SERVER['SCRIPT_FILENAME'])=    /home/myorganization/www/sites/staging/crm.myorganization.org/index.php
  getcwd()=  /home/myorganization/www/sites/staging/crm.myorganization.org
  __FILE__=  /home/myorganization/www/sites/staging/crm.myorganization.org/index.php

Bonus Question

After fixing the above, the "System Status" screen still complains "Incorrect Resource URL: The Resource URL is not set correctly. Please set the CiviCRM Resource URL." Why?


texts:
I try to get rid of this persistent and annoying warning message:

  Warning: is_dir(): open_basedir restriction in effect.
  File(/usr/share/pear/api/v3) is not within the allowed path(s):
  (/var/www/civicrm/htdocs:/var/www/civicrm/apps:/var/www/civicrm/priv:/var/www/civicrm/tmp:/usr/share/php:/tmp)
  in Civi\API\Provider\MagicFunctionProvider->getEntityNames() (line 106
  of
  /var/www/civicrm/htdocs/drupal/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php).

getEntityNames gets the /usr/share/pear path from the get_include_path(). Where is the /usr/share/pear coming from? The path does not even exist on my Ubuntu 14.04 system.  I have been looking everywhere. CiviCRM runs under Drupal, Apache and PHP fastcgi.


texts:
After the Mandrill's announcement that their customers require a paid monthly MailChimp accounts, has anyone opted to sign up for MailChimp?

Mailchimp monthly pricing is based on subscribers, does this mean that you need to sign up for an account equivalent to your contacts count?

Or can you sign up for the basic $10 (0-500 subscribers) and pay the additional Mandrill fees for outgoing emails?


texts: Send Schedule Mailings job succeeds but scheduled mailing not completely sent

texts:
On Civi 4.7.27 send first large mailing to 12733 emails through SparkPost, only some were delivered (about 900), and the job says it has not completed. Unfortunately, it is 16h later and the Send Schedule Mailings (Entity: job Action: process_mailing) keeps succeeding every 5 minutes.

The settings were default, so the job attempted to send all 13k emails at once, which I confirmed by finding one child job still in state of 'Running' in the civicrm_mailing_job table with 0 offset and all mailings included.

My suspicion is that the job timed out.

How can I invoke a job that will complete the sending? Can I determine from one of the tables which emails have been sent to, and can I restart from there?


texts:
New WP install. Getting this error...

Unpacking the package…

Could not extract file from archive. civicrm/civicrm/packages/kcfinder/themes/dark/img/files/big/..png

Thanks,

Brad


texts:
Are we at a stage where we can be reporting Drupal 8 bugs?

If so, where should they go? Should they go on the Jira somewhere, or maybe a mailing list?


texts: Drupal View adding trailing zeros to Activity ID

texts:
I have a Drupal View displayed as a block, which includes a link to a webform using the Activity ID and the Contact ID for logged in users. It's been working fine but now I find that it's adding trailing zeros onto the aid, e.g. https://my.site/volunteer-role?cid2=540&aid=78668.0000

This is the link in a global custom text field: "volunteer-role?cid2=[contact_id]&aid=[id]"

Any ideas how I can remedy this?


texts: "Network Error Unable to reach the server" only doing certain actions

texts:
we have a CiviCRM installation under WordPress 4.9.10 and 2 MySQL db: one for Wordpress and one for CiviCRM.
Actually we imported and start to manage more than 5000 contacts.

Everything operate as well, excepting the following actions, returning us a

  Network Error
  Unable to reach the server. Please refresh this page in your browser and try again.

clicking to go on page 2 on a "Search -> Find Contacts" or a "Search
-> Advanced Search"
adding a meeting or phone call in the contact summary.

There are NO ERRORS adding contributions, registering for events, adding pledges, sending emails.

We see no errors in apache logs too.
Actual PHP variables are:

 php_value memory_limit 256M
 php_value max_input_vars 2500
 php_value upload_max_filesize 16M
 php_value register_globals off
 php_value max_execution_time 600
 php_value output_buffering 0

Any ideas about to solve it?
TIA -- Francesco


texts: Civirules: how to move contact into NEW group XX days after added to group

texts:
I want to automatically move Contacts from my "New Organizer" group to my "Active" group 90 days after the Contact is ADDED to the "New organizer" group.
I have created a pipeline to track the stages of my volunteer's involvement. I am triggering movement into each stage by manually setting an Activity Type and a Unique Activity Status for each stage of my pipeline. I'm then added people to groups based on their Activity Status using Civirules. This works great.
But I also want to set rules that automatically move new and inactive volunteers into new groups.
I can almost see the way there using Civirules, but don't see the option to do a Field Value Comparison on Date Added to Group (or Activity Created Date, which could be another option for me)
OPTION 1
LINKED TRIGGER: Daily trigger for group members
FIELD VALUE COMPARISON: I can only select from Contact or GroupContact fields, so I can't proceed.
OPTION 2
LINKED TRIGGER: Activity Date reached ; Activity with type XX AND Status XX
LINKED CONDITION: Field Value Comparison; Activity Created Date = +90 days

LINKED ACTIONS: Remove Contact from initial Group; add Contact to new Group
Is this going to work as I expect? Will the Civirule be activated without an explicit trigger to do the date comparison 90 days after the Activity Created Date?


texts:
After upgrading to CiviCRM 4.6.5, I cannot access any more to any popup window. This overlay window is somehow slightly greyed.
It doesn't react anymore (not event the cancel button) and the only way to remove the window is pressing the escape button.

In drupal administration I have this warning :

Warning : array_shift() expects parameter 1 to be array, string given dans civicrm_permission() (ligne 67 dans /home/website/public_html/sites/all/modules/civicrm/drupal/civicrm.module).

Is it a Drupal issue or a Civi one ?

Thanks for advice and help.

====


texts: How do I add additional information to a contribution page? PROFILE OPTION NOT WORKING

texts:
In my contribution page, there is not an option to add a profile:

The dropdown menu doesn't work (doesn't exist) and even if I type in the name of a profile that I have created, it doesn't actually do anything. We have PayPal Standard and because we have that set up as a payment instrument thru CiviCRM, it isn't a button that we can add settings to from PayPal, so PayPal doesn't collect that information for us. We need to be able to collect donor addresses to send them their donation receipts. If the donors are already in our database, I can pull a report from CiviCRM but if they aren't all we have is a name and email address.

Is there a workaround? Or am I doing something wrong? I have several profiles on CiviCRM--some of the standards and some that I've created and none are available.

I looked at the suggestions here but none worked. My page (here) is on WordPress. Also, I am a total novice at coding, so the more info you can give if suggesting going into the code, the better. Thank you!


texts: Renewal link mangled by webmail client with ISP

texts:
We have been successfully using the contact.checksum link in renewal reminder emails for our Wordpress site. The link in the received email typically looks like:

https://sdbikecoalition.org/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2&cs=yyyyyy&cid=xxx

However, one user has different behavior when opening the email on a webmail client (it will be OK when reading the email in another client). The webmail client is with a local ISP, cox.net. The link has an extra path in the URL, e.g.

https://webmail.west.cox.net/do/mail/message/sdbikecoalition.org/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2&cs=yyyyyy&cid=xxx

This seems to be CLEARLY the fault of the ISP. The SAME email, when forwarded to another mail provider is correct. The user with this problem has talked to their ISP (cox.net) and they cannot provide an answer.

I'm just posting to see if anyone has encountered something like this with either cox.net or any other ISP.


texts:
We are having a problem with the click through links in the email templates.  I need to see if it works if link tracking is disabled.  Where can I turn that off?

Thank you


texts:
Is there a smart way to automate calling civilint before committing on a repository specific basis? i.e. just call it on civicrm (core and extension) repos and not on other repos?

Just tweaking and improving my development workflow.


texts: Clicking Fields in Front-end Profile View Gives Inconsistent Results

texts:
These issues have existed for a while, but perhaps without resolution?

Front-end Profile View Issues

When you go to view the full profile from a profile-based search, all the fields are clickable but the actions after the click are inconsistent. For example:

Click on a website URL - goes to the website. Click on an email link - goes back to the profile list search results for that email address. Click on a text-type field - adds that to the search criteria.

I would rather have email fields trigger an "emailto:" type action.

And in the specific instance I'm working with, it would probably be best if text type fields were not clickable at all in the full profile.

All profile fields are set to Expose publicly and for listings.

Wordpress 4.7.5 CiviCRM 4.7.17


texts: Add/update activity date time using webform

texts: Is it possible to use webform to update the activity date and time using webform?


texts: Wordpress: MyISAM Database Engine Error after update

texts:
After update to Civicrm 5.8.0 I got a:

MyISAM Database Engine
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.

Had a look into the db, found out it's just about three tables:

Is it save to do ALTER TABLE tablename ENGINE=InnoDB;?


texts:
I currently use Drupal's Calendar module to display CiviCRM activities on a Views Calendar. I also have another content type that displays nodes on a Views Calendar. Is it possible to display both CiviCRM activites and content type nodes in one calendar?

I tried the CiviCRM Entity module, but activities don't seem to be available as a field.


texts: CiviCRM Profile not showing on User Account Page

texts:
I am using CiviCRM on Backdrop (Drupal 7). I am new to CiviCRM, but not new to Drupal.

I have read the CiviCRM documentation on Groups, Profiles,etc. Well all of it pretty much. Also read old an new posts about Accounts and Roles and Profiles. I am pretty sure I have everything set up correctly.

I have a CiviCRM Profile used for new user registration which works fine. It is creating the Backdrop Roles, Civi Group and Membership Type as I want.

Logging in as the new user having got a password sorted, there is no sign of the Civi Profile or a link to it on the User Account Page.
In the Profile Settings I have checked the 'View/Edit Drupal User Account [ x ] CiviContribute' field so it should show up.

I have unchecked the Backdrop Permisssions for 'access all custom data' and in the Civi ACLs I have tried setting both 'A profile' and 'A set of custom data fields' in the 'Type of Data' but no go. The Profile is not seen on the Account Page. Even when logged in as the Administrator I cannot see this data on a user's accounts Page.

I must be missing something here, but what?


texts:
I am on shared linux hosting and using the CPanel cron job setup page. Set to run every 1/2 hour. I just need the command line, and I consulted the books for more info. The command line I came up with is:

/usr/bin/php -q /home/acct123/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -j -s mydomain.org -u Paul -p password -e Job -a process_mailing

This doesn't work. Cron returns (via email):

PHP Fatal error:  cli.php can only be run from command line. in /home/acct123/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.class.php on line 86


texts:
Is there a way to display a list of all available tokens on the system (other than scrolling through the dropdown)?

Our donor intake person would like to see what's available in a readable way.


texts:
I expect this is a common problem,

Treasurer get loads on contributions in CSV format ( Contact ID / Amount / Date )

Bulk loading contributions via CSV is completely detached from membership renewal.

As memberships are set to go 'grace' on expiry I think a script like

Search membership in grace
If contribution made and receipt date > membership expiry date
   set membership status to current ,
   set expiry to end next period,
   link contribution to membership

I don't think this is too challenging in SQL  ( I haven't looked at API ing it )

So now the question,  there are batch jobs - how are they created / structured ?


texts: Recurring Contributions consistently stuck in Pending Status

texts: We've been noticing a trend over the last few months that typically around the 21-23 of the month several of our recurring contributions end up not being processed by iATS and then get stuck with a Pending status.  Where are the first places that I should look to figure out the problem of why there is this pattern?  We are using Civi 5.10.4 and iATS Extension 1.6.2.


texts: Adding defaults for custom field - dependant on encounter medium civiCase/rules

texts: Trying to speed up data entry in back end, by pre-filling 4 custom fields in the case, using rules, the defaults would vary based on encounter medium.  I can only seem to update the case status using an action.  I looked at creating new rule action but couldn't find any instructions I understood.  Is there a better way to do this or can someone point me at some simple instructions?


texts: How can I make a mailing public after it's been sent?

texts:
If a mailing has already been sent, how can we make the archive of it public? We didn't set the Visibility to Public when we were sending it. Is there a way to change this retroactively?

Thanks.


texts: How to install civix and build an extension in drupal

texts:
Please I don't know how to install civix and build an extension using civicrm. I
already installed drupal and civicrm module. but I have no clue how to write an extension or how to run anything here. I am totally new to it.

thanks


texts: CiviCRM edit history for different users

texts:
Is there a way to find out when an account signs into the CiviCRM admin panel and edits something. Specifically I am looking for the person who changed a price field. We're using Joomla with Civi.

Logging was not turned on


texts: Can I add phone number as a searchable field on Advanced search Page?

texts: We are currently running on civiCRM version 4.1. Can I add phonenumber as a searchable field on Advanced search Page?


texts:
The View Volunteer Roster for a CiviVolunteer Project indicates it should only be displaying the Assignments for the current day and future days.  However, it lists the assignments which are in the past.  How do we eliminate the past assignments?

In addition, the "Back to Manage Volunteer Projects" button at the bottom of the window does not work.

Drupal - 7.54
CiviCRM - 4.7.17
CiviVolunteer Extention - 4.6-2.2.1


texts: Paypal ipn issues after upgrade to 4.6.15.

texts:
Paypal ipn is failing with 500 after upgrading to 4.6.15 from 4.6.10

The notification url looks correct but isn't working
https://www.mysite.com/civicrm/extern/ipn.php?reset=1&contactID=83&contributionID=80&module=contribute

I am using Drupal 7 with Pantheon. I already have implemented this patch
https://www.drupal.org/node/2177647

I'm not sure how to further debug this. The extern/ipn.php file hasn't changed from 4.6.10 to 4.6.15. Where else can I look.

Any tips on debugging would be greatly appreciated, thanks.


texts: Has the Dashboard Cache Timeout setting been moved?

texts:
I can't seem to find the Dashboard Cache Timeout setting, which according to my experience and documentation can be adjusted

  by visiting Administer > System Settings > Misc and editing Dashboard cache timeout.

But this setting is not to be found at that location, neither on my (slightly dated) out-of-the box 4.7.15 install, nor on the Drupal demo site.

Has this setting been moved or removed as of some version of CiviCRM? If so, how would one go about changing the Dashboard Cache Timeout?


texts: Deadlocked queries cause an instant error for end-users, but are retried in other circumstances

texts:
We have a lot of smart groups, and consequently a lot of deadlocks. There's already code in Civi that detects deadlock Exceptions, and then retries the query a few times. This is really helpful - I have extra logging on this, and I can see that it prevents a lot of errors. But this code doesn't kick in for people directly using the UI - they get the 'unknown error' yellow-screen-of-death immediately. This can happen on exports, or when opening complex groups. I dug into this and sort-of know why it's happening:

When a deadlock happens, an exception is thrown if $GLOBALS['_PEAR_default_error_options'][1] is set to 'exceptionHandler'. This exception triggers the code which retries the query.
An exception is not thrown if $GLOBALS['_PEAR_default_error_options'][1] is set to 'handle'.
$GLOBALS['_PEAR_default_error_options'][1] is set to 'exceptionHandler' when you generate smart groups via the API, and in most other circumstances
But $GLOBALS['_PEAR_default_error_options'][1] is set to 'handle' in the UI in general (?) - at least, it is on exports and when using 'Manage Groups'. So in this case no exception is raised. And if there's no exception, the try-catch blocks have nothing to work with and front-end users get 'unknown error' immediately.

I am happy to fund a fix for this, but I'm not sure what I'm getting myself into. Is this a bug, or is it an unfortunate consequence of how error handling needs to work for end users?


texts: Redirect TO PayPal Standard working for Events but not contribution pages

texts:
I have a site where payment for an event via Paypal Std works fine, but a contribution page set to use Paypal Std does not redirect to Paypal but just completes without leaving the site.
There are no errors logged. Could anyone advise what the problem might be?


texts:
I get this error when searching for any email address in advanced search or search builder.

https://pastebin.com/6LRJDyt1

The 1-address alias is not defined, so it fails. In advanced search it does not let me select the location type for the email. However, in search builder it does and it still fails. I tested this on the demo https://wpmaster.demo.civicrm.org/ and email search works there. I have disabled all civi extensions and it still fails.

WP 5.2.1 and Civi 5.13.4 multisite. Anyone else seeing this?


texts:
Uninstall CiviCRM from WordPress, is creating me a big issue.
I needed to uninstall CiviCRM (5.31.1) from a production site, saving all theme and others settings.
CiviCRM went away without uninstall its db data. So:

I tried to delete the tables using phpmyadmin, failing
From command line, I dropped the db and I recreated it from a dump, cutting away the CiviCRM part, maining all tables without wp_ prefix; doing this the Wordpress site operate all as well.

Some days ago it was necessay to reinstall CiviCRM... All was good until we clicked the plugin enable link, recieving this page:
Initialization Error

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'sat_wp2020.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'sat_wp2020.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'sat_wp2020.civicrm_setting' doesn't exist]"]

Where old CiviCRM data are still inside db?
Did someone prepare a SQL script performing correct db uninstall?
Could be possibile to add the data delete checkbox during plugin uninstall process, like in many others Wordpress plugins?
TIA -- Francesco


texts:
I ran into some validation problem when run a DAO with a 'YmdHis' date string using a Date type callback. It turns out the Date type does not take a full date+time string. So I changed to use Timestamp callback with a timestamp string like this this one "1432650922" but it failed again.

Took a look and realise that the Timestamp type is not really for Unix timestamps but for date strings in either 'YYYYMMDD' or 'YYYYMMDDHHMMSS' format.

In this case, should we call it Datetime rather than Timestamp? Just to avoid confusions.


texts: Change thumbnail size on public directory detail page

texts:
We have a public directory that contains the contact image. By default the image thumbnail is set to a size of 100px X 100px. We would like this to be larger. Does anyone know where we can change that? I took a look at the css but did not see anything.

We are using WordPress 4.9.1 & CiviCRM 4.7.27.

Thanks


texts: Making "My billing address is same as above" checkbox work on webforms

texts:
Currently, "My billing address is same as above" checkbox is not visible on webform-civicrm. I can see that billing fields are not part of a webform and they are loaded directly from civicrm using civicrm's billingBlock.js.

Please can I ask, if it is possible at all to make the checkbox work for webforms since the address fields are on a different page than the payments page? If yes, what would be the best way to do it?

Thanks!


texts: is there any way to restrict data export?

texts: Is there any way to restrict data export while still allowing users to see all data? I still want to give this permission 'View ANY CONTACT in the CiviCRM database, export contact info and perform activities such as Send Email, Phone Call, etc.' but don't want them to be able to export the contacts. civi 4.6.11, drupal 7


texts: My hosting company does not support SUPER privilege - can I use CiviCRM with them?

texts:
I finally after a week and 3 tickets got CiviCRM/Joomla to install on my Startlogic hosted server, but I can't add anything to the database.  The final response I got from Startlogic support was "Hello Michael, We apologize for any inconvenience this has caused you. It looks like the extension which you are trying to install requires super privilege which is not supported. Also, we do not support binary logging which the extension requires. Thus, you are receiving the error message. You can try using any alternative extension and check."  At this point I think they are blowing me off and about to go through the headache of switching hosts.
Is there anything I can do get CiviCRM to work on the Startlogic server, as they seem not to want to help.


texts: How to change component style,there is cssclass in component edit, we don't know where to write the class. Any help please.


texts: Case type edit not saving, broken case types - how to debug?

texts:
On a particular Civi 4.6.4 / Drupal 7 installation, recently upgraded from 4.4, there are some misbehaving case types. They appear to have been created through the CiviCase UI since the 4.6 upgrade, as there are no corresponding xml files in CRM/Case/xml/configuration/ under the custom template directory. These case types have no activity types and no timeline specified. The xml in the definition field of the civicrm_case table is just this:

<?xml version="1.0" encoding="utf-8" ?>

<CaseType>
<name>engagement</name>
</CaseType>

When I try to edit one of these broken case types through the UI, e.g. adding activity types or adding a standard timeline containing Open Case, it does not save. No error is reported on screen, in CiviCRM.blah.log, Drupal watchdog, Firebug console or the web server error log.

The following civicrm/ajax/rest call is shown in Firebug on saving:

action: create
entity: CaseType
json: {"id":"4","name":"engagement","title":"Engagement","is_active":"1","is_reserved":"0","weight":"2","definition":[],"is_forkable":"1","is_forked":""}

Note "definition":[]. This I assume should hold details of the activity types & timeline I have just attempted to add. The response is as expected, given the data that was provided:

{"is_error":0,"version":3,"count":1,"id":4,"values":{"4":{"id":"4","name":"engagement","title":"Engagement","description":"","is_active":"1","is_reserved":"0","weight":"2","definition":[],"is_forkable":"1","is_forked":""}}}

However I was able to create a new case type OK.

Any advice on debugging this would be much appreciated.


texts: Is there a way of automatic discounting renewals based on referrals?

texts: We have an offer for our existing members, that whenever any new member enrolls based on existing member's recommendation, that recommending member gets a fixed discount on his nearest membership fee. He can convinced as many new members, as he is able to do and by doing this he gets this discount for each of recommended new member and thus reduces his membership fee. Is it possible to calculate his discount every time he attempts to renew his membership? Any suggestions how to implement such functionality (CiviCRM 4.7 on WordPress)?


texts: Is it possible to add just a time as a custom data field for an event?

texts:
We want to show multiple dates for the event, each with its own start and stop time.

Day 1
  Start Time #1
  Stop Time #1

Day 2
  Start Time #2
  Stop Time #2

But in custom data (Administer > Customize Data and Screens > Custom Fields), it doesn't seem to be possible to add a field that is just a time without a date.

I realize we could create two fields, each of which contains both a date and a time:

Day 1 Start
Day 1 End
Day 2 Start
Day 2 End

But we'd have to enter each date twice, extra work and introducing an opportunity for errors in entering the redundant information. For each day of the event, we want to enter three items: the date, a start time and a stop time.


texts: How do I send an email to all event participants immediately?

texts:
I know you can schedule reminders, but you can't choose a date and time, only a date (when does it send if you choose the same day?), otherwise you have to choose a time before the event or after the event.
I just want to send an email right now and I don't want to have to create a group to do it.
This is a basic feature in competing platforms - is there something obvious i am missing?


texts: How can i solve search issue in civiCRM?

texts: In Wordpress I create two forms: one for a teacher and a second for a student. I need to search for teacher data using the student search form. But I can't understand how to do it. Please give solution, how can i solve this issue?


texts:
Similar to CiviRules triggers, but fails to send email,
but I've not seen a resolution there. For the past ~year, have had CiviRules sending my DRIP email campaign, along with a couple of tag setting functions.
(techie enough to be dangerous... I can get in to things, but...)
Recently, (not sure exactly when) I noticed that it wasn't sending the emails, though, it was processing other things in the actions. Emails do send no problem - manually.
I didn't know about CiviRules logging, so just loaded it, but don't know where the logs might show up. I added another user, it triggered, but no emails, and no errors - at least not seen in Administer> Administration Console> View Log.
From above post, I saw about civicrm_queue_item table. There are a number of items there from the past ~2 months, but I don't know how to interpret.
Cron is running, including process civirules and process delayed civirule actions (both always, with no errors).
I just saw another question with problem with delays, so I changed the delay on my first email from 1minute - to no delay. Created user, with the trigger tag. It sent the email! Now, will it send the rest? (2, 4, 6... day delays on them.
Running:
WordPress 5.5
CiviCRM 5.27.3
CiviRules 2.16
Email API 1.19
Thanks for any ideas/suggestions/hints...
..clark


texts: Why is my Menu and dashboards not working on clean installation on Wordpress?

texts:
I have installed Civicrm 5.4 on a new Wordpress installation, I ran through the setup with one issue of a dashboard contact ID and have gone through the Configuration Checklist, but after that my Civicrm Menu never shows.

I went through the fixes online and implemented everything from making sure the resource urls are correct everywhere, resetting the menu through another plugin, clearing the menu in the DB, changing settings in the civicrm.settings.php file but with no success.

I have manually added an entry in the dashboards table so I can atleast see the Resources on the front dashboard but I am unable to move it next to the News.

I am running wordpress 4.9.8 and php version 5.6.5 on a company server.

Please let me know if there is more information I can give and thank you in advance.


texts: What is the best way to track Business Development and Donor Intel

texts:
I work for a nonprofit and we are trying to figure out the best way to document and track business development work such as Intel into potential donors or conversations various execs have had with an individual and keep it in Civi. For instance, if my CEO goes to talk to Mr. Smith and Mr. Smith gives us all kinds of information about Foundation ABC even if they don't work there then what is the best way to keep track of all of that information? Is it through activities and then just adding all mentioned parties as contact with? Or is there an extension or organization method that my CEO could just click on Foundation ABC and find all relevant notes to that FOundation to help make the ask that much better?

We are hoping to use Civi not only for our donor tracking but also business and grant development too and we can't seem to find the best way to organize to make that happen.

Any advice is appreciated!


texts: Another CRON headache: fwrite() expects parameter 1 to be resource, string given in … /WP_CLI/Loggers/Base.php

texts:
CRON was behaving as expected for a few days, but now I'm getting this:
Warning: fwrite() expects parameter 1 to be resource, string given in [REDACTED]/WP_CLI/Loggers/Base.php on line 57

Any idea what's causing this?


texts: I've got API access to Contacs, lack permissions for Membership or Contribution!

texts:
I have dug deeper and more structured into my permissions problems. I have tried to access our CiviCRM via API3 REST.php? interface, designed from the APIv3 assistant. Both on releases 5.14 and 5.35 (under WP)same problem. I am an Administrator with maximum permissions granted.
Both "get" access and "create" access with the Contacts-part work fine, but I get no access for Memberships or Contributions. The system states that I do not have sufficient permissions for the later two accesses. <error_message>API permission check failed for Contribution/get call; insufficient permission: require access CiviCRM and access CiviContribute</error_message> I have those permissions granted, and at least access CiviCRM but be OK as it works for Contacts. Does anyone know what might be the problem? I am using Python requests methods post or get, no difference. Is there a way to find out what permissions are actually granted as stored for my user?


texts: Modifying Contribution and Event Templates

texts:
I am trying to modify the confirmation and final page (not sure of the name) for  contributions and events. I want to modify the templates like described in this post - Why does the Contribution page amounts appear as a quanity?.

A few questions:

How do I find what template to modify?
How do I know where to put the custom template?
Is it best to just modify the template or to put this in an extension? I already have an extension with some simple JS.

I appreciate the help.

Thanks!


texts: we have created the new webform and included custom fields. we need to align the components styles(like width,background)etc. Any one please help us how to change the design. Thanks,kanchana.


texts: Using buildkit on MAMP but hitting "Fatal error: Call to a member function getDriver() on null"

texts:
I am trying to install buildkit on a Mac with MAMP, but am hitting this wall:

  Fatal error: Call to a member function getDriver() on null in phar:///Users/user/buildkit/bin/amp/src/Amp/Database/MySQL.php on line 58

What am I missing?

I have been following the buildkit readme and have gone through this thread about setting up with MAMP but am not sure where I went wrong because I get the error when I actually try to use it.

MacOSX:dmaster.localhost user$ civibuild create dmaster
[[Download dmaster (type 'drupal-demo' in '/Users/user/buildkit/build/dmaster')]]
Already downloaded dmaster
[[Install dmaster/default (type 'drupal-demo' in '/Users/user/buildkit/build/dmaster')]]
[[Execute /Users/user/buildkit/app/config/drupal-demo/install.sh]]
++ source /Users/user/buildkit/app/config/drupal-demo/install.sh
+++ amp_install
+++ _amp_install_cms
+++ echo '[[Setup MySQL and HTTP for CMS]]'
[[Setup MySQL and HTTP for CMS]]
+++ cvutil_assertvars _amp_install_cms CMS_ROOT SITE_NAME SITE_ID TMPDIR
+++ _cvutil_assertvars_back=ehxB
+++ set +x
++++ mktemp.php ampvar
+++ local amp_vars_file_path=/Users/user/buildkit/app/tmp/ampvar3Oj48j
+++ local amp_name=cmsdefault
+++ '[' default == default ']'
+++ amp_name=cms
+++ '[' -n http://dmaster.dev ']'
+++ amp create -f --root=/Users/user/buildkit/build/dmaster --name=cms --prefix=CMS_ --url=http://dmaster.dev --output-file=/Users/user/buildkit/app/tmp/ampvar3Oj48j --perm=admin
PHP Fatal error:  Call to a member function getDriver() on null in phar:///Users/user/buildkit/bin/amp/src/Amp/Database/MySQL.php on line 58

Fatal error: Call to a member function getDriver() on null in phar:///Users/user/buildkit/bin/amp/src/Amp/Database/MySQL.php on line 58


texts: Enable location "Name" in CiviEvent location configuration?

texts:
Is there a way to enter a location name above the address fields in CiviEvent location settings?

When configuring an event:

It would be nice to be able to place the name just above the address like this:

"Conference Center Name"
Street address 1
City, State, ZIP

Anybody know how to do this?


texts: How can I bulk update a collection of recurring contributions to set the next scheduled contribution to a specific date?

texts: If you're using the iATS Payments Extension you control the schedules of recurring contribution from within your CiviCRM. You can already edit a given recurring series and change the next scheduled date. Can this be done in bulk?


texts: How do HTTPS settings interfere with CiviMail?

texts:
I have CiviCRM sites (5.12 and 5.13 on Drupal 7 with Aegir 3) where the behaviour of CiviMail initialisation (and the admin status page) depends on particular HTTPS setup: finishes or loops infinitely.

How HTTPS setup influences this behaviour? How to configure HTTPS on Cloudflare to avoid interference with CiviMail?

When HTTPS managed by Aegir, the mailing initialisation works.
When HTTPS are managed by Cloudflare and Pound, but not Aegir, mailing initialising never ends. Workaround here to run on plain HTTP, which is hardly acceptable.

The status page for CRM administrators also behave differently, it point to some Angular issues.

(update) Error in console:

Blocked loading mixed active content “http://example.com/sites/example.com/files/civicrm/persist/contribute/dyn/angular-modules.87ce61fa6dc174d5e3e11f666ca386e5.json”[Learn More] a:1:778
Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user’s experience. For more help http://xhr.spec.whatwg.org/ jquery.min.js:4:26272
Using //@ to indicate sourceMappingURL pragmas is deprecated. Use //# instead jquery.min.js:2:21
WARNING: Tried to load angular more than once. jquery.min.js:320:189

Solved: this D7 patch has solved the issue. More info here.


texts:
Does anyone know how to export a multiple choice field into a spreadsheet in a way that filters each response into a different column?

For example, a field has options:

apple
banana
pineapple

A contact record has "apple" and "banana" selected for the field.

In exporting their record, I would like three columns to represent the data in the field, one column for apple, one for banana, one for pinapple.

Is there a way to do this in CiviCRM, or would I need to export and then run a script in Excel?

Thanks!


texts: CiviCRM contribution tab not graying out "refunded" contributions 5.16

texts: one of our end users noticed that on our civicrm 5.16 install where we use drual 7 'seven' for our civicrm administrative theme, refunded transactions are no longer clearly "grayed out" or made clear they were refunded. not sure if this was a change in civi versions or a setting. any leads? thank you!


texts: How are folk storing lots of Files on Cases?

texts:
I know there are File fields on Activities, and we can add File Fields to the case itself.

But say there are 20 documents to add over time.

while googling I found this which sounds interesting https://github.com/CiviCooP/org.civicoop.documents since their roadmap talks about searching by 'case type'


texts:
Good morning,

I was trying to sync my contacts from CiviCRM to Mailchimp, but I get the following error Invalid MailChimp List ID: 3b27444534. After a while, the syncing process does not progress at all. Do you have any solution to this issue?

Thank you very much,

Best Regards,

Alberto


texts: Bug with Check for Matching Contact(s) button

texts:
Following the upgrade to 5.3.0, we are finding that the 'Check for Matching Contacts' button, which is in the edit contact screen, is not working. The screen refreshes and reloads the same contact, with no error message.

If you run the default supervised rule from the 'Find and Merge Duplicate Contacts' screen, it picks the duplicate up.  But the Check for Matching Contacts function has stopped working.  Is this a bug anyone else is seeing?

Thank you!

Robin

Drupal 7


texts:
I have created a Custom Data field of the field type
Alphanumeric Select
with 3 selectable options - I want to be able to edit the options that can be selected, but when I try I get an error

"This option group is reserved for system use. You cannot add or delete options in this list."

What can I do to allow edits to the list

WordPress 5.5.8 and CiviCRM 5.5.1


texts: Where is the "Domain Access CiviCRM" extension?

texts:
I am installing a MultiDomain CiviCRM implementation using Drupal using the Domain Access drupal module.
I am unable to locate the installer for Domain Access CiviCRM extension which is required to backport users created from CiviCRM into the drupal records. The link in the docs is: https://civicrm.org/extensions/domain-access-civicrm but it does not say where the code is. Nor the civicrm new extensions screen lists this during install.


texts:
I collect data in case activities, and I'm currently trying to build a Drupal Views of this data. I'm running into a problem with multiple fields. For example: "What colors do you prefer?" The results are showing up like:

Red, Blue, Green
Green, Blue

Is there a way to present each line as a color? My end goal is to create a pivot table to show a count of each color. I have a lot of multiple field questions that have this problem right now. The only solution I can think of is to create a PHP code to output a if statement == "RED" line by line.


texts: Any organisation in London that would be willing to show us funtionalities of CiviCRM ?

texts: I am trying to promote civiCRM at my governmental organisation in London and I would be very grateful if I could visit another organisation that uses several functionalities to see how it works live. Mailing and campaigning are the most important features for us. Thank you all for your time. Romina.


texts:
How do you integrate CiviCRM API3 with Laravel?

I put this question here to link the package I created for this as I wished I would have found more info on the API while searching here.

See my answer below


texts:
I have a WordPress multisite with CiviCRM 4.7.24 also in multisite mode. The main site Scheduled Jobs page (civicrm/admin/job&reset=1) looks and works fine, but that page on other sites looks like this:

If I click "Add New Scheduled Job" I get this:

which is not what I want. :(

Can anyone clarify why the additional sites don't have the regular Scheduled Jobs interface?


texts: CiviCRM Event Email Receipt Displays Custom Field Attributes Rather Than Values

texts:
A similar question has been answered in 2015, but it was not resolved: Contribution email receipt with custom fields shows array in template

I'm having a similar issue. But instead of custom fields returning "array" to the recipient, it is returning field attributes. Since there are many custom fields on this form, the email is screenshot after screenshot long. This happens not only for anonymous users, but logged in users and email receipts sent to staff.

There are no errors in the logs. While inspecting, the only thing I see is a warning: Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check https://xhr.spec.whatwg.org, which doesn't seem related.

Any help would be appreciated.


texts: CiviEvent Introductory Text HTML Problem

texts: I have some basic HTML in an event's "Complete Description" - a link to an image, and a change to the style of some text. This works fine. When I try and do the same on the "Introductory Text" of the registration screen and then click "Save", screen seems to freeze with spinny cursor. I then have to go backwards in browser to return to responsive CiviCRM. Re-visiting the event, "Introductory Text" is as it was before edit. I can save with basic text, and add simple HTML such as a bold tag but as soon as I add the image, it doesn't save. Version is 5.18.


texts: Is it possible to send an registration email confirmation to 2 recipients?

texts:
We are working on an event registration and would like to have the option to have the email confirmation sent to more than one email address.

In some cases an assistant will register people and they want the email to go to the person completing the form and the registrant.

Does anyone have a way to do this?

Using CiviCRM 4.6.26 with WordPress.


texts:
Can I batch change more than one event type at once?
I want them all to be the new, same type. Do I have to go into each event configuration separately to change the event type?


texts: Disable Inline Editing of Fields in Profile Form

texts:
I have created a profile where authenticated members can edit some custom fields which are part of a multivalue fieldset that I created. Everything works fine - the links to view, edit and delete all work ok. However, on the profile listings page itself the inline editing feature is not working for dropdown list custom fields, only for text and text area fields. When a user clicks on one of the dropdown fields, it simply dissappears and throws a jQuery error:

jquery.crmEditable.js:19 Uncaught TypeError: Cannot read property 'id' of undefined
    at n.fn.init.$.fn.crmEditableEntity (jquery.crmEditable.js:19)
    at HTMLDivElement.getData (jquery.crmEditable.js:204)
    at HTMLDivElement.<anonymous> (jquery.jeditable.min.js:17)
    at HTMLDivElement.dispatch (jquery.min.js?p9n09n:3)
    at HTMLDivElement.r.handle (jquery.min.js?p9n09n:3)

Is it possible to disable completely the inline editing for that profile form? Or perhaps for authenticated users? They can still edit the record by clicking on the edit button.

I am using CiviCRM 4.7.28 with Drupal 7.59.


texts: Remove User Login from Event registration

texts:
I am creating an event for my organization and its showing the enter a username
 as require. I want to remove this as this is a public event and it complecate things for people. I went and found where to go to allow anonymous user to register and did the anonymous role change on the dupral access but still Im getting the username thing.


texts: How does one flush the non-database cache (such as memcache) from CiviCRM code?

texts:
I've seen from a different question a suggestion to use CRM_Core_Invoke::rebuildMenuAndCaches() as the "granddaddy" of all cache flushing. However, I'd like to know if this is only clearing the cache in the database, such as civicrm_cache and so on or if it also clears non-database cache as well such as memcache.

As far as I can tell the above function calls CRM_Core_Config::cleanupCaches() which calls CRM_Core_Config::clearDBCache() and that function truncates various cache tables. Am I missing something? How do the other caching backends get flushed?


texts:
I have civicrm on a local server using Drupal7.
I have had the same issue with every recent upgrade.
The SysAdmin manual contains the following url to update the database following an upgrade:
http://example.org/civicrm/upgrade?reset=1

In my case I am using a local fileserver so this becomes:
http://myserver/drupal/civicrm/upgrade?reset=1
This has not worked for me on a number of upgrades which resulted in me finding a different method by mistake. (honesty).
The url I have now used successfully is :
http://myserver/drupal/index.php?q=civicrm/upgrade?reset=1

suggesting the following generic url
http://example.org/index.php?q=civicrm/upgrade?reset=1

So my question is whether there is an error in my original install which is causing the documented url not to work?


texts: Export activities and the activity target contact

texts:
I found an old thread on the forum site: -
 https://forum.civicrm.org/index.php?topic=20506.0

My question is still the same as DaveJ's actually. We want to export the activity target contact with the activity details.

By default, it is exporting the activity source contact


texts: What could stop a mailing from being sent?

texts:
When I submit a mailing (as administrator), it works correctly. When another user (WP editor) does it, the mailing didn't get sent. There was nothing unusual in the cron job log as far as I could see. I didn't find any special settings in the privileges list.

Where should I look?


texts: Prettifying forms - what is the best we can use as a theming for pure civi forms?

texts:
There's Shoreditch ext - bit seems it is only limited to backend admin UI?

Are there any other alternatives for contribution and event registration pages?


texts: Is it possible to make Case Resources a smart group?

texts:
I discovered via http://forum.civicrm.org/index.php/topic,35204 that the Case Resources available in CiviCase pull from the Case Resources group.  Is there any way to make it use a Smart Group?

If not, my best workaround idea is to create the Smart Group I want, then run a script daily to synchronize that Smart Group with the Case Resources static group.


texts: How to use existing scheduled email function programmatically in extensions?

texts: I need to send payment page links to user on schedule basis, is there any way to use existing  scheduled email functionality trough custom extension?


texts: Database error when saving CiviCRM event: “Row size too large”

texts:
I'm using CiviCRM in multilingual mode. I can generally create events (and other objects) fine. However, I often run into update problems at some point. The interface will "spin" and never save.

Looking at the CiviCRM error log reveals a database error:

nativecode=1118 ** Row size too large (> 8126)

I have looked at this clearly related case: Database error when using CiviCRM admin UI: "Row size too large"

I have tried (with some trepidation because I haven't worked on the Civi backend yet and don't know where the pitfalls are) to change the ROW_FORMAT of Civicrm_event_en_CA to Dynamic, but am told that it is not a base table.

I'm not really clear as I am more of a db user than a programmer, but assume that this table is somehow subsidiary to civicrm_event.

That table is set to ROW_TYPE=COMPACT. I'm game to change it, but it seems drastic enough that I am wondering:

Is it safe to do so WRT to CiviCRM operation?
Will it persist through a CiviCRM upgrade or will it revert (and potentially throw away data)?


texts: Cybersource setup for recurring payments

texts:
We've configured cybersource using omnipay and it works fine for one-time payments.

Is there any plans/alternative to make this payment processor work for recurring payments in civicrm?


texts: Custom Fields are not showing when trying to import a CSV

texts:
I have created some custom fields. I am trying to import contacts with values for those fields. But the fields are not showing up during the step 2 "matching civicrm field"  though other custom fields that I have created shows up, this one particular doesn't show up. I have allowed multiple records for this one custom field set alone. Is that because of this?

On further testing, when I disallowed multiple records for this set, it shows up in the matching options. Is this a bug?


texts:
I have an API call to get ACL roles that worked before I upgraded to 4.7.29 (I think I was at 4.7.22). Now, this returns no results:

    $entity_id = $group["id"];
    $apiParams = array("entity_id" => $entity_id
            , "entity_table" => "civicrm_group", "is_active" => 1);

    $entity_name = "Acl_Role";
    $result = civicrm_api3_get($entity_name, $apiParams);

I'm debugging now, but wondering if anyone can quickly tell me if something changed recently that I need to catch up on?


texts:
When creating a case, one of the fields is 'Detail'. It's a very useful description area for the case. However, can anyone point me to where it is then displayed or is editable? I can't find it on any reports or any screens. Could of course be an operator head-space error on my part.
Many thanks.


texts:
Having a very odd error with a CiviCRM install on wordpress. Every seems to be working (membership signup, looking up people, etc.) except running reports.

Click on report URL
View report options, then select "Refresh Results"
Page loads "No Results Found"

If I add &reset=1 to the end of the report, it works correctly

CiviCRM 5.15.0
Wordpress 5.2.2–en
PHP 7.2 on hosted service


texts: I've installed the group based pricing extension and enabled it, however I can't seem to get it to kick in. The two extra fields that are supposed to show don't appear. I'm using 4.7.7 and Drupal. Has anyone managed to get this extension to work?


texts: Fresh WP install succeeds then fails - path or permissions problem?

texts:
I've followed the install instructions on docs.civicrm.org site to make a fresh installation of CiviCRM in Wordpress on a local server (Synology NAS running Linux kernel).  All went fine, leading to message that CiviCRM was successfully installed but then screen refreshed to show this warning:

  Warning: include(/volume1/web/wp-content/uploads/civicrm/templates_c/en_US//%%E6/E65/E656EDCD%%wordpress.tpl.php): failed to open stream: No such file or directory in /volume1/web/wp-content/plugins/civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1270 Warning: include(): Failed opening '/volume1/web/wp-content/uploads/civicrm/templates_c/en_US//%%E6/E65/E656EDCD%%wordpress.tpl.php' for inclusion (include_path=

The CiviCRM admin page is blank except for this warning.  I notice that there is a double // in the path to the compile directory. Could that be a bug?

The path exists down to [..]/templates_c/en_US/ but there are no folders below that.  I have checked that /en_US/ has permissions 755.


texts: CiviEvent Dashboard not displaying all events

texts: Title pretty much sums it up - upgraded to CiviCRM 4.6.8 and now the Event Dashboard only shows one event, although I have two active. Changing the number of displayed events under Administer>CiviEvent makes no difference.


texts: Upgrading to 4.7.21 on Wordpress get uncaught exception on status page

texts:
After uploading the 4.7.21 plugin the CiviCRM admin pages loaded ok with the status at bottom indicating new version and of course with a red 'System Status' warning. On clicking this to get to the status page to update db etc, got this error:
Uncaught exception: You have requested a non-existent service "asset_builder".

Tried installing clean copy again. Same result. Resolved issue by manually entering the upgrade page url. This brought up expected option to upgrade db. All well after this.
https://xxx/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

Question: is this just our installation or have others had same behaviour, and did this fix resolve?


texts: Best way to manage common contacts between 2 CiviCRM databases?

texts:
The situation is that we have 2 separate non-profit sport organizations. Org A has 1000 paid members and 10000 contacts. They are just now starting the process to switch to CiviCRM as their membership is in a large spreadsheet. CiviMember will likely be a key tool of Org A. I am on the technical committee of Org A.

Org B is a completely separate non-profit created specifically for an annual event that Org A is sponsoring financially next year, and with volunteers from Org A's list of contacts. CiviEvent will be a key tool of Org B. I am the president of Org B.

Currently, Org B has no list of contacts list at all as it is new. We want to keep some organizational separation between A and B, since they are both separate legal entities, and also because in the future there may be little or no need to link them. They both currently have separate web sites, FB pages, etc and both Orgs will be using WordPress.

There are some commercial membership software that allow "sub-accounts", that is, a parent organization with sub-organizations. I do not believe this to be the case with CiviCRM, but correct me if I'm wrong. Also, I don't see any built-in way to "link" 2 CiviCRM instances unless one does custom development, again correct me if I'm wrong.

My question is, if Org A has their own CiviCRM and Org B has our own CiviCRM installation, would it be best to manage volunteers for Org B's event in Org A's CiviCRM, or just maintain separate CiviCRMs and export those volunteers over to Org B's?

(or is there another solution I'm missing?)

EDIT: after doing a bit more research, I did find some info on WordPress Multi-site, but since both Orgs are hosted with different web hosts I don't think that will work for us, again correct me if I'm wrong.

thanks


texts: How do I call an SMF function from CiviCRM?

texts: I want to write a postProcess hook to post submitted form info to a Simple Machines Forum.  How do I call SMF functions from Civi?


texts: We're trying to have the date-of-birth field for our contacts displayed in dd-mm-yyyy format when using mailings but despite me altering every single relevant setting in Civi...our test mailings still display the date of birth in yyyy-mm-dd format? Why might this be?


texts: Confusion between Contribution ID vs Invoice_ID in the database

texts:
CiviCRM 4.6 - Moneris payment processor -

CiviCRM's invoice uses the ID column to generate the Invoice number (INV_XXXXX) but creates its own hash and adds it to the invoice_id column - is there a way to reconcile the two? It seems CiviCRM uses the ID column to reference a contribution everywhere except in the invoice_id column after a successful transaction as been made.

We notice that when "Send Invoice Email" is used in the Contribution view, it changes the invoice_id column to the INV_xxxxx naming which has given our client major reconciliation headaches. Based on the database logging, the "Send Invoice Email" function sends an Insert request and updates the invoice_id field.

I tried searching the issues tracker, but couldn't find anything.

Before and after images included -


texts: Does CiviCRM supporting LDAP? Can we have a connection between LDAP and CiviCRM on a WordPress website?


texts:
We have been having issues trying to add a scheduled email reminder for members that have a membership expiring in two weeks. Every time we try - CiviCRM stalls and the logo simply spins.

Only error I can find is

send @ jquery.min.js?r=kX8Gx:4
/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2FscheduleReminders&action=add&snippet=json:1 Failed to load resource: the server responded with a status of 403 ()

also the warning:

send @ jquery.min.js?r=kX8Gx:4
/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2FscheduleReminders&action=add&snippet=json:1 Failed to load resource: the server responded with a status of 403 ()

I was not able to duplicate in the demo - any idea what is happening?

Latest wordpress and CiviCRM


texts:
Somebody already asked this on the old forums but there's no reply. I can see how to search for events by date then create an RSS or html version of the search results, but how do I display this in a Mailing? I'm sure it can't be that difficult but I've not managed to figure it out yet...

Thanks


texts: Civcrm Refund - why are amount and fin. type are based on (priceset) rather than line_item?

texts:
For non-'test'/Dummy refund (e.g. Authorize), the refund 'contribution' details for a 'contribution' consisting of 2 line_items (a price and a service fee) are getting assigned the same financial type and total amount (with sign reversed) instead of retaining the line_item values. For example, a refund for an event where the price-set includes an event_fee of $20 and service_fee of $2 should have -$20 for the event_fee and -$2 for the service_fee, and the financial-types not changed. In CRM/Contribute/BAO/Contribution.php, both the event_fee and service_fee amount is set to -$22 and service_fee financial type is changed to 'event_fee' type.
   I modified the code in (Civicrm 4.7.23) CRM/Contribute/BAO/Contribution.php.  Is there a reason NOT to do this?


texts: Is there a direct way to clean the Civi Cache?

texts:
Cleaning the civi cache updates the Smart Groups immediately (instead of waiting 5 minutes).

Is there a way to clean the civi cache directly (instead of Menu>Administer>SystemSettings>Cleanupcache&updatepaths>Cleanup Caches)

(I am not a programmer, but I may be able to include it in a small php program, if I am told how to do it).


texts: Multilingual instances show 'no such field' errors after update

texts:
I'm not sure if this is the forum where you want this issue raised, or whether Mattermost or a bug report is best, but here goes.  Please let me know if I should be raising this elsewhere.

A recurring error after updating a multilingual site is 'no such field' for a number of fields.  It is still occurring after the 5.2.2 update, in particular in the civicrm_uf_group view, where the following fields are missing:

frontend_title
submit_button_text
cancel_button_text

Having got a bit fed up with errors like this occurring every update, it seemed, I have investigated further to discover the following:

It seems that line 375 in CRM/Upgrade/Form.php
should read

CRM_Core_I18n_Schema::rebuildMultilingualSchema($this->locales, $rev, TRUE);
not
CRM_Core_I18n_Schema::rebuildMultilingualSchema($this->locales, $rev);

to tell the function that we are doing an upgrade.

When the schema structure is updated, a file of the form
SchemaStructure_x_y_z.php should be included in CRM/Core/18n, as SchemaStructure.php doesn't appear to be called during the update/upgrade process.  That file should contain the class 18n_SchemaStructure_x_y_z

The upgrade to 5.2.2 is giving 'no such field' errors because the latest schema structure file is Schematructure_4_7_alpha1.php, and so is the latest file to be called by the update process.

Is this a correct analysis, or have I misunderstood something?


texts: Does anyone know why I have two "Summary" tabs on each contact when I use a custom template?

texts:
I use a custom template for the "Summary" tab. In recent versions of CiviCRM, this has created two identical "Summary" tabs at the top of each contact. Both of these tabs work correctly and bring up identical fields from the custom template - see image.

Has anyone else had this happen with a custom template? It looks like a bug to raise.

I am using Drupal with CiviCRM 4.7.10