Updating to 3.1.8 DB Error

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
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.
Tarantino
Registered User
Posts: 754
Joined: Sat Feb 18, 2012 1:51 pm
Contact:

Re: Updating to 3.1.8 DB Error

Post by Tarantino » Fri Mar 18, 2016 5:33 am

That message almost always means that you have overwritten your config.php file with the blank one.

make sure the config.php file is not blank.

;)

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

Re: Updating to 3.1.8 DB Error

Post by 3Di » Fri Mar 18, 2016 5:43 am

Tarantino wrote:That message almost always means that you have overwritten your config.php file with the blank one.

make sure the config.php file is not blank.

;)
And some link that states your quoted statement?

And explain it to me how to get that error then, if the board it is unable to connect to the DB (config.php blank ?) :roll:

Don't you think that will throws out an error like "unable to connect to the database" of some sort? :geek:

Please re-consider your support, thank you. ;)
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
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

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

Re: Updating to 3.1.8 DB Error

Post by Tarantino » Fri Mar 18, 2016 5:47 am

Use this instead for your config.php and replace your database info, it will (pretty sure) work to access the database_update, I've solve this issue many times by doing this:

Code: Select all

<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysql';
$dbhost = '';
$dbport = '';
$dbname = 'yourdatabase name here';
$dbuser = 'youruser';
$dbpasswd = 'yourpassword';
$table_prefix = 'your prefix';
$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);

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

Re: Updating to 3.1.8 DB Error

Post by 3Di » Fri Mar 18, 2016 5:55 am

3Di wrote:
Tarantino wrote:That message almost always means that you have overwritten your config.php file with the blank one.

make sure the config.php file is not blank.

;)
And some link that states your quoted statement?

And explain it to me how to get that error then, if the board it is unable to connect to the DB (config.php blank ?) :roll:

Don't you think that will throws out an error like "unable to connect to the database" of some sort? :geek:

Please re-consider your support, thank you. ;)
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
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

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

Re: Updating to 3.1.8 DB Error

Post by Tarantino » Fri Mar 18, 2016 5:57 am

The message "Please read: INSTALL.html before attempting to update." appears a lot when config is empty.
If this is not the case, its similar. The config if its old, it needs to be updated to the 3.1 model.
In many cases this will solve this problem.

So, I would always recommend this first.

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

Re: Updating to 3.1.8 DB Error

Post by 3Di » Fri Mar 18, 2016 6:03 am

Tarantino wrote:The message "Please read: INSTALL.html before attempting to update." appears a lot when config is empty.
If this is not the case, its similar. The config if its old, it needs to be updated to the 3.1 model.
In many cases this will solve this problem.

So, I would always recommend this first.
Any link that states what you are stating?

I have never heard of this but I a am open mind and willing to learn.

In my experience I can say that if a config.php does not contains the infos needed (or blank??? :P ) you cannot connect to the DB hence you cannot get a such error but something like " unable to connnect to the DB ..etc..etc.."

Ok, I stop here.....
Tarantino wrote:So, I would always recommend this first.
Where? Better to avoid that IMO. ;)
Tarantino wrote: The config if its old, it needs to be updated to the 3.1 model..
Really? It only diffs where there is in one commented out line related to debug that not everybody uses (yet).
And for the EOF that's blank,
I do not see where the problem lies then?
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
πŸ‘¨β€πŸ« | Take a tour to | The Studio | πŸ‘¨β€πŸ«

User avatar
PlanetMelb
Registered User
Posts: 135
Joined: Sat May 10, 2003 5:19 am

Re: Updating to 3.1.8 DB Error

Post by PlanetMelb » Tue Mar 22, 2016 2:13 am

I suspect after further reading, it is my old config file stopping this from working

I will try and upload a new one using Tarantino's code above. I am just checking with my hosts to ensure I have the settings correct as there are more fields than the old config file.

If that works then I will try run database_update.php again

Fingers crossed

Thanks again for your help guys

User avatar
PlanetMelb
Registered User
Posts: 135
Joined: Sat May 10, 2003 5:19 am

Re: Updating to 3.1.8 DB Error

Post by PlanetMelb » Mon Mar 28, 2016 10:27 pm

Update:

Unfortunately my hosts are not being much help when I ask them for the settings of the config.php file other than to say the ones I have are correct. My current config (my X's)

Code: Select all

<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysql';
$dbhost = 'mysql.ilisys.com.au';
$dbport = '3306';
$dbname = 'wines_db';
$dbuser = 'XXXXXXXX';
$dbpasswd = 'XXXXXXXX';
$table_prefix = 'phpbb_';
$phpbb_adm_relative_path = './adm';
$acm_type = 'file';

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

?>
Yet I am still getting this error:

Image

Any help appreciated

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

Re: Updating to 3.1.8 DB Error

Post by Lumpy Burgertushie » Mon Mar 28, 2016 11:00 pm

either you haven't updated the database yet or you are accessing the wrong database.


that ext table is not in phpbb 3.0 but is in 3.1

the upgrade from 3.0 includes upgrading the database by accessing the install/database_update.php file in your browser. if that was done properly you would not get that error because that table would be there.

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?

User avatar
PlanetMelb
Registered User
Posts: 135
Joined: Sat May 10, 2003 5:19 am

Re: Updating to 3.1.8 DB Error

Post by PlanetMelb » Mon Mar 28, 2016 11:19 pm

Thanks Robert

To be clear, I was running 3.0.6 and pushed a fresh install of 3.1.8 - which obviously caused this issue.

If I try and run install/database_update.php I get another error as follows.

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'is_dynamic' in 'field list' [1054]

SQL

SELECT config_name, config_value, is_dynamic FROM phpbb_config

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

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

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

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 71
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\config\db->__construct()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 886
CALL: ReflectionClass->newInstanceArgs()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 452
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->createService()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 932
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 929
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->resolveServices()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 871
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->resolveServices()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 452
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->createService()

FILE: [ROOT]/install/database_update.php
LINE: 91
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

Locked

Return to β€œ[3.1.x] Support Forum”