• Welcome to Simple Machines Community Forum. Please login or sign up.
September 19, 2021, 10:42:10 AM

News:

Follow SMF on Twitter.


SQL

Started by Preacher Rick, June 16, 2021, 12:12:06 PM

Previous topic - Next topic

Preacher Rick

Hi all this is the first time i have run into this problem on moving server i backed up my database and then put my url over to the new server
then droped Sql data on the new server then imported old data base and this is what i get when i go to the url please can you try to help me please

Sir Osis of Liver

Do you see the table in the database?
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Preacher Rick

hi yes it does this wheater i leave the new setting in the database or not

Sir Osis of Liver

 ? Don't know what that means.  The error indicates forum is connecting to database but table is missing.  Are the tables in the database?  There should be 63 tables minimum.  Is table prefix correct?
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Preacher Rick

i intalled fresh smf on new server then i droped all areas in sql database and then imported the database from old sever now no matter wheater i leave the new settings file there or not i get that message

KittyGalore

June 16, 2021, 01:16:57 PM #5 Last Edit: June 16, 2021, 01:29:59 PM by KittyGalore
Quote from: Preacher Rick on June 16, 2021, 12:12:06 PM
Hi all this is the first time i have run into this problem on moving server i backed up my database and then put my url over to the new server
then droped Sql data on the new server then imported old data base and this is what i get when i go to the url please can you try to help me please
How did you backup the database through the admin panel or from the server. Because if you done it from the admin panel it might explain why some tables are missing as it's not reliable to backup through the admin panel.
SMF Curve 2.0x

Kindred

1- you imported the contents of the old database to the new database?

As indicated -- confirm that ALL tables are actually present.

2- Did you confirm that your Settings.php actually HAS the correct connection information?

3- Did you update all of the PATHs and URLs in the database to match your new server (using repair_settings.php)?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Preacher Rick

hi
i have moved forums to different servers over the years and never have had this problem
if i message you with details can you please help me please

Sir Osis of Liver

If you can pm cpanel access (url/user/pw) I'll have a look.  Would also help if you can upload database dump somewhere where I can get it.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Advertisement: