Menu
▾
▴
1 Attachments
#808 Invalid cache
I'm using v 4.8.1 and I found that it has some cache which shows me invalid content very often. For example, when I perform some actions not in Adminer, I can't see changes until I change URL manually or perform an action in the Adminer interface. I tried the down to version 4.4.0 but the same. I found that when I drop databases not in Adminer, I can see non-existing databases in the list but without collations.
When I checked the network activity, even when I press Ctrl+F5, it loads HTML page content with non-existing databases:
<p>MySQL version: <b>5.7.34</b> through PHP extension <b>PDO_MySQL</b>
<p>Logged as: <b>root@172.22.0.2</b>
<form action='' method='post'>
<table cellspacing='0' class='checkable'>
<script nonce="NTQ3MGNjN2FhZjIwNjUwYjU3YTRhYjE4YTg5NjQzZTM=">mixin(qsl('table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true)});</script>
<thead><tr><td> <th>Database - <a href='?server=mysql&username=root&refresh=1'>Refresh</a><td>Collation<td>Tables<td>Size - <a href='?server=mysql&username=root&dbsize=1'>Compute</a><script nonce="NTQ3MGNjN2FhZjIwNjUwYjU3YTRhYjE4YTg5NjQzZTM=">qsl('a').onclick = partial(ajaxSetHtml, '?server=mysql&username=root&script=connect');</script></thead>
<tr><td><input type='checkbox' name='db[]' value='information_schema' aria-labelledby='Db-information_schema'><th><a href='?server=mysql&username=root&db=information_schema' id='information_schema'>information_schema</a><td><a href='?server=mysql&username=root&db=information_schema&database=' title='Alter database'>utf8_general_ci</a><td align='right'><a href='?server=mysql&username=root&db=information_schema&schema=' id='tables-information_schema' title='Database schema'>?</a><td align='right' id='size-information_schema'>?
<tr class="odd"><td><input type='checkbox' name='db[]' value='mage2' aria-labelledby='Db-mage2'><th><a href='?server=mysql&username=root&db=mage2' id='mage2'>mage2</a><td><a href='?server=mysql&username=root&db=mage2&database=' title='Alter database'> </a><td align='right'><a href='?server=mysql&username=root&db=mage2&schema=' id='tables-mage2' title='Database schema'>?</a><td align='right' id='size-mage2'>?
<tr><td><input type='checkbox' name='db[]' value='magi_entities' aria-labelledby='Db-magi_entities'><th><a href='?server=mysql&username=root&db=magi_entities' id='magi_entities'>magi_entities</a><td><a href='?server=mysql&username=root&db=magi_entities&database=' title='Alter database'>latin1_swedish_ci</a><td align='right'><a href='?server=mysql&username=root&db=magi_entities&schema=' id='tables-magi_entities' title='Database schema'>?</a><td align='right' id='size-magi_entities'>?
<tr class="odd"><td><input type='checkbox' name='db[]' value='magi_static-data' aria-labelledby='Db-magi_static-data'><th><a href='?server=mysql&username=root&db=magi_static-data' id='magi_static-data'>magi_static-data</a><td><a href='?server=mysql&username=root&db=magi_static-data&database=' title='Alter database'> </a><td align='right'><a href='?server=mysql&username=root&db=magi_static-data&schema=' id='tables-magi_static-data' title='Database schema'>?</a><td align='right' id='size-magi_static-data'>?
<tr><td><input type='checkbox' name='db[]' value='mysql' aria-labelledby='Db-mysql'><th><a href='?server=mysql&username=root&db=mysql' id='mysql'>mysql</a><td><a href='?server=mysql&username=root&db=mysql&database=' title='Alter database'>latin1_swedish_ci</a><td align='right'><a href='?server=mysql&username=root&db=mysql&schema=' id='tables-mysql' title='Database schema'>?</a><td align='right' id='size-mysql'>?
<tr class="odd"><td><input type='checkbox' name='db[]' value='notify_send' aria-labelledby='Db-notify_send'><th><a href='?server=mysql&username=root&db=notify_send' id='notify_send'>notify_send</a><td><a href='?server=mysql&username=root&db=notify_send&database=' title='Alter database'> </a><td align='right'><a href='?server=mysql&username=root&db=notify_send&schema=' id='tables-notify_send' title='Database schema'>?</a><td align='right' id='size-notify_send'>?
<tr><td><input type='checkbox' name='db[]' value='performance_schema' aria-labelledby='Db-performance_schema'><th><a href='?server=mysql&username=root&db=performance_schema' id='performance_schema'>performance_schema</a><td><a href='?server=mysql&username=root&db=performance_schema&database=' title='Alter database'>utf8_general_ci</a><td align='right'><a href='?server=mysql&username=root&db=performance_schema&schema=' id='tables-performance_schema' title='Database schema'>?</a><td align='right' id='size-performance_schema'>?
<tr class="odd"><td><input type='checkbox' name='db[]' value='sys' aria-labelledby='Db-sys'><th><a href='?server=mysql&username=root&db=sys' id='sys'>sys</a><td><a href='?server=mysql&username=root&db=sys&database=' title='Alter database'>utf8_general_ci</a><td align='right'><a href='?server=mysql&username=root&db=sys&schema=' id='tables-sys' title='Database schema'>?</a><td align='right' id='size-sys'>?
</table>
I'm using Adminer as a Docker container:
adminer:
image: adminer:4.4.0
restart: always
ports:
- 8080:8080
depends_on:
- mysql
I can't remember such issues before. What can be the issue?
I've noticed similar issue. I'm cloning adminer github project into docker container and I'm accessing it via apache webserver. Problem is the same. Every time there is change in database not from adminer (doctrine migrations, external edit), it displays old data even after refresh without cache.
Getting databases is very expensive and Adminer really caches it. There's a link to refresh this cache.
Can you please specify where that link should be? I didn't find it anywhere. I'm using custom css skin. Can it be the reason why I don't see it?
Thank you
See image.
Thank you very much. I just didn't notice it :-)