-
-
Notifications
You must be signed in to change notification settings - Fork 41
Issue with phpmyadmin prefs table #1
Comments
Same thing here. Reconfigured with dpkg and the missing |
Originally posted this in the wrong queue: geerlingguy/drupal-vm#71 |
This still seems to be active |
Solution could be: http://stackoverflow.com/a/24937839/100134 I'll see how simple it is to just reconfigure the package as part of the setup task. Annoying... but it seems to be the status quo with Debian package installation :P |
Annoyingly, neither reconfiguring the package without user interaction (e.g. # Method 1 - this doesn't work.
- name: Reconfigure PHPMyAdmin (to fix an install error).
command: dpkg-reconfigure -f noninteractive phpmyadmin
when: install_phpmyadmin_debian.changed
sudo: yes
# Method 2 - this doesn't work either.
- name: Expand phpMyAdmin create_tables.sql script.
command: gzip -d /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz
when: install_phpmyadmin_debian.changed
sudo: yes
- name: Reconfigure PHPMyAdmin (to fix an install error).
shell: mysql < /usr/share/doc/phpmyadmin/examples/create_tables.sql
when: install_phpmyadmin_debian.changed
sudo: yes It looks like this was caused by the Debian/Ubuntu package not being updated to take into account the double-underscore I'm going to close this ticket and just recommend that Debian/Ubuntu users manually run Solutions to this problem:
Unfortunately, I don't want to take on the work of trying to automate these fixes; if someone else can figure out a way to automate the fix simply, please submit a PR. |
It looks like the only missing step after importing |
I fixed this issue on my end, as root in PhpMyAdmin, I executed the SQL script create_tables.sql with a little change. I changed for every table created the double underscore by a single underscore. Script available here https://gist.github.com/Luukyb/efd2bb9b7932081b68a3 |
Perhaps I do not understand what the root password for phpmyadmin. This patch solved
patch:
|
I get this error when trying to browse a table in phpmyadmin:
This might be an Ubuntu-wide issue http://stackoverflow.com/questions/20731487/phpmyadmin-pma-table-uiprefs-doesnt-exist
I was able to fix it by using the interactive setup:
sudo dpkg-reconfigure phpmyadmin
Tested on Ubuntu 14.04
The text was updated successfully, but these errors were encountered: