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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 3.0 to 3.1.4 issues -
Pages: [1]

Author Topic: 3.0 to 3.1.4 issues -  (Read 941 times)

BayBoyHDG

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
3.0 to 3.1.4 issues -
April 15, 2010, 05:44:01 pm
I recently migrated my site to a new hosting company (TMDhosting). They advertised support for CiviCRM and their yearly cost is less than $50/year. While they were mostly successful in migrating my Civi install from one location to another I did have to bring in CiviCRM experts to resolve a number of issues. To be fair, TMDhosting doesn't claim to provide "developer" support.

After my CiviCRM developer fixed the problems with the install I asked my hosting company to apply the upgrade to 3.1.4 (We were on 3.0).

Things mostly look normal but I've encountered the following:

The CiviCRM Admin Menu bar appears correctly but only when I manually enter the correct URL - civicrm.stonewalldemocratsmd.org/civicrm/admin

My goal would be that the menu bar appears not on the login screen but on every screen after you login.

I got the following error message when trying to navigate to the CiviCRM dashboard page.

Fatal error: require_once() [function.require]: Failed opening required 'CRM/Contact/Page/View/DashBoard.php' (include_path='.:/home/stonewal/public_html/civicrm/sites/all/modules/civicrm:/home/stonewal/public_html/civicrm/sites/all/modules/civicrm/packages:.:/usr/lib/php:/usr/local/lib/php') in /home/stonewal/public_html/civicrm/sites/all/modules/civicrm/CRM/Core/Invoke.php on line 188

I get this message when I try to access the CiviCRM Configuration Checklist:


Sorry. A non-recoverable error has occurred.

DB Error: no such field

Database Error Code: Unknown column 'option_value.domain_id' in 'where clause', 1054

Return to home page.

Error Details:

Array
(
[callback] => Array
(
  • => CRM_Core_Error
  • [1] => handle
    )

Code: [Select]
=> -19
[message] => DB Error: no such field
[mode] => 16
[debug_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_group.name = 'from_email_address' AND option_value.domain_id = 1 ORDER BY weight [nativecode=1054 ** Unknown column 'option_value.domain_id' in 'where clause']
[type] => DB_Error
[user_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_group.name = 'from_email_address' AND option_value.domain_id = 1 ORDER BY weight [nativecode=1054 ** Unknown column 'option_value.domain_id' in 'where clause']
[to_string] => [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_group.name = 'from_email_address' AND option_value.domain_id = 1 ORDER BY weight [nativecode=1054 ** Unknown column 'option_value.domain_id' in 'where clause']"]
)




adixon

  • I post frequently
  • ***
  • Posts: 314
  • Karma: 19
    • Blackfly Solutions
Re: 3.0 to 3.1.4 issues -
April 16, 2010, 10:29:53 am
this message:

Database Error Code: Unknown column 'option_value.domain_id' in 'where clause', 1054

suggests you only got your code updated, and didn't do the database upgrade. Or else your database was already bad.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 3.0 to 3.1.4 issues -

This forum was archived on 2017-11-26.