Error in sql for Member_List

Begonnen von crux, 27 Februar 2004, 18:27:27

⏪ vorheriges - nächstes ⏩

0 Mitglieder und 1 Gast betrachten dieses Thema.

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 ...
:o :quest

[Edited on 27/2/2004 by crux]

Andi

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....  ;)
schön´s Grüssle, Andi

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 ;)