Comment to Database Error
-
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` != 0Mysql 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