6

It sounds like you imported the first_name and last_name values - but the value at the top of the record is the display_name. You have two options: Use your SQL script to update the display_name accordingly. Export ONLY the contact_id of the affected records (or all records). Reimport the contact ID via the "Import Contacts" functionality. All records ...


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

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

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

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

CiviCRM is open source software so there isn't so much a 'company' to go to for help as a 'community'. Within that community there are Partners who can provide professional support but they and many other users also provide a lot of free help through StackExchange (SE) and via chat.civicrm.org. If it would help, we could have a quick skype call (~20 mins) ...


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 ...


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

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 ...


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

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

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

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

It's really bad idea to customize CiviCRM core files when you can do thing using extensions. If you feel your customization fixes core issues than you should try to submit pull request against civicrm-core. If your changes are client specific than you can either move those files into custom php or custom template(again bad idea since its very difficult to ...


3

You could also have a look at the User Guide to find out what CiviCRM can do. You can find the User Guide here: https://docs.civicrm.org/user/en/latest/ Also, it helps if you understand the CiviCRM is supported by a community. Almost all the people answering questions here do so in their own time without getting paid. They will do their best to help you. 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 ...


2

welcome to StackExchange. This forum is used typically for questions about using, administering, extending, and troubleshooting CiviCRM. That's not to say if you search the forum there haven't been questions asked and answered about what CiviCRM can do - but they are usually a little more narrow in scope. For information on the features of CiviCRM, I'd ...


2

The difference in counts might be explained by the fact that at one time Find Activities only returned results where the With Contact field wasn't empty, and a quick check on the public demo suggests that's still true. That also seems true for Advanced Search. You can also try Search Builder, but the list of fields is minimal. If you're using Drupal, you ...


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

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

Maybe you do not have ssh access and MySQL access. But this can also done from the user interface. To rebuild the triggers use the url: http://<<servername>/civicrm/menu/rebuild?reset=1&triggerRebuild=1 (This is documented in the system admin manual.) Recreating the Case Views can be done by disabling the case module and enabling it again (...


2

Ahh did you upgraded to unstable version of CiviCRM? The last stable release i see is 5.4.1. Try replacing the civicrm code base to 5.4.1 and then update the civicrm_domain.version to 5.4.1 and also truncate all cache tables and anything under template_c folder.


2

It's strongly recommended NOT to delete data directly via SQL. I don't think it's possible to say which tables you need to delete from - there are hundreds of tables, not including those added by extensions, and it's impossible for us to know which are in use for you. Instead, consider the suggestions by Jitendra and Aidan above - the issue is that the ...


2

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 ...


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

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


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 ...


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