site_user_list_view' is not BASE TABLE
Ashford - February 2, 2009 - 23:04
| Project: | Site User List |
| Version: | 5.x-1.x-dev |
| Component: | User interface |
| Category: | support request |
| Priority: | normal |
| Assigned: | pukku |
| Status: | active |
| Issue tags: | MySQL, site user list |
Jump to:
Description
I was having a lot of problems with the database. I ran 'analyze' on all the tables using phpMyAdmin. The lines shown below were displayed.
site_user_list_view' is not BASE TABLE
site_user_list_view' is corrupt
I tried running 'repair' and that did not resolve the issue. What could cause this type of problem and what can be done to fix it?
Ashford
#1
I have this issue also.
#2
In the admin section (admin/settings/site_user_list), is it set to retrieve data from a database view, or a table? If set to a database view, this would explain why phpMyAdmin complains it isn't a table, because it isn't -- it's a view.
#3
Thank you, pukku, for responding. So...if it's a view and not a table, why would it be in phpMyAdmin at all?
Regardless of the answer to my secondary question, I assume from your answer that this is not causing whatever problems I am having with the web site.
Should I ignore the database alerts, delete a record somewhere, or what?
site_user_list_view' is not BASE TABLE
site_user_list_view' is corrupt
Ashford
#4
First, it could be a table -- it depends on the setting in the admin section.
Second, sometimes databases or database admin clients treat views as tables in certain circumstances, especially when displaying a list of things you can do a SELECT from.
Third, I don't know what the problem you're having is, so I don't know what to suggest.
What errors are you getting in Drupal? What is going wrong?
Ricky