Transferring to Another Host

[keng_113]

Thanks, Illori.

I was able to upload the database successfully

Code Select Expand

Import has been successfully finished, 545 queries executed. (b7_13485051_pinoyshoegame.sql).

However i'm still having problems. To give you guys a detailed info on the things I did:

1. upload files to new host: uploaded it to both 'www' and 'public_html' (not sure where to upload it)
2. upload database file. I created a new database then upload the .sql file from my original forum
3. uploaded repair_settings.php but when I access it thru pinoyshoegame.org/repair_settings.php I get this error:

Code Select Expand

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Thank you!

[keng_113]

Hi everyone, thanks for being patient with me.

I no longer receive that error whenever I try to visit my site after changing permissions to the folder. This is what I receive now:

Code Select Expand

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

When i try to access pinoyshoegame.org/repair_settings.php this error shows up:

Code Select Expand

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/pinoysho/public_html/repair_settings.php on line 336

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/pinoysho/public_html/repair_settings.php on line 338

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/pinoysho/public_html/repair_settings.php on line 353

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/pinoysho/public_html/repair_settings.php on line 355

Notice: Undefined index: database_error in /home/pinoysho/public_html/Sources/Subs-Db-mysql.php on line 572

Fatal error: Call to undefined function allowedTo() in /home/pinoysho/public_html/Sources/Subs-Db-mysql.php on line 573

[Sir Osis of Liver]

Attach the repair_settings.php you're using.

[keng_113]

Attach the repair_settings.php you're using.

Here it is. Thanks a lot!

[Sir Osis of Liver]

The functions that are failing are called from /Sources/Subs-Db-mysql.php.  Try uploading a clean copy from the upgrade or install package.

[keng_113]

The functions that are failing are called from /Sources/Subs-Db-mysql.php.  Try uploading a clean copy from the upgrade or install package.

Do you mean the whole package? or just this single file?

I uploaded a fresh copy but I don't see that something has changed.

[Sir Osis of Liver]

Don't think it'll help, but try this older version of repair_settings.php.

[keng_113]

Don't think it'll help, but try this older version of repair_settings.php.

Wow. I think that worked. I just need to update the MySQL Database Info. I'm not sure what credentials to use, will it the old one from my host? or the new one on this current host? These are for: MySQL database name, username, password, table prefix, etc.

Thanks!!

[Sir Osis of Liver]

It worked because the newer version of repair_settings.php tries to fix the theme url's, and that's the bit that was causing the errors, no idea why.  The older version does not touch theme paths, so you may have to reset them in Admin -> Themes and Layout -> Theme Settings.  The reset button is at the bottom.  If it doesn't work, you can manually edit the paths by clicking on theme names.

Settings.php requires the database info for the new database on the new host.  Your old database has been imported into the new db, and you have to connect your forum to it.

[Sir Osis of Liver]

 
TAKE THAT LINK OFF YOUR POST.  Anyone can use it to screw with your settings.  And don't forget to delete repair_settings.php when you're done.

[keng_113]

It worked because the newer version of repair_settings.php tries to fix the theme url's, and that's the bit that was causing the errors, no idea why.  The older version does not touch theme paths, so you may have to reset them in Admin -> Themes and Layout -> Theme Settings.  The reset button is at the bottom.  If it doesn't work, you can manually edit the paths by clicking on theme names.

Settings.php requires the database info for the new database on the new host.  Your old database has been imported into the new db, and you have to connect your forum to it.

Hmm sorry. you mean I will need both? What will I input in the MySQL Database Info in the repair_settings.php page? Thank you..

[Sir Osis of Liver]

No, the old db settings are irrelevant now.  From earlier posts, looks like you've successfully imported the old db to the new one on your new host.  You need the new credentials for the new db.  SMF needs that info to connect to the db.

[Chalky]

keng_113, I've removed your attachment because database settings and passwords were in clear view.  Please be careful to obscure any sensitive information before posting things like that.

[keng_113]

keng_113, I've removed your attachment because database settings and passwords were in clear view.  Please be careful to obscure any sensitive information before posting things like that.

Sorry about that.

It seems like I can't set up my MySQL info. It give me this error:

Code Select Expand

Some settings are not being shown because the MySQL connection information is incorrect.


I'm quite sure about all my credentials except the MySQL table prefix.

Thanks again.

[Arantor]

You don't have, say, an apostrophe inside the MySQL password, do you?

[keng_113]

You don't have, say, an apostrophe inside the MySQL password, do you?

No.

By the way, how will I know my MySQL prefix? I'm suspecting that there is where I got it wrong

[Arantor]

The prefix is whatever is in the tables' names.

For example, there is a table called admin_info_files, and is the first table in the list normally. If your database contains a table called smf_admin_info_files, the prefix will be smf_ and that's the default normally.

[keng_113]

I got the table prefix right. I'm wondering what's causing the problem. I'm stuck whit this.

[Tony Reid]

Just a thought - Is your db server localhost - or are you on a hosting plan that has the mysql server somewhere else?

Also, after this is resolved - please change all your passwords as you have exposed them all in this thread, including the repair_settings files.

[keng_113]

Just a thought - Is your db server localhost - or are you on a hosting plan that has the mysql server somewhere else?

Also, after this is resolved - please change all your passwords as you have exposed them all in this thread, including the repair_settings files.

I'm not sure about that. As far as I know, it's localhost but I may need to verify that with my host.

With regards to my passwords, thanks, I'll keep that in mind.