From fa9e978e4992935f77d09267f8e19d5d18010170 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 5 Mar 2014 16:56:05 +0800 Subject: [PATCH] DataObjects/Core_watch.php --- DataObjects/Core_watch.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/DataObjects/Core_watch.php b/DataObjects/Core_watch.php index 33aafaff..c7c12fb2 100644 --- a/DataObjects/Core_watch.php +++ b/DataObjects/Core_watch.php @@ -58,8 +58,8 @@ class Pman_Core_DataObjects_Core_watch extends DB_DataObject if (!empty($q['_split_event_name'])) { $this->selectAdd(" - substr( event, substring_index(event, '.',1)) as event_left, - substr( event, 0, substring_index(event, '.',1)) as event_right + substr( event, LOCATE(event, '.',1)) as event_left, + substr( event, 0, LOCATE(event, '.)) as event_right "); -- 2.39.2