We’re rewarding the question askers & reputations are being recalculated! Read more.
5

I had the same problem today, so I looked in the source code. In civicrm.install there's a function called _civicrm_get_db_config. It's looking in the $databases array for an element with a key civicrm. So I added this to settings.php: $databases['civicrm']['default'] = array ( 'database' => 'civi_db_name', 'username' => 'mysqluser', '...


5

Your DB connection specifies mysql://, and you are using PHP7.2. The MySQL extension was deprecated in PHP 5.5 and removed in PHP 7.0. Try switching the two DB connect strings in civicrm.settings.php to use mysqli:// instead of mysql:// and see if that resolves the issue. I would also remove any other changes (eg the addition of port :3306), to eliminate ...


5

That's really two operations: splitting the combined db to separate WP and Civi ones, and migrating. For the migration part see the manual. To split the db, you could make a duplicate of the original as the Civi db (dump and load), then in the Civi one delete all the non-civi tables and in the original/WP one, delete all the civi tables. In your civicrm....


5

You could do something like CRM_Core_DAO::executeQuery("SELECT LAST_INSERT_ID()");. If your needs are simple that seems like the easiest. Probably to do it "right", you would use civix generate:entity. See https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-entity Then you could do things in an object-y way, like: $myclass = new MyClass(); $...


4

One small gotcha with large deletions: MySQL may not free-up the space in the way you expect. The exact mechanics and numbers probably depend on the variant of MySQL and its configuration options, but just for a general sense: if the goal is to reduce the disk-usage of those tables on the active system by 75% (8gb to 2gb), then you might try to DELETE the ...


4

we have a custom overnight routine that copies data from civicrm_mailing_x and civicrm_mailing_event_x tables to duplicate tables with a archive namespace and then deletes the appropriate rows from the main tables. The biggest things is making sure that you adequately understand the relationships between the tables so you don't accidentally delete data that ...


4

The payment method of a contribution table is stored on the civicrm_financial_trxn table. Payments and Contributions are related through civicrm_entity_financial_trxn table. Some discussions about similar issues have recently taken place on financial issue board. Please consider whether you can make a contribution on any of them or if you need to report a ...


3

I've had an excellent experience using this extension: https://github.com/jitendrapurohit/nz.co.fuzion.deleteoldbulkmailings I needed a few small fixes for my purposes (include a limit parameter and removal of code that assumed extended logging is on), which you can see in my fork here: https://github.com/adixon/nz.co.fuzion.deleteoldbulkmailings As I ...


3

This is so that you can temporarily or permanently remove a campaign from being selected. If you have say 30 campaigns and 20 of them are completed, you don't really want them cluttering up the drop down lists when you create events etc. You only want the active campaigns.


3

Am I allowed to answer my own question? lol. I was able to resolve the DB error for this specific smart group by changing the Operator criteria from "Empty" to "Null". So "IS EMPTY" became "IS NULL" and "NOT EMPTY" became "NOT NULL". Also, I find it somewhat important to note now that whenever I attempted to edit this Smart Group's search criteria, I ...


3

There are no database changes between the 5.10 versions so you can switch the code back & forth without issue - however you will lose the security patches, making your site vulnerable - which is not great since the SAs have been published - it might be you do that temporarily but prioritise getting the extension fixed. If you tighten the permission on ...


3

As established from the comments on your original question, this appears to have been a corrupted MySQL table. CiviCRM was reporting in the backtrace that a core table did not exist: TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'example.civicrm_acl_contact_cache' doesn't exist in engine] You used MySQL to inspect the DB using SHOW ...


3

You can find the list of required permissions here: https://docs.civicrm.org/sysadmin/en/latest/requirements/#mysql-permissions You might want to check out some of the options for hosting here https://civicrm.org/partners-contributors?country_1=All&services=Hosting&language=All&cms=All


3

Also see https://civicrm.stackexchange.com/a/31644/225 where the suggested fix is: ALTER TABLE civicrm_menu ROW_FORMAT=DYNAMIC Then rebuild the menus


2

You can use the data processor extension (https://lab.civicrm.org/extensions/dataprocessor) for that. The data processor is an extension for CiviCRM which gets data from CiviCRM and exposes this to the API (it is possible to add your own outputs, e.g, csv file, page etc..) At the Drupal side you need the CiviMRF Core Module (https://github.com/CiviMRF/...


2

Yes, you can change the engine but they are temporary tables so will disappear soon - and more will appear. It is a warning rather than an error. The data integrity message is intended to relate to the permanent tables, not these temporary ones. Since your permanent tables show as InnoDB you can safely ignore this message. I've logged this here: https://...


2

This pull request seems relevant to the database error you encountered: (dev/core#660) Address regression whereby Anonymous users can no longer register for an event if they have ACLs to see a contact. This fixes an issue that was I believe introduced in Civi 5.9.0 and fixed in 5.9.1 . See also related issue Fatal DB Error: already exists on event ...


2

I could solve the problem... I had disabled the Mail module of CiviCRM as I do yet not use it. After reenabling it, the error was gone. Looks like that even disabled modules leave remnants in the database causing possible trouble.


2

Good question. There's some discussion here about utf8mb4_unicode_520_ci or utf8mb4_0900_ai_ci, but there's maybe some issues with that since at the moment in the associated changes it seems to be staying at utf8_unicode_ci. But it might change. But the warning might be due to your global settings. In order to support this you need barracuda format ...


2

It depends what you mean by "all records", but the custom search called full-text search (under Search - Custom Searches) can be made to run via url like so: https://dmaster.demo.civicrm.org/civicrm/contact/search/custom?csid=15&text=894-1515&table=Contact&force=1&reset=1 That will bring up the contact with phone 894-1515. If you want to ...


2

I began to import the database in pieces to a new installation to see if I could pinpoint where the issue might be coming up in the database. I found that the problem was with the civicm_setting table. There was a row added for address formatting that had the weird characters in it. I deleted the row and the problem disappeared.


1

Suggestions from various folks on chat include the following settings in my.cnf: innodb_log_file_size (may be too small by default) innodb_large_prefix=true innodb_file_format=barracuda I changed those and was still having issues. This setting fixed it for me (and may be due to the site running on MariaDB?). innodb_strict_mode=0


1

I think you are saying that you have a single database for CMS content on the old site and that you already have new CMS content in the database for the new site. I think you want to move the CiviCRM structure and data. If I have understood that correctly (it would be good if you clarified by editing the question) then you can do the following. 1) split the ...


1

Thanks to comments by Demerit, my confusion arises from the fact that our MySQL server and web server (with core CiviCRM files) are separate. The 173.236.128.0/255.255.128.0 mask matches our web server and so that definer field in the trigger just indicates the server from which the triggerRebuild command was executed. There was nothing wrong with our ...


1

After a lot of digging, I realised what was happening. For some reason, there was a second civicrm_saved_search table in the database named civicrm_saved_search-b . That hyphen - is an 'illegal' character unless you escape it. To resolve the issue, all I did was change the - to a _ which cleared everything up and enabled me to upgrade my site within ...


1

It was my table and column collation settings. Both were latin1_swedish_ci. Evidently this collation does not support the weirdo characters those foreigners use ;^). I rolled the database back using the backup I made (ALWAYS glad I make a backup before upgrading!!!). Then using phpMyAdmin I edited the table civicrm_state_province to have a collation of ...


1

To add to the answer above you could consider deleting browsing history when the browser is closed. This would effect all sites however many businesses use this method, really depends on your use case and how far you want to go.


1

The server doesn't know that you closed your browser, so it considers that you are still looking at the last page; for a very long time. The vast majority of users doesn't log out to explicitly inform the server they are out.Your drupal/webserver is going to discard stalled sessions when they stay inactive for too long, so it doesn't have an impact to ...


1

For some reason, I didn't receive a notification on the ldap github repo, thanks to raise it here! I answered on the issue in github, let's follow there? I never tried civildap on wordpress, I don't know if it's why it has some issue. To exclude some potential sources of the problem, could you change your config file and put: settings.civicrm.action = "...


1

I managed to resolve this dilemma. The goal was to move a 2 database Drupal/CiviCRM website into the CiviCRM Starterkit platform which requires that Drupal and CiviCRM use a single database. I was not able to import my database dump into the existing Drupal website because although I had set foreign_key check to zero, I was receiving a "Cannot add foreign ...


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