Questions tagged [database]

The tag has no usage guidance.

29 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
65 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
39 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
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
66 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
59 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
31 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
119 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
35 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
32 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
23 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
104 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
57 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
80 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
104 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
1answer
36 views

Using Views with two sql servers

I am trying to set up Views on my CiviCRM 4.7.10 (Drupal 7.42). My Drupal database is on one SQL server. And my CiviCRM database is on another SQL server. Whenever I try to create a new view, I ...
1
vote
0answers
140 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
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
32 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
27 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 ...