13
votes
Accepted
MyISAM database but all civicrm_ tables are INNODB... is this a problem?
I backed the database up, opened it up in Sequel Pro and went to the civicrm_system_log table. Under "Table Info" I could select "InnoDB" from the dropdown. Then I cleared the caches on the CiviCRM ...
- 8,231
8
votes
Accepted
Error during Drupal installation: MySQL support not included in PHP
Recommend setting MAMP to use PHP5.6 if you have that option.
The screenshots show MAMP is set to use PHP7, but CiviCRM isn't ready for PHP7 yet.
(PHP7 removes ext/mysql in favour of ext/mysqli and ...
- 9,872
7
votes
MyISAM database but all civicrm_ tables are INNODB... is this a problem?
Sounds good. To be sure, please execute ///civicrm/menu/rebuild?reset=1&triggerRebuild=1 which fixes the trigger and function definitions in the database.
- 3,544
7
votes
ER diagram for the latest Civicrm , Foreign key in Structure, test cases/plans
I will answer your questions #1 and #2. (I'm not sure what you mean by #3. If #3 is sufficiently unrelated to #1 and #2, I would suggest creating a separate question for it)
Why an ER (Entity ...
- 3,158
7
votes
When will MySQL utf8mb4 support be mandatory?
It seems like it's still under discussion as of last week. See e.g. https://lab.civicrm.org/dev/core/issues/979
- 21.4k
6
votes
timestamp mismatch
It turns out that if you are using Wordpress you need to set the timezone to specific location, e.g. London, rather than using the default UTC offset. When I used the London timezone the problem went ...
- 417
5
votes
Civi Database erased when upgrading from 4.6.3 to 4.6.4
Two issues. 1. Database is getting reset when you upgrade 2. you cannot restore from backup.
Answer to #1 is this: Make sure you are following the upgrade procedure on
this page: http://wiki....
- 879
5
votes
Need help solving unserialize():Error at offset
This line reads the data from the table civicrm_setting and specifically the column value. You could use a SQL client to run the query:
SELECT id, name, value FROM civicrm_setting;
Typical values ...
- 5,619
5
votes
Update DB Query fails sporadically when saving contact; nativecode=1205 ** Lock wait timeout exceeded
We have seen this on large instances. Things to do:
upgrade to 5.13.5 (this also puts you close to the next ESR - a paid for service - which will be released on Nov20).
There have been performance ...
- 15.1k
5
votes
Possible Bug? Foreign key constraint error on upgrade to 5.31.0 (populating civicrm_relationship_cache)
Further to Pradeep Nayak's reply, the ultimate cause of the problems I was having were missing foreign key constraints on the civicrm_relationship table leaving orphaned data when contacts were ...
- 403
4
votes
I need to migrate data from one CiviCRM on Drupal instance to a clean one. HELP?
Before pronouncing the old database deceased, I would make sure the structure is correct and if not what is broken. You can try this: https://github.com/progressivetech/civi-schema-harmonizer or http:...
- 1,642
4
votes
INSTALLER fails. Database can't "SELECT GET_LOCK" at civicrm/install/index.php(271)
Here's a patch that seems to address the issue, although there could still be compatibility issues in the PEAR mysql and mysqli library versions used by CiviCRM.
This patch is for CiviCRM 4.7.4:
...
- 51
4
votes
Accepted
non-asci characters ending up in database
CiviCRM historically uses the CRM_Core_DAO::VALUE_SEPARATOR character as a serialization technique for storing multiple values in a field. Best practice is use the API for accessing values, or if you ...
- 21.4k
4
votes
Accepted
ER diagram for the latest Civicrm , Foreign key in Structure, test cases/plans
2) You can use a tool like SchemaSpy to extract the structure of the database, have the foreign key displayed in a table or on a schema and navigate easily between related tables.
You can see an ...
- 2,321
4
votes
Accepted
What character is VALUE_SEPARATOR?
In fact, if you use HEX() function, you can guess it's the ASCII code 01 which is not really readable :
MySQL> SELECT substring(besoins_sp__114, 1,1)
FROM ...
- 2,321
4
votes
My hosting company does not support SUPER privilege - can I use CiviCRM with them?
There are only two scenarios in which CiviCRM requires the SUPER privilege:
You're using a very old version of MySQL. Versions of MySQL 5.1.6 and higher support the TRIGGER permission. Before that, ...
- 38.4k
4
votes
Accepted
SQL Syntax Error - When starting civicrm with joomla
it seems php 7.2 is not compatible with 5.x.x
or i do not know how to do the configuration
i think downgrade the php would be the best solution
but i wonder if there is other answer, and how to do it....
- 349
4
votes
Update DB Query fails sporadically when saving contact; nativecode=1205 ** Lock wait timeout exceeded
Karin's answer is a good one. However, not all smart groups are created equal! Culling the right smart groups is what will fix your deadlocks.
Identify your slow smart groups. Here's a script (...
- 38.4k
4
votes
Accepted
Possible Bug? Foreign key constraint error on upgrade to 5.31.0 (populating civicrm_relationship_cache)
Your system have orphan data in civicrm_relationship table. There are few rows in civicrm_relationship table that have contact id in column civicrm_relationship.contact_id_a or ...
4
votes
Accepted
One database table very large
Thats from Civimobile extension and You can find quick solution at https://lab.civicrm.org/extensions/civimobileapi/-/issues/57#note_54817
One thing I have found is editing the scheduled job ...
3
votes
MyISAM database but all civicrm_ tables are INNODB... is this a problem?
Single command to update all tables is:
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=InnoDB;')
FROM information_schema.TABLES WHERE ENGINE = 'MyISAM';
- 83
3
votes
Accepted
INSTALLER fails. Database can't "SELECT GET_LOCK" at civicrm/install/index.php(271)
Another solution is to upgrade at least to CiviCRM 4.6.16 or to CiviCRM 4.7.7 or you can also patch your installation.
If you are familair with patches you can also download a patch from the civi ...
- 3,645
3
votes
I need to migrate data from one CiviCRM on Drupal instance to a clean one. HELP?
If you wish to transfer the content of the database
a) export the existing data. You can do this as an action from the search/find screens. Export contacts, activities, memberships, contributions as ...
- 823
3
votes
is there an easy local install method for civics and all dependent software
Two options:
a. Use the bitnami package: https://bitnami.com/stack/civicrm
b. Use a CiviCRM hosting provider: https://civicrm.org/providers/hosting
- 3,803
3
votes
CiviMail recipient count stuck on Estimating
I was able to 'fix' the issue by simply deleting all the groups (I didn't have any previous mailings in here) from the Recipients field and then re-adding them. Make no other edits before the ...
- 388
3
votes
Multiple Entry Custom Values : Find modified ID?
Don't know if this will help, but at least you can try it. :)
The custom() hook is called after the db write on a custom table, so when the field is writen, you can't know which was the change, so ...
- 472
3
votes
Accepted
Funky errors in 'drush cvup' / 'drush cvupdb'
I ran into a similar problem when manually updating. Depending on how your database is configured the update will fail when trying to change the image_URL from VARCHAR(256) to VARCHAR(512). I wasn't ...
- 1,146
3
votes
"alter routine command denied to user" error when installing extensions?
The user does not have the permissions to alter and create routines (functions). This should fix it:
GRANT CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO civicrm;
- 1,247
3
votes
Accepted
Should I change mysql.connect_timeout variable in php.ini?
I have definitely altered this variable for upgrades, but my notes show I only increased the values to 1800.
I don't recall whether this was because I found that -1 didn't work, or because I ...
- 9,872
3
votes
SQL to unlink contacts and drupal accounts
The table you are looking for is civicrm_uf_match with the following structure
CREATE TABLE `civicrm_uf_match` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'System generated ID.',
`...
- 3,183
Only top scored, non community-wiki answers of a minimum length are eligible