Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Error in public bookmark folders

Quote Reply
Error in public bookmark folders
Hi,
when an user wants to view a public bookmark folder of an other user I get the following error:

Code:
Can't call method "fetchall_hashref" on an undefined value at /www/htdocs/v030672/cgi-bin/unterricht/admin/Links/Bookmark.pm line 343.


Does anybody know, how to fix this?
Thanks for any suggestions...
Matthias

Matthias
gpaed.de

Last edited by:

Matthias70: Oct 18, 2007, 2:34 PM
Quote Reply
Re: [Matthias70] Error in public bookmark folders In reply to
Can you enable debugging and paste the full error? Thanks.

Adrian
Quote Reply
Re: [brewt] Error in public bookmark folders In reply to
Hi Brewt,
here is the complete error

A fatal error has occured:

Can't call method "fetchall_hashref" on an undefined value at /www/htdocs/v784653/cgi-bin/links/admin/Links/Bookmark.pm line 343.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (28749): Links::environment called at /www/htdocs/v784653/cgi-bin/links/admin/Links.pm line 751 with no arguments.
Links (28749): Links::fatal called at /www/htdocs/v784653/cgi-bin/links/admin/Links/Bookmark.pm line 343 with arguments
(Can't call method "fetchall_hashref" on an undefined value at /www/htdocs/v784653/cgi-bin/links/admin/Links/Bookmark.pm line 343.
).
Links (28749): Links::Bookmark::_links_list called at /www/htdocs/v784653/cgi-bin/links/admin/Links/Bookmark.pm line 178 with arguments
(Matthias_Lunz, 3).
Links (28749): Links::Bookmark::folder_view called at /www/htdocs/v784653/cgi-bin/links/admin/GT/Plugins.pm line 133 with no arguments.
Links (28749): GT::Plugins::dispatch called at /www/htdocs/v784653/cgi-bin/links/admin/Links/Bookmark.pm line 54 with arguments
(GT::Plugins=HASH(0x83d037c), bookmark_users_links, CODE(0x836e918)).
Links (28749): Links::Bookmark::handle called at /www/htdocs/v784653/cgi-bin/links/admin/GT/Plugins.pm line 133 with no arguments.
Links (28749): GT::Plugins::dispatch called at bookmark.cgi line 30 with arguments
(GT::Plugins=HASH(0x83d037c), handle_bookmark, CODE(0x8197630)).

System Information
======================================
Current user: v784653 (640)
Perl version: 5.8.8
Gossamer Links version: 3.2.0
GT::SQL version: 1.111
GT::Template version: 2.161
DBI.pm Version: 1.50
Running under mod_perl: No
Running under SpeedyCGI: No
@INC =
/www/htdocs/v784653/cgi-bin/community/private/lib
/www/htdocs/v784653/cgi-bin/links/admin
/usr/lib/perl5/5.8.8/i586-linux-thread-multi
/usr/lib/perl5/5.8.8
/usr/lib/perl5/site_perl/5.8.8/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.8/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8
/usr/lib/perl5/vendor_perl
.
GT::SQL::error = Failed to execute query: 'SELECT * FROM glinks_Bookmark_Links,glinks_Links WHERE glinks_Bookmark_Links.my_link_id_fk = glinks_Links.ID AND ((glinks_Bookmark_Links.my_folder_id_fk = '3' AND glinks_Bookmark_Links.my_user_username_fk = 'Matthias') AND (glinks_Links.isValidated = 'Yes')) ORDER BY Title aufsteigend LIMIT 0, 25': 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 'aufsteigend LIMIT 0, 25' at line 1

CGI Input
======================================
action => users_links
my_folder_id => 3

CGI Cookies
======================================
4images_lang => deutsch
4images_lastvisit => 1192297699
4images_userid => 1
4images_userpass => b358ab87e30577c6be0ccdc6b4d
Community_Session => d5f7ca45253c538097bb1b7b35ed8635
__utma => 203064007.838939381.1188678760.1192740614.1192800346.389
__utmb => 203064007
__utmc => 203064007
__utmz=203064007.1192483161.368.48.utmccn=(organic)|utmcsr=google|utmctr=site webtipps kommunikation|utmcmd => organic
editor_cols => 100
editor_rows => 15
site => Tine
phpbb2mysql_data => a:2:{s:11:"autologinid";s:32:"b358ab87e30577c755f4b4d";s:6:"userid";i:2;}


Thanks
Matthias

Matthias
gpaed.de
Quote Reply
Re: [Matthias70] Error in public bookmark folders In reply to
Your order by is wrong:
Code:
...s.isValidated = 'Yes')) ORDER BY Title aufsteigend LIMIT 0, 25

Adrian
Quote Reply
Re: [brewt] Error in public bookmark folders In reply to
brewt wrote:
Your order by is wrong:
Code:
...s.isValidated = 'Yes')) ORDER BY Title aufsteigend LIMIT 0, 25

Hi Adrian,
I'm using the german glinks version. So what can I do?

Matthias

Matthias
gpaed.de
Quote Reply
Re: [Matthias70] Error in public bookmark folders In reply to
Oh, I see the problem. That's a translation bug in the template. You need to open up the templates/admin/setup_user.html template and change:
Code:
<td class="option">bookmark_links_sort_order</td>
<td class="value">
<select name="bookmark_links_sort_order">
<option<%if bookmark_links_sort_order eq 'ASC'%> selected<%endif%>>aufsteigend</option>
<option<%if bookmark_links_sort_order eq 'DESC'%> selected<%endif%>>absteigend</option>
</select>
</td>
to:
Code:
<td class="option">bookmark_links_sort_order</td>
<td class="value">
<select name="bookmark_links_sort_order">
<option<%if bookmark_links_sort_order eq 'ASC'%> selected<%endif%> value="ASC">aufsteigend</option>
<option<%if bookmark_links_sort_order eq 'DESC'%> selected<%endif%> value="DESC">absteigend</option>
</select>
</td>

Then resave the user options page.

Adrian
Quote Reply
Re: [brewt] Error in public bookmark folders In reply to
Hi Adrian,
thanks it works perfect now

Matthias

Matthias
gpaed.de

Last edited by:

Matthias70: Oct 19, 2007, 3:16 PM