From: Tim Brody <tdb2 AT ecs.soton.ac.uk>
Date: Mon, 15 Mar 2010 11:20:56 +0000
| Threading: | ↑ [EP-tech] Bug in EP 3.2.0-rc2 from Ian.Stuart AT ed.ac.uk • This Message |
This will be fixed in 3.2.1.
/Tim.
Index: cgi/users/lookup/name
===================================================================
--- cgi/users/lookup/name (revision 5141)
+++ cgi/users/lookup/name (working copy)
@ AT -27,7 +27,7 @ AT
my $Q_num_matches = $database->quote_identifier( "num_matches" );
my $Q_eprint_status = $database->quote_identifier( ↵
"eprint_status" );
-my $sql = "SELECT COUNT($Q_table.$Q_eprintid) $Q_num_matches," .
+my $sql = "SELECT COUNT($Q_table.$Q_eprintid) ↵
".$database->sql_AS."
$Q_num_matches," .
join(",", map { $database->quote_identifier($_) } AT fields) .
" FROM $Q_table" .
" LEFT JOIN $Q_name_table" .
On Mon, 2010-03-15 at 11:07 +0000, Ian Stuart wrote:
> In cgi/users/lookup/name there is an error in the main lookup SQL ↵
statement.
>
> Line 30 currently reads:
>
> my $sql = "SELECT COUNT($Q_table.$Q_eprintid) $Q_num_matches," .
>
> it should read:
>
> my $sql = "SELECT COUNT($Q_table.$Q_eprintid) AS ↵
$Q_num_matches," .
>
> .... the word "AS" is missing.
>
> thanks.
>
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/