Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 179511

Summary: phpmyadmin: outdated support tables creation script
Product: Gentoo Linux Reporter: Alessandro Zarrilli <alessandro>
Component: New packagesAssignee: Gentoo Linux MySQL bugs team <mysql-bugs>
Status: RESOLVED CANTFIX    
Severity: minor CC: web-apps
Priority: High    
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description Alessandro Zarrilli 2007-05-23 12:37:26 UTC
The POSTINST message suggest to launch "mysql -u root -p < /usr/share/webapps/phpmyadmin/${PVR}/sqlscripts/mysql/${PVR}_create.sql" to create pmadb user, grant database access, create the pmadb database and so on.

The problem is that ${PVR}_create.sql script is a little outdated: for example it's missing the PMA_designer_coords table creation (see designer_coords parameter in http://www.phpmyadmin.net/documentation/) and some collations are not the same as in last official PhpMyAdmin SQL table creation scripts.

So please merge /usr/share/webapps/phpmyadmin/${PVR}/sqlscripts/mysql/${PVR}_create.sql with the contents of the official /usr/share/webapps/phpmyadmin/2.10.0.2/htdocs/scripts/create_tables_mysql_4_1_2+.sql


Reproducible: Always

Steps to Reproduce:
Comment 1 Renat Lumpau (RETIRED) gentoo-dev 2007-05-28 00:45:21 UTC
i've dropped this completely, as upstream kept complaining that we patch the default config.