CiviCRM Community Forums (archive)

On a civicrm 4.1.3 instance, I encounter the same issue -- here's my dump from PEAR.php

DB_Error Object SELECT * FROM civicrm_contact_type_ru_RU WHERE ( civicrm_contact_type_ru_RU.name = 'Individual' ) nativecode=1356 View 'civicrm_contact_type_ru_RU' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

after a mysql import, it appears that some privileges or views are invalid, I'm going to troubleshoot and post back my results, as this is a persistant and reproducible problem, which has kept me from deploying using db dumps -- I've had to invoke API for setting / changing most of the system-specific requirements instead of merely deploying a db from staging to production.

My fix was granting all on the tables to the db user again, and it seems to work now.

I'm having a similar issue here :
- I need to set up a dev instance of our server
- I migrated the codebase and DB, emptied the cached files and cache tables, as well as the domain table
- It's a multilingual instance
- I get PEAR out of memory errors when trying to reach the civicrm part

I also had permissions problems on views due to the initiator not having the same name, which were solved by a grant all privileges and refresh (not much of an issue on a dev server, but would be a problem for a production machine however.)

yet, the memory errors remained.

I then added this line
die (sprintf(PEAR_Error::toString ()));in /sites/all/modules/civicrm/packages/PEAR.php in the function that was failing and got this :

[db_error: message="DB Error: no such field"
code=-19
mode=callback
callback=CRM_Core_Error::handle prefix=""
info=" SELECT option_value.id as id, option_value.label as label, option_value.value as value, option_value.name as name, option_value.description as description, option_value.weight as weight, option_value.is_active as is_active, option_value.is_default as is_default FROM civicrm_option_value as option_value, civicrm_option_group as option_group WHERE option_group.id = option_value.option_group_id AND option_value.is_active = 1 AND option_group.name = 'languages' ORDER BY weight
[nativecode=1054 ** Unknown column 'option_value.label' in 'field list']"]

So if I read this correctly, it's looking for 'label' in the option_value table.
I have label_fr_FR, label_nl_NL and label_en_GB but no 'label' in that table
And I have views civicrm_option_value_fr_FR, civicrm_option_value_nl_NL, and civicrm_option_value_en_GB which do have a 'label' column

not being a programmer, all I can do here is guess something went wrong because of multilingual   

So the big question is : where do I fix it and how come it works in the original environment ?