Cannot change Display Options

[Stefan Maier]

Hello,

I have installed Refbase 0.9.6 at Ubuntu 16.04 with PHP 5.6. Except the mysql error 3065
problem everything seems to work. But I cannot change the display options for single users.
When I press the "edit options" button, no forms are shown, after "Modify your account options:"
noting appears.

Thanks

Stefan

[Richard Karnesky]

Thank you for reporting this. I am able to reproduce this. I've pushed a patch on svn:

--- includes/include.inc.php    (old)
+++ includes/include.inc.php    (working copy) 
@@ -4308,7 +4300,7 @@
        if (empty($userID))
            // Find all unique language entries in the 'languages' table that are enabled:
            // (language names should be unique anyhow, so the DISTINCT parameter wouldn't be really necessary)
-           $query = "SELECT DISTINCT language_name FROM $tableLanguages WHERE language_enabled = 'true' ORDER BY order_by";
+           $query = "SELECT DISTINCT language_name FROM $tableLanguages WHERE language_enabled = 'true' ORDER BY $tableLanguages.language_name";
        else
            // Get the preferred language for the user with the user ID given in '$userID':
            $query = "SELECT language AS language_name FROM $tableUsers WHERE user_id = " . quote_smart($userID);

Essentially: we hadn't provided a proper sort order for the list of languages that can be chosen. You should be able to edit includes/include.inc.php and fix this manually.

[Stefan Maier]

Unfortunately it still does not work. Neither as user nor as admin:
Manage Users --> show details and options --> edit details --> this works, forms are shown
Manage Users --> show details and options --> edit options --> no forms
Manage Users --> show details and options --> edit permissions --> no forms

[Stefan Maier]

Sorry, my failure. Now it works ! Thank you for your quick help !
Best regards
Stefan