Unable to view all users in administrator area users list

SANDEEP KUMAR Posted in Technical Support 3 weeks ago

On my website more than 10 people have registered. But i am unable to view all. It is showing only 10 users. And next page option is not there. user list
And showing error.
OssnDatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-10, 10' at line 1 SELECT u.guid, u.* FROM ossnusers as u WHERE(u.timecreated IS NOT NULL) ORDER by u.guid ASC LIMIT -10, 10; in /storage/ssd3/552/8809552/publichtml/classes/OssnDatabase.php:96 Stack trace: #0 /storage/ssd3/552/8809552/publichtml/classes/OssnDatabase.php(195): OssnDatabase->execute() #1 /storage/ssd3/552/8809552/publichtml/classes/OssnUser.php(634): OssnDatabase->select(Array, true) #2 /storage/ssd3/552/8809552/publichtml/classes/OssnUser.php(447): OssnUser->searchUsers(Array) #3 /storage/ssd3/552/8809552/publichtml/components/verified-account/plugins/default/forms/admin/users/list.php(18): OssnUser->getSiteUsers() #4 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.views.php(27): include('/storage/ssd3/5...') #5 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.views.php(50): ossninclude('/storage/ssd3/5...', Array) #6 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.plugins.php(75): ossnview('/storage/ssd3/5...', Array) #7 /storage/ssd3/552/8809552/publichtml/system/plugins/default/output/form.php(18): ossnpluginview('forms/admin/use...', Array) #8 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.views.php(27): include('/storage/ssd3/5...') #9 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.views.php(50): ossninclude('/storage/ssd3/5...', Array) #10 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.plugins.php(75): ossnview('/storage/ssd3/5...', Array) #11 /storage/ssd3/552/8809552/publichtml/libraries/ossn.lib.views.php(241): ossnpluginview('output/form', Array) #12 /storage/ssd3/552/8809552/publichtml/system/plugins/default/pages

Replies
German ~Z~ Man Replied 3 weeks ago

/storage/ssd3/552/8809552/publichtml/components/verified-account/plugins/default/forms/admin/users/list.php(18):
OssnUser->getSiteUsers()

SANDEEP KUMAR,

if you want a stable Ossn communitiy I can only recommend not to blindly install anything you might find on the web. The component 'verified-account' was developed for Ossn 3.0 in 2015 and has been removed for good reasons from our component download section here. It comes with an incompatible pagination handler - that's why you're getting these crashes. Simply remove it and replace it by the component you can find at
https://www.softlab24.com/product/view/3791/verified-profiles