View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0012033 | mantisbt | installation | public | 2010-06-11 07:22 | 2011-08-02 12:35 |
| Reporter | thefake | Assigned To | dhx | ||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.2.1 | ||||
| Target Version | 1.2.3 | Fixed in Version | 1.2.3 | ||
| Summary | 0012033: check.php tests views if they are utf8 like tables | ||||
| Description | On install or update on testing the system with <path>/admin/check.php it shows some errors if there are views in the mysql database. The function test_database_utf8() checks the Collation field of the "SHOW TABLE STATUS" statement for every table. This will fail on views as written on http://dev.mysql.com/doc/refman/5.5/en/show-table-status.html | ||||
| Steps To Reproduce | make an view on the database where you want to install mantis, copy the copy of mantis on the webserver and run /admin/check.php | ||||
| Additional Information | A possible fix would be adding a new line to the test_database_utf8() function: code:function test_database_utf8() {
} | ||||
| Tags | No tags attached. | ||||
|
MantisBT: master a6e6fb6d 2010-08-12 09:29 Details Diff |
Fix 0012033: admin/check utility treats MySQL views like tables The function test_database_utf8() checks the Collation field of the "SHOW TABLE STATUS" statement for every table. This will fail on views as written on http://dev.mysql.com/doc/refman/5.5/en/show-table-status.html quote "For views, all the fields displayed by SHOW TABLE STATUS are NULL except that Name indicates the view name and Comment says view." |
Affected Issues 0012033 |
|
| mod - admin/check/check_database_inc.php | Diff File | ||
|
MantisBT: master-1.2.x 18e38217 2010-08-12 09:29 Details Diff |
Fix 0012033: admin/check utility treats MySQL views like tables The function test_database_utf8() checks the Collation field of the "SHOW TABLE STATUS" statement for every table. This will fail on views as written on http://dev.mysql.com/doc/refman/5.5/en/show-table-status.html quote "For views, all the fields displayed by SHOW TABLE STATUS are NULL except that Name indicates the view name and Comment says view." |
Affected Issues 0012033 |
|
| mod - admin/check.php | Diff File | ||