My questions is regarding the module "Site User List" - here are the steps I have followed and the errors at each step.

1.) upload version 4.7 to my 4.7 version installation folder. /modules/contrib
2.) Enable module from modules screen - no errors
3.) Go to Settings -> Site User List and I get the following:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR REPLACE VIEW site_user_list_view AS SELECT u.uid as uid, u.name as name, u.ma' at line 1 query: CREATE OR REPLACE VIEW site_user_list_view AS SELECT u.uid as uid, u.name as name, u.mail as mail FROM users as u WHERE u.status = 1 in /home/site/public_html/includes/database.mysql.inc on line 120.

4.) When I go to the Site User List module menu I get the following:

user warning: Table 'site_db1.site_user_list_view' doesn't exist query: SELECT DISTINCT cd.uid as uid_key, cd.mail FROM site_user_list_view as cd WHERE cd.uid not in (0) ORDER BY cd.mail ASC in /home/site/public_html/includes/database.mysql.inc on line 120.

From my limited understanding of SQL it appears as though the installer is failing to create the table "User_List_View" and assign the proper fields.

Any ideas of suggestions would be most appreciated.

Regards,

Comments

pukku’s picture

Hi! This probably means that you're using MySQL < 5.0; in the settings select to use a table, and regenerate via cron.