I get the following sql errors when i try to sort the memberlist according to Country :
sql_query():
qry: select * from mx_users where uname != 'Anonymous' AND user_stat=1 AND uname like 'A%' order by user_from1 ASC LIMIT 0, 20
descr: Unknown column 'user_from1' in 'order clause' ( mysql 1054 )
details:
file: C:\xampp\htdocs\vkpmx\modules\Members_List\index.php # line: 173, cmd: sql_query(select * from mx_users where uname != 'Anonymous' AND user_stat=...),
file: C:\xampp\htdocs\vkpmx\modules.php # line: 106, cmd: include_once(select * from mx_users where uname != 'Anonymous' AND user_stat=..., C:\xampp\htdocs\vkpmx\modules\Members_List\index.php),
Nick Age Name Familystatus Location Country Search Admin
Error sql_num_rows():
descr: mysql_num_rows(): supplied argument is not a valid MySQL result resource
details:
file: C:\xampp\htdocs\vkpmx\modules\Members_List\index.php # line: 206, cmd: sql_num_rows(false),
file: C:\xampp\htdocs\vkpmx\modules.php # line: 106, cmd: include_once(false, C:\xampp\htdocs\vkpmx\modules\Members_List\index.php),
Error sql_fetch_array():
descr: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
details:
file: C:\xampp\htdocs\vkpmx\modules\Members_List\index.php # line: 208, cmd: sql_fetch_array(false),
file: C:\xampp\htdocs\vkpmx\modules.php # line: 106, cmd: include_once(false, C:\xampp\htdocs\vkpmx\modules\Members_List\index.php),
Is a table missing ...
:o :quest
[Edited on 27/2/2004 by crux]
Hi Crux :)
this is not the original module?
Zitatdescr: Unknown column 'user_from1'
This means, that the field user_from1 is not in the table mx_users.
Please can you post the structure from the table mx_users here?
Than we will see.... ;)
Just fixed it .... the members_list/index.php had a wrong entry of user_from1 instead of user_from
silly me ;)
Thanks a lot for all your help ... gr8 CMS ... need good english translation though .... will post some corrections here ;)