Hi Pukku,

I installed your module and then I got the following error:

user warning: Table 'baszeeland.BAS_site_user_list_view' doesn't exist query: site_user_list_form SELECT DISTINCT cd.uid as uid_key, cd.name, cd.mail FROM BAS_site_user_list_view as cd WHERE cd.uid not in (0) ORDER BY cd.name ASC in /usr/local/psa/home/vhosts/baszeeland.org/httpdocs/includes/database.mysql.inc on line 172.

Whenever I set the settings to 'table'and then save it, it switches back to views.

Also: whenever I ask for a list I get the message: 'There are no contacts which match your request' but I havent searched for anything yet

My Mysql is below 5. I have 18 profile fields of which one is a picture.

Can you shed some light?

Thanks in advance

TR

Comments

theorichel’s picture

theorichel commented

I have checked with PHPMyadmin and indeed there is no table referring to the site_user_list_view. I suppose that that is because my Mysql version is too old. However there is no table whatsoever in Mysql that refers to the site_user_list, shouldnt there be?

Also the error mentions a table that starts with baszeeland.BAS_site_user_list_view . The prefix I use is BAS, not Baszeeland.BAS

Hope this helps.

Thanks

theorichel’s picture

theorichel commented
Title: Error » Error - solved

The problem is solved. Before I selected table instead of view, changed some other parameters and clicked save configuration, only to find that it didnt remembare the table-choice. Did this 3 or 4 times

Now I have done a Cron job and thereafter selected only the table and saved the configuration and voila, it remembers the table choice andf my list is available.

pukku’s picture

pukku commented
Assigned: Unassigned » pukku
Status: Active » Closed (fixed)

Hm. OK, I'll close the ticket. I have no idea why it didn't save your settings in the first place...

Ricky