Corrupt my forum upgrading from 3.3.0 to 3.3.1

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Si666
Registered User
Posts: 33
Joined: Sun Jan 21, 2018 3:20 pm

Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Si666 »

Website is ZX14R.co.uk

I tried to update using the Automatic Update
It then got in a loop modifying the files where I downloaded then installed the files, about 20 times.

I then found another post on here which i cant find now which had instructions to do a full restore after the above issue. I think from memory it was a database update.

I seem to now have messed up the database and get the following message

General Error
SQL ERROR [ mysqli ]

Can't connect to MySQL server on '10.169.0.186' (110) [2003]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

I took a full download of the PHPBB3 folder before I started
I also took a full Database backup from the ACP but not sure where that is now. I'm now not convinced this downloaded to my laptop

Is it possible to upload the saved PHPBB3 folder and restore the saved database?

Feeling foolish and deflated now
Siguza
Registered User
Posts: 316
Joined: Wed Apr 22, 2020 10:59 am
Location: Melbourne, Australia
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Siguza »

You should use the Full Package when possible.

The backups are in the /store directory
Si666
Registered User
Posts: 33
Joined: Sun Jan 21, 2018 3:20 pm

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Si666 »

I thought the idea of the Automatic update was to allow extensions to be kept?

I have six backup files in my Store folder. I assume these can be restored from the ACP once i get the forum up and running

Is there a guide to restore a forum please?
Siguza
Registered User
Posts: 316
Joined: Wed Apr 22, 2020 10:59 am
Location: Melbourne, Australia
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Siguza »

No. Automatic update isn't to keep extensions, it's to keep core file modifications.

Regardless of what upgrade method you use, extensions are always kept
Si666
Registered User
Posts: 33
Joined: Sun Jan 21, 2018 3:20 pm

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Si666 »

Thank you thats good to know going forward

I'm just FTPing the old PHPBB3 folder which will take about 3 hours with my internet

I just need to get it restored to 3.3.0
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72344
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by KevC »

The error is suggesting it can't connect to the server with the information that is in the config.php file, not that it's corrupt.

If that information is right ask your hosts if the database server is actually running.

Restoring a database should be the last thing you ever contemplate as most errors will be related to files or the host.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
ssl
Registered User
Posts: 1607
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by ssl »

Hi
If you don't want to deactivate extensions during the update, it is better to use this method than to go through the automatic update.

It is especially important to make sure that the extensions will be compatible with the new version before taking the plunge.

Hope this automatic installation didn't break the file config.php
Last edited by ssl on Thu Aug 20, 2020 10:50 am, edited 1 time in total.
Sorry for my English ... I do my best!

phpBB: 3.3.11 | PHP: 8.2.16
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Siguza
Registered User
Posts: 316
Joined: Wed Apr 22, 2020 10:59 am
Location: Melbourne, Australia
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Siguza »

ssl wrote: Thu Aug 20, 2020 10:48 am It is especially important to make sure that the extensions will be compatible with the new version before taking the plunge.
That is correct.

My board died after I left an ext from 3.3.0 enabled (inactive user manager)
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5871
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by thecoalman »

Si666 wrote: Thu Aug 20, 2020 10:47 am I'm just FTPing the old PHPBB3 folder which will take about 3 hours with my internet
For the directories /images/avatars/ and files/ you only need to upload .htacess and index.htm

For the store folder you only need .htacess, index.htm and the database backup you will be restoring.

The other contents of /images/avatars/ and files/ can be uploaded whenever.

Also note you will need to set the permissions on the cache folder, store, /images/avatars/ and files if you have deleted the existing ones on server.

Also check the options in your FTP program, there is usually a setting for connections. Bump it up to 3. 5MB's of many small files takes a lot longer than one 5MB file because there is a lot of overhead, increasing the connections can increase transfer rate even on slow connection.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
JoshyPHP
Code Contributor
Posts: 1288
Joined: Mon Jul 11, 2011 12:28 am

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by JoshyPHP »

Si666 wrote: Thu Aug 20, 2020 10:33 am I also took a full Database backup from the ACP but not sure where that is now. I'm now not convinced this downloaded to my laptop

Is it possible to upload the saved PHPBB3 folder and restore the saved database?
That sounds like a solid way to lose all of your data forever. Contact your web host and ask them why you can't connect to the database and why the server is unresponsive.

Maybe send them your config.php and ask them whether the credentials are ok.
I wrote the library that handles markup in phpBB 3.2+.
Si666
Registered User
Posts: 33
Joined: Sun Jan 21, 2018 3:20 pm

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Si666 »

Thank you all I will go back to the hosts and check the settings

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysqli';
$dbhost = '10.169.0.186';
$dbport = '';
$dbname = '*******_db1';
$dbuser = '*******_db1';
$dbpasswd = '***********************';

$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>
User avatar
warmweer
Jr. Extension Validator
Posts: 11235
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by warmweer »

Code: Select all

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

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
//@define('DEBUG_CONTAINER', true);
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Si666
Registered User
Posts: 33
Joined: Sun Jan 21, 2018 3:20 pm

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Si666 »

warmweer
Do I need to change

$dbms = 'phpbb\\db\\driver\\mysqli';
$acm_type = 'phpbb\\cache\\driver\\file';
$phpbb_adm_relative_path = 'adm/';

References
Si666
Registered User
Posts: 33
Joined: Sun Jan 21, 2018 3:20 pm

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by Si666 »

I've managed to get the forum sort of running but have the following now

Parse error: syntax error, unexpected 'the' (T_STRING) in /home/e7v3z0y2x6rw/public_html/phpBB3/ucp.php on line 407

Code: Select all

		/**
		* Event to modify the template before listing of friends
		*
		* @event core.ucp_modify_friends_template_vars
		* @var	array	row			friend user row
		* @var	array	tpl_ary		friend template array
		* @var	string	which		friend is 'online' or 'offline'
		*
		* @since 3.2.10-RC1
		* @since 3.3.1-RC1
		*/
		$vars = [
			'row',
			'tpl_ary',
			'which',
		];
		extract($phpbb_dispatcher->trigger_event('core.ucp_modify_friends_template_vars', compact($vars)));

		$template->assign_block_vars("friends_{$which}", $tpl_ary);
	}
	$db->sql_freeresult($result);
Line 407 seems to be the blank line between the extract and the $template
User avatar
warmweer
Jr. Extension Validator
Posts: 11235
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Corrupt my forum upgrading from 3.3.0 to 3.3.1

Post by warmweer »

Navigating to your board I get

Code: Select all

Parse error: syntax error, unexpected ')', expecting end of file in /home/e7v3z0y2x6rw/public_html/phpBB3/includes/startup.php on line 87
I see you used the automatic update.
If you have no file modifications: perform a full package update: https://www.phpbb.com/support/docs/en/3 ... date_full/

after uploading all the files (and before accessing /install): delete the /production and /installer from /cache
and in /store delete any migrationsxxx, install_config.php and io_lock.lock
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Post Reply

Return to “[3.3.x] Support Forum”