If you don't have a prefix in your table names, there will be a table created called: "groups" which is a SQL keyword and MySQL struggles with the dynamic queries built by PHP. How I got around this is in the PHP code I safely escape all mentions to a table name using back-ticks. I believe this could be an easy patch fix, to add back ticks to escape table names when queries are being constructed.

Sudo code:

<?

$query = 'SELECT * FROM `'.$table.'` ORDER BY 1;';

?>


Otherwise can someone prescribe what needs to be done so if I go and update all my table tables, that my website will know that I added a prefix, post-install?