StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I just upgraded from PMA v3.5.4 to v4.0.5 and ran into the same issue</p> <blockquote> <p>The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.</p> </blockquote> <p>clicking on the link gave me a run down of what is not setup yet</p> <blockquote> <p>$cfg['Servers'][$i]['recent'] ... not OK [ Documentation ] Persistent recently used tables: Disabled $cfg['Servers'][$i]['table_uiprefs'] ... not OK [ Documentation ] Persistent tables' UI preferences: Disabled</p> </blockquote> <h2>Quick steps to setup advanced features:</h2> <p>Copied from the bottom of <code>http://SERVER/phpmyadmin/chk_rel.php</code></p> <ul> <li>Create the needed tables with the examples/create_tables.sql. Documentation</li> <li>Create a pma user and give access to these tables. Documentation</li> <li>Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php. Documentation</li> <li><strong>Re-login to phpMyAdmin to load the updated configuration file.</strong></li> </ul> <h2>Detailed:</h2> <p><strong>Step 1.</strong> Add additional configuration into <code>phpMyAdmin/config.inc.php</code></p> <pre class="lang-php prettyprint-override"><code>$cfg['Servers'][$i]['recent'] = 'pma_recent'; $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs'; </code></pre> <p><strong>Step 2.</strong> Modify phpMyAdmin database using <code>phpMyAdmin/examples/create_tables.sql</code>. <strong><em>Renamed the table names of course!</em></strong></p> <pre class="lang-sql prettyprint-override"><code>-- -------------------------------------------------------- -- -- Table structure for table `pma_recent` -- CREATE TABLE IF NOT EXISTS `pma_recent` ( `username` varchar(64) NOT NULL, `tables` text NOT NULL, PRIMARY KEY (`username`) ) COMMENT='Recently accessed tables' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `pma_table_uiprefs` -- CREATE TABLE IF NOT EXISTS `pma_table_uiprefs` ( `username` varchar(64) NOT NULL, `db_name` varchar(64) NOT NULL, `table_name` varchar(64) NOT NULL, `prefs` text NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`username`,`db_name`,`table_name`) ) COMMENT='Tables'' UI preferences' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; -- -------------------------------------------------------- </code></pre> <p><strong>Step 3.</strong> Make sure to logout of PhpMyAdmin and re-login, refresh will not reload the config file.</p> <p>and we are left with no more errors</p> <pre><code>$cfg['Servers'][$i]['recent'] ... OK Persistent recently used tables: Enabled $cfg['Servers'][$i]['table_uiprefs'] ... OK Persistent tables' UI preferences: Enabled </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload