My K1000 database is corrupted after update
Hi there,
I went on to my K1000 and it said there was an available update to 6.4 so i updated it, then it rebooted itself and didn't come back up properly. I couldn't ping it or login via ESXi console so I did a hard reboot and it came up properly but when I go to the website now it says:
PHP Error: Uncaught ADODB_Exception in /kbox/kboxwww/include/KPermission.class.php on line 210: mysqli error: [1146: Table 'ORG1.USER_ROLE_PERMISSION_VALUE' doesn't exist] in EXECUTE("select PD.FILE_NAME
from KBSYS.PERMISSION_DEFINITION as PD,
ORG1.USER_ROLE_PERMISSION_VALUE UV
where PD.GROUP like '%AdminUI%'
and PD.PARENT_ID != 0
and PD.NAME in ('Dashboard','Search')
and PD.ID = UV.PERMISSION_ID
and UV.ROLE_ID = '1'
and UV.VALUE != 'HIDE'
order by ID")
from KBSYS.PERMISSION_DEFINITION as PD,
ORG1.USER_ROLE_PERMISSION_VALUE UV
where PD.GROUP like '%AdminUI%'
and PD.PARENT_ID != 0
and PD.NAME in ('Dashboard','Search')
and PD.ID = UV.PERMISSION_ID
and UV.ROLE_ID = '1'
and UV.VALUE != 'HIDE'
order by ID")
Is there any way to fix it?
Any help gratefully received.
Thanks!
Alastair Ferguson
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
anonymous_9363
7 years ago
Why not simply restore from the back-up/snapshot you took before doing the update?
