SQL errors
Created by: ilu33
I still haven't figured out what's wrong with our hub by going through the logs .... this shows up regularly:
2017-04-29 19:39:39
select uid from pconfig where cat = 'perm_limits' and k = 'view_stream' and ( v & 1 ) > 0 ;
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text & integer
LINE 1: ...cat = 'perm_limits' and k = 'view_stream' and ( v & 1 ) > 0 ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
This one showed up only once when somebody (unsuccessfully) tried to log in for the first time - we have ldap. He might have used the wrong username, but still shouldn't have caused an error.
2017-04-29 13:35:47
alter table channel add channel_password varchar(255) not null default '' ;
SQLSTATE[42701]: Duplicate column: 7 ERROR: column "channel_password" of relation "channel" already exists
2017-04-29 13:35:47
alter table channel add channel_salt varchar(255) not null default '' ;
SQLSTATE[42701]: Duplicate column: 7 ERROR: column "channel_salt" of relation "channel" already exists