Database Update

  • Resolved davidmacnichol

    (@davidmacnichol)


    7 months, 2 weeks ago

    Issue with WooCommerce backup. Plugin is version 10.3.3, but the backup is 9.7.1. Tried to update manually, but it’s not doing it. Have tried deleting WooCommerce and reinstalling but not changing anything. I think it might have something to do with the schedule. I have 37 past due, but when I click on them, it times out, so I have no idea what they are. Have installed WP crontrol but that also has not helped. Is there a way to knock WooCommerce completely out of the system and install a new one? Or any other suggestions appreciated. Been at this for two weeks now

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

Viewing 7 replies - 16 through 22 (of 22 total)
1 2
  • Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    7 months, 2 weeks ago

    Hi there!

    Thank you for following up with those details. The command you tried — more .ssh/id_rsa.pub — is designed for Unix/Linux systems (like macOS or most web server terminals). Since your prompt shows a Windows path, the command works a bit differently there.

    On Windows, the more command doesn’t access files in the same way, so you’ll want to use the correct syntax for your operating system instead.

    Here’s what you can try:

    If you generated your SSH key using PuTTYgen or OpenSSH on Windows, the public key file should be located at:

    C:\Users\Owner\.ssh\id_rsa.pub

    To view and copy your public key in Command Prompt, run:

    type C:\Users\Owner\.ssh\id_rsa.pub

    This should display your public key so you can copy and paste it into your hosting control panel under SSH Access, as instructed by your host.

    If you haven’t generated a key pair yet, you can do so by opening PowerShell and running:

    ssh-keygen

    Then follow the prompts to create your SSH key pair.

    Once your public key is added to your hosting account, you should be able to connect via SSH and use WP-CLI as described earlier.

    If you continue to have trouble, please let us know which SSH tool you’re using (for example, PuTTY, PowerShell, or Git Bash) and share any error messages you see. That will help us provide more specific guidance.

    Thread Starter davidmacnichol

    (@davidmacnichol)

    7 months, 2 weeks ago

    FEEL LIKE IM CHASING MY TAIL HERE. FOLLOWED INSTRUCTIONS ABOVE.

    WP‑CLI is usually preinstalled on most WordPress hosting plans, but you need to connect via SSH to use it. You can log in to your hosting control panel and look for the SSH Access section to find your hostname and username, then connect using an SSH client and make sure your public key is added. DONE. SEE IMAGE. Once connected, you can run wp commands directly on your server. HOW DO I DO THIS?

    For more detailed guidance on using WP CLI, including how to configure it and run specific commands, please review the following resources: the official WordPress documentation at https://developer.ww.wp.xz.cn/cli/commands/, the WooCommerce CLI guide at https://woocommerce.com/document/woocommerce-cli/,

    PAGE NOT FOUND

    this Hosting.com article on using SSH and WP CLI from the command line at https://kb.hosting.com/docs/how-to-use-ssh-and-wp-cli-from-the-command-line-on-hostingcom-managed-wordpress,

    HOSTING.COM TELLS ME TO CLICK ON WORDPRESS BUT THERE IS NO WORDPRESS SHOWING

    and this Sucuri blog post on connecting to WordPress via SSH using WP CLI at https://blog.sucuri.net/2023/04/wp-cli-how-to-connect-to-wordpress-via-ssh.html.

    DOWNLOADED THE PUTTY APP BUT IM NOT GETTING THE APPLICATION SCREEN IT SHOWS UNDER ITEM 3

    Thread Starter davidmacnichol

    (@davidmacnichol)

    7 months, 2 weeks ago

    https://snipboard.io/YzvbkJ.jpg

    Moses M. (woo-hc)

    (@mosesmedh)

    7 months, 2 weeks ago

    Whoops @davidmacnichol,

    I understand that setups like this can be challenging, especially if you’re new to it. From what I can see, your hosting provider hasn’t been very helpful, even though they’re best positioned to guide you with the connection. My colleagues have offered guidance, but it seems to be more confusing than helpful, and this request is slightly beyond our support scope.

    To move forward, it may be better to consult experts on platforms like Codeable.io, who can access your hosting system and either perform the update for you or guide you step by step.

    Alternatively, we can try a PHP-based approach. Please install a code snippet plugin on your website and add the following code:

    if ( class_exists( 'WC_Install' ) ) {
    WC_Install::update_db_version();
}

    Make sure the snippet is set to run only in the admin area, then activate it. After activation, reload your admin dashboard and navigate around a few pages. This should trigger the WooCommerce database update. Once the update completes, please remove and delete the snippet.

    Before doing this, it’s highly recommended to take a backup of your website in case anything goes wrong.

    If this method doesn’t work, the only alternative is using WP-CLI, which would require either assistance from your hosting provider or guidance from an expert on platforms like Codeable.io.

    Plugin Support thelmachido a11n

    (@thelmachido)

    7 months, 1 week ago

    It’s been a while since we heard back from you for this reason we are closing this thread. 

    If WooCommerce has been useful for your store and you appreciate the support you’ve received, we’d truly appreciate it if you could leave us a quick review here: 

     https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/#new-post

    Feel free to open a new forum topic if you run into any other problem. 

    Thread Starter davidmacnichol

    (@davidmacnichol)

    7 months, 1 week ago

    Ended up deleting WooCommerce and reinstalling. Of course, that meant all my prior sales info is gone.

    Glad of the people who tried to help me but none of it worked, or I couldn’t figure out how to make it work.

    It would be worth woo having an easier way to fix two dates that don’t match like this

    Moses M. (woo-hc)

    (@mosesmedh)

    7 months, 1 week ago

    Hi @davidmacnichol,

    I’m sorry to hear about the workaround you had to go through. I understand how frustrating that must have been, and your concern is completely valid.

    To clarify, if you previously had WooCommerce installed and then deactivated, deleted, and reinstalled it, your orders and past sales data should still be preserved, since the database remains intact unless you deleted your entire website along with the database to start from scratch.

    We apologize for your experience. If you ever need further assistance in the future, please don’t hesitate to open a new topic, and we’ll be happy to help.

Viewing 7 replies - 16 through 22 (of 22 total)
1 2

The topic ‘Database Update’ is closed to new replies.

Tags