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

  • 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] => 
    )
  • 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. 

  • @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

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

Stats

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

Other Projects

View Team Webgalli's plugins