Tommy server – Phpbb sql error?

[gringoh]

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

 

 

 

[wolstech]

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.

[gringoh]

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.smekdigital.com/how-to-import-large-mysql-database/

 

https://philiplb.de/sqldumpsplitter3/

 

Thanks,

G