Error on channel creation
Created by: ilu33
Whenever a new channel is created:
2016-09-15 04:42:02
select * from abook left join xchan on abook_xchan = xchan_hash where
abook_channel = 9 and abook_xchan in ( select xchan from abconfig where chan = 9 and cat =
'their_perms' and k = 'delegate' and v = 1 ); returned false
ERROR: operator does not exist: text = integer
LINE 2: ... = 9 and cat = 'their_perms' and k = 'delegate' and v = 1 );
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
diff --git a/Zotlabs/Module/Manage.php b/Zotlabs/Module/Manage.php
index 8f815d6..ec9ef4c 100644
--- a/Zotlabs/Module/Manage.php
+++ b/Zotlabs/Module/Manage.php
@@ -143,7 +143,7 @@ class Manage extends \Zotlabs\Web\Controller {
$create = array( 'new_channel', t('Create a new channel'), t('Create New'));
$delegates = q("select * from abook left join xchan on abook_xchan = xchan_hash where
- abook_channel = %d and abook_xchan in ( select xchan from abconfig where chan = %d and cat =
'their_perms' and k = 'delegate' and v = 1 )",
+ abook_channel = %d and abook_xchan in ( select xchan from abconfig where chan = %d and cat =
'their_perms' and k = 'delegate' and v = '1' )",
intval(local_channel()),
intval(local_channel())
);