Jump to content


Photo

Tommy server – Phpbb sql error?

Phpbb mysql internal server error localhost tommy

  • Please log in to reply
2 replies to this topic

#1 gringoh

gringoh

    Rank I Member

  • Members
  • Pip
  • 10 posts
  • Gender:Male
  • Location:PARIS

Posted 24 January 2019 - 04:31 PM

Hi,

I am struggling with my Phpbb forum database, any help would be appreciated.

 

- I have uploaded my files by FTP in a directory: public_html/forum

- I have imported my sql backup in PhpMyAdmin

- I have edited my config.php file

 

And I cannot connect to my forum, I have an Internal Server Error:

 

http://greed-is-good.fr/forum/

 

In order to go further and check if I was doing something wrong, I have also installed Phpbb thanks to softaculous, in public_html/phpbb and here it is working fine, but I cannot find where the error is?

 

In the config.php file there are some differences:

 

- Mysql vs mysqli

- @define('PHPBB_ENVIRONMENT', 'production');

 

Even if I change those lines I still have the issue, I also tried to change localhost to 127.0.0.1

 

Any ideas?

Regards,

G

 

 

 



#2 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 11,041 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 24 January 2019 - 04:36 PM

Did you change your file permissions? If you upload your own files, you need to make sure the permissions on them are set to 644. All folders inside of public_html (but not public_html itself) should be 755.

 

When you upload, the folders are usually 775 and the files are 664 by default (note that center number!) and need to be changed. Apache does not like files and folders being writable by the group.


Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#3 gringoh

gringoh

    Rank I Member

  • Members
  • Pip
  • 10 posts
  • Gender:Male
  • Location:PARIS

Posted 25 January 2019 - 08:53 AM

Many thanks for your help, I was so focused on potential problems with the sql database that I have completely forgotten the basics.

 

In case it can help someone, concerning the large sql database issue in PhpMyAdmin (limitation to 50 Mg) I have used a tool to split the sql backup in multiple files which then can be imported in PhpMyAdmin:

 

https://www.smekdigi...mysql-database/

 

https://philiplb.de/sqldumpsplitter3/

 

Thanks,

G







Also tagged with one or more of these keywords: Phpbb, mysql, internal server error, localhost, tommy

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users