Suche

[crux]

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 ...


[Edited on 27/2/2004 by crux]

[Andi]

Hi Crux

this is not the original module?
 

descr: 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....  

[crux]

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