Why are view option and roles submodule missing from one web site?
| Project: | Site User List |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | pukku |
| Status: | closed |
I have just installed this module on a site, and found it so useful I installed it on a second site. The download of the module is dated 12/27/2007, so I believe it is the latest available. On the first site, when I configure the module, three options are shown for "Retrieve Data from a..." subselect query, view, and table. On the second site, which has views enabled also, only one option, table, is presented. Why?
Also, on the first site, under Administer > Site Building > Modules, both Site User List and Site User List Roles are listed, while on the second site, only Site User List is shown. Why?
I would appreciate any ideas as to why I am seeing these differences. I am using Drupal 5.2 on the first site, and 5.3 on the second. Both use Views 5.x-1.6.
#1
I partially solved one problem, but now I have another. The second site does not allow me command level access, so I FTPd the contents of the module. One file was missing: site_user_list_roles.info. So I resent that module. Now when I try to install Site User List Roles, I get a long error message, shown below. It looks like my database was not properly modified when I installed the modules.
I tried to disable and deinstall Site User List module, and reinstall, but it doesn't help. How can I fix my database?
START OF ERROR LIST:
* user warning: Table 'presbyte_presbos.site_user_list_roles' doesn't exist query: DELETE FROM site_user_list_roles WHERE uid = 1 in /home/presbyte/public_html/cms/includes/database.mysql.inc on line 172.* user warning: Table 'presbyte_presbos.site_user_list_roles' doesn't exist query: INSERT INTO site_user_list_roles (uid, roles) VALUES (1, '<div class=\"item-list\"><ul><li>authenticated user</li><li>content editor</li></ul></div>') in /home/presbyte/public_html/cms/includes/database.mysql.inc on line 172.
* user warning: Table 'presbyte_presbos.site_user_list_roles' doesn't exist query: DELETE FROM site_user_list_roles WHERE uid = 4 in /home/presbyte/public_html/cms/includes/database.mysql.inc on line 172.
* user warning: Table 'presbyte_presbos.site_user_list_roles' doesn't exist query: INSERT INTO site_user_list_roles (uid, roles) VALUES (4, '<div class=\"item-list\"><ul><li>authenticated user</li><li>content editor</li></ul></div>') in /home/presbyte/public_html/cms/includes/database.mysql.inc on line 172.
* user warning: Table 'presbyte_presbos.site_user_list_roles' doesn't exist query: DELETE FROM site_user_list_roles WHERE uid = 5 in /home/presbyte/public_html/cms/includes/database.mysql.inc on line 172.
* user warning: Table 'presbyte_presbos.site_user_list_roles' doesn't exist query: INSERT INTO site_user_list_roles (uid, roles) VALUES (5, '<div class=\"item-list\"><ul><li>authenticated user</li><li>Council</li><li>blogger</li></ul></div>') in /home/presbyte/public_html/cms/includes/database.mysql.inc on line 172.
The rest of the error listing is in an attachment.
#2
I found the cause of the problem with the Site User List Roles module. The site_user_list_roles.install file was 0 length. I disabled and deinstalled both modules, and re-FTPd the files to the site. Now the roles module seems to work fine.
But I still only see tables as an option for "Retrieve Data from a..." Any ideas?
#3
The "view" referred to has _nothing_ to do with the Views module. It is a database view — a virtual table maintained by the database engine. The issue probably has to do with the version of MySQL. MySQL doesn't support database views or subselect queries in all versions.
#4
pukku,
Thanks for the comment. I hadn't considered that the sites were hosted on different services and that they could be supported by different versions of MySQL. I had been planning to move my problem site to the other site anyway, so this gives me some motivation to do so.
#5