Zandra

I installed UNA 13.1.0-B1 on a live site and now there are random people receiving database query errors when viewing pages with a timeline.

Long story short, my UNA site is unusable now 😂

here is the error from sys_db.log

Sep 01 06:33:49 [8612] / Database query error
  Error: Unknown column 'bx_timeline_events.owner_id' in 'where clause'
  Query: (SELECT `te`.*
            FROM `bx_timeline_events` AS `te`
            LEFT JOIN `bx_timeline_handlers` ON `te`.`type`=`bx_timeline_handlers`.`alert_unit` AND `te`.`action`=`bx_timeline_handlers`.`alert_action` INNER JOIN `sys_profiles` AS `tpoo` ON ABS(`te`.`object_owner_id`)=`tpoo`.`id` AND `tpoo`.`status`='active'  
            WHERE 1  AND `bx_timeline_events`.`owner_id` NOT IN (9966) AND `bx_timeline_events`.`object_owner_id` NOT IN (9966)AND `te`.`active`='1' AND `te`.`status`='active'  AND IF(`te`.`system`='0' AND (`te`.`object_owner_id`=8612), 1, `te`.`status_admin`='active') AND `bx_timeline_handlers`.`id` NOT IN (44,4) AND IF(`te`.`system`='0' AND `te`.`object_id` = 8612, 1, `te`.`date` <= UNIX_TIMESTAMP()) AND ((`te`.`owner_id` = 8612) OR (`te`.`owner_id` = '0' AND IF(`te`.`system`='0', `te`.`object_id` = 8612, 1)))  ORDER BY `te`.`sticked` DESC, `te`.`reacted` DESC, `te`.`id` DESC LIMIT 0, 6) UNION (SELECT `te`.*
            FROM `bx_timeline_events` AS `te`
            LEFT JOIN `bx_timeline_handlers` ON `te`.`type`=`bx_timeline_handlers`.`alert_unit` AND `te`.`action`=`bx_timeline_handlers`.`alert_action` INNER JOIN `sys_profiles` AS `tpoo` ON ABS(`te`.`object_owner_id`)=`tpoo`.`id` AND `tpoo`.`status`='active' INNER JOIN `sys_profiles_conn_subscriptions` AS `c` ON `c`.`content` = `te`.`owner_id` AND `c`.`initiator` = 8612
            WHERE 1  AND `bx_timeline_events`.`owner_id` NOT IN (9966) AND `bx_timeline_events`.`object_owner_id` NOT IN (9966)AND `te`.`active`='1' AND `te`.`status`='active'  AND IF(`te`.`system`='0' AND (`te`.`object_owner_id`=8612), 1, `te`.`status_admin`='active') AND `bx_timeline_handlers`.`id` NOT IN (44,4) AND IF(`te`.`system`='0' AND `te`.`object_id` = 8612, 1, `te`.`date` <= UNIX_TIMESTAMP()) AND `te`.`type`<>'bx_channels'  ORDER BY `te`.`sticked` DESC, `te`.`reacted` DESC, `te`.`id` DESC LIMIT 0, 6) UNION (SELECT `te`.*
            FROM `bx_timeline_events` AS `te`
            LEFT JOIN `bx_timeline_handlers` ON `te`.`type`=`bx_timeline_handlers`.`alert_unit` AND `te`.`action`=`bx_timeline_handlers`.`alert_action` INNER JOIN `sys_profiles` AS `tpoo` ON ABS(`te`.`object_owner_id`)=`tpoo`.`id` AND `tpoo`.`status`='active' INNER JOIN `sys_profiles_conn_subscriptions` AS `cc` ON `te`.`system` = 0 AND `te`.`object_privacy_view` > 0 AND `cc`.`content` = `te`.`object_owner_id` AND `cc`.`initiator` = 8612
            WHERE 1  AND `bx_timeline_events`.`owner_id` NOT IN (9966) AND `bx_timeline_events`.`object_owner_id` NOT IN (9966)AND `te`.`active`='1' AND `te`.`status`='active'  AND IF(`te`.`system`='0' AND (`te`.`object_owner_id`=8612), 1, `te`.`status_admin`='active') AND `bx_timeline_handlers`.`id` NOT IN (44,4) AND IF(`te`.`system`='0' AND `te`.`object_id` = 8612, 1, `te`.`date` <= UNIX_TIMESTAMP()) AND 1  ORDER BY `te`.`sticked` DESC, `te`.`reacted` DESC, `te`.`id` DESC LIMIT 0, 6) UNION (SELECT `te`.*
            FROM `bx_timeline_events` AS `te`
            LEFT JOIN `bx_timeline_handlers` ON `te`.`type`=`bx_timeline_handlers`.`alert_unit` AND `te`.`action`=`bx_timeline_handlers`.`alert_action` INNER JOIN `sys_profiles` AS `tpoo` ON ABS(`te`.`object_owner_id`)=`tpoo`.`id` AND `tpoo`.`status`='active'  
            WHERE 1  AND `bx_timeline_events`.`owner_id` NOT IN (9966) AND `bx_timeline_events`.`object_owner_id` NOT IN (9966)AND `te`.`active`='1' AND `te`.`status`='active'  AND IF(`te`.`system`='0' AND (`te`.`object_owner_id`=8612), 1, `te`.`status_admin`='active') AND `bx_timeline_handlers`.`id` NOT IN (44,4) AND IF(`te`.`system`='0' AND `te`.`object_id` = 8612, 1, `te`.`date` <= UNIX_TIMESTAMP()) AND `te`.`promoted` <> '0'  ORDER BY `te`.`sticked` DESC, `te`.`reacted` DESC, `te`.`id` DESC LIMIT 0, 6) ORDER BY `sticked` DESC, `reacted` DESC, `id` DESC LIMIT 0, 6
  Account ID: 4306

Hello Everyone!

I been thinking of moving my community from Dolphin 7.3.5 to UNA. There used to be a conversion tool, but i don't see any reference to it anywhere.

It would be amazing if someone could point me in the right direction!

Thanks

Ran into a roadblock on a new install. After uploading a 1.4Gb test video, it converted to ~200mb but leaves the original upload file in storage.

Want to move users from dolphin, and were a video heavy site - making this a huge problem.

Known issue? Any suggestions?

Saying I’m regretting switching from dolphin to una is an understatement.

Where is the best place to hire developers? I really want the timeline improved or redone so it’s not the weak link making my site look dead.