unable to edit installation details in Softaculous

  • Resolved blogdropper

    (@blogdropper)


    8 months, 1 week ago

    Hi, I’m receiving error: Error establishing a database connection for website1.com

    I have 3 websites (each with its own database), the url in the wp_options tables show

    wpdb1 url: website1.com, wpdb2 url: website2.com wpdb3 url: website3.com. The problem is when I open Softaculous WordPress Managment and check the database details, I see that sites website1.com and website3.com have the same database name: wpdb3 . When I try to edit the installation details in Softaculous for website1.com to change the database name from wpdb3 to wpdb1 I receive error:

    • The MySQL Username or Password or Database host is wrong as a connection could not be established.
    • The Username, Password and Database host are correct and database wpdb1 belongs to website1.com.
    • Any help on how to change installation details much appreciated. Thanks

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter blogdropper

    (@blogdropper)

    website2.com and website3.com are no longer active and can be removed, but I’m not sure how that will effect the situation and don’t want to create more problems

    Moderator James Huff

    (@macmanx)

    Softaculous is a third-party installer, so we cannot provide support for it. I recommend contacting your hosting provider’s support instead.

    Alternatively, you can manually edit the wp-config.php file on the site in question to provide the correct database details: https://developer.www.ads-software.com/apis/wp-config-php/

    Thread Starter blogdropper

    (@blogdropper)

    Thanks for your reply, Softaculous is where I see the problem – 2 urls trying to use the same database, all details in wp-config.php are correct and the wp-option tables seem to be correct. Apart from contacting the hosting provider is there anything else I can do to resolve this issue – without using Softaculous. The full error is:

    Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘mosheavn_david’@’localhost’ (using password: YES) in?/home1/mosheavn/public_html/wp-includes/wp-db.php?on line?1531 Error establishing a database connection

    Thanks for your help.

    Moderator James Huff

    (@macmanx)

    Ok, as mentioned, Softaculous is a third-party installer, so we cannot provide support for it.

    You’ll need to contact your hosting provider’s support instead.

    Moderator James Huff

    (@macmanx)

    Sorry, I misread the question.

    You could try checking to see if your database user has full access and privileges to the site’s MySQL database.

    Since all hosting providers are different, you’ll need to consult your hosting provider’s documentation or support for specifics.

    • This reply was modified 8 months, 1 week ago by James Huff. Reason: typo
    Thread Starter blogdropper

    (@blogdropper)

    OK, I’ve created a new privelaged user and update wp-config.php, I now receive the following:

    Deprecated: Function create_function() is deprecated in /home1/mosheavn/public_html/wp-content/plugins/nextgen-gallery/widgets/media-rss-widget.php on line 138

Deprecated: Function create_function() is deprecated in /home1/mosheavn/public_html/wp-content/plugins/nextgen-gallery/widgets/widgets.php on line 145

Deprecated: Function create_function() is deprecated in /home1/mosheavn/public_html/wp-content/plugins/nextgen-gallery/widgets/widgets.php on line 345

Deprecated: Non-static method WPShortcodeExecPHP::Check_prerequisites() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php.php on line 48

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1318

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1319

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1320

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1321

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1322

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1323

Deprecated: Non-static method WPShortcodeExecPHP::Check_function() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/shortcode-exec-php/shortcode-exec-php-class.php on line 1324

Notice: add_shortcode was called incorrectly. Invalid shortcode name: OilOnCanvas 2012. Do not use spaces or reserved characters: & / < > [ ] = Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home1/mosheavn/public_html/wp-includes/functions.php on line 4239

Notice: add_shortcode was called incorrectly. Invalid shortcode name: OilOnCanvas 2014. Do not use spaces or reserved characters: & / < > [ ] = Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home1/mosheavn/public_html/wp-includes/functions.php on line 4239

Notice: The called constructor method for WP_Widget in nggMediaRssWidget is deprecated since version 4.3.0! Use__construct()instead. in /home1/mosheavn/public_html/wp-includes/functions.php on line 3994

Notice: The called constructor method for WP_Widget in nggSlideshowWidget is deprecated since version 4.3.0! Use__construct()instead. in /home1/mosheavn/public_html/wp-includes/functions.php on line 3994

Notice: The called constructor method for WP_Widget in nggWidget is deprecated since version 4.3.0! Use__construct()instead. in /home1/mosheavn/public_html/wp-includes/functions.php on line 3994

Warning: Cannot modify header information - headers already sent by (output started at /home1/mosheavn/public_html/wp-content/plugins/nextgen-gallery/widgets/media-rss-widget.php:138) in /home1/mosheavn/public_html/wp-content/plugins/si-contact-form/wp-session/class-wp-session.php on line 92

Deprecated: Non-static method nggGallery::get_theme_css_file() should not be called statically in /home1/mosheavn/public_html/wp-content/plugins/nextgen-gallery/nggallery.php on line 394

    Can you tell me what this indicates and how to correct it?

    Thanks

    Moderator James Huff

    (@macmanx)

    Try manually resetting your plugins (no Dashboard access required). If that resolves the issue, reactivate each one individually until you find the cause.

    If that does not resolve the issue, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel (consult your hosting provider’s documentation for specifics on these), navigate to /wp-content/themes/ and rename the directory of your currently active theme. Hopefully, this will force the default theme to activate and rule out a theme-specific issue (theme functions can interfere like plugins).

    Thread Starter blogdropper

    (@blogdropper)

    In wp-config.php I changed:

    define(‘WP_DEBUG’, true);

    define(‘WP_ALLOW_REPAIR’, true); to

    define(‘WP_DEBUG’, false); define(‘WP_ALLOW_REPAIR’, false); and all the errors magically disappeared – from sight. Who needs Softaculous?

    Thanks for your help

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘unable to edit installation details in Softaculous’ is closed to new replies.