[livejournal] r19496: LJSV-1325: Last txtid select.

LJSV-1325: Last txtid select.

U   trunk/cgi-bin/ljlang.pl

Modified: trunk/cgi-bin/ljlang.pl
===================================================================
--- trunk/cgi-bin/ljlang.pl	2011-07-19 08:14:48 UTC (rev 19495)
+++ trunk/cgi-bin/ljlang.pl	2011-07-19 09:45:23 UTC (rev 19496)
@@ -358,7 +358,7 @@
     my $dbh = LJ::get_db_writer();
     my $txtid = 0;
 
-    my $oldtextid = $dbh->selectrow_array("SELECT txtid FROM ml_text WHERE lnid=? AND dmid=? AND itid=?", undef, $lnid, $dmid, $itid);
+    my $oldtextid = $dbh->selectrow_array("SELECT MAX(txtid) FROM ml_text WHERE lnid=? AND dmid=? AND itid=?", undef, $lnid, $dmid, $itid);
 
     if (defined $text) {
         my $userid = $opts->{'userid'} + 0;