removing prefix

[thepreacher]

What files need to be editted/how to completely remove the database prefix?

[KevC]

Remove it in phpmyadmin for each table and edit the config.php file to match.
I'm not really sure what the point would be though.

[thepreacher]

Because otherwise I'd need 2 users tables for integration

[thepreacher]

Ok, I tried that and got 503

[21-Aug-2017 07:03:38 America/New_York] PHP Fatal error: Uncaught Error: Call to undefined method database::sql_close() in /forums/includes/functions.php:4736
Stack trace:
#0 /forums/includes/functions.php(3336): garbage_collection()
#1 [internal function]: msg_handler(256, 'SQL ERROR [ mys...', '/forums...', 999, Array)
#2 /forums/phpbb/db/driver/driver.php(999): trigger_error('SQL ERROR [ mys...', 256)
#3 /forums/phpbb/db/driver/mysqli.php(193): phpbb\db\driver\driver->sql_error('SELECT config_n...')
#4 /forums/phpbb/db/driver/factory.php(329): phpbb\db\driver\mysqli->sql_query('SELECT config_n...', 0)
#5 /forums/phpbb/config/db.php(57): phpbb\db\driver\factory->sql_query('SELECT config_n...')
#6 /forums/cache/production/container_e37d40c70e76cc491c1b742bba0ca8f9.php(757): phpbb\config\db->__construct(Object(phpbb\db\driver\factory), Object(phpbb\cache\driver\file), 'phpbban_c in /forums/includes/functions.php on line 4736

[david63]

Did you purge the cache after making the changes?

[thepreacher]

Same error still. But it has more to do with the SSO integration.

Here is the particular portion I believe:

Code: Select all

session_regenerate_id();
    $_SESSION['loggedin'] = 1;
    $_SESSION['userid'] = $mem['user_id'];
    $IP = $db->escape($_SERVER['REMOTE_ADDR']);
    $db->query("UPDATE `users` SET `lastip_login` = '$IP', `last_login` = " . $_SERVER['REQUEST_TIME'] . " WHERE `user_id` = {$mem['user_id']}");
    }

So now I'm trying to learn the request portion of phpbb

[thepreacher]

So, I've cleared my cache and the server cache. closed the browser, restarted and still get:

General Error
SQL ERROR [ mysqli ]

Table '****.insertprefix_config' doesn't exist [1146]

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

Is there anywhere else this might have been written to during installation?

[AmigoJack]

No. Or a non-professional custom code or extension. And your internet browser has nothing to do with phpBB's cache.

Table '****.insertprefix_config'

This implies your /config.php looks like this:

Code: Select all

	$table_prefix= 'insertprefix_';

when it should look like this:

Code: Select all

	$table_prefix= '';

[thepreacher]

the table prefix literally was ''.

I used that same file to also update the database name change. It updated the database name change, but not the table prefix.

[stevemaury]

See attached. May need tweaking for newer version. Delete the .txt extension before running.