Database & Other Issues Since 122018 Update

  • Dana Kester-McCabe

    (@danakestermccabe)


    7 years, 5 months ago

    I am getting the “Error connecting to database.” message and I am unable to post, to update posts, or to upload images. The live site seems to be working ok.

    Things I have done:
    Repaired the database via the WordPress Utility
    Deactivated all plug ins
    Contacted my host to see if this is a problem with the MYSQL server.

    The host is currently saying that I have an open script running somewhere that is stressing the database.

    If that is indeed the problem, right now the likely culprit could be a script that my client has me use on every post:
    <script type="text/javascript" src="https://connecttravel.com/analytics/ga-scroll-track-v2.js"></script>

    When I accessed the posts to look for one that may not have been copy/pasted properly I am finding that the latest update to WordPress and its new Gutenberg, has converted them all to this:
    <script type="text/javascript" src="https://connecttravel.com/analytics/ga-scroll-track-v2.js"><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span></script>

    I’d like to do a simple search and replace but I fear the system will simply convert them again.

    Does anyone have any suggestions for this multilayered problem?

    Thanks,
    Dana Kester-McCabe
    Moonshell Productions

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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 5 months ago

    That script loads javascript that hits Google, not your database; it’s probably not the issue.

    This may be a plugin or theme conflict. Please attempt to disable all plugins, and use one of the default (Twenty*) themes. If the problem goes away, enable them one by one to identify the source of your troubles.

    If you can install plugins, install “Health Check”: https://ww.wp.xz.cn/plugins/health-check/ On the troubleshooting tab, you can click the button to disable all plugins and change the theme for you, while you’re still logged in, without affecting normal visitors to your site. You can then use its admin bar menu to turn on/off plugins and themes one at a time.

    Thread Starter Dana Kester-McCabe

    (@danakestermccabe)

    7 years, 5 months ago

    Thanks Steven,

    I have attempted this. When I am in the Troubleshooting mode and switch to a different theme I get this message from HealthCheck:

    When switching the active theme to twentyseventeen, a site failure occurred. Because of this we reverted the theme to the one you used previously.

    I get that message no matter which theme I attempt to use.

    I am not sure what to do next.

    Thanks again,
    Dana

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 5 months ago

    What happens if you disable that analytics plugin?

    Thread Starter Dana Kester-McCabe

    (@danakestermccabe)

    7 years, 5 months ago

    As per my original post above I have already deactivated all plug ins.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 5 months ago

    So where is this troublesome script getting loaded?

    Thread Starter Dana Kester-McCabe

    (@danakestermccabe)

    7 years, 5 months ago

    Unfortunately I have no idea. I feel like I am flying blind on this one.

    I wonder if anyone can suggest how I might find out.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 5 months ago

    it’s from a plugin or your theme. Or did your client actually insert that script in every page/post? That would be…. um…. unfortunate.

    JNashHawkins

    (@jnashhawkins)

    7 years, 5 months ago

    If you or somebody else added the Javascript to each page manually then…

    Maybe you could create a super simple test page without the javascript inserted and try to load that?

    I’d run the Classic Editor Plugin to kill Gutenberg temporarily since that is probably clobbering that code in those posts or pages.

    I’d also excise that code when I saw it in a post or page.

    Put that code in the theme’s footer where it belongs… after you get the rest of this working right.

    Thread Starter Dana Kester-McCabe

    (@danakestermccabe)

    7 years, 5 months ago

    Thanks guys, I will look into that and let you know how I make out.

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

The topic ‘Database & Other Issues Since 122018 Update’ is closed to new replies.