[Register]
Powered by Elgg

Plugins :: Blog :: Error With Files Widget

December 13, 2007

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") {
from
function 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.

 

 

Posted by bigorangemachine @ Plugins

You must be logged in to post a comment.

Site supported by Curverider Ltd - powered by the awesome Elgg