queXS

ADOConnection problem

Asked by Nicolas Truchaud on 2017-09-20

Hello,

I've just installed queXS on a CentOS server and I get an error when trying to add operators :
ADOConnection._Execute(INSERT INTO operator (`operator_id` ,`username` ,`firstName` ,`lastName`, `Time_zone_name`,`voip`,`chat_enable`,`chat_user`,..., false) % line 1229, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO operator (`operator_id` ,`username` ,`firstName` ,`lastName`, `Time_zone_name`,`voip`,`chat_enable`,`chat_user`,...) % line 114, file: operators.php

The displayed error is : Could not add operator. There may already be an operator of this name: 'jdoe' whatever the operator's login is...

I also have a time zone problem : Your database does not have timezones installed, please see here for details ...
or
Check that you have granted relevant permissions on 'time_zone_...' tables in database named 'mysql'.

Is there a link ?

Question information

Language:: English Edit question

Status:: Solved

For:: queXS Edit question

Assignee:: No assignee Edit question

Solved by:: Adam Zammit

Solved:: 2017-09-27

Last query:: 2017-09-27

Last reply:: 2017-09-25

Link existing bug

Revision history for this message

Adam Zammit (adamzammit) said on 2017-09-21:

Hi Nicolas,

These problems sound related.

Make sure you have the timezone database in mysql installed. See: https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

You may also need to grant permission to the database user. See: https://quexs.acspri.org.au/installation-manual

Adam

Revision history for this message

Nicolas Truchaud (nicktruch) said on 2017-09-21:

Hello,

Thank you for the information provided.

When we check the database timezone configuration, we notice that the database gets timezone information from the operating system :

SELECT @@global.time_zone, @@session.time_zone;
+-------------------------------+-------------------------------+
| @@global.time_zone | @@session.time_zone |
+-----------------------------+-------------------------------+
| SYSTEM | SYSTEM |
+---------------------------+--------------------------------+
and the timezone was already configured like below :