questionnaire shift issue

Hi Nicolas,

Can you please confirm what version of mysql you are using and what version of PHP on what operating system?

Also please confirm that the database user for queXS is either a superuser or has read access to the mysql timezone table - for example:

GRANT select on mysql.time_zone_transition_type to 'quexs'@'localhost' IDENTIFIED BY 'password' ;
GRANT select on mysql.time_zone_transition to 'quexs'@'localhost' IDENTIFIED BY 'password' ;
GRANT select on mysql.time_zone_leap_second to 'quexs'@'localhost' IDENTIFIED BY 'password' ;
GRANT select on mysql.time_zone to 'quexs'@'localhost' IDENTIFIED BY 'password' ;
GRANT select on mysql.time_zone_name to 'quexs'@'localhost' IDENTIFIED BY 'password' ;

Adam

Hi Adam,

It has been a long time since our last contact. It's good to read you again.

The mysql user for quexs is a superuser and has access to the mysql timezone table. Right now I'm testing the new quexs release at a Citrix XenServer virtual machine. The base system is a debian 8.5 (kernel 3.16.7 ), MySQL 5.5.49 and PHP 5.6.22

thanks in advance!

Nicolas

Hi Nicolas,

I am currently testing this on a similar virtual machine - can you please send through your config.inc.local.php file (without username/passwords)

Thank you.

Adam

Hi Adam,

here I pasted the config.inc.local.php's content:

 ------>

<?php
/**
 * Configuration file
 *
 *
 * This file is part of queXS
 *
 * queXS is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * queXS is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with queXS; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
 *
 *
 * @author Adam Zammit <email address hidden>
 * @copyright Deakin University 2007,2008
 * @package queXS
 * @subpackage configuration
 * @link http://www.deakin.edu.au/dcarf/ queXS was writen for DCARF - Deakin Computer Assisted Research Facility
 * @license http://opensource.org/licenses/gpl-2.0.php The GNU General Public License (GPL) Version 2
 *
 */

/**
 *
 * Only some of the configuration directives are here. See the file: config.default.php for them all
 *
 * Make your configuration changes in this file only - they will "overwrite" the default configuration
 *
 */

/**
 * VoIP definitions
 */
define('VOIP_ENABLED',true);
define('ALLOW_OPERATOR_EXTENSION_SELECT',true);

/**
 * The Asterisk server conf
 */
define('VOIP_SERVER', '192.168.x.xxx');
define('SUPERVISOR_EXTENSION', "7541");
define('VOIP_ADMIN_USER', 'xxxx');
define('VOIP_ADMIN_PASS', 'xxxx');
define('ORIGINATE_CONTEXT','cati4');
define('MEET_ME_ROOM','6500');

/**
 * Whether to automatically pop up a coding window when the respondent hangs up
 */
define('AUTO_POPUP',false);

/**
 * The number of minutes of inactivity to wait before automatically logging out an operator with an open screen
 * False to disable
 */
define('AUTO_LOGOUT_MINUTES',60);

/**
 * The path to LimeSurvey and queXS from the server root
 */
define('LIME_PATH', 'include/limesurvey/');
define('QUEXS_PATH', '/quexs-1.14.1/');

/**
 * Define how many minutes between each system sort (defaults to 5 as this is a common interval for appointments)
 */
define ('SYSTEM_SORT_MINUTES',5);

/**
 * Temporary upload directory
 */
define('TEMPORARY_DIRECTORY', "/tmp");

/**
 * Database configuration for queXS
 */
define('DB_USER', 'root');
define('DB_PASS', 'xxxxxxx');
define('DB_HOST', '127.0.0.1');
define('DB_NAME', 'quexs');

/**
 * Company Information
 */
if (!defined('COMPANY_NAME')) define ('COMPANY_NAME', 'queXS TEST ');
if (!defined('ADMIN_PANEL_NAME')) define ('ADMIN_PANEL_NAME',' Administration Panel TEST');

?>

<---------------

Hi Nicolas,

I can't replicate this error on my copy of Debian 8.5

Can you please confirm that the operator you are logged in as has their own timezone set : Go to Operator management, then edit the current operator and make sure the timezone is set to a valid one and try again.

Adam