Kod: Zaznacz cały
General Error
SQL ERROR [ mysqli ]
Table 'trucklif_forums.sessions' doesn't exist [1146]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
phpbb_banlist a banlist, tak samo nie phpbb_sessions tylko sessions.Jak pisałem wcześniej robie coś takiego pierwszy raz i potrzebuje pomocy od doświadczonych osób. Przypomnę, że edytuje wszystko z panelu admina na xaa.plInstalling additional phpBB forums
The steps for installing additional phpBB forums are exactly the same as for the first installation, with one exception, you do not need to rename the database tables for additional installations. All you have to do is edit the includes/constants.php file to tell your new phpBB installation to use the shared tables.
The tricky part
Next comes the tricky stuff. phpBB uses a kind of system where it caches the user permission for each board into the users table. I’m not entirely sure how the system works, but suffice it to say that each board needs its own cache. So you will need to add additional columns to the users table, specifically the user_permissions and the user_perm_from fields.
What you need to do is add assign a number for each phpBB installation and then duplicate the above two fields with the addition of the installation number as its suffix. For example, if your primary forum installation is assigned the number 1, the duplicated fields will be called user_permissions_1 and user_perm_from_1. This can be anything you want it to be as long as you know that it refers to this specific installation. Do the same for all other installations.
Now you need to change all reference to these fields for each phpBB installation. Open up includes/auth.php for each phpBB installation, and change all references to user_permissions and user_perm_from to the appropriate tables. For example, the includes/auth.php file for your primary phpBB installation will use user_permissions_1 and user_perm_from_1, provided these tables are the ones you’ve assigned to this specific installation. The same goes for all of your phpBB installations, so in my case I have three forums sharing the same user database, the first one is assigned with the number one so it uses the tables user_permissions_1 and user_perm_from_1. The second forum uses the tables user_permissions_2 and user_perm_from_2, and the third one user_permissions_3 and user_perm_from_3.
Of course, this depends entirely on what you name the tables, but for simplicity’s sake, I decided to go with numbers as suggested in the forum post mentioned above.
Kod: Zaznacz cały
ALTER TABLE users ADD user_permissions_2 mediumtext NOT NULL;
ALTER TABLE users ADD user_perm_from_2 mediumint(8) UNSIGNED DEFAULT '0' NOT NULL;includes/auth.php.user_permissios i każde user_perm_from w jednym i drugim forum zmieniłem auth w pierwszym że idzie tam 1 i w drugim forum że idzie tam 2. Natomiast gdy rejestruje się testowy użytkownik wyskakuje ten błąd:Kod: Zaznacz cały
Błąd ogólny
SQL ERROR [ mysqli ]
Field 'user_permissions_1' doesn't have a default value [1364]
Wystąpił błąd bazy danych podczas pobierania tej strony. Jeśli problem będzie się powtarzał, skontaktuj się z administratorem.
Kod: Zaznacz cały
General Error
SQL ERROR [ mysqli ]
Unknown column 'user_perm_from_2_1' in 'field list' [1054]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.user_permissions. Zamień na user_permissions_1 (oczywiście numerki powinny odpowiadać tym, które ustawiłeś w auth.php).Kod: Zaznacz cały
Unknown column 'user_perm_from_2_1' in 'field list' [1054]user_perm_from_2.Kod: Zaznacz cały
Błąd ogólny
SQL ERROR [ mysqli ]
Field 'user_permissions' doesn't have a default value [1364]
Wystąpił błąd bazy danych podczas pobierania tej strony. Jeśli problem będzie się powtarzał, skontaktuj się z administratorem.Kod: Zaznacz cały
// These are the additional vars able to be specified
$additional_vars = array(
'user_permissions' => '',
'user_permissions_1' => '',
'user_timezone' => $config['board_timezone'],