News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Users cannot search users from the top bar

Started by paq, April 05, 2015, 05:56:39 PM

Previous topic - Next topic

paq

... but can search other users from the USERS menu.

Moderators and admin have no issues here, but when a regular user looks up another user via the search in the top bar a database error occurs. The user will see an error notice within the SMF board.

From the error log:
QuoteDatabase error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
AND mem.is_activated = 1
ORDER BY mem.real_name ASC
LIMIT 0, 30' at line 5

Quotehttp://www.domain/index.php?action=mlist;sa=search;fields=name,email;search=*username*

QuoteC:/domains/domain/wwwroot/Sources/Memberlist.php
line: 515

I can't really figure out how this error occurs.

Night09

Do you have a custom profile mod installed? Might be best to list all mods.

Illori

the members search from the top of the forum works fine for me when not an admin.

try using the latest version on github and test again.

live627

Need to execute this SQL code in phpMyAdmin

ALTER TABLE {$db_prefix}membergroups
ADD COLUMN tfa_required tinyint(3) NOT NULL default '0',

paq

#4
Quote from: live627 on April 05, 2015, 08:08:41 PM
Need to execute this SQL code in phpMyAdmin

ALTER TABLE {$db_prefix}membergroups
ADD COLUMN tfa_required tinyint(3) NOT NULL default '0',


When I execute this, I get this error in phpMyAdmin

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$db_prefix}membergroups
ADD COLUMN tfa_required tinyint(3) NOT NULL default '0' at line 1



edit:
I manually added the column (at the end)
ALTER TABLE `smf_membergroups` ADD `tfa_required` TINYINT(3) NOT NULL DEFAULT '0' ;
Still the very same outcome

Illori

replace {$db_prefix} with your db prefix, most likely smf_

paq

yep I did afterwards.
The column is present now, but there is no difference.

Illori

are you using the latest 2.1 from github? if not you should upgrade and see if that helps.

paq

Quote from: Illori on April 06, 2015, 09:19:00 AM
are you using the latest 2.1 from github? if not you should upgrade and see if that helps.


hmm probably not... I downloaded the latest version from this site.

Kindred

well, that would be the problem.  The version on this site is currently MONTHS out of date and HUNDREDS of bugs have been fixed.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: