I get this error.
=================
Fatal error: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] in EXECUTE("select * from elgg_files where files_owner = 2 and ( owner = 2 OR access IN ('PUBLIC', 'LOGGED_IN', 'user2') ) order by time_uploaded desc limit ") in /home/~user/public_html/elgg/lib/adodb/adodb-errorhandler.inc.php on line 77
=================
What causes it is a user adds the 'file widget' to their profile and doesn't set a number for how many files to view. However, I am using 0.8.
The error is in file mod/file/lib.php. Line 180. I fixed it by the following adjustment
function file_widget_display($widget) {
global $CFG;
$latest_files = widget_get_data("latest_files",$widget->ident);
if(strlen($latest_files)==0 || !is_numeric($latest_files)){$latest_files=5;}
$html = "<p>" . __gettext("No files found.") . "</p>";
if ($widget->type == "file::files") {fromfunction file_widget_display($widget) {
global $CFG;
$latest_files = widget_get_data("latest_files",$widget->ident);
$html = "<p>" . __gettext("No files found.") . "</p>";
if ($widget->type == "file::files") {I just set a default amount.
