CiviCRM Community Forums (archive)

What is your version of CiviCRM and Views?

If Views is enabled then you should see the array on civicrm/admin/setting/uf?reset=1

Can you clear your CiviCRM template cache and flush all Drupal caches and try again?

I do not know. You could try upgrading to 4.2.8 and if it still fails, create a new thread and post the full details there.

Hi Hershel,

Tried to do that (and followed all instructions carefully) but now have a new issue that needs to be resolved before moving on, maybe I should create a new topic?

We backed everything up, edit the civicrm settings file and uploaded the new version but when we try to fun the upgrade script we get this error:

"Sorry but we are not able to provide this at the moment.
Your database has already been upgraded to CiviCRM 4.2.7
Return to home page."

However, that's the version we are upgrading from, not to. So we are stuck at that point. I have a page redirection module installed that sends the user to the civicrm dashboard as their homepage after login. I'll try switching that module off and try again then update the results here.

UPDATE:  After upgrading to 4.2.8 and deleting all of the cached files in the template_C directory and then running the script file:

civicrm/admin/setting/uf?reset=1

 that should show the array I still get no array data displayed.

UPDATE:  After upgrading to 4.2.8 and deleting all of the cached files in the template_C directory and then running the script file:

civicrm/admin/setting/uf?reset=1

 that should show the array I still get no array data displayed.

PS ... I have Views enabled and also Views PHP is installed and enabled.

I don't know if this is the equivalent of your suggestion Hershel, but rather than doing a separate installation I used the sandbox instead on the assumption it would be running the latest versions with this URL:

http://sandbox.drupal.civicrm.org/civicrm/admin/setting/uf?reset=1

... and there is no visible array information there, either. Does that mean there's either a change in CiviCRM so this is normal (now) or could it possibly be a bug, do you think? Or is my testing method flawed? 

Drupal 7.2
CiviCRM Starter Kit (civicrm_starterkit-7.x-2.8-rc2)
Database system version - 5.5.30-log
PHP - 5.3.22
Views - 7.x-3.6

I'm experiencing a problem which I believe is the result of having one MySQL for Drupal and one MySQL for CiviRM.  For whatever reason which I didn't notice initially, the Drupal db has a prefix of dr_ before every table while the CiviCRM one does not.

I've followed the instructions found here to the letter: wiki.civicrm.org/confluence/display/CRMDOC40/Views3+Integration

I get the whole long list of arrays to add to the settings.php file. When I add them I get this error:

Error
The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ewlyncom_jvmf.semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home7/ewlyncom/public_html/working/jvmf/includes/lock.inc).
Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ewlyncom_jvmf.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 19849718265157b043753c01.47273538 ) in lock_release_all() (line 269 of /home7/ewlyncom/public_html/working/jvmf/includes/lock.inc).

When I add the suggested 'default' => '', to the array, I get this:

Error
The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ewlyncom_jvmf.semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home7/ewlyncom/public_html/working/jvmf/includes/lock.inc).
Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ewlyncom_jvmf.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 2686623085157af00475238.53983167 ) in lock_release_all() (line 269 of /home7/ewlyncom/public_html/working/jvmf/includes/lock.inc).

Without anything added to my settings.php file, I get this error in views:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ewlyncom_jvmf.dr_civicrm_contribution' doesn't exist

I am officially at a lost.  I managed to get it to acknowledge the second database for a while - I can't even remember how I did it now and unfortunately did not think to keep a copy of it - with the settings.php file enough to change that error to read the name of the CiviCRM database, but couldn't figure out how to get it to understand that there is not dr_ before anything in it. I put in the prefix as being '' instead of 'dr_' but it didn't seem to do anything. I think I simply have my settings.php file wrong, but don't know enough about it to configure it correctly.

Basically, I am at a loss and would appreciate any help anyone can offer.

Thank you so much!

Why didn't I think of that?  Lobo, that fixed it!  It's always the most obvious thing that one overlooks, right?  I can't believe I didn't try that.

Thank you so, so much!