Relaunch is not working, Need help with Database

ah, OK, thanks! I ran it again, but no change… /relaunch is still in all urls in wp_posts and chaos still appears online…

https://www.jessicavoiceover.com/img/db2.png

The code is being accepted by SQL, so that means it is reaching your database and tables…but then the fact that nothing is being changed would mean SQL is not finding *exactly* ‘https://www.jessicavoiceover.com/relaunch’ to be replaced.

Is there any chance your database might be using any of these…
‘https://www.jessicavoiceover.com/relaunch’ -or-
‘https://jessicavoiceover.com/relaunch’ -or-
‘https://jessicavoiceover.com/relaunch’ ???

If you might decide to try any of those in the “old” position in the code (three places), be certain the “new” (three places) in the code is what you actually want it to be.

note: We have reached the end of my SQL experience, so I do not know any additional possible reason for the code to not work.

aHA! I see it was NOT using www, SO I deleted www, BUT I only deleted it in the relaunch code, meaning, I went from ‘https://jessicavoiceover.com/relaunch’ to ‘https://www.jessicavoiceover.com’ and then noticed that I made that mistake and loaded: ‘https://www.jessicavoiceover.com’ to ‘https://jessicavoiceover.com’ … but still, NO changes online. I see the change in wp_posts and wp_options though, but chaos still reigns online…

But I strongly believe, in fact, I know for sure, that www was in my wordpress & site url before

BUT www wasn’t in the thousands of urls under wp_posts

AND www is the root directory in FTP …

Any suggestions? Shouldn’t everything be consistent?

I see the change in wp_posts and wp_options though, but chaos still reigns online…

Deleting htaccess and then re-saving things (re-writing it) at Dashboard > Settings > Permalinks might fix that or at least help a bit, and then there is also the matter of whether you have cleared your browser cache and/or have any site-wide cache in place.

www was in my wordpress & site url before

BUT www wasn’t in the thousands of urls under wp_posts

AND www is the root directory in FTP …

Any suggestions? Shouldn’t everything be consistent?

Yes, you want to use either www or non-www everywhere, and I do not know what you mean by “www is the root directory in FTP” unless you might be speaking of your “public root” directory that just happens to have that name…and that would have nothing to do with your actual URL. For me that directory is ‘public_html’, and for others it is ‘htdocs’ or whatever.

To get everything straight, first be certain you have what you actually want — www or non-www — in all places throughout your database. After that, htaccess is where either can be redirected to the other so WordPress will only ever receive what is actually being expected by your database and will only use (for finding things) what actually works at your site.

I changed everything to www again because I know the permalinks were with www.

www is also showing in wp_options in such fields: /hp/ce/ad/ig/www/wp-content/uploads/et_temp

But it’s probably like you said with FTP: ‘public root’ that happens to have that name
===========
NOW, I am using the divi theme by elegant themes and when I go into WP, there is absolutely NO content or page builder in pages/posts… Nothing.

I have the sneaky suspicion that the FTP backup from my provider was missing information as there were some images missing. Could there have been important information missing or is all the text content in the DB? I moved the backup files and erased everything in /relaunch once I saw it was working, ’cause it was working in chrome at first…

NOW, I am using the divi theme by elegant themes and when I go into WP, there is absolutely NO content or page builder in pages/posts… Nothing.

Support for that theme and its functions will have to come from its source:
https://www.elegantthemes.com/gallery/divi/

Could there have been important information missing [from the FTP backup from my provider] or is all the text content in the DB?

As far as I know, all pages, posts and such are only in the database and then all uploads are in /wp-content/.

note: At my own site, however, I recently discovered some things were confused by having revisions and “trash” (deleted things still) in the database, and I used ‘WP Clean Up’ to clear everything:
https://www.ads-software.com/plugins/search.php?q=WP+Clean+Up
However, doing something like that might or might not make any difference for you.

The only other possibility I know about here would be if your theme or any plugin might be using “absolute server path” and now needs to be uninstalled and then re-installed so it can reset itself in order to find things in their new location.

An afterthought: Take a close look at cPanel > File Manager to see whether you have a /public_html/ (or /htdocs/) folder. At my own host three years ago, I had been working in /www/ and a Support Tech told me I should only be working in /public_html/. I do not know what difference that makes, but /public_html/ (or /htdocs/), if you have one, would be your actual “public root” at server level.

Thanks! I’ve been in contact with divi support since yesterday as well, but they keep suggesting migration plugins which isn’t exactly what I need… You were the only one so far who has been able to help me, so that you from the bottom of my heart!

I will look into my plugins and file mgr. now… That sounds like a provider thing as it was set up from them, but as I wrote earlier, they were of NO help whatsoever and quite rude about it too…

divi support…they keep suggesting migration plugins which isn’t exactly what I need…

Not at this point anyway! Also, and while there certainly are plugins that can move sites, at least one of them specifically cautions that it is not for the novice.

provider…they were of NO help whatsoever and quite rude about it too…

As far as I know, “moving WordPress” is not in the job description for the typical Support Tech…but I have occasionally happened to get one who knows WordPress well and was willing to help.

yup, I wouldn’t want to touch some of those plugins…

no, it’s not in the provider’s skill set, but the first guy was very helpful, but when I called back, it was someone else and he was not helpful, even when I was trying to figure out why their automatic backups weren’t complete…

I started a support ticket (not free) at fixrunner.com, so am waiting for an answer from them. It’s my last hope/chance as I spent literally months on my new design and it looked great and I’d crumble if I had to redo it… cross your fingers for me please! :/

Thanks again for your kind support!

I made the mistake of erasing the folder ‘relaunch’ in my ftp program because I had a backup on my computer, BUT I just now realized that the backup is missing stuff, such as images under wp-content/uploads… SO, if images are missing, I’m afraid more important stuff is also missing…

Believe me, I know the feeling. Some time ago I was doing some re-installing here in my multi-boot system and deleted my entire /siteworks/ partition while thinking I had a backup elsewhere…but I did not. I now have backups in three places.

My best to you as you hopefully get it all sorted.

Thank you. I was just contacted by the fixrunner’s support team and I went to set them up as a new user and my user field is BLANK. I’m not even listed as a user in WP anymore… oh boy, I don’t even know if they can help me… I don’t want to give them my login, yikes!

If I were you, I would make certain I had these backups stored in a safe place:

current SQL database export
previous (relaunch) SQL database export
current/previous /wp-content/ folder and contents
current wp-config.php file
current .htaccess

Then at that point I would delete everything from “public root” other than your current /wp-content/ folder and contents and your wp-config.php file.

Following that, I would download and unzip a fresh copy of WordPress and then upload everything other than /wp-content/.

I would next drop all tables from your database and then re-import your previous (relaunch) backup and then again do the SQL update for your URL in one shot.
note: I am hoping all the poking around is what broke your user entries and/or whatever else is not working.

Option Two: *Copy* (do not move) things back to /relaunch/ as they were (including database) and get that working again to see what you have. If that looks better than at present, then use Dashboard > Settings > General to make the URL change and then go back out to ‘https://www.jessicavoiceover.com’ and see what you have.
note: To actually do that safely, I would first add another database (assigning the same SQL user) for /relaunch/ and then edit the wp-config for /relaunch/ to only use that new database.

edit: Off to take a nap!