I'd like to try this out, I got it via CVS, but once installed in Drupal it can't find the table, and resulting fields. What would the commands be to create the necessary tables/fields for this to work? Thanks, this will be very useful for my Biblio instance.

Comments

David Lesieur’s picture

David Lesieur commented

Do you mean that the 'apachesolr_biblio_fields' table is missing? If so, have you made sure to also get the apachesolr_biblio.install file before enabling the module?

phil.cryer’s picture

phil.cryer commented

Long story short, yes, the 'apachesolr_biblio_fields' table is missing.

Details:
I have Biblio, Apachesolr-biblio all enabled and working:
Apache Solr Biblio - Adds Biblio fields to the Solr index for faceted search - Depends on: Biblio (enabled), Apache Solr framework (enabled), Taxonomy (enabled), Search (enabled)

Within the Apachesolr settings I have this listed:
Biblio: Filter by Citation Contributor

But anytime I hit the search page, I get the following:

user warning: Table 'cite.apachesolr_biblio_fields' doesn't exist query: SELECT * FROM apachesolr_biblio_fields in /var/www/devcite.biodiversitylibrary.org/sites/all/modules/apachesolr_biblio-HEAD/apachesolr_biblio.module on line 46.

warning: Invalid argument supplied for foreach() in /var/www/devcite.biodiversitylibrary.org/sites/all/modules/apachesolr/apachesolr.module on line 1190.

And looking at my database it's true, I don't have that table cite.apachesolr_biblio_fields:

show tables;
[..]
 apachesolr_search_node       
 apachesolr_stats

I have disabled/renabled the modules, yet that table is not created. What should create it, and/or how do I create it by hand? Thanks

David Lesieur’s picture

David Lesieur commented

I think the following steps will help:

  1. Disable the Apache Solr Biblio module.
  2. Get the latest version of Apache Solr Biblio (downloaded from here) and replace your old version.
  3. With your favorite MySQL client, look into the 'system' table from your site's database. Find the row where name = 'apachesolr_biblio', and set 'schema_version' to -1 instead of 0.
  4. Enable the Apache Solr Biblio module. The module's installer should now create the table.
phil.cryer’s picture

phil.cryer commented
Status: Active » Closed (fixed)

Thank you David, this fixed my problem