Navigation

Pligg Support

After you install the Sidebar saved Stories module, you get an error :

" PHP Warning: 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 'ORDER BY saved_id DESC limit 5' at line 1 in

and the module won't work. To fix it:

open \modules\sidebar_saved\templates\sidebar_saved_index.tpl

go to line 22 and change this:

$res = "select link_id,link_title,saved_id,saved_user_id,saved_link_id from ".table_links.",".table_saved_links." WHERE saved_link_id = link_id AND link_author = ".$userid." ORDER BY saved_id DESC limit 5";

To this:

$res = "select link_id,link_title,saved_id,saved_user_id,saved_link_id from ".table_links.",".table_saved_links." WHERE saved_link_id = link_id AND link_author = link_author ORDER BY saved_id DESC limit 5";

The error was in:

AND link_author = ".$userid."

It must be :

AND link_author = link_author