[Help] Migrating a Wordpress site - multiple errors

Status
Not open for further replies.
D

disclos2

New Member
Messages
6
Reaction score
0
Points
1
[Solved]

Greetings,
I'm new to these parts and still adjusting. I'm trying to do the first ever migration of my wordpress site. I'm using both to x10 hosting and subdomain.

I followed this tutorial stopping at "Transfer WordPress from wordpress.com"

I have uploaded my entire site to x10 using the public_html folder as the root directory. I have imported my old database successfully. The contents are visable via phpmyadmin. I have changed the values in wp-config.php and used the string 'localhost' as the sql host.

Lastly, I used these functions to update the site location. One thing I don't know about with this step was "add these lines to the functions.php file of your theme." I was using a theme titled Parabolic which wasn't present in the functions.php file by searching. It was a really long file so I put the functions after the first:
<?php...
update_option('siteurl','http://www.new-site-address.com');
update_option('home','http://www.new-site-address.com');

rest of code... Maybe if someone has a keyword I can place them in the right spot?

During the process, the first error was a Database connection. After putting in the update function all I get is a white screen with no text.

many, many, many, many, thanks to you, and <3 + ice cream <#

MpuNSUu.png
 
Last edited:
C

caftpx10

Well-Known Member
Messages
1,534
Reaction score
114
Points
63
Can you show the bottom portion of the popup? All I can see is the status 'ok'.
 
C

caftpx10

Well-Known Member
Messages
1,534
Reaction score
114
Points
63
That's very strange.

Are you attempting to import an .SQL file?
 
Last edited:
D

disclos2

New Member
Messages
6
Reaction score
0
Points
1
caftpx10 said:
That's very strange.

Are you attempting to import the .SQL file?
Click to expand...

The database file was archived when uploaded, titled: u778332875_db.sql.gz. I saw the import process state it accepted archives so I figured I'd try it. Which appeared successful. those previous images are database checks.


This is the contents of that .gz. Getting a gist I should delete the current DB and try this file?
5Fpvrgh.png
 
C

caftpx10

Well-Known Member
Messages
1,534
Reaction score
114
Points
63
Ooo.. You'll need that file.

Okay, so you'll need to switch cPanel "theme" using the option in the header and picking something like cPanelX3 (or whatever it's called), open phpMyAdmin, press the database on the left pane you want to import the data to, press the 'import' tab, pick the SQL file, and upload it.


Oh and before all of that, make sure the database you're wanting to use has no tables in it if you want it to only carry what you have stored in that SQL file.
 
Last edited:
D

disclos2

New Member
Messages
6
Reaction score
0
Points
1
caftpx10 said:
Ooo.. You'll need that file.

Okay, so you'll need to switch cPanel "theme" using the option in the header and picking something like cPanelX3 (or whatever it's called), open phpMyAdmin, press the database on the left pane you want to import the data to, press the 'import' tab, pick the SQL file, and upload it.


Oh and before all of that, make sure the database you're wanting to use has no tables in it if you want it to only carry what you have stored in that SQL file.
Click to expand...

Done. Sadly, same results.

http://disclosure.x10host.com
 
C

caftpx10

Well-Known Member
Messages
1,534
Reaction score
114
Points
63
That's very unusual. It doesn't look like it's something that would be caused by MySQL alone...
 
D

disclos2

New Member
Messages
6
Reaction score
0
Points
1
caftpx10 said:
That's very unusual. It doesn't look like it's something that would be caused by MySQL alone...
Click to expand...

What about the file structure, is this correct? Picture of file manage from cPanel. The folder Public_html contains wp-config.php and the like as well.
0G82m8e.png

I really need to make this work somehow. x10host seems really ideal for this site, even if I have to restart, because it isn't monetizing at the least. It's a place my family can share their experiences and communicate. Which has been great giving us a platform to keep in touch. However, my current host is creating false resource limitations resulting in 500 - Server unreachable errors fishing for that upgrade.
 
Patrick.B

Patrick.B

Member
Messages
96
Reaction score
4
Points
8
disclos2 said:
During the process, the first error was a Database connection. After putting in the update function all I get is a white screen with no text.
Click to expand...

In major time when you get a blank page and assuming the code is in a good shape, is coming from the connection between the webpage and DB.
Check in the code where the Db connection info is stored, if is on linked page, check the link, check the infos.
If not, check the source.
 
D

disclos2

New Member
Messages
6
Reaction score
0
Points
1
Dead-i said:
Hi,

I enabled error reporting for your account, and this error is now showing instead of the blank page:

This article from WordPress might help: https://codex.wordpress.org/Changing_The_Site_URL

Thank you,
Click to expand...

That did the trick!

The solution that worked was, "Changing the URL directly in the database." I removed any defines or updates from wp-config.php and functions.php and just edited those two rows in the database under the wp_options table.

Anyone know why those calls were producing errors? Its like I don't even have functions to parse those calls.

But you people are awesome!!! I'm extremely grateful for your service, assistance, and effort.
 
C

caftpx10

Well-Known Member
Messages
1,534
Reaction score
114
Points
63
It was because update_option() didn't exist at the time you were calling for it.
 
Last edited:
Status
Not open for further replies.
Top