Database Error

• 

  Chris Muench

  • August 07, 2019 02:41

  Did you make any changes to

  Application/hooks/setup_phppos.php

   

  attach this file and I can take look

  0
• 

  Ahmed Gad

  • August 07, 2019 20:35

  <?php
  function remote_addr_set()
  {
  if ($ip = get_real_ip_address())
  {
  $_SERVER['REMOTE_ADDR'] = $ip;
  }
  }
  
  function clear_expired_session_data()
  {
  $CI =& get_instance();
  //use $_SESSION because we need to see expire
  $sess_data = isset($_SESSION) ? $_SESSION : array();
  foreach($sess_data as $sess_key => $sess_data_row)
  {
  if (is_array($sess_data_row) && isset($sess_data_row['expire']))
  {
  if ($sess_data_row['expire'] <= time())
  {
  $CI->session->unset_userdata($sess_key);
  }
  }
  } 
  
  }
  function setup_mysql()
  {
  $CI =& get_instance();
  
  //Makes sure we have a simple mode that doesn't have strict restrictions
  $CI->db->query('SET SESSION sql_mode=""'); 
  $CI->db->query('SET SESSION optimizer_switch="index_merge_intersection=off"');
  }
  
  //Loads configuration from database into global CI config
  function load_config()
  { 
  $CI =& get_instance();
  
  if ($CI->db->table_exists('app_config'))
  {
  foreach($CI->Appconfig->get_all()->result() as $app_config)
  {
  $CI->config->set_item($app_config->key,$app_config->value);
  
  if ($app_config->key == 'number_of_items_per_page' && $CI->agent->is_mobile())
  {
  $CI->config->set_item($app_config->key,20); 
  }
  }
  
  if($CI->session->userdata('language'))
  {
  $CI->lang->switch_to($CI->session->userdata('language'));
  }
  elseif($CI->Employee->is_logged_in() && $CI->Employee->get_logged_in_employee_info()->language)
  {
  $CI->lang->switch_to($CI->Employee->get_logged_in_employee_info()->language);
  }
  else if ($CI->config->item('language'))
  {
  $CI->lang->switch_to($CI->config->item('language'));
  } 
  date_default_timezone_set('America/New_York');
  define('BUILT_ON_DATE', date(get_date_format(). ' '.get_time_format(), BUILD_TIMESTAMP). ' EST'); 
  
  if ($CI->db->table_exists('locations'))
  {
  if ($CI->Location->get_info_for_key('timezone'))
  {
  date_default_timezone_set($CI->Location->get_info_for_key('timezone'));
  }
  else
  {
  $timezone = $CI->Location->get_info_for_key('timezone',1);
  if (!$timezone)
  {
  $timezone = 'America/New_York';
  }
  
  date_default_timezone_set($timezone);
  }
  }
  } 
  }
  ?>

  0
• 

  Chris Muench

  • August 07, 2019 20:44

  That looks fine

  Try removing

  CI->db->query('SET SESSION sql_mode=""');

  Does this happen all the time? Can you give me access to server (send to chris@phppos.com) will look tomorrow

  0
• 

  Chris Muench

  • August 07, 2019 21:02

  IN application/config/database.php

   

  FIND
  
  

  $db['default']['stricton'] = TRUE;

   

  REPALCE

  $db['default']['stricton'] = FALSE;

  0
• 

  Chris Muench

  • August 07, 2019 21:05

  Remove the entire line that has either

   

  $db['default']['stricton'] = FALSE;

   

  $db['default']['stricton'] = TRUE;

  0
• 

  Ahmed Gad

  • August 07, 2019 21:41

  Hi Chris,

  Removing the entire line:

  $db['default']['stricton'] = FALSE;

  solved the issue.

  Thanks!

  0

Please sign in to leave a comment.