Author Topic: Multilingual database health check? (Read 1409 times)

lolas · May 07, 2013, 08:10:48 am

Hello Everyone

We are assisting someone who may have added the multilingual feature to the database without the proper MySQL permissions in place and then run it for some time, eg. adding data and so on. It is not really possible to just roll them back to a backup at this point.

Is there a procedure we can run to check for missing views, triggers etc.? Of course we can do a schema compare with an empty multilingual install - but is there anything quicker?

Is there any suggested procedure to reload a clean multilingual install along the same lines as there is a suggested procedure for cleaning up the general schema?
Wiki page for the general schema: http://wiki.civicrm.org/confluence/display/CRMDOC43/Ensuring+Schema+Integrity+on+Upgrades.

Donald Lobo · May 07, 2013, 04:50:22 pm

hey lola:

1. There is an option to rebuild all triggers (either via drush or the UI)

2. There is no option to rebuild all views, but i did a quick check of the code and seems like it should be fairly easy to add this

3. There is no option to check and alter multi-lingual table structure to match the current config. This also seems quite doable based on current code structure

If you want to work on it, ping me on IRC and i can help get started. Most/All of the code and helper functions are here: CRM/Core/I18n/Schema.php

lobo

lolas · May 09, 2013, 08:28:58 am

Hi Lobo,

Thanks for your helpful reply. It is great to hear that someone has started making this process easy and fast. I may be able to take a look at the views part of it later in the week. Not sure how far I can get.

CiviCRM Community Forums (archive)

News:

Author Topic: Multilingual database health check? (Read 1409 times)

lolas

Multilingual database health check?

Donald Lobo

Re: Multilingual database health check?

lolas

Re: Multilingual database health check?