Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Operator » database engine error
  •  
monkluk

Messages: 7
Karma: 0
Send a private message to this user
Hello world. When you try to log on tab ' auto configured phones ' started to get an error the database engine. There are thoughts of how to fix it?



[08/Jul/2016 01:54:13] [08-Jul-2016 01:54:13] PHP Warning: ibase_execute(): database file appears corrupt () wrong page type page 1684955504 is of wrong type (expected 5, found 0) in /opt/kerio/operator/www/lib/Database.inc on line 248
[08/Jul/2016 01:54:13] Failed to execute query: select distinct PHONE_TYPES.PHONE_TYPES_ID as "x_356",PHONE_TYPES.PROVISIONING_MODULES_ID as "x_3wy",PHONE_TYPES.PHONE_IDENTIFIER as "x_37m",PHONE_TYPES.MAXIMUM_LINES as "x_3q7",PHONE_TYPES.DESCRIPTION as "x_3f9",PHONE_TYPES.SECURE_SUPPORT as "x_3z2",PHONE_TYPES.METADATA_JSON as "_meta_PHONE_TYPES" from PHONE_TYPES where ((PHONE_TYPES.PROVISIONING_MODULES_ID = ?)); values: [15]
[08/Jul/2016 01:54:13] Failed to execute the query.
[08/Jul/2016 01:54:13] [08-Jul-2016 01:54:13] PHP Fatal error: Uncaught exception 'DatabaseError' in /opt/kerio/operator/www/lib/DbHelper.inc:278

  • Attachment: Snap39.jpg
    (Size: 70.76KB, Downloaded 33 times)

[Updated on: Fri, 08 July 2016 02:58]

  •  
Filip Jenicek (Kerio)

Messages: 1050
Karma: 76
Send a private message to this user
Hi,

it seems your configuration database file is corrupted. This is most likely a hard drive error or a result of a power outage.

Is there anything related to the hard drive in the kernel log? If there is, then you should attempt to fix the hardware first.

To fix the database, it might help to make a backup and restore it, or to restore the system to a previously made backup. Otherwise you might have to factory reset Operator and reconfigure it from scratch.

If you want, I can have a look at the installation to identify the error. Contact me at fjenicek<_at_>kerio.com.

Filip
  •  
monkluk

Messages: 7
Karma: 0
Send a private message to this user
Many thanks Fillip. Really was one drive failure. Unfortunately Kerio Operator problems were spotted recently and workable version of the archives have been overwritten.
  •  
monkluk

Messages: 7
Karma: 0
Send a private message to this user
Restoring from backup is not helped. Helped to load old configuration with FTP. Smile
Previous Topic: Auto Attendant script input keys do not work
Next Topic: *8 catch a call - Number is missing in the display
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Sun Dec 11 14:48:51 CET 2016

Total time taken to generate the page: 0.01030 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.