Need some help importing database

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Wed Mar 13, 2019 10:33 pm

Question has been put out to the host some time ago but no response yet.

I found this: https://www.liquidweb.com/kb/apache-err ... nd-solved/

This looks like the problem I seem to be having.
..vaak rankend of klimmend..

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 12:30 am

I fixed the problem. I went through everything and noticed that the final few tables in the database had not imported. I am unsure why, maybe I used a bigdump.php file that I had not correctly edited. Started everything from scratch again:

Image

:)
..vaak rankend of klimmend..

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 12:36 am

And then I'm back where I was yesterday:

Image

Did not the emergency kit message.
..vaak rankend of klimmend..

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 12:42 am

That line in includes/functions.php reads:

Code: Select all

		'S_LOAD_UNREADS'			=> ($config['load_unreads_search'] && ($config['load_anon_lastread'] || $user->data['is_registered'])) ? true : false,
..vaak rankend of klimmend..

User avatar
3Di
Former Team Member
Posts: 13603
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Need some help importing database

Post by 3Di » Thu Mar 14, 2019 12:45 am

Forget for now such error.

New steps:

1 - make a backup of the DB as it is now.

2 - delete all files except for config.php (you already have it)

3 - upload as binary all files from the 3.2.5 package except for config.php

4 - go straight to your_site/install/app.php

5 - wait till the end

6 - In case and before you to proceed with something not in the list pls ASK.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity ΒΊ PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 12:52 am

What does upload as binary mean?

Just FTP'ing all the 3.2.5 files to the root like I did before with 3.0.14 or something different?
..vaak rankend of klimmend..

User avatar
3Di
Former Team Member
Posts: 13603
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Need some help importing database

Post by 3Di » Thu Mar 14, 2019 12:54 am

Yes, just make sure your FTP client has in the settings "transfer files as binary mode" set to ON (yes).
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity ΒΊ PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 12:55 am

Do I need to set this to Binary?

Image
..vaak rankend of klimmend..

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 12:55 am

3Di wrote: ↑
Thu Mar 14, 2019 12:54 am
Yes, just make sure your FTP client has in the settings "transfer files as binary mode" set to ON (yes).
Okay crosspost, check! :)
..vaak rankend of klimmend..

User avatar
3Di
Former Team Member
Posts: 13603
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Need some help importing database

Post by 3Di » Thu Mar 14, 2019 12:59 am

Make it BINARY please, not auto.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity ΒΊ PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 1:04 am

3Di wrote: ↑
Thu Mar 14, 2019 12:45 am
4 - go straight to your_site/install/app.php
There is a black icon swirling for a second and then nothing.
..vaak rankend of klimmend..

User avatar
3Di
Former Team Member
Posts: 13603
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Need some help importing database

Post by 3Di » Thu Mar 14, 2019 1:07 am

Yeah it works, click update.

http://prntscr.com/mxkn47
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity ΒΊ PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 1:09 am

3Di wrote: ↑
Thu Mar 14, 2019 1:07 am
Yeah it works, click update.

http://prntscr.com/mxkmvp
I did and then like I said: black icon for a second and nothing.
..vaak rankend of klimmend..

User avatar
3Di
Former Team Member
Posts: 13603
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Need some help importing database

Post by 3Di » Thu Mar 14, 2019 1:13 am

Another 500 Internal server error, check your error logs.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity ΒΊ PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

User avatar
Nachtschade
Registered User
Posts: 107
Joined: Thu Nov 15, 2012 12:29 am
Location: Netherlands
Name: Marcel

Re: Need some help importing database

Post by Nachtschade » Thu Mar 14, 2019 1:27 am

3Di wrote: ↑
Thu Mar 14, 2019 1:13 am
Another 500 Internal server error, check your error logs.
Still only the same error as earlier today, nothing new was logged.
..vaak rankend of klimmend..

Post Reply

Return to β€œ[3.2.x] Support Forum”