Revision: 2706
https://sourceforge.net/p/mrbs/code/2706/
Author: cimorrison
Date: 2013-02-20 14:55:58 +0000 (Wed, 20 Feb 2013)
Log Message:
-----------
Fixed incorrect quoting of id column, resulting in error messages when running
under PostgreSQL. See SF bugs #266
Modified Paths:
--------------
mrbs/trunk/web/view_entry.php
Modified: mrbs/trunk/web/view_entry.php
===================================================================
--- mrbs/trunk/web/view_entry.php 2013-02-20 06:30:57 UTC (rev 2705)
+++ mrbs/trunk/web/view_entry.php 2013-02-20 14:55:58 UTC (rev 2706)
@@ -151,7 +151,7 @@
// as per the original series settings
$sql = "SELECT id
FROM $tbl_entry
- WHERE repeat_id=\"$id\" AND entry_type=" . ENTRY_RPT_ORIGINAL . "
+ WHERE repeat_id=$id AND entry_type=" . ENTRY_RPT_ORIGINAL . "
ORDER BY start_time
LIMIT 1";
$id = sql_query1($sql);
@@ -165,7 +165,7 @@
// but edit_entry.php will display the start time of the entry
$sql = "SELECT id
FROM $tbl_entry
- WHERE repeat_id=\"$id\"
+ WHERE repeat_id=$id
ORDER BY start_time
LIMIT 1";
$id = sql_query1($sql);
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
