UpdateDatabase.php
authorAlan Knowles <alan@roojs.com>
Tue, 27 May 2014 05:58:52 +0000 (13:58 +0800)
committerAlan Knowles <alan@roojs.com>
Tue, 27 May 2014 05:58:52 +0000 (13:58 +0800)
UpdateDatabase.php

index c359c68..36c3453 100644 (file)
@@ -682,7 +682,7 @@ class Pman_Core_UpdateDatabase extends Pman
         $c->query("
             UPDATE Companies 
                 SET
-                    comptype_id = (SELECT id FROM core_enum where etype='comptype' and name=Companies.comptype)
+                    comptype_id = (SELECT id FROM core_enum where etype='comptype' and name=Companies.comptype LIMIT 1)
                 WHERE
                     comptype_id = 0
                     AND