CiviCRM Community Forums (archive)

I am brand new to Drupal and brand new to CiviCRM, having installed both products within the last week; so I've probably bitten off more than I can chew!

As part of the Drupal installation, I also installed CTools and a View component.

I defined a view for displaying information on upcoming events, but realize that the view table "dr_civicrm_event" hasn't been created.  I assumed that views are created on the fly when defined or used.  It wasn't until I got an SQL error during display of the view that I even saw there was a problem.  I then verified the problem by seeing the error that was displayed when I edited the view.

Can someone lead me in the right direction in solving this issue?  I have no data of my own in the database yet - only the pre-installed CiviCRM data that came standard with the installer.

I'm using the latest version of Drupal 7 and the latest version of CiviCRM

Thanks in advance for your guidance and assistance.

That was very interesting...

No, I hadn't known about the information you posted.  Funny thing is that the settings.php file already had a definition for the $databases parameter.  I placed the new code immediately after the existing block, just as the instructions indicated, and when I did that, my site would not come up at all.  Removing the code allowed my site to come up, but with the same errors as originally reported.

So, I've enclosed another couple of screenshots of the "Views" component and "Chaos" module.

Maybe you can tell me where to fit the cut/paste code.  I can tell you that the Drupal and CiviCRM data is stored in a single database.  Some tables have the dr_ prefix, and some have the civicrm_ prefix.  There are no other tables in that database, and there are no other databases that contain tables.

On a PREVIOUS attempt to install CiviCRM, I recall it asking me for login credentials for a separate database.  After uninstalling Drupal/CiviCRM and removing all files/databases, I tried a second install.  I again recall being asked about a separate database to store CiviCRM data into, however, that database is completely blank... the database is there, but no tables exist in it at all.  Does that help?

I appreciate the time you're putting into this.  Once I get familiar with a product, I tend to spend a lot of time in forums, helping other users.  So just know that your "investment" will pay dividends eventually!

And thank you to whoever removed the requirement for that annoying captcha before posting 

Thank you.  That code cleared the SQL error.  When I now click on the "Upcoming Events" link in my menu, I am presented with a generic page that lists space-holders for events.  Checking the Events Management area, I see there are two pre-loaded events in the database that came from CiviCRM.

I'll check the block definition (this is the very first block I've defined, so I may not have the hang of it yet) to see if I made an error.  In the meantime, if you have a suggestion, I'm all ears.

I checked the View definition and didn't realize I had to select which fields were displayed.  It's all good now.

Thank you very much for your help!

Thanks, I saw that, and edited my previous post to indicate that I found the problem.  Thanks again.

To the right of "add" which is to the right of Fields, there is an arrow. Open that and find one of the options and choose it. Then you can drag and drop them into order.

If all else works, then you can ignore Undefined variable warnings.

Thanks.  I've now reordered the fields to my satisfaction.  However, the Undefined Variables message appears on the live website, not just when configuring the event view.

It also shows if you're NOT logged in? If so, Go to Administer > Site configuration > Error reporting (admin/settings/error-reporting).

I'm also going to look for a way to leave more space between entries... the first line of subsequent events appears immediately after the last line of prior events.  I need some separation.

Adjust the CSS of your theme for this.

I found the cause of the undefined variables message...

When defining the "Title" field, I asked it to link to the Event page.  When I went back to look at the field definition, it showed the Title as not being linked to any type of link(!)

I tried again to select a page to link to, and immediately noticed that the link was not properly stored (it still indicated it was not linking to any other page).

Only after completely removing the field, and adding it back as an UNLINKED field did the error message go away.

I have not attempted to link to another page.  I'll do that later.

Well, after adding the Title back, I again tried to link it to one of the Events pages, and again, the undefined variable error occurred.  When I first associated the Title field with a link, the link was operational, despite the error messages.  So, I may look at the PHP code and see whether this variable is undefined because of a path through the code that causes it to be undefined.  It won't be the first time I've found a module that had undefined variables due to the logic of the PHP file not anticipating every path through the code.