• Resolved mrroses

    (@mrroses)


    When I try and creat a new Gallery on NextGen Gallery, I keep recieving the following message:

    Oops! Sorry, but an error occured. This may be due to a server misconfiguration. Check your PHP error log or ask your hosting provider for assistance.

    Has anyone ran into this same error? Please let me know

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter mrroses

    (@mrroses)

    After Speaking with a namecheap support team member they advised that some data base tables are missing:

    Please check the logs:

    [30-Sep-2020 15:37:12] WARNING: [pool default-one] child 6854 said into stderr: “NOTICE: PHP message: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_ngg_gallery (title, author, extras_post_id, gid, name, slug, path, pageid, previewpic) VALUES (‘test’, ‘1’, ‘994’, ‘0’, ‘test’, ‘test’, ‘/wp-content/gallery/test/’, ‘0’, ‘0’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, M_Ajax->serve_ajax_request, C_Ajax_Controller->index_action, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_AddGallery_Ajax->import_media_library_action, C_DataMapper_Model->save, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_DataMapper_Driver_Base->save, ExtensibleObject->__call, ExtensibleObject”
    [30-Sep-2020 15:37:12] WARNING: [pool default-one] child 6854 said into stderr: “->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Gallery_Mapper->_sav…”
    – – 30/Sep/2020:15:36:59 +0000 “POST /index.php” 200
    2020/09/30 15:37:12 [error] 18#18: *5821 FastCGI sent in stderr: “PHP message: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_ngg_gallery (title, author, extras_post_id, gid, name, slug, path, pageid, previewpic) VALUES (‘test’, ‘1’, ‘994’, ‘0’, ‘test’, ‘test’, ‘/wp-content/gallery/test/’, ‘0’, ‘0’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, M_Ajax->serve_ajax_request, C_Ajax_Controller->index_action, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_AddGallery_Ajax->import_media_library_action, C_DataMapper_Model->save, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_DataMapper_Driver_Base->save, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Gallery_Mapper->_sav” while reading response header from upstream, client: 193.111.60.7, server: , request: “POST /index.php?photocrati_ajax=1 HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php-fpm-default-one.sock:”, host: “houseofroses.org”, referrer: “https://houseofroses.org/wp-admin/admin.php?page=ngg_addgallery”;

    Does anyone have an idea on how to correct this issue?

    Hello @mrroses,

    Let’s check something on your site.
    Please, go to the Tools menu > Site Health.
    Then, go to the Information tab and click on the button “Copy site info to clipboard”.
    Save that on a text file.

    10.01.2020-10.23.21

    You might see something like this.

    SQL Mode : NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    Having your database setup to “NO_AUTO_VALUE_ON_ZERO” might be generating the issue here. If that’s your case, contact your system administrator and let them know that you need to remove that setting.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Server Misconfiguration’ is closed to new replies.