Log in

User validation by admin [1.8 - 2.X] v1.0

  • Asa
    Asa

    I installed 1.1 still no email and when I go to unvalidated users I get the following error.

    Fatal Error.

An exception occurred while executing 'SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))':

SQLSTATE[42000]: Syntax error or access violation: 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 'AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 =' at line 5

QUERY: SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))

DatabaseException Object
(
[message:protected] => An exception occurred while executing 'SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))':

SQLSTATE[42000]: Syntax error or access violation: 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 'AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 =' at line 5

QUERY: SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))
[string:Exception:private] => exception 'DatabaseException' with message 'An exception occurred while executing 'SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))':

SQLSTATE[42000]: Syntax error or access violation: 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 'AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 =' at line 5

QUERY: SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))' in /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php:424
Stack trace:
#0 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php(367): Elgg\Database->executeQuery('SELECT COUNT(DI...', Object(Doctrine\DBAL\Connection))
#1 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php(218): Elgg\Database->getResults('SELECT COUNT(DI...', '', true)
#2 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php(453): Elgg\Database->getDataRow('SELECT COUNT(DI...')
#3 /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/entities.php(470): Elgg\Database\EntityTable->getEntities(Array)
#4 /home1/adakonli/public_html/mod/uservalidationbyadmin/views/default/forms/uservalidationbyadmin/bulk_action.php(24): elgg_get_entities(Array)
#5 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(397): include('/home1/adakonli...')
#6 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(310): Elgg\ViewsService->renderViewFile('forms/uservalid...', Array, 'default', true)
#7 /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('forms/uservalid...', Array, false, '')
#8 /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/views.php(1272): elgg_view('forms/uservalid...', Array)
#9 /home1/adakonli/public_html/mod/uservalidationbyadmin/views/default/admin/users/unvalidated.php(9): elgg_view_form('uservalidationb...', Array)
#10 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(397): include('/home1/adakonli...')
#11 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(310): Elgg\ViewsService->renderViewFile('admin/users/unv...', Array, 'default', true)
#12 /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('admin/users/unv...', Array, false, '')
#13 /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/admin.php(565): elgg_view('admin/users/unv...', Array)
#14 [internal function]: _elgg_admin_page_handler(Array, 'admin')
#15 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Router.php(95): call_user_func('_elgg_admin_pag...', Array, 'admin')
#16 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Application.php(428): Elgg\Router->route(Object(Elgg\Http\Request))
#17 /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Application.php(371): Elgg\Application->run()
#18 /home1/adakonli/public_html/index.php(8): Elgg\Application::index()
#19 {main}
[code:protected] => 0
[file:protected] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php
[line:protected] => 424
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php
[line] => 367
[function] => executeQuery
[class] => Elgg\Database
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))
[1] => Doctrine\DBAL\Connection Object
(
[_conn:protected] => Doctrine\DBAL\Driver\PDOConnection Object
(
)

[_config:protected] => Doctrine\DBAL\Configuration Object
(
[_attributes:protected] => Array
(
)

)

[_eventManager:protected] => Doctrine\Common\EventManager Object
(
[_listeners:Doctrine\Common\EventManager:private] => Array
(
)

)

[_expr:protected] => Doctrine\DBAL\Query\Expression\ExpressionBuilder Object
(
[connection:Doctrine\DBAL\Query\Expression\ExpressionBuilder:private] => Doctrine\DBAL\Connection Object
*RECURSION*
)

[_isConnected:Doctrine\DBAL\Connection:private] => 1
[autoCommit:Doctrine\DBAL\Connection:private] => 1
[_transactionNestingLevel:Doctrine\DBAL\Connection:private] => 0
[_transactionIsolationLevel:Doctrine\DBAL\Connection:private] => 
[_nestTransactionsWithSavepoints:Doctrine\DBAL\Connection:private] => 
[_params:Doctrine\DBAL\Connection:private] => Array
(
[dbname] => adakonli_adak
[user] => adakonli_sirasa
[password] => purple48
[host] => localhost
[charset] => utf8
[driver] => pdo_mysql
)

[platform:Doctrine\DBAL\Connection:private] => Doctrine\DBAL\Platforms\MySqlPlatform Object
(
[doctrineTypeMapping:protected] => 
[doctrineTypeComments:protected] => 
[_eventManager:protected] => Doctrine\Common\EventManager Object
(
[_listeners:Doctrine\Common\EventManager:private] => Array
(
)

)

[_keywords:protected] => 
)

[_schemaManager:protected] => 
[_driver:protected] => Doctrine\DBAL\Driver\PDOMySql\Driver Object
(
)

[_isRollbackOnly:Doctrine\DBAL\Connection:private] => 
[defaultFetchMode:protected] => 5
)

)

)

[1] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php
[line] => 218
[function] => getResults
[class] => Elgg\Database
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))
[1] => 
[2] => 1
)

)

[2] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php
[line] => 453
[function] => getDataRow
[class] => Elgg\Database
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(DISTINCT e.guid) as total FROM elgg_entities e WHERE e.enabled='no' AND NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = ) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1))
)

)

[3] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/entities.php
[line] => 470
[function] => getEntities
[class] => Elgg\Database\EntityTable
[type] => ->
[args] => Array
(
[0] => Array
(
[type] => user
[wheres] => Array
(
[0] => e.enabled='no'
[1] => NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = )
)

[limit] => 10
[offset] => 0
[count] => 1
)

)

)

[4] => Array
(
[file] => /home1/adakonli/public_html/mod/uservalidationbyadmin/views/default/forms/uservalidationbyadmin/bulk_action.php
[line] => 24
[function] => elgg_get_entities
[args] => Array
(
[0] => Array
(
[type] => user
[wheres] => Array
(
[0] => e.enabled='no'
[1] => NOT EXISTS (
SELECT 1 FROM elgg_metadata md
WHERE md.entity_guid = e.guid
AND md.name_id = 
AND md.value_id = )
)

[limit] => 10
[offset] => 0
[count] => 1
)

)

)

[5] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 397
[args] => Array
(
[0] => /home1/adakonli/public_html/mod/uservalidationbyadmin/views/default/forms/uservalidationbyadmin/bulk_action.php
)

[function] => include
)

[6] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 310
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => forms/uservalidationbyadmin/bulk_action
[1] => Array
(
)

[2] => default
[3] => 1
)

)

[7] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/views.php
[line] => 337
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => forms/uservalidationbyadmin/bulk_action
[1] => Array
(
)

[2] => 
[3] => 
)

)

[8] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/views.php
[line] => 1272
[function] => elgg_view
[args] => Array
(
[0] => forms/uservalidationbyadmin/bulk_action
[1] => Array
(
)

)

)

[9] => Array
(
[file] => /home1/adakonli/public_html/mod/uservalidationbyadmin/views/default/admin/users/unvalidated.php
[line] => 9
[function] => elgg_view_form
[args] => Array
(
[0] => uservalidationbyadmin/bulk_action
[1] => Array
(
[id] => uservalidationbyadmin-form
[action] => action/uservalidationbyadmin/bulk_action
)

)

)

[10] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 397
[args] => Array
(
[0] => /home1/adakonli/public_html/mod/uservalidationbyadmin/views/default/admin/users/unvalidated.php
)

[function] => include
)

[11] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php
[line] => 310
[function] => renderViewFile
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => admin/users/unvalidated
[1] => Array
(
[page] => Array
(
[0] => users
[1] => unvalidated
)

)

[2] => default
[3] => 1
)

)

[12] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/views.php
[line] => 337
[function] => renderView
[class] => Elgg\ViewsService
[type] => ->
[args] => Array
(
[0] => admin/users/unvalidated
[1] => Array
(
[page] => Array
(
[0] => users
[1] => unvalidated
)

)

[2] => 
[3] => 
)

)

[13] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/lib/admin.php
[line] => 565
[function] => elgg_view
[args] => Array
(
[0] => admin/users/unvalidated
[1] => Array
(
[page] => Array
(
[0] => users
[1] => unvalidated
)

)

)

)

[14] => Array
(
[function] => _elgg_admin_page_handler
[args] => Array
(
[0] => Array
(
[0] => users
[1] => unvalidated
)

[1] => admin
)

)

[15] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Router.php
[line] => 95
[function] => call_user_func
[args] => Array
(
[0] => _elgg_admin_page_handler
[1] => Array
(
[0] => users
[1] => unvalidated
)

[2] => admin
)

)

[16] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Application.php
[line] => 428
[function] => route
[class] => Elgg\Router
[type] => ->
[args] => Array
(
[0] => Elgg\Http\Request Object
(
[attributes] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
)

)

[request] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
)

)

[query] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
[__elgg_uri] => /admin/users/unvalidated
)

)

[server] => Symfony\Component\HttpFoundation\ServerBag Object
(
[parameters:protected] => Array
(
[DOCUMENT_ROOT] => /home1/adakonli/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
[HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => Elgg=4e56e01b0aff2504ac70ad42665a4ad1
[HTTP_HOST] => adak.online
[HTTP_REFERER] => http://adak.online/admin/plugins
[HTTP_UPGRADE_INSECURE_REQUESTS] => 1
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
[HTTP_X_HTTP_PROTO] => HTTP/1.1
[HTTP_X_LOG_6653] => 173.25.235.180
[HTTP_X_REAL_IP] => 173.25.235.180
[PATH] => /bin:/usr/bin
[QUERY_STRING] => __elgg_uri=admin/users/unvalidated
[REDIRECT_QUERY_STRING] => __elgg_uri=admin/users/unvalidated
[REDIRECT_STATUS] => 200
[REDIRECT_UNIQUE_ID] => V7ILeGyniQsAAa3-MSMAAAEH
[REDIRECT_URL] => /admin/users/unvalidated
[REMOTE_ADDR] => 173.25.235.180
[REMOTE_PORT] => 45726
[REQUEST_METHOD] => GET
[REQUEST_URI] => /admin/users/unvalidated
[SCRIPT_FILENAME] => /home1/adakonli/public_html/index.php
[SCRIPT_NAME] => /index.php
[SERVER_ADDR] => 108.167.137.112
[SERVER_ADMIN] => webmaster@adak.online
[SERVER_NAME] => adak.online
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] => <address>Apache Server at adak.online Port 80</address>

[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => V7ILeGyniQsAAa3-MSMAAAEH
[PHP_SELF] => /index.php
[REQUEST_TIME_FLOAT] => 1471286136.24
[REQUEST_TIME] => 1471286136
[argv] => Array
(
[0] => __elgg_uri=admin/users/unvalidated
)

[argc] => 1
)

)

[files] => Symfony\Component\HttpFoundation\FileBag Object
(
[parameters:protected] => Array
(
)

)

[cookies] => Symfony\Component\HttpFoundation\ParameterBag Object
(
[parameters:protected] => Array
(
[Elgg] => 4e56e01b0aff2504ac70ad42665a4ad1
)

)

[headers] => Symfony\Component\HttpFoundation\HeaderBag Object
(
[headers:protected] => Array
(
[accept] => Array
(
[0] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
)

[accept-encoding] => Array
(
[0] => gzip, deflate, sdch
)

[accept-language] => Array
(
[0] => en-US,en;q=0.8
)

[connection] => Array
(
[0] => close
)

[cookie] => Array
(
[0] => Elgg=4e56e01b0aff2504ac70ad42665a4ad1
)

[host] => Array
(
[0] => adak.online
)

[referer] => Array
(
[0] => http://adak.online/admin/plugins
)

[upgrade-insecure-requests] => Array
(
[0] => 1
)

[user-agent] => Array
(
[0] => Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
)

[x-http-proto] => Array
(
[0] => HTTP/1.1
)

[x-log-6653] => Array
(
[0] => 173.25.235.180
)

[x-real-ip] => Array
(
[0] => 173.25.235.180
)

)

[cacheControl:protected] => Array
(
)

)

[content:protected] => 
[languages:protected] => 
[charsets:protected] => 
[encodings:protected] => 
[acceptableContentTypes:protected] => 
[pathInfo:protected] => 
[requestUri:protected] => /admin/users/unvalidated
[baseUrl:protected] => 
[basePath:protected] => 
[method:protected] => 
[format:protected] => 
[session:protected] => 
[locale:protected] => 
[defaultLocale:protected] => en
)

)

)

[17] => Array
(
[file] => /home1/adakonli/public_html/vendor/elgg/elgg/engine/classes/Elgg/Application.php
[line] => 371
[function] => run
[class] => Elgg\Application
[type] => ->
[args] => Array
(
)

)

[18] => Array
(
[file] => /home1/adakonli/public_html/index.php
[line] => 8
[function] => index
[class] => Elgg\Application
[type] => ::
[args] => Array
(
)

)

)

[previous:Exception:private] => 
)
  • Asa
    Asa

    wait I did get the email that time just the error with the unvalidated user. 

    and I can validate the user from the email that was sent to me just not from the admin panel. 

  • Team Webgalli
    Team Webgalli

    @Asa: if you are using Elgg 2.X, we recommend using the V 2.1 of the plugin.

    The emails are sent to the first site admin account.

Team Webgalli

Team Webgalli

Leading Elgg developers India. We provide Elgg development, consultation and optimizations. To know more about our Elgg services and for cool elgg stuffs visit us

Project Info

Stats

  • Category: User admin
  • License: GNU General Public License (GPL) version 2
  • Updated: 2016-7-15
  • Downloads: 5737
  • Recommendations: 38

Other Projects

View Team Webgalli's plugins

Navigation

Contact

info@elgg.org

Security issues should be reported to security@elgg.org!

Legal

©2014 the Elgg Foundation

Elgg is a registered trademark of Thematic Networks.

Cover image by Raül Utrera is used under Creative Commons license.

Icons by Flaticon and FontAwesome.