help fixing this fatal error please

hi there, i've only just noticed this when logged out as a guest, when i click on a profile avatar anywhere i get this error, also i'v just noticed i don't have this dropdown menu on my site either, when i click the avatar logged in it clicks to their profile page but no dropdown menu. when i log in as another member it clicks to their profile page but no dropdown menu again.

 

edit: so i'v disabled some plugins but it made no difference, but it works in the alborg theme, i use hypeui :/ 

 

 

help to fix this please 

 

thank you

 

 

 

 

 

  • You have to provide more information. What exactly does your error log file shows for timestamp 1549062123?

    Share the error log and then someone will be able to help you.

  • thank you buddy, the bottom one says a different number to what u said 1549062123 

     

  • so i just recreated the error and i got all this below the line i highlight in the img above in my last post

     

    [01-Feb-2019 23:24:22 UTC] Exception at time 1549063462 : fatal error in exception handler : An exception occured in driver: SQLSTATE[42000] [1226] User 'u861446799_uwuge' has exceeded the 'max_user_connections' resource (current value: 15)
    [02-Feb-2019 13:15:47 UTC] Exception at time 1549113347: exception 'DatabaseException' with message 'An exception occurred while executing 'SELECT DISTINCT e.* FROM dyuj_entities e  JOIN dyuj_metadata n_table on e.guid = n_table.entity_guid  JOIN dyuj_metadata n_table1 on e.guid = n_table1.entity_guid  JOIN dyuj_metadata n_table2 on e.guid = n_table2.entity_guid  WHERE  ((n_table.name_id IN (82,658)) AND ((n_table.value_id IN (715)) AND (n_table1.name_id IN (82,658) AND n_table1.value_id IN (1215)) AND (n_table2.name_id IN (82,658) AND n_table2.value_id IN (661,1182))) AND ((n_table.access_id IN (2,-5)) AND (n_table.enabled = 'yes' AND 
    NOT EXISTS (
    SELECT 1 FROM dyuj_private_settings
    WHERE
    entity_guid IN (n_table.guid, n_table.owner_guid)
    AND name = 'plugin:user_setting:private_profiles:user_activity_setting'
    AND value = 'members'
    )
    ))) AND  ((e.type = 'object' AND e.subtype IN (6,2,15,8,11))) AND  (e.site_guid IN (1)) AND ((e.access_id IN (2,-5)) AND (e.enabled = 'yes' AND 
    NOT EXISTS (
    SELECT 1 FROM dyuj_private_settings
    WHERE
    entity_guid IN (e.guid, e.owner_guid)
    AND name = 'plugin:user_setting:private_profiles:user_activity_setting'
    AND value = 'members'
    )
    )) ORDER BY e.time_created desc LIMIT 0, 8':
     
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'n_table.guid' in 'where clause'
     
    QUERY: SELECT DISTINCT e.* FROM dyuj_entities e  JOIN dyuj_metadata n_table on e.guid = n_table.entity_guid  JOIN dyuj_metadata n_table1 on e.guid = n_table1.entity_guid  JOIN dyuj_metadata n_table2 on e.guid = n_table2.entity_guid  WHERE  ((n_table.name_id IN (82,658)) AND ((n_table.value_id IN (715)) AND (n_table1.name_id IN (82,658) AND n_table1.value_id IN (1215)) AND (n_table2.name_id IN (82,658) AND n_table2.value_id IN (661,1182))) AND ((n_table.access_id IN (2,-5)) AND (n_table.enabled = 'yes' AND 
    NOT EXISTS (
    SELECT 1 FROM dyuj_private_settings
    WHERE
    entity_guid IN (n_table.guid, n_table.owner_guid)
    AND name = 'plugin:user_setting:private_profiles:user_activity_setting'
    AND value = 'members'
    )
    ))) AND  ((e.type = 'object' AND e.subtype IN (6,2,15,8,11))) AND  (e.site_guid IN (1)) AND ((e.access_id IN (2,-5)) AND (e.enabled = 'yes' AND 
    NOT EXISTS (
    SELECT 1 FROM dyuj_private_settings
    WHERE
    entity_guid IN (e.guid, e.owner_guid)
    AND name = 'plugin:user_setting:private_profiles:user_activity_setting'
    AND value = 'members'
    )
    )) ORDER BY e.time_created desc LIMIT 0, 8 
     
    PARAMS: Array
    (
    )
    ' in /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php:446
    Stack trace:
    #0 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php(387): Elgg\Database->executeQuery('SELECT DISTINCT...', Object(Doctrine\DBAL\Connection), Array)
    #1 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php(209): Elgg\Database->getResults('SELECT DISTINCT...', NULL, false, Array)
    #2 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php(802): Elgg\Database->getData('SELECT DISTINCT...')
    #3 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database/EntityTable.php(677): Elgg\Database\EntityTable->fetchFromSql('SELECT DISTINCT...', NULL)
    #4 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/entities.php(327): Elgg\Database\EntityTable->getEntities(Array)
    #5 /home/u861446799/public_html/mod/widget_pack/views/default/widgets/content_by_tag/content.php(178): elgg_get_entities(Array)
    #6 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(370): include('/home/u86144679...')
    #7 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(306): Elgg\ViewsService->renderViewFile('widgets/content...', Array, 'default', true)
    #8 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('widgets/content...', Array, false, '')
    #9 /home/u861446799/public_html/mod/widget_manager/views/default/object/widget/elements/content.php(25): elgg_view('widgets/content...', Array)
    #10 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(370): include('/home/u86144679...')
    #11 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(306): Elgg\ViewsService->renderViewFile('object/widget/e...', Array, 'default', true)
    #12 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('object/widget/e...', Array, false, '')
    #13 /home/u861446799/public_html/mod/widget_manager/views/default/object/widget.php(70): elgg_view('object/widget/e...', Array)
    #14 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(370): include('/home/u86144679...')
    #15 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(306): Elgg\ViewsService->renderViewFile('object/widget', Array, 'default', true)
    #16 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('object/widget', Array, false, '')
    #17 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(905): elgg_view('object/widget', Array, false, false)
    #18 /home/u861446799/public_html/mod/widget_manager/views/default/page/layouts/widgets.php(92): elgg_view_entity(Object(WidgetManagerWidget), Array)
    #19 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(370): include('/home/u86144679...')
    #20 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(306): Elgg\ViewsService->renderViewFile('page/layouts/wi...', Array, 'default', true)
    #21 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('page/layouts/wi...', Array, false, '')
    #22 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(709): elgg_view('page/layouts/wi...', Array)
    #23 /home/u861446799/public_html/mod/hypeUI/views/default/profile/layout.php(13): elgg_view_layout('widgets', Array)
    #24 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(370): include('/home/u86144679...')
    #25 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(306): Elgg\ViewsService->renderViewFile('profile/layout', Array, 'default', true)
    #26 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(337): Elgg\ViewsService->renderView('profile/layout', Array, false, '')
    #27 /home/u861446799/public_html/mod/hypeUI/views/default/resources/profile/view.php(14): elgg_view('profile/layout', Array)
    #28 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(370): include('/home/u86144679...')
    #29 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/ViewsService.php(306): Elgg\ViewsService->renderViewFile('resources/profi...', Array, 'default', true)
    #30 /home/u861446799/public_html/vendor/elgg/elgg/engine/lib/views.php(514): Elgg\ViewsService->renderView('resources/profi...', Array)
    #31 /home/u861446799/public_html/mod/profile/start.php(78): elgg_view_resource('profile/view', Array)
    #32 [internal function]: profile_page_handler(Array, 'profile')
    #33 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Router.php(100): call_user_func('profile_page_ha...', Array, 'profile')
    #34 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Application.php(436): Elgg\Router->route(Object(Elgg\Http\Request))
    #35 /home/u861446799/public_html/vendor/elgg/elgg/engine/classes/Elgg/Application.php(384): Elgg\Application->run()
    #36 /home/u861446799/public_html/index.php(8): Elgg\Application::index()
    #37 {main}
  • Those number are basically the timestamp. The bottom one is different number because someone else might have got an fatal error and that got recorded in your error_log file.

    For your last error - The problem is with your number of sql connection. I am not sure if you are using a shared server or not but this error is generally seen on shared servers where your service provider limit the number of sql connection. 

    Solutions:

    1. Ask your service provider to increase the value of 'max_user_connections' for your database.
    2. If the service provider is not willing to do it, try to make multiple db users with read access and one db user with write access and configure your setting.php file to use the master/slave feature keeping the same localhost.
    3. If both the above solution don't work for you then I will suggest you change your hosting provider and move a dedicated server or a cloud server.

    Hope this helps! 

  • For the error log provided, the error clearly states the problem:

    Unknown column 'n_table.guid' in 'where clause'

    and here n_table is referring to dyuj_private_settings table. If you check the table there is no guid column in the table.

    You might be using any 3rd party plugin that has a bad written sql code which is creating the error. Probably the plugin is not compatible with the elgg version you are using.

    Try disabling widget_pack plugin and check if the issue is solved.

  • @Rohit Gupta

    disabling the widget_pack plugin worked thank you !  

    what does that plugin do because it's not changed anything on the site and all the widgets are still there, do i only need the widget_manger plugin ? 

     

     

  • what does that plugin do because it's not changed anything on the site and all the widgets are still there

    I have no idea what does that plugin do, I just suggested you to disable the plugin based on the error_log shared.

    Do i only need the widget_manger plugin ? 

    The answer depends on your requirement. If you are using managing widgets on profile, dashboard, groups etc then yes you will need it otherwise no. 

  • ok no worries everything seems to working now thank you :)