CiviCRM Community Forums (archive)

Hi,

  I am new to civicrm.  I got error message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_event.title' in 'field list'

  in my view (I am using View3).  Anyone can help me?

Thanks,

R

I did the view integration.  But I still got same error.

Here is my settings.php

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'drupal',
      'username' => 'root',
      'password' => 'XXXX',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);
$databases['default']['default']['prefix']= array(
  'default'                                  => '',
  'civicrm_acl'                              => '`civicrm`.',
  'civicrm_acl_cache'                        => '`civicrm`.',
  'civicrm_acl_contact_cache'                => '`civicrm`.',
  'civicrm_acl_entity_role'                  => '`civicrm`.',
  'civicrm_action_log'                       => '`civicrm`.',
  'civicrm_action_mapping'                   => '`civicrm`.',
  'civicrm_action_schedule'                  => '`civicrm`.',
  'civicrm_activity'                         => '`civicrm`.',
  'civicrm_activity_assignment'              => '`civicrm`.',
  'civicrm_activity_target'                  => '`civicrm`.',
  'civicrm_address'                          => '`civicrm`.',
  'civicrm_address_format'                   => '`civicrm`.',
  'civicrm_batch'                            => '`civicrm`.',
  'civicrm_batch_en_ca'                      => '`civicrm`.',
  'civicrm_batch_zh_tw'                      => '`civicrm`.',
  'civicrm_cache'                            => '`civicrm`.',
  'civicrm_campaign'                         => '`civicrm`.',
  'civicrm_campaign_group'                   => '`civicrm`.',
  'civicrm_case'                             => '`civicrm`.',
......);

Please help me.

Thanks,

R

Here is the query:   

SELECT civicrm_event.title AS civicrm_event_title, civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date
FROM
{civicrm_event} civicrm_event
WHERE (( (civicrm_event.is_active <> '0') AND (civicrm_event.is_public <> '0') )AND( (DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-25200)), '%Y-%m') >= '2012-10' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-25200)), '%Y-%m') <= '2012-10') ))
ORDER BY civicrm_event_start_date ASC

Thanks,

R

define( 'CIVICRM_UF_DSN'           , 'mysql://root:XXX@localhost/drupal?new_link=true' );

define( 'CIVICRM_DSN'          , 'mysql://root:XXX@localhost/civicrm?new_link=true' );

Check out my post here, its at the bottom. http://forum.civicrm.org/index.php?topic=24741.0