Update catastrophe!

[LedricMedric]

Please help!

My board has years worth of work on and I am at wits end! So far I reinstalled my entire operating system, Debian 12, and am back at the beginning.

I imported my sql file into MariaDb

I then downloaded new copy of phpbb. Moved the following files into the new phpbb folder
The config.php file

The ext/ directory

The images/ directory

The files/ directory

The store/ directory

But now I'm getting this when clicking the update button. I added the user into my db with the same password as the config.php file so not sure what's happening!

Code: Select all

General Error:SQL ERROR [ mysqli ]Access denied for user 'user'@'localhost' [1698]SQLSELECT config_name, config_value, is_dynamic FROM phpbb_config in file /var/www/html/forum/phpbb/db/driver/driver.php on line 1031

[KevC]

As long as you have the database you haven't lost anything.

It looks like maybe you haven't assigned that username with permission to access that database.

[LedricMedric]

Thanks I managed to set the permission on the user correct now I think...Not getting this error

Code: Select all

General Error:SQL ERROR [ mysqli ]Table 'forum.phpbb_config' doesn't exist [1146]SQLSELECT config_name, config_value, is_dynamic FROM phpbb_config in file /var/www/html/forum/phpbb/db/driver/driver.php on line 1031

[KevC]

Is the prefix in the config.php file correct?

[LedricMedric]

it looks like this?

Code: Select all

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

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
// @define('DEBUG_CONTAINER', true);

[janus_zonstraal]

table_prefix = 'phpbb_';

Is that the same prefix as in the database? (phpbb_)

[KevC]

From the error, it looks like the prefix might be forum.phpbb_

[LedricMedric]

No the preface matches the config file

Code: Select all

MariaDB [bbforum]> show tables ; 
+---------------------------+
| Tables_in_forum         |
+---------------------------+
| phpbb_acl_groups          |
| phpbb_acl_options         |
| phpbb_acl_roles           |
| phpbb_acl_roles_data      |
| phpbb_acl_users           |
| phpbb_attachments         |
| phpbb_banlist             |
| phpbb_bbcodes             |
| phpbb_bookmarks           |
| phpbb_bots                |
| phpbb_config       

[LedricMedric]

i managed to sort this! Thanks for all help

[Mick]

For the benefit of other users what did you do to fix it?