Revision: 1563
http://mrbs.svn.sourceforge.net/mrbs/?rev=1563&view=rev
Author: cimorrison
Date: 2010-11-02 09:29:31 +0000 (Tue, 02 Nov 2010)
Log Message:
-----------
Removed a "LIMIT" from an UPDATE query as PostgreSQL doesn't like them.
Modified Paths:
--------------
mrbs/branches/provisional_bookings_new_style/web/upgrade/17/post.inc
Modified: mrbs/branches/provisional_bookings_new_style/web/upgrade/17/post.inc
===================================================================
--- mrbs/branches/provisional_bookings_new_style/web/upgrade/17/post.inc
2010-11-02 09:00:54 UTC (rev 1562)
+++ mrbs/branches/provisional_bookings_new_style/web/upgrade/17/post.inc
2010-11-02 09:29:31 UTC (rev 1563)
@@ -80,8 +80,7 @@
// Set the approval status for each one
$sql = "UPDATE $tbl_repeat
SET status=status|" . STATUS_AWAITING_APPROVAL . "
- WHERE id=" . $row['repeat_id'] . "
- LIMIT 1";
+ WHERE id=" . $row['repeat_id'];
if (sql_command($sql) != 1)
{
fatal_error(FALSE, "Failed to update status column in repeat table with
approval status.");
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
