Change database tables to Dynamic

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
SpIdErPiGgY
Registered User
Posts: 189
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm
Contact:

Change database tables to Dynamic

Post by SpIdErPiGgY »

Hello,

I have a question... Is it okay to change all database tables to Dynamic?
There are a few extension that gave an error on installation, error told me to change the table to "Dynamic".

So then I thought maybe it's better to change all tables at once...
Will that give any problems at some point?

And is this the correct way to di it:

Code: Select all

ALTER TABLE `phpbb_acl_arcade_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_options` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_roles` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_roles_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_options` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_roles` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_roles_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_access` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_announce` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_announce_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_categories` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_challenge` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_challenge_champ` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_config` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_delete_games` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_download` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_favorites` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_games` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_game_rating` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_logs` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_menu` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_plays` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_ranks` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_reports` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_scores` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_sessions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_super_scores` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_tour` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_tour_champ` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_tour_wins` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_users_banned` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_attachments` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_banlist` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_bbcodes` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_bookmarks` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_bots` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_captcha_answers` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_captcha_questions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_config` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_config_text` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_confirm` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_disallow` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_dm_partners` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_drafts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ext` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_extensions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_extension_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums_access` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums_track` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums_watch` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_icons` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_image_upload` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_jv_points_transfer_log` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_jv_shoutbox` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_lang` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_log` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_login_attempts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_migrations` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_moderator_cache` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_modules` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_notifications` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_notification_emails` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_notification_types` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_oauth_accounts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_oauth_states` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_oauth_tokens` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_poll_options` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_poll_votes` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_portal_config` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_portal_modules` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_posts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ppde_currency` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ppde_donation_pages` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ppde_txn_log` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs_folder` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs_rules` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs_to` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_fields` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_fields_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_fields_lang` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_lang` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_qa_confirm` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ranks` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_reports` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_reports_reasons` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_search_results` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_search_wordlist` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_search_wordmatch` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sessions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sessions_keys` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sitelist` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_smilies` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sortables_answers` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sortables_confirm` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sortables_questions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_styles` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_teampage` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics_posted` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics_track` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics_watch` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topic_prefixes` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_userdownloadslog` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_user_group` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_user_notifications` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_warnings` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_whovisitedthistopic` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_words` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_zebra` ROW_FORMAT=DYNAMIC;
Yes I know, I can test it, and make a backup first... But don't want it to create problems later...
phpBB NL Extension translations, also on request.
--> Click Here: Myarea51secrets.com <--
User avatar
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: Change database tables to Dynamic

Post by david63 »

Are they not already "dynamic"? Mine are and I have done nothing to them.

You can only make them dynamic if the innodb file format is Barracuda.

Dynamic file format is not a problem in running phpBB
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26508
Joined: Fri Aug 29, 2008 9:49 am

Re: Change database tables to Dynamic

Post by Mick »

Plus, I’ve not heard of any extensions that suggests that that is done especially as extensions by their very nature should install and run without having to modify anything else, not that that means there aren’t any, can you link to some? I suggest if you have such issues you should consult with the extension author in the first place.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
SpIdErPiGgY
Registered User
Posts: 189
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm
Contact:

Re: Change database tables to Dynamic

Post by SpIdErPiGgY »

I don't think it's the fault of the extentions. Maybe the way the database is configured in Plesk?
I altered them all to Dynamic, and hope that problem is resolved now.
Guess this was not a phpBB problem... sorry ;)

Server:

System: Linux 3.10.0
Webserver: nginx
PHP: 8.0.5
Database server: MySQL(i) 10.5.10-MariaDB
System: Redhat
phpBB NL Extension translations, also on request.
--> Click Here: Myarea51secrets.com <--
Post Reply

Return to “[3.3.x] Support Forum”