Questions tagged [database]

The tag has no usage guidance.

35 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
114 views

SOLVED!! DB Error: no such table ERROR searching erroneous ACL table

I have read other related questions but I do not see a match with my mistake. Civicrm version 4.7.31 Drupal 7.67 MySQL 5.6.42 PHP7.1 After migrating from civicrm 4.5.8 and php5.6 everything works fine ...
3
votes
0answers
43 views

Fix for column names breaking the 64-character limit

I'm trying to generate a report using custom fields and I am getting nativecode=1166 ** Incorrect column name This happens when the report is trying to generate temp tables using an alias as the ...
2
votes
1answer
21 views

When exporting data from CheckBox field, can value of be different from what is displayed?

When exporting data from a custom CheckBox field, can the value of the data exported be different from what is displayed? For example, the checkbox Multiple choice is labeled "Asked" but I would ...
2
votes
0answers
27 views

How to loop and update BAO objects

I was trying to be down with the cool kids and use DB_Object models for a looped database update. I've found somethning I thought should work, but doesn't so I must be doing/understanding something ...
2
votes
1answer
78 views

CiviCRM database issue with views and the definer

We have a website using CiviCRM that was recently switched from Drupal to WordPress as well as to a new server. Everything on the website is working properly and they have had no issues with CiviCRM. ...
2
votes
2answers
62 views

I get a WSOD when I use the search function on CiviCRM

CiviCRM was working fine until I downloaded an extension called CiviRules. I looked into the API for field UFMatch, clicked around in there, and pressed execute (got no warning that it was going to ...
2
votes
0answers
39 views

Multilingual and multidomain: “unknown column” DB error. How to set preferred language for child domains?

I am running CiviCRM v.5.4.0 in a WordPress (v.4.9.9) multisite. The WordPress main site is CiviCRM Domain_ID 1, and each WordPress child site has a different CiviCRM Domain_ID. This has been working ...
2
votes
0answers
120 views

DB Error after upgrading 4.7.x to 5.1 (Drupal)

After upgrading CiviCRM from v4.7.14 to 5.1 (or v4.7.31) which went seemingly well, CiviCRM encounters the following problem. UPDATE: Issue does not appear until 4.7.29 (including), and comes up only ...
2
votes
0answers
45 views

CiviMail cannot create ACL recipient table after upgrading to CiviCRM 4.7.31

After upgrading to CiviCRM 4.7.31 I began to get several errors while initially trying to send a test e-mail using an ACL-based user. I noticed that these errors were not happening with the ...
2
votes
0answers
28 views

Update Canadian (or Australian) currency $ display

CiviCRM simply shows a $ to represent either Can$ (or australian dollars). This can become confusing when $ currencies mix. It keeps these symbols in the database. I suspect I can do something like ...
2
votes
0answers
27 views

Bug in Custom Searches - Date Added to CiviCRM

I'm fairly new to CiviCRM but have successfully imported over 3,100 contacts from our current PC based DB system. If an error occurs during the my imports I have found the Custom Search 'Date Added to ...
1
vote
1answer
48 views

CiviCRM_API3_Exception

When I enable or disable an extension I get the error that follows. Enabling or disabling still happens. Advice on resolving this would be gratefully received. This site is running 5.21.2 on Joomla. &...
1
vote
0answers
16 views

Field size job.run_frequency

Is it possible to make the size of the field run_frequency in the table job greater? It is now 8, but if would be 10 then the translation for 'daily' will not be truncated (not for me in this case).
1
vote
0answers
41 views

Trigger Rebuild Is Not Working

I am getting this error " [nativecode=1442 ** Can't update table 'civicrm_contact' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.]" ...
1
vote
0answers
19 views

How to fix transaction mistakes in CiviEvent & CiviContribute

In CiviEvent, had a user that mistook chargeback for refund then using the Line Item Edit extension made more mistakes. The result is that for one event payee shows $500 refund more than correct. Upon ...
1
vote
0answers
25 views

Wordpress Civicrm_acl_contact_cache Table got Deleted

I am using CiviCRM wordpress version 5.12.3 - For some reason Civicrm_acl_contact_cache table got deleted I am sure no one has Database access (apart from me). But still the table got deleted. Also, ...
1
vote
2answers
120 views

Your database settings don't appear to be correct. All green, but still error!

trying to install CiviCRM with Wordpress and I get the red DB error BUT all the line items are green. Any suggestions? Thanks! WP: 4.9.10 CiviCRM: 4.7.30 Wordpress Mysql: 5.7 on Azure Added ...
1
vote
1answer
63 views

Wordpress CiviCRM site unusable after database upgrade from 5.4.0 to 5.5.1

I'm relatively new to CiviCRM and am trying to get a client set up with the platform. I like it overall, it seems much more usable than most I've touched in the past. All seemed to be going well ...
1
vote
1answer
91 views

Civicrm local db error

My Specs I migrated a production Drupal 7/Civicrm 7.x-4.7.9 site to my local machine. For my stack, I am running MAMP and PHP 5.6.32, the production server is on PHP 5.6.33 I downloaded all files,...
1
vote
0answers
48 views

Update Indices fails with errno 150 on DROP INDEX UI_case_contact_id after upgrade from 4.6 to 4.7.27

Upgraded from 4.6.19 to 4.7.27 (on wordpress 4.8.3) and attempted to update indices. The table that fails is civicrm_case_contact, with the old index UI_case_contact_id. The error is identical to ...
1
vote
0answers
15 views

CiviCRM won't store Outbound email settings

I've just updated to 4.7.24. When I try to save Outbound email settings, I get an error with this backtrace: #0 /srv/website.com/public/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php(187): ...
1
vote
0answers
114 views

CiviCRM 4.7 with WordPress 4.8 : DB Constraint Violation - contact_id should possibly be marked as mandatory for DashboardContact,create API

This is on a completely fresh install of CiviCRM. I tried running the upgrade, but the message said I was already upgraded to the latest. Any idea how to fix this?
1
vote
0answers
69 views

Database upgrade error - 4.7.13

The process to upgrade my civiCRM database from 4.7.11 to 4.7.13 terminated with the following error: [Error: Upgrade DB to 4.7.13: SQL] Error Field Error Value Type DB_Error Code -19 Message ...
1
vote
0answers
143 views

How to connect with state and country table

We are using CiviCRM (4.7.9) with WordPress (4.5.3). We are pulling the data from the CiviCRM state and country tables into Gravity Forms using code in our function.php. But we are running into ...
1
vote
0answers
26 views

Saving in any frame just churns

Every time I save in a frame I get the following error. Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame\n\n thrown in /var/www/html/sites/all/modules/...
1
vote
0answers
51 views

Export Fails when Merge Households Option Used

I get a DB Error when exporting contact search results using the "Merge Household Members into their Households" option (image below). Only this merge option causes the error. The others do not. I ...
0
votes
0answers
22 views

Reinstall Summary Fields Not Creating Triggers

I have uninstalled and reinstalled Summary Fields a couple of times trying to get the triggers to show up on the admin screen as having been recreated. I started looking into this because we have a ...
0
votes
0answers
12 views

How to troubleshoot DB Error: no database selected

I'm upgrading to Drupal 8. My database logins in civicrm.settings.php are correct but I continue to get this error. I'm just trying to load the dashboard at /civicrm. Is there a way to produce more ...
0
votes
0answers
12 views

CIVIRM CV TOOL 0.3.2 trying to upgrade dbase 4.6.10 to 5.25 (or at least 4.7.13)

So i have a clean joomla 3.9 install and 5.25 codebase installed, I put the 4.6.10 database on there and ran the cv tool: cv:upgrade db –test It showed codebase 5.25 and database verison 4.6.10 so ...
0
votes
0answers
15 views

civicrm_contact_push_notification_messages table huge

We installed Civimobile as a test, and aren't yet using it. It does look great! We have noticed a file on our server of gigantic proportions: civicrm/civicrm_contact_push_notification_messages.ibd: ...
0
votes
0answers
14 views

Import Contacts to CiviCRM using SQL query

How to import contacts to CiviCRM using SQL query? It should include the Group name too. I have a huge database need to import in CiviCRM, currently getting timeout error if I upload more than 1000 ...
0
votes
1answer
23 views

I get an error “One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias” when trying to access most of my data

Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it. I installed on WordPress last year, and everything generally went ...
0
votes
1answer
42 views

CiviEvent Listing module in Joomla not finding database table

We are working on a long-needed update of our website. I thought I would take the opportunity to also follow what many say is best practice and move our Civi db out of a db shared with our Joomla CMS. ...
0
votes
0answers
33 views

Unknown column civicrm_relationship.is_active while child smart group edit (create temporary table fails)

There are a parent Smart Group which contains several "child" Smart Groups. All was working a while, until at some time point it starts throw an error, something like [debug_info] => CREATE ...
-1
votes
1answer
28 views

duplicate database in civiCRM

Is it possible to duplicate the data base on Civi ? (contacts) Because i need to do it for my traineeship.I don't even know if it's possible but maybe does an alternativ way to do it. thanks and have ...