Database Error

if you only got this error once, and not a whole bunch of times, its probably safe to ignore.  especially if you got it along with a database error connect message, and then total silence after that...
if you keep getting hammered with this, repeatedly, its an issue.  

hm, ive got it too  

Database error in myTribes.net

Query:
SELECT `sys_profiles`.* FROM `sys_profiles` INNER JOIN `sys_acl_levels_members` AS `tlm` ON `sys_profiles`.`id`=`tlm`.`IDMember` WHERE 1 AND `tlm`.`IDLevel` IN (7,8) AND (`tlm`.`DateStarts` IS NULL OR `tlm`.`DateStarts` <= NOW()) AND (`tlm`.`DateExpires` IS NULL OR `tlm`.`DateExpires` > NOW()) AND `sys_accounts`.`email_confirmed` != 0

Mysql error:
Unknown column 'sys_accounts.email_confirmed' in 'where clause'

Location:
The error was found in getAll function in the file /home/villageshaman/www.mytribes.net/public/inc/classes/BxDolAclQuery.php at line 444.

collation_connection:
utf8mb4_unicode_ci
although mine is a bit different.  

I'd mess with this right now, but I'd rather eat dinner :D

or if you understand what the problem is, perhaps you can make a commit.   if not of course, then never mind .

it's a not equal to operator they are noticing i think.  
the statement seems designed to check to ensure one has been confirmed, and cleared onto tlm and acl list, and then joins them into the sys_accounts table while running the rest of the BxDolAcl script..
I don't see an error in the code, but I'm not actually a programmer :)

unless of course you just edit the code, and add in the changes...
:)
But I do thank you for pointing my attention at the commit in regards to this error.
 

i have zero experience with una cloud.  :-)  Unsure, but I'm not the guy to ask.

I got the same error today. Please, does anyone know when the update to fix this will be? It occur when someone request an invitation to join the website.