News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Show Members location on Members List

Started by Chas Large, February 07, 2010, 03:23:42 PM

Previous topic - Next topic

Chas Large

Quote from: CheeseHead05 on July 18, 2013, 11:48:08 PM
For some odd reason, when I install this mod and go to see if it actually shows members' location on member list, it doesn't show up...any suggestions?
Version of SMF? Do you see any errors during install? Does it display correctly using the default theme? Often these issues are theme related. Do you have any other mods that affect the members list?
My Modifications :)  My Forum

Please DO NOT PM me with support requests. Post the problem in the appropriate Support Board so everyone can benefit from the advice given.

Joey

FYI: with this mod installed on 2.0.7 if you do a search for members /index.php?action=mlist;sa=search
and check the box Search by position..... you come up with the error...

Database Error: Operand should contain 1 column(s)


SELECT COUNT(*)
FROM *******smf_members AS mem
LEFT JOIN nlgcomsmf_membergroups AS mg ON (mg.id_group = CASE WHEN mem.id [nofollow]_group = 0 THEN mem.id [nofollow]_post_group ELSE mem.id [nofollow]_group END)
WHERE (location, '' LIKE '%joey%' OR IFNULL(group_name, '') LIKE '%joey%')
AND mem.is [nofollow]_activated = 1
Apply Filter: Only show the errors from this file
File: ******************/Sources/Memberlist.php
Line: 527
 
if you uninstall the mod the search works ok any one have en idea whats going on ???



525:  AND mem.is_activated = {int:is_activated}',
526: $query_parameters
==>527: );
528: list ($numResults) = $smcFunc['db_fetch_row']($request);
529: $smcFunc['db_free_result']($request);
All to often the "hard to find" or "most expensive" component will
sacrifice itself in an attempt to save the two cent "fuse"
http://newlifegames.com [nofollow]

Chas Large

I can confirm an error occurs Joey, never tested that parameter before, however the error I get is:

Operand should contain 1 column(s)
File: /home/fiftyplu/public_html/forum/Sources/Memberlist.php
Line: 516

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.7, whilst your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.


I'll look into it but I doubt I'll be able to fix it as my mod merely added another column into the list and did nothing to the search function.
My Modifications :)  My Forum

Please DO NOT PM me with support requests. Post the problem in the appropriate Support Board so everyone can benefit from the advice given.

Chas Large

Ah, the error you see is in the error log, I see that too now.


http://www.fiftyplusforum.co.uk/forum/index.php?action=mlist;sa=search

Database Error: Operand should contain 1 column(s)

SELECT COUNT(*)
FROM smf_members AS mem
LEFT JOIN smf_membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = 0 THEN mem.id_post_group ELSE mem.id_group END)
WHERE (member_name LIKE '%joey%' OR real_name LIKE '%joey%' OR location, '' LIKE '%joey%' OR IFNULL(group_name, '') LIKE '%joey%' OR email_address LIKE '%joey%')
AND mem.is_activated = 1

File: /home/fiftyplu/public_html/forum/Sources/Memberlist.php
Line: 516
My Modifications :)  My Forum

Please DO NOT PM me with support requests. Post the problem in the appropriate Support Board so everyone can benefit from the advice given.

Joey

Good deal hope you or some one can help find a fix it's a nice Mod... would hate to lose it.. Thanks Joey
All to often the "hard to find" or "most expensive" component will
sacrifice itself in an attempt to save the two cent "fuse"
http://newlifegames.com [nofollow]

Chas Large

Thanks Joey for spotting the bug. All fixed, version 1.6 tested with TWO installs on 2.0.7 and works perfectly. ;D
My Modifications :)  My Forum

Please DO NOT PM me with support requests. Post the problem in the appropriate Support Board so everyone can benefit from the advice given.

FrizzleFried

#46
EDIT: My apologies... wrong topic.

margarett

Are you sure you posted in the correct topic? :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Advertisement: