When I updated to v2.23, the player and studio stopped working.
That is the error I’m getting:
==> /opt/kaltura/log/kaltura_apache_errors.log <==
[Mon Dec 15 07:45:54 2014] [error] [client 10.100.22.0] script ‘/opt/kaltura/web/html5/html5lib/v2.22/mwEmbedLoader.php’ not found or unable to stat, referer: http://backend1.flomina.com/apps/studio/v1.9.1/index.html
How did you do the update? if you created a whole new player folder called v2.23 then you have to change the “html5_version” in base.ini (/opt/kaltura/app/configurations/base.ini)
Try change that, restart httpd and clear cache and test again.
I updated using the RPM update procedure for centos.
I changes base.ini html5_version to v2.23, removed the cache and restarted httpd.
Still have the same error:
==> /opt/kaltura/log/kaltura_apache_errors.log <==
[Mon Dec 15 12:42:49 2014] [error] [client 10.100.101.1] script ‘/opt/kaltura/web/html5/html5lib/v2.22/mwEmbedLoader.php’ not found or unable to stat, referer: http://backend1.flomina.com/apps/studio/v1.9.1/index.html
There’s something still linking to v2.22 instead of udpated v2.23
Your problem is a missing stored procedure - kalturadw.calc_partner_usage_data.
I am not sure how this happened to you since when a DB exists, it does not get deleted or updated when running kaltura-config-all.sh since it check whether or not the DB exists and skips if so.
You can, AFTER creating backups of the entire DB just in case, drop all the DWH DBs using:
PASSWD=YOURPASSWD
for i in mysql -N -p$PASSWD kalturadw_bisources -e "show tables";do mysql -p$PASSWD kalturadw_bisources -e “drop table $i”;done
for i in mysql -N -p$PASSWD kalturadw -e "show tables";do mysql -p$PASSWD kalturadw -e “drop table $i”;done
for i in mysql -N -p$PASSWD kalturadw_ds -e "show tables";do mysql -p$PASSWD kalturadw_ds -e “drop table $i”;done
for i in mysql -N -p$PASSWD kalturalog -e "show tables";do mysql -p$PASSWD kalturalog -e “drop table $i”;done
for i in mysql -p$PASSWD -e "Show procedure status" |grep kalturadw|awk -F " " '{print $2}';do mysql kalturadw -p$PASSWD -e “drop procedure $i;”;done
for i in mysql -p$PASSWD -e "Show procedure status" |grep kalturadw_ds|awk -F " " '{print $2}';do mysql kalturadw_ds -p$PASSWD -e “drop procedure $i;”;done