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
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 ...
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.
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 ...
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
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 ...
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
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 ...
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 ...
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:
...
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 ...
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 ...
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 ...
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, ...
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....
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 (...
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
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 ...
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 ...
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';
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
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;
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 ...
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
votes
Accepted
How to check if DB table exists?
There is a specific CiviCRM function (but all the ways in the other answers will be just as good :-)):
CRM_Core_DAO::checkTableExists($tableName)
This function will return TRUE or FALSE.
3
votes
Drupal - MySQL support not included in PHP
CiviCRM is looking for the function mysqli_connect(), which is provided via the mysqli ("MySQL improved") extension in PHP.
To enable this, uncomment -
extension=mysqli.so
If that doesn't work, ...
3
votes
What is required to run CiviCRM on Amazon RDS?
We haven't tried running CiviCRM on RDS yet but we have been shifting a Drupal installation across to AWS. A few things we've noted so far that are relevant:
It helps if the RDS instance is in the ...
3
votes
Using an External (custom) Table in a Custom Report
Check out an example here - this is a report that joins tables the extension creates/maintains with other civicrm core tables to produce this report:
https://github.com/jake-mw/CDNTaxReceipts/blob/...
3
votes
My hosting company does not support SUPER privilege - can I use CiviCRM with them?
You will either need to get a hosting plan that allows root access and "binary logging" or pay your host to install it. I recommend the former. In my experience, managed types of hosting don't tend to ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
mysql × 195database × 37
drupal × 28
wordpress × 22
error × 18
php × 18
installation × 17
custom-fields × 11
upgrade × 10
performance × 9
joomla × 8
sql × 8
developer × 7
timezone × 7
civimail × 6
contacts × 6
civireport × 6
logs × 6
migration × 5
mariadb × 5
extension × 4
issues × 4
core × 4
drush × 4
db-logging × 4