Hot answers tagged

14

We had one site that had 'lost' all it angular pages, eg CiviMail and System Status. In our case the angular cache files were returning 404 on the New Mailing page. (and 'inspector' was showing a lot of red angular errors) It was building the cache files in sites/default/files/civicrm/images, but then searching for them in sites/default/files/civicrm/...


8

I was able to solve this, at least for now, on my WordPress 4.8/Civi 4.7.22 site using this suggestion from Tim Otten: another work-around should be going to "Administer => System Settings => Debugging" and disabling the "Asset Cache" Of course in the long term we'd like to take advantage of the Asset Cache. But for now at least we have our angular-based ...


7

It depends on the upgrade i.e from 6.x to 7.x to 8.x. If its a simple and internal version i.e 7.12 to 7.29 than you can perform update directly and you won't have problem in CiviCRM but if its from 6 to 7/8 then you will need to replace the CiviCRM files with same version for D7 or D8 and then clear CiviCRM cache(probably delete template_c). Note: Backup ...


6

First of all, I should say that this is a job for someone who is reasonably technically minded and comfortable with using the command line. If this doesn't sound like you, then I would suggest that you look for help with this - perhaps from the person that installed CiviCRM in the first place. You can find detailed instructions in the Administrator Guide. ...


6

Best to review the tables which are largest in your DB, and also identify which queries during the upgrade take the longest. This is a chicken-and-egg problem, which means you might review the tables you "lighten" as you work through the upgrade process. Here's something I was using a few years ago on fairly heavy DB. This would exclude data in those tables ...


6

In the latest version, you can also rebuild the multilingual schema yourself by navigating to API Explorer http://www.site-name/civicrm/api#explorer Select Entity = System, Action = rebuildmultilingualschema and click on Execute button. If you aren't able to access the API explorer UI, try using the cv command from the terminal. cv api System....


5

If I understand correctly, you first installed 4.6.0 and then loaded a DB dump for 4.3.4 on top of the 4.6.0 system. Doing so would put the database in an inconsistent state — some elements from 4.6.0 (e.g. the table civicrm_mailing_abtest) are still present, but other elements are replaced by the 4.3.4 version (e.g. the table civicrm_domain). When ...


5

This thread helped me: How to find and/or fix missing indices? I've aggregated the SQL listed there below, copy it and run it via phpMyAdmin: ALTER TABLE civicrm_prevnext_cache DROP INDEX index_all; ALTER TABLE civicrm_option_value DROP FOREIGN KEY FK_civicrm_option_value_option_group_id; ALTER TABLE civicrm_option_value DROP INDEX ...


5

The equivalent would be any of these: Navigate to civicrm/admin/extensions/upgrade?reset=1 Navigate to "System Status" or "Manage Extensions". Those pages will link to the above. On CLI, run cv ext:upgrade-db (Download cv from https://github.com/civicrm/cv)


5

Apparently the people before me who was using the website had the files on another server and gave me a different server credentials. Thank you all who took the time to try and help I am sorry for the weird question.


5

This is a core bug and Eileen has send a PR for the fix. Will you be able to try by applying the patch from here? If the patch works for you than please comment your test result on PR so that it will speed up process of merging into core and having it available in next release. Cheers Pradeep


4

You could use the extension CiviRules to do that. You need to set up two different Rules, one for each process. Select a trigger and condition with your requirements (group contact is added, and contact is changed, would be the triggers I think) Dependent on your preference, you could create one of these actions: a scheduled activity assigned to a ...


4

Please follow the steps in the link one by one Link: https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Drupal+7#UpgradingCiviCRMforDrupal7-1.DownloadthemostrecentCiviCRMPackage I guess this helps !!!


4

You are correct that latest.civicrm.org/versions.json is the canonical source for CiviCRM version information. The file is quite new and the release-publishing script has not yet been updated to write to it (an issue has been filed for this), so at the moment it must be updated by hand. I agree that the file should be under version control. If anyone is ...


4

I feel your pain. There is no way to do it through the modules panel. However, I believe the instructions you are following are unnecessarily complex. What we do is back up, then delete the civicrm directory, upload the new version and then run the update script. We don't bother disabling and enabling extensions. We use maintenance mode if it's during ...


4

You can apply this PR - and reload System status page. This will let you know in advance which indices are already present in DB and would result in DB error on hitting Update Indices button. So what need to be done is - Apply this PR. Reload System status page. Some duplicate indices would be shown above Update Indices button including a message of what ...


4

I had a similar issue and posted here: https://github.com/veda-consulting/uk.co.vedaconsulting.gdpr/issues/50 I have not had a chance to see why the tokens were not working for me, but I can add them manually: https://example.org/wp-civicrm-basepage/?page=CiviCRM&q=civicrm/gdpr/comms-prefs/update&reset=1&{contact.checksum}&cid={contact....


4

Aivars, If the problem you facing is something related to report then i would suggest to fix the report rather wasting time exporting-importing data/structure from 2 different instances. The problem you facing has nothing to do with db structure. The error in report might be Any installed extension might be conflicting with report code, so you can probably ...


3

It sounds like you're using some very old-school approaches to system management. You can probably make your life easier by adopting some newer practices. Always run upgrades on a test server. I like to run it on my own laptop. You can use a virtual machine for that. Ideally, use a version control system like git, so you can push your upgrade from your ...


3

Try importing the "drop everything" file from the CiviCRM tarball in sql/civicrm_drop.mysql to remove all 4.6.0 tables from your new database. Then re-import your 4.3.4 database. Then try the upgrade.


3

Follow the instructions at http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Drupal+7. If you have questions about the documentation, please post a separate question back here.


3

The most reliable way to do this is to not import addresses that are known matches. I regularly use Pentaho Kettle to create import files for me. I'll separate addresses into their own CSV, then use Kettle to look up whether the address matches the contact's address in Civi. I'll filter out those that do, leaving only remaining addresses. However, Kettle ...


3

Currently updating contribution to add/update soft credits are not supported. I feel Updating soft credit was missed during initial implementation. We will need to submit a core fix to have it working for Contribution Batch update.


2

It seems to be an issue with running php bin/cli.php. Can you try using wp-cli instead? /path/to/wp --user=<cron> --url=<http://example.com> --path=</path/to/wp> civicrm api job.execute auth=0


2

I noticed on all my sites that I upgraded, it also initially had an error that cron was not running. But after the first automatic cron run triggered by my host cron job, this went away.


2

afaik there is nothing in civicrm that delivers quite what you ask. The closest 'in the box' is probably the 'contact dashboard' which does let Primary Contact edit the Organisation record, and if you "allow second degree relationship permissions" here the if Primary Contact has permission over the ORganisation and the Organisation has permissioned ...


2

I looks like CRM-18567 and CRM-18504 Have a look at Chris Burgess comment, there are couple of commits that seem to fix the issue. https://github.com/fuzionnz/civicrm-core/commit/a0bcc16171d2f30c4416aeec079bab56c313390a https://github.com/fuzionnz/civicrm-core/commit/d3e9ab21a0f2256197125854fe6312c3fa0c8c8a I would recommend to create a backup or ...


2

You haven't given enough detail in your question but I will have a go at answering what I think is your question. You say "Now i have updated membership type to 1 year expiration". I am taking that at face value, ie your membership type called "our membership" did have a duration of 2 years but has been updated so that it now has a duration of 1 year. (If ...


2

You may have to amend the 'end dates' that are on those old style memberships either via SQL manually in the DB via a Batch Update of Memberships export Membership data and reimport it (as per JoAnne's answer - added here to include in this list) Which option suits you may depend on your skills and the number of memberships involved.


2

This is a very small bug, but to fix easily, here's my above comment again. This problem is also true for Drupal on a couple of 4.6.9 test systems of mine. I fixed by using the navigation menu update in administer/customise data and screens. I deleted the second Support item and all was well.


Only top voted, non community-wiki answers of a minimum length are eligible