DataObjects/Core_watch.php
authorAlan Knowles <alan@roojs.com>
Wed, 5 Mar 2014 08:56:05 +0000 (16:56 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 5 Mar 2014 08:56:05 +0000 (16:56 +0800)
DataObjects/Core_watch.php

index 33aafaf..c7c12fb 100644 (file)
@@ -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        
                              
             ");