Forum Settings
       
Reply To Thread

Lucy item search error messageFollow

#1 May 15 2024 at 2:38 AM Rating: Good
12 posts
Attempting to perform an item search from the Lucy page has started returning the following error message.

The error has not cleared up in a few days, so it may not be a known issue.

Quote:
error: Column 'id' in field list is ambiguous at /home/lucy/htdocs/_maketable line 67.
context:
...
63: $prevstr = $pagenum > 1 ? "<a href=$prevpage> <<< </a>" : "";
64: }
65: }
66: $sth = $dbh->prepare($query) || die $dbh->errstr;
67: $sth->execute(@$args) || die $dbh->errstr;
68:
69: $matches = $sth->rows unless($countstr);
70:
71: my @rows;
...
code stack: /home/lucy/htdocs/_maketable:67
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
/home/lucy/htdocs/itemlist.html:8
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
/home/lucy/htdocs/autohandler:9
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
#2 May 15 2024 at 7:00 PM Rating: Excellent
Toromin wrote:
Attempting to perform an item search from the Lucy page has started returning the following error message.

The error has not cleared up in a few days, so it may not be a known issue.

Quote:
error: Column 'id' in field list is ambiguous at /home/lucy/htdocs/_maketable line 67.
context:
...
63: $prevstr = $pagenum > 1 ? "<a href=$prevpage> <<< </a>" : "";
64: }
65: }
66: $sth = $dbh->prepare($query) || die $dbh->errstr;
67: $sth->execute(@$args) || die $dbh->errstr;
68:
69: $matches = $sth->rows unless($countstr);
70:
71: my @rows;
...
code stack: /home/lucy/htdocs/_maketable:67
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
/home/lucy/htdocs/itemlist.html:8
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
/home/lucy/htdocs/autohandler:9
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135


Thanks for the report, I'll look into this and get it fixed.
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
#3 May 15 2024 at 7:42 PM Rating: Excellent
This has been fixed. Thanks again!
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 66 All times are in CST
Anonymous Guests (66)