https://bugzilla.wikimedia.org/show_bug.cgi?id=43571
Daniel Renfro <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #8 from Daniel Renfro <[email protected]> --- I get the same error: $ php ./phpunit.php PHPUnit 3.7.7 by Sebastian Bergmann. Configuration read from /home/wiki/wiki/wiki/tests/phpunit/suite.xml A database query syntax error has occurred. The last attempted database query was: "CREATE TEMPORARY TABLE `unittest_view_categorylinks_nonhiddencat` (LIKE `vpw_view_categorylinks_nonhiddencat`)" from within function "DatabaseMysql::duplicateTableStructure". Database returned error "1347: 'wikidb.vpw_view_categorylinks_nonhiddencat' is not BASE TABLE (localhost)" This is because MySQL cannot create temporary tables based on views. I quote from the MySQL online documentation (http://dev.mysql.com/doc/refman/5.1/en/create-table.html): Use LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table ... LIKE works only for base tables, not for views. This means that if any MW installations that want to run PHPUnit unit tests have views in their database, the MW-specific unit-test setup will fail (because MySQL will fail.) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
