CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Initialization Error, after install language
Pages: [1]

Author Topic: Initialization Error, after install language  (Read 2968 times)

cristianomr

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
    • www.pixxpublicidade.com.br
  • CiviCRM version: 3.4.6
  • CMS version: Joomla 1.5.22
  • MySQL version: 5.1.58
  • PHP version: 5.2.10
Initialization Error, after install language
September 30, 2011, 05:18:24 pm
I installed the CiviCRM, so had a probleam putting the folder to translate to my language.
After solved this probleam.
I was trying to change the configuration of the language like i read at the document (back-end), the CiviCRM began to show a page of error when I click in icon at beck-end.

I uninstalled, and install again but the same error apear.
Anybody can help me?

Code: [Select]
Initialization Error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -13
    [message] => DB Error: division by zero
    [mode] => 16
    [debug_info] =>
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1356 ** View 'pixxpublicidad05.civicrm_option_value_en_US' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
    [type] => DB_Error
    [user_info] =>
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1356 ** View 'pixxpublicidad05.civicrm_option_value_en_US' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
    [to_string] => [db_error: message="DB Error: division by zero" code=-13 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1356 ** View 'pixxpublicidad05.civicrm_option_value_en_US' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]"]
)

backTrace

/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2424
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1610
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 152
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 879
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Preferences.php, executeQuery, 300
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, retrieveDirectoryAndURLPreferences, 346
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 397
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 202
/home/pixxpublicidade/www/administrator/components/com_civicrm/admin.civicrm.php, singleton, 48
/home/pixxpublicidade/www/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 59
/home/pixxpublicidade/www/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/home/pixxpublicidade/www/libraries/joomla/application/component/helper.php, require_once, 162
/home/pixxpublicidade/www/administrator/includes/application.php, renderComponent, 136
/home/pixxpublicidade/www/administrator/index.php, dispatch, 67
« Last Edit: September 30, 2011, 05:26:45 pm by cristianomr »

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Initialization Error, after install language
October 01, 2011, 10:46:18 am
Quote
View 'pixxpublicidad05.civicrm_option_value_en_US' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Not 100% sure but looks like this might be to do with your mysql permissions.  Do you have the relevant permissions to create/show views?

http://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

cristianomr

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
    • www.pixxpublicidade.com.br
  • CiviCRM version: 3.4.6
  • CMS version: Joomla 1.5.22
  • MySQL version: 5.1.58
  • PHP version: 5.2.10
Re: Initialization Error, after install language
October 07, 2011, 09:16:40 pm
I contacted the host and was said to me do that:

Code: [Select]
***************ITS WAS CREATED LIKE THIS:**************

CREATE ALGORITHM=UNDEFINED DEFINER=`pixxpublicidad05`@`%` SQL SECURITY DEFINER VIEW `civicrm_option_value_en_US` AS
select `pixxpublicidad05`.`civicrm_option_value`.`id` AS `id`,`pixxpublicidad05`.`civicrm_option_value`.`option_group_id` AS `option_group_id`,`pixxpublicidad05`.`civicrm_option_value`.`value` AS `value`,`pixxpublicidad05`.`civicrm_option_value`.`name` AS `name`,`pixxpublicidad05`.`civicrm_option_value`.`grouping` AS `grouping`,`pixxpublicidad05`.`civicrm_option_value`.`filter` AS `filter`,`pixxpublicidad05`.`civicrm_option_value`.`is_default` AS `is_default`,`pixxpublicidad05`.`civicrm_option_value`.`weight` AS `weight`,`pixxpublicidad05`.`civicrm_option_value`.`is_optgroup` AS `is_optgroup`,`pixxpublicidad05`.`civicrm_option_value`.`is_reserved` AS `is_reserved`,`pixxpublicidad05`.`civicrm_option_value`.`is_active` AS `is_active`,`pixxpublicidad05`.`civicrm_option_value`.`component_id` AS `component_id`,`pixxpublicidad05`.`civicrm_option_value`.`domain_id` AS `domain_id`,`pixxpublicidad05`.`civicrm_option_value`.`visibility_id` AS `visibility_id`,`pixxpublicidad05`.`civicrm
_option_value`.`label_en_US` AS `label`,`pixxpublicidad05`.`civicrm_option_value`.`description_en_US` AS `description` from `civicrm_option_value`

******** I SHOULD CREATE LIKE THIS: *************

CREATE DEFINER=CURRENT_USER SQL SECURITY INVOKER
VIEW `civicrm_option_value_en_US` AS
SELECT `pixxpublicidad05`.`civicrm_option_value`.`id` AS `id`,`pixxpublicidad05`.`civicrm_option_value`.`option_group_id` AS `option_group_id`,`pixxpublicidad05`.`civicrm_option_value`.`value` AS `value`,`pixxpublicidad05`.`civicrm_option_value`.`name` AS `name`,`pixxpublicidad05`.`civicrm_option_value`.`grouping` AS `grouping`,`pixxpublicidad05`.`civicrm_option_value`.`filter` AS `filter`,`pixxpublicidad05`.`civicrm_option_value`.`is_default` AS `is_default`,`pixxpublicidad05`.`civicrm_option_value`.`weight` AS `weight`,`pixxpublicidad05`.`civicrm_option_value`.`is_optgroup` AS `is_optgroup`,`pixxpublicidad05`.`civicrm_option_value`.`is_reserved` AS `is_reserved`,`pixxpublicidad05`.`civicrm_option_value`.`is_active` AS `is_active`,`pixxpublicidad05`.`civicrm_option_value`.`component_id` AS `component_id`,`pixxpublicidad05`.`civicrm_option_value`.`domain_id` AS `domain_id`,`pixxpublicidad05`.`civicrm_option_value`.`visibility_id` AS `visibility_id`,`pixxpublicidad05`.`civicrm
_option_value`.`label_en_US` AS `label`,`pixxpublicidad05`.`civicrm_option_value`.`description_en_US` AS `description` from `civicrm_option_value`

Só I removed the line "civicrm_option_value_en_US" and I create like the host said to me.
But now was showing that code when I click at beck-end:

Code: [Select]
Initialization Error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1146 ** Tabela 'pixxpublicidad05.civicrm_option_group_en_US' não existe]
    [type] => DB_Error
    [user_info] =>
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1146 ** Tabela 'pixxpublicidad05.civicrm_option_group_en_US' não existe]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1146 ** Tabela 'pixxpublicidad05.civicrm_option_group_en_US' não existe]"]
)

backTrace

/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2424
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1610
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 152
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 879
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Preferences.php, executeQuery, 300
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, retrieveDirectoryAndURLPreferences, 346
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 397
/home/pixxpublicidade/www/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 202
/home/pixxpublicidade/www/administrator/components/com_civicrm/admin.civicrm.php, singleton, 48
/home/pixxpublicidade/www/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 59
/home/pixxpublicidade/www/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/home/pixxpublicidade/www/libraries/joomla/application/component/helper.php, require_once, 162
/home/pixxpublicidade/www/administrator/includes/application.php, renderComponent, 136
/home/pixxpublicidade/www/administrator/index.php, dispatch, 67
Its saying that "civicrm_option_group_en_US" is not created
And i really didn't see "civicrm_option_group_en_US" at the phpmyadmin
How Can I create this table on phpmyadmin?
Why the CIVI-CRM doesn't clean all tabelas at the database when I unisntall de plugin? And re-create when I install again?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Initialization Error, after install language
October 08, 2011, 03:21:46 pm

Those are views, not tables.

In general manipulating the DB directly is best avoided. We've had issues with joomla upgrades and hence we dont drop the tables. I suspect 1.7 fixes many of these issues and we can and should improve this process

Wanna help with improving the joomla install/upgrade process?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Initialization Error, after install language

This forum was archived on 2017-11-26.