Feature search box not working

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Feature search box not working

Sofia Robb-4
Hi Again,

My feature search boxes (name and id) are not working, I thought I might get it to work if I added the combined search, so I followed this tutorial http://tripal.info/node/136/

Here are the errors I am getting.

Thank you again and again,
Sofia

PS I am running CentOS7, does anyone think that I might be getting so many error constantly because of my OS? Would I be better off using Ubuntu?



SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "feature" does not exist LINE 5: feature feature ^

and 

  • Notice: Undefined index: mview_id in tripal_views_integration_form_validate() (line 1122 of/var/www/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: mview_id in tripal_views_integration_form_submit() (line 1168 of/var/www/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).

------------------------------------------------------------------------------

_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal
Reply | Threaded
Open this post in threaded view
|

Re: Feature search box not working

Kucheran, Lacey Sanderson
Hi Sofia,

The errors you posted imply that Drupal views can’t access your chado database. Have you applied the patch to Drupal Views?

There is also a bug in the Drupal Views 3.0 code that prevents Tripal's administrative and search data views from functioning. The patch is provided within the tripal_veiws module. To apply the patch execute the following:

cd /var/www/html/sites/all/modules/views
patch -p1 < ../tripal/tripal_views/views-sql-compliant-three-tier-naming-1971160-22.patch
If not, does doing so fix it?
~Lacey

------------------------------------------------------
Lacey-Anne Sanderson
Bioinformaticist
Pulse Crop Breeding and Genetics
Phone: (306) <a href="tel://966-3208">966-3208
Room 2C33 Agriculture
Department of Plant Sciences
University of Saskatchewan

On November 11, 2015 at 11:53:57 PM, Sofia Robb ([hidden email]) wrote:

Hi Again,

My feature search boxes (name and id) are not working, I thought I might get it to work if I added the combined search, so I followed this tutorial http://tripal.info/node/136/

Here are the errors I am getting.

Thank you again and again,
Sofia

PS I am running CentOS7, does anyone think that I might be getting so many error constantly because of my OS? Would I be better off using Ubuntu?



SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "feature" does not exist LINE 5: feature feature ^

and 

  • Notice: Undefined index: mview_id in tripal_views_integration_form_validate() (line 1122 of/var/www/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: mview_id in tripal_views_integration_form_submit() (line 1168 of/var/www/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
------------------------------------------------------------------------------
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal

------------------------------------------------------------------------------

_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal
Reply | Threaded
Open this post in threaded view
|

Re: Feature search box not working

Sofia Robb-4
Hi Lacey,
I thought I applied the patch, but I guess not. The error is gone, and now my "Unique Name" and "Name" feature search work, but my "Uniquename nd Synonyms List" search does not. I will remove the filter criteria I created and try again.

I love it when the fixes are easy.


Thank you!
Sofia

On Tue, Nov 17, 2015 at 12:45 PM, Kucheran, Lacey Sanderson <[hidden email]> wrote:
Hi Sofia,

The errors you posted imply that Drupal views can’t access your chado database. Have you applied the patch to Drupal Views?

There is also a bug in the Drupal Views 3.0 code that prevents Tripal's administrative and search data views from functioning. The patch is provided within the tripal_veiws module. To apply the patch execute the following:

cd /var/www/html/sites/all/modules/views
patch -p1 < ../tripal/tripal_views/views-sql-compliant-three-tier-naming-1971160-22.patch
If not, does doing so fix it?
~Lacey

------------------------------------------------------
Lacey-Anne Sanderson
Bioinformaticist
Pulse Crop Breeding and Genetics
Phone: (306) <a href="tel://966-3208" target="_blank">966-3208
Room 2C33 Agriculture
Department of Plant Sciences
University of Saskatchewan

On November 11, 2015 at 11:53:57 PM, Sofia Robb ([hidden email]) wrote:

Hi Again,

My feature search boxes (name and id) are not working, I thought I might get it to work if I added the combined search, so I followed this tutorial http://tripal.info/node/136/

Here are the errors I am getting.

Thank you again and again,
Sofia

PS I am running CentOS7, does anyone think that I might be getting so many error constantly because of my OS? Would I be better off using Ubuntu?



SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "feature" does not exist LINE 5: feature feature ^

and 

  • Notice: Undefined index: mview_id in tripal_views_integration_form_validate() (line 1122 of/var/www/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: mview_id in tripal_views_integration_form_submit() (line 1168 of/var/www/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
------------------------------------------------------------------------------
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal


------------------------------------------------------------------------------

_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal