3.24 -> 3.25 update error (SOLVED!)

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

3.24 -> 3.25 update error (SOLVED!)

Post by Tom Wells » Fri Dec 28, 2018 10:18 pm

In trying to update from 3.24 to 3.25, I got into a permissions problem with my Debian Stretch server. After finally making the root directory, / , executable I could get the update process started by pointing my browser to the install directory.

I have copied all the new 3.25 files in, kept my files directory and the others not needing overwriting, and am now trying to update the data base. When I select Update Database, I get a big red error box:

Code: Select all

General Error:SQL ERROR [ mysqli ]No such file or directory [2002] in file /var/www/phpBB3/phpbb/db/driver/driver.php on line 997

BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: installer_msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 439
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1056
CALL: phpbb\db\driver\driver->sql_transaction()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 444
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 1001
CALL: phpbb\db\tools\tools->sql_create_table()

FILE: [ROOT]/phpbb/install/module/update_database/task/update.php
LINE: 134
CALL: phpbb\db\migrator->create_migrations_table()

FILE: [ROOT]/phpbb/install/module_base.php
LINE: 149
CALL: phpbb\install\module\update_database\task\update->run()

FILE: [ROOT]/phpbb/install/installer.php
LINE: 219
CALL: phpbb\install\module_base->run()

FILE: [ROOT]/phpbb/install/controller/update.php
LINE: 133
CALL: phpbb\install\installer->run()

FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.php
LINE: 111
CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()

FILE: [ROOT]/vendor/symfony/http-foundation/Response.php
LINE: 383
CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()

FILE: [ROOT]/install/app.php
LINE: 62
CALL: Symfony\Component\HttpFoundation\Response->send()
BTW I checked. The files appear to all be there.

Below that is a skip list:

Skip “installer.update_filesystem.download_updated_files” task
Skip “installer.update_filesystem.update_files” task
Skip “installer.update_filesystem.show_file_status” task
Skip “installer.update_filesystem.diff_files” task
Skip “installer.update_filesystem.check_task” task
Skip “installer.obtain_data.update_ftp_settings” task
Skip “installer.obtain_data.update_files” task
Skip “installer.obtain_data.file_updater_method” task

Another odd symptom is that the phpBB3 is redirected to another page (Mozilla tells me so) if I point it at the install directory; if I point the browser at the web site (no install directory, just the web site) I get a similar error to the data base update error - at least it looks like the same error code of 2002:

Code: Select all

General Error
SQL ERROR [ mysqli ]
No such file or directory [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Also, when the data base update screen appears,it has an orange header stating: No valid update directory was found, please make sure you uploaded the relevant files.


I confess to trying various edits to Debian permissions and Apache2 config files prior to the root directory change which got me (I think) a step closer to success, so I may have dislocated some directory reference...

Any thoughts about how to correct this?

Thanks,

Tom
Last edited by Tom Wells on Sat Dec 29, 2018 1:44 am, edited 1 time in total.

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2386
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: 3.24 -> 3.25 update error

Post by kinerity » Fri Dec 28, 2018 10:40 pm

Are you following these instructions? Knowledge Base - Updating 3.2.x
Kailey Truscott - Community Team

Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

Re: 3.24 -> 3.25 update error

Post by Tom Wells » Fri Dec 28, 2018 10:53 pm

Yes I followed those instructions as literally as I could. When I got to step 10 things went awry.

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2386
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: 3.24 -> 3.25 update error

Post by kinerity » Fri Dec 28, 2018 11:07 pm

I seem to remember someone else having a similar issue. If I remember correctly, all they did was delete everything in the cache directory except the .htaccess and index.htm files. Give that a shot.
Kailey Truscott - Community Team

Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

Re: 3.24 -> 3.25 update error

Post by Tom Wells » Fri Dec 28, 2018 11:15 pm

There were two directories in the cache directory, both empty: installer and production, along with the two files .htaccess and index.htm. I deleted the directories and tried the update again. Same result.

The two empty directories are back, but no other change I could see.

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10347
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: 3.24 -> 3.25 update error

Post by Noxwizard » Fri Dec 28, 2018 11:20 pm

Check your settings in config.php. From the error message, it's saying that it can't connect to the database.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

Re: 3.24 -> 3.25 update error

Post by Tom Wells » Fri Dec 28, 2018 11:53 pm

I didn't change anything that I'm aware of w/respect to the config.php or its executable or data locations.

At the top of the file there's a reference to having been auto-generated with phpBB 3.1.x

I've checked the file locations in the config.php by looking for the files referenced in the directories they point to. They all seem to be there.

My hunch is that I've changed something in Debian Stretch 9 or Apache2 2.4 that has the phpBB3 software looking in the wrong places for those files. In other words, something translates the phpBB3 file references to be offset by one directory if that makes any sense.

Here's a little clue, maybe: if I go to the introduction directly, and hover over the installation guide, my screen shows this URL at the bottom: http://www.firstcoastcobraclub.com/docs/INSTALL.html

If I then click on the update button, and go back to the previous screen after the errors appear that were mentioned in my first post, hover over the same installation guide, the URL has changed to: [b]http://www.firstcoastcobraclub.com/install/docs/INSTALL.html[/b]

It's as if the install directory has been inserted into the URL

Hope this helps,

Tom
Last edited by stevemaury on Sat Dec 29, 2018 12:40 am, edited 1 time in total.
Reason: Added [c] tags so url can be read

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50894
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: 3.24 -> 3.25 update error

Post by stevemaury » Sat Dec 29, 2018 12:43 am

Give us your database host name, your database port, your database name, your database prefix and your database username. Then post your config.php file without the password.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

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

Re: 3.24 -> 3.25 update error

Post by 3Di » Sat Dec 29, 2018 1:04 am

I see that
No valid update directory was found, please make sure you uploaded the relevant files.
Surfing to http://www.firstcoastcobraclub.com/install/app.php/update from http://www.firstcoastcobraclub.com/install/
tmp_1.png
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
✒️ Black Friday 2019 @ The Studio ▪️◾️

Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

Re: 3.24 -> 3.25 update error

Post by Tom Wells » Sat Dec 29, 2018 1:09 am

config.php:

<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'phpbb3';
$dbuser = 'phpbb3user';
$dbpasswd = '12345';
$table_prefix = 'p3_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';

@define('PHPBB_INSTALLED', true);
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
// @define('DEBUG', true);
// @define('DEBUG_CONTAINER', true);


No expert here, but I think these are the other items you asked for:
Port is 3306
Database name is phpbb3
Username is phpbb3user
Hostname is localhost

If these aren't the right ones, I may need to see what to do to find them!

Tom

Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

Re: 3.24 -> 3.25 update error

Post by Tom Wells » Sat Dec 29, 2018 1:14 am

3Di,

This error message is part of what I don't understand...

I have taken the new files from the downloaded package and copied them over the existing files as instructed. No idea why they can't be found.

Something seems to be pointing the phpBB3 software elsewhere than it is supposed to be looking.

Possibly something I changed in the Apache2 configuration, or the Debian system itself.

Tom

Tom Wells
Registered User
Posts: 12
Joined: Tue Aug 28, 2012 7:04 pm

Re: 3.24 -> 3.25 update error

Post by Tom Wells » Sat Dec 29, 2018 1:25 am

Nox & Steve,

Got it!

The mysql was not running. I started it and everything works!

Thank you both for pointing me in that direction!

Tom

Post Reply

Return to “[3.2.x] Support Forum”