HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Get Involved
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Wed Nov 09, 2016 5:29 pm

I'm try this solutions, they are not working for me.
viewtopic.php?f=466&t=2349671

Support Request Template
What version of phpBB are you using? phpBB 3.1.10
What is your board's URL? Private
Who do you host your board with? Private
How did you install your board? I used the download package from phpBB.com (https://www.phpbb.com/downloads/#install)
https://www.phpbb.com/support/docs/en/3 ... /upgrade3/
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? Yes
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.0.14
What styles do you currently have installed? SE Gamer Dark
What language(s) is your board currently using? British English
Which database type/version are you using? Database Settings
Database system: MySQL(i) 5.6.33-cll-lve
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Nothing
Please describe your problem. I followed steps provided by phpBB and once I got to /install/database_update.php it said successful but I just get a white page saying Error 500 on it.

My servers meets the requirements for running phpBB 3.1. I can't upgrade current board but i can install a fresh board to my server without any problem.
I think, update_database.php not working properly. I think, i should update my board database manually. Here my support info:
Anonymous User
Constant user_id: 1
DB user_id: 1
Username: Anonymous
Style used: SE Gamer Dark : style_id: 2
Group(s):
Guests

Anti-Spam Measures
Authentication method: db
Spambot countermeasures for registrations: Yes
Account activation: By user (email verification)
New member post limit: 3
Spambot Countermeasure: Q&A CAPTCHA Plugin
GD library version: bundled (2.1.0 compatible)
GD Image (.png) support: Yes
PHP imagecreatetruecolor() exists: Yes
Username length: 3 min 20 max
Username characters: Any letter and number
Password length: 6 min 100 max
Password complexity: No requirements
Force password change: Disabled
Allow email address re-use: No
Banned IPs: 1
Banned Email Addresses: 0
Port 43 to whois.arin.net is open.

Attachments
Allow attachments: Yes
Allow attachments in PMs: No
Upload directory: /files/
Upload directory permissions: 755
Attachment display order: Descending
Size of posted attachments: 0 BYTES
Total attachment quota: 2 MIB
Maximum file size of 256 KIB less than estimated server PHP limit of 128 MIB
Maximum file size PMs: 256 KIB
Maximum attachments per post: 3
Maximum attachments per PM: 1
Check file mimetype: Yes
Secure downloads: No
Image attachments
Display images inline: Yes
Create thumbnail: No
Imagemagick path:
Maximum image dimensions: 0 × 0 px (width × height)
Image link dimensions: 0 × 0 px (width × height)


AutoMOD Settings
/includes/functions_mods.php not found
AutoMOD is not correctly installed

Avatar Settings
Enable avatars: Yes
Gallery avatars: Yes
Remote avatars: Yes
Avatar uploading: No
Remote avatar uploading: No
Maximum avatar file size: 87.89 KIB
Minimum avatar dimensions: 100 × 100 px (width × height)
Maximum avatar dimensions: 100 × 100 px (width × height)
Avatar storage path: images/avatars/upload
Avatar storage folder permissions: 755
Avatar gallery path: images/avatars/gallery
Avatar gallery folder permissions: 755
Can upload avatar: No

Cookie Settings
Cookie domain: __PRIVATE__.com
Cookie name: phpbb3_qlub9
Cookie path: /
Cookie secure: No

DB cookie_domain: __PRIVATE__.com
DB cookie_name: phpbb3_qlub9
DB cookie_path: /
DB cookie_secure: 0

Database Settings
Database system: MySQL(i) 5.6.33-cll-lve
Database size: 3.97 MIB
Database host: localhost
Database port:
Database name: __PRIVATE__name
Database user: __PRIVATE__user
Database password: {removed}
Table prefix: phpbb_
Cache ($acm_type): file
PHP extensions ($load_extensions):
config.php line count: 16 (1 lines more than standard)
Storage engine posts table: InnoDB
Storage engine sessions table: InnoDB

Email Settings
Enable board-wide e-mails: Enabled
Users send e-mails via board: Disabled
E-mail function name: mail
E-mail package size: 20
E-mail chunk size: 50
E-mail queue interval: 60 secs
Contact e-mail address: contact@__PRIVATE__.com
Contact name:
Return e-mail address: contact@__PRIVATE__.com
Hide e-mail addresses: Yes
Use SMTP server for e-mail: Yes
SMTP server address: localhost
SMTP server port: 587
Authentication method for SMTP: Plain
SMTP username: ********@__PRIVATE__.com
SMTP password: ************ (12 characters)

Ext composer.json location

File Check
Check first 5 characters of PHP files (should be: <?php)
./bin/phpbbcli.php first 5 characters: #!/us : NOT correct

File check finished in: 0.23 seconds (wall-clock time)

Paths and Permissions
$phpbb_root_path: ./
Path to this file: /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/support_info.php
/install/ directory exists
Enable URL Rewriting: No
mod_rewrite enabled
Post icons path: images/icons
Post icons folder permissions: 755
Ranks path: images/ranks
Ranks folder permissions: 755
Smilies path: images/smilies
Smilies folder permissions: 755
config.php permissions: 644
/adm/index.php permissions: 644
/includes/startup.php permissions: 644
/includes/captcha not found
/cache/ permissions: 755
/files/ permissions: 755
/store/ permissions: 755
/store/mods/ not found

PHP Values
PHP version: 5.5.38
PHP safe mode: Off
zlib.output_compression: Off
upload_max_filesize: 128 MIB
post_max_size: 128 MIB
memory_limit: 2 GIB
∴ Estimated maximum file upload size: ≤ 128 MIB
max_file_uploads: 20
Max execution time: 3000 secs
Max input time: 6000 secs
max_input_vars: 1000
file_uploads: Enabled
allow_url_fopen: Disabled
imagick PHP extension not available
Check if ImageMagick operating not made, exec() disabled on server
getimagesize remote: Not working
getimagesize local: Not working

Search Settings
Enable search: Yes
User search flood interval: 0 seconds
Guest search flood interval: 0 seconds
Search page system load: 0
Min author name: 3 characters
Max number of keywords: 10
Search result cache: 1800 seconds
Search backend: fulltext_native
Enable fulltext updating: Yes
Min characters indexed: 3
Max characters indexed: 14
Common word threshold: 5%

Server Settings
Force server URL settings: No
phpBB determined server URL settings
Server protocol: http://
Domain name: private
Server port: 80
Script path: /

Server type/version (OS): LiteSpeed
GZip compression enabled: No
Compression available in PHP: Yes
Session IP validation: A.B.C
Validate X_FORWARDED_FOR header: No
Check for valid MX record: Yes
Session length: 3600 secs (60 mins)
Maximum time to submit forms: 7200 secs (120 mins)
Allow persistent logins (autologin): Yes
Custom profile field load settings
Display custom profile fields in memberlist: No
Display custom profile fields in profile: No
Display custom profile fields in topics: No

Styles Info
/styles/prosilver/template/overall_header.html is writable
/images/spacer.gif permissions: 0644
/styles/prosilver/imageset/icon_online.gif could not be found
/styles/prosilver/theme/images/icon_faq.gif permissions: 0644
Default style: prosilver
Override user style: Yes
Recompile stale style components: No
Installed Styles
SE Gamer Dark
prosilver

Version Settings
Board start date: 29 Oct 2014
constants.php version: 3.1.10
Cached version: 3.0.14
DB version: 3.0.14



Here my server error:
2016-11-09 20:22:05.735 [NOTICE] [178.75.65.196:52902] [STDERR] PHP Fatal error: Uncaught exception 'Twig_Error_Loader' with message 'Unable to find template "message_body.html" (looked into: ).' in /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Loader/Filesystem.php:215
#4 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/phpbb/template/twig/environmen in /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Loader/Filesystem.php on line 215
#3 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Environment.php(378): Twig_Environment->getTemplateClass('message_body.ht...', NULL)
#2 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Environment.php(312): Twig_Loader_Filesystem->getCacheKey('message_body.ht...')
#1 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Loader/Filesystem.php(139): phpbb\template\twig\loader->findTemplate('message_body.ht...')
#0 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/phpbb/template/twig/loader.php(107): Twig_Loader_Filesystem->findTemplate('message_body.ht...')


Thank you very much for sparing your time.
Best regards.

Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Fri Nov 11, 2016 12:31 pm

I'm sure, only problem is updating databases.
Any ideas? We can try together.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51865
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Brf » Fri Nov 11, 2016 1:09 pm

Blackquote wrote:

Code: Select all

'Unable to find template "message_body.html
You should uninstall your other style before trying to upgrade.

Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Fri Nov 11, 2016 6:42 pm

Brf wrote:
Blackquote wrote:

Code: Select all

'Unable to find template "message_body.html
You should uninstall your other style before trying to upgrade.
I'm try AGAIN for you. :)
All mods deleted.
Style: prosilver.
Phpbb vers.: 3.0.14
Same HTTP 500 error. Here my server error logs after update:
2016-11-11 21:39:19.605 [NOTICE] [212.252.64.160:38383] [STDERR] PHP Fatal error: Uncaught exception 'Twig_Error_Loader' with message 'Unable to find template "message_body.html" (looked into: ).' in /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Loader/Filesystem.php:215
#4 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/phpbb/template/twig/environmen in /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Loader/Filesystem.php on line 215
#3 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Environment.php(378): Twig_Environment->getTemplateClass('message_body.ht...', NULL)
#2 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Environment.php(312): Twig_Loader_Filesystem->getCacheKey('message_body.ht...')
#1 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/vendor/twig/twig/lib/Twig/Loader/Filesystem.php(139): phpbb\template\twig\loader->findTemplate('message_body.ht...')
#0 /home/__PRIVATE__/public_html/__PRIVATE__.com/forum/forumpage/phpbb/template/twig/loader.php(107): Twig_Loader_Filesystem->findTemplate('message_body.ht...')
This time database update is successful (i guess :) ).
Here my support_info.php after update:
Anonymous User
Constant user_id: 1
DB user_id: 1
Username: Anonymous
Style used: prosilver : style_id: 1
Group(s):
Guests

Anti-Spam Measures
Authentication method: db
Spambot countermeasures for registrations: Yes
Account activation: By user (email verification)
New member post limit: 3
Spambot Countermeasure: Q&A CAPTCHA Plugin
GD library version: bundled (2.1.0 compatible)
GD Image (.png) support: Yes
PHP imagecreatetruecolor() exists: Yes
Username length: 3 min 20 max
Username characters: Any letter and number
Password length: 6 min 100 max
Password complexity: No requirements
Force password change: Disabled
Allow email address re-use: No
Banned IPs: 1
Banned Email Addresses: 0
Port 43 to whois.arin.net is open.

Attachments
Allow attachments: Yes
Allow attachments in PMs: No
Upload directory: /files/
Upload directory permissions: 755
Attachment display order: Descending
Size of posted attachments: 0 BYTES
Total attachment quota: 2 MIB
Maximum file size of 256 KIB less than estimated server PHP limit of 128 MIB
Maximum file size PMs: 256 KIB
Maximum attachments per post: 3
Maximum attachments per PM: 1
Check file mimetype: Yes
Secure downloads: No
Image attachments
Display images inline: Yes
Create thumbnail: No
Imagemagick path:
Maximum image dimensions: 0 × 0 px (width × height)
Image link dimensions: 0 × 0 px (width × height)


AutoMOD Settings
/includes/functions_mods.php not found
AutoMOD is not correctly installed

Avatar Settings
Enable avatars: Yes
Gallery avatars: Yes
Remote avatars: Yes
Avatar uploading: No
Remote avatar uploading: No
Maximum avatar file size: 87.89 KIB
Minimum avatar dimensions: 100 × 100 px (width × height)
Maximum avatar dimensions: 100 × 100 px (width × height)
Avatar storage path: images/avatars/upload
Avatar storage folder permissions: 755
Avatar gallery path: images/avatars/gallery
Avatar gallery folder permissions: 755
Can upload avatar: No

Cookie Settings
Cookie domain: PRIVATE.com
Cookie name: phpbb3_qlub9
Cookie path: /
Cookie secure: No

DB cookie_domain: PRIVATE.com
DB cookie_name: phpbb3_qlub9
DB cookie_path: /
DB cookie_secure: 0

Database Settings
Database system: MySQL(i) 5.6.33-cll-lve
Database size: 3.65 MIB
Database host: localhost
Database port:
Database name: PRIVATE_db_name
Database user: PRIVATE_user_name
Database password: {removed}
Table prefix: phpbb_
Cache ($acm_type): file
PHP extensions ($load_extensions):
config.php line count: 16 (1 lines more than standard)
Storage engine posts table: InnoDB
Storage engine sessions table: InnoDB

Email Settings
Enable board-wide e-mails: Enabled
Users send e-mails via board: Disabled
E-mail function name: mail
E-mail package size: 20
E-mail chunk size: 50
E-mail queue interval: 60 secs
Contact e-mail address: contact@PRIVATE.com
Contact name:
Return e-mail address: contact@PRIVATE.com
Hide e-mail addresses: Yes
Use SMTP server for e-mail: Yes
SMTP server address: localhost
SMTP server port: 587
Authentication method for SMTP: Plain
SMTP username: ********@PRIVATE.com
SMTP password: ************ (12 characters)

Ext composer.json location

File Check
Check first 5 characters of PHP files (should be: <?php)
./bin/phpbbcli.php first 5 characters: #!/us : NOT correct

File check finished in: 0.22 seconds (wall-clock time)

Other Stats
Total files (not just .php files): 2124
Rows in sessions table: 6
Rows in sessions_keys table: 61
Number of users (config table): 22
Number of users (users table): 24
Number of topics (config table): 34
Number of topics (topics table): 34
Number of posts (config table): 72
Number of posts (posts table): 72
Maximum user_id: 93
Next auto_increment user_id: 94
Language(s) installed:
British English
Turkish

Paths and Permissions
$phpbb_root_path: ./
Path to this file: /home/PRIVATE/public_html/PRIVATE.com/forum/forumpage/support_info.php
/install/ directory exists
Enable URL Rewriting: No
mod_rewrite enabled
Post icons path: images/icons
Post icons folder permissions: 755
Ranks path: images/ranks
Ranks folder permissions: 755
Smilies path: images/smilies
Smilies folder permissions: 755
config.php permissions: 644
/adm/index.php permissions: 644
/includes/startup.php permissions: 644
/includes/captcha not found
/cache/ permissions: 755
/files/ permissions: 755
/store/ permissions: 755
/store/mods/ not found

PHP Values
PHP version: 5.5.38
PHP safe mode: Off
zlib.output_compression: Off
upload_max_filesize: 128 MIB
post_max_size: 128 MIB
memory_limit: 2 GIB
∴ Estimated maximum file upload size: ≤ 128 MIB
max_file_uploads: 20
Max execution time: 3000 secs
Max input time: 6000 secs
max_input_vars: 1000
file_uploads: Enabled
allow_url_fopen: Disabled
imagick PHP extension not available
Check if ImageMagick operating not made, exec() disabled on server
getimagesize remote: Not working
getimagesize local: Not working

Search Settings
Enable search: Yes
User search flood interval: 0 seconds
Guest search flood interval: 0 seconds
Search page system load: 0
Min author name: 3 characters
Max number of keywords: 10
Search result cache: 1800 seconds
Search backend: fulltext_native
Enable fulltext updating: Yes
Min characters indexed: 3
Max characters indexed: 14
Common word threshold: 5%

Server Settings
Force server URL settings: No
phpBB determined server URL settings
Server protocol: http://
Domain name: forum.PRIVATE.com
Server port: 80
Script path: /

Server type/version (OS): LiteSpeed
GZip compression enabled: No
Compression available in PHP: Yes
Session IP validation: A.B.C
Validate X_FORWARDED_FOR header: No
Check for valid MX record: Yes
Session length: 3600 secs (60 mins)
Maximum time to submit forms: 7200 secs (120 mins)
Allow persistent logins (autologin): Yes
Disabled module(s): acp: :
Disabled module(s): acp: :
Custom profile field load settings
Display custom profile fields in memberlist: No
Display custom profile fields in profile: No
Display custom profile fields in topics: No

Styles Info
/styles/prosilver/template/overall_header.html is writable
/images/spacer.gif permissions: 0644
/styles/prosilver/imageset/icon_online.gif could not be found
/styles/prosilver/theme/images/icon_faq.gif permissions: 0644
Default style: prosilver
Override user style: Yes
Recompile stale style components: No
Installed Styles
prosilver

Version Settings
Board start date: 29 Oct 2014
constants.php version: 3.1.10
Cached version: 3.1.10
DB version: 3.1.10

Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Sun Nov 13, 2016 4:33 pm

I'm google it and read every topic in this forum but i can't solve the problem. Would you help me please?

Tarantino
Registered User
Posts: 758
Joined: Sat Feb 18, 2012 1:51 pm
Contact:

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Tarantino » Mon Nov 14, 2016 12:30 pm

Clean your cache manually and change the default style for a 3.1 style.

Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Tue Nov 15, 2016 12:32 pm

Tarantino wrote:Clean your cache manually and change the default style for a 3.1 style.
Thanks for reply but I'm try it already (many times). And my board style is prosilver. I'm desperate. :(

Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Wed Nov 16, 2016 4:44 am

Problem solved by leimad4mind.
Thanks a lot.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66727
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Lumpy Burgertushie » Wed Nov 16, 2016 5:02 am

who is that and how was the problem solved?

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Blackquote
Registered User
Posts: 8
Joined: Wed Nov 09, 2016 4:51 pm

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Blackquote » Thu Nov 17, 2016 11:33 am

Lumpy Burgertushie wrote:who is that and how was the problem solved?

robert
He's a freelance programmer.
He said that:
...you didn't clean the board properly (cleaning the database tables from 3.0 mods) there was like 20 columns at total that wasn't from 3.0 clean installation...

User avatar
Lumpy Burgertushie
Registered User
Posts: 66727
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: HTTP ERROR 500 | Upgrading from 3.0.14 to 3.1.10

Post by Lumpy Burgertushie » Thu Nov 17, 2016 4:21 pm

thanks, that makes sense.
I believe that the official instructions should include using the stk to clean the database before running the update. the set of instructions that many of us use has that in them.

Upgrading from phpbb 3.0.x to phpbb 3.1.x
  • Your server must be running at least PHP 5.3.3 and less than PHP 7
  • Most MODs for 3.0.x are incompatible with 3.1.x and their functionality will be removed in the update process.
  • Styles for 3.0.x cannot be installed or used on 3.1.x.
  1. Backup up your board's files and database
  2. Download the Support Toolkit. Install it and run the database cleaner to remove all old MODs from the database.
  3. Deactivate all styles except for prosilver
  4. Ensure that the activated spambot countermeasure is one of the standard phpBB plugins (Simple image, GD image, GD 3D image, Q&A, reCaptacha).
  5. Set British English as the only language pack
  6. Delete all of your phpBB 3.0.x files EXCEPT for the following:
    • The config.php file
    • The /images/ directory
    • The /files/ directory
  7. Upload the contents of the phpBB3 directory from the uncompressed 3.1.x Full Package (EXCEPT for config.php) into your forum's directory (Note: you don't want to overwrite your original config.php file)
  8. Browse to yourdomain.com/yourphpbb/install/database_update.php and keep clicking the continue button until it says it is finished. This will take a long time on a large board, maybe hours. Dont give up.
  9. Delete the folder named /install/
  10. Hold one foot in the air and spin around in a circle three times saying "I am a phpbb guru".
(#10 is not optional, things just won't work right without that step. I mean it, for real.... )
robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Locked

Return to “[3.1.x] Support Forum”