title: Codeigniter database issue on live server
body: <p>Hi guys I would really appreciate if you could help my with this problem I am facing with codeigniter on live server. Everything works fine on localhost however for unknown reason active record doesn’t work on live server. I am not being able to perform any type of queries and have been trying to fix it for days now. I am not getting any errors related to database connection and I am also sure that all the database configuration details are correct and also all the user privileges. </p>
  
  <p>Database.php </p>
  
  <pre><code>$active_group = 'default';
  $active_record = TRUE;
  
  $db['default']['hostname'] = '111.11.111.111';
  $db['default']['username'] = 'username';
  $db['default']['password'] = 'password';
  $db['default']['database'] = 'database';
  $db['default']['dbdriver'] = 'mysql';
  $db['default']['dbprefix'] = '';
  $db['default']['pconnect'] = TRUE;
  $db['default']['db_debug'] = False;
  $db['default']['cache_on'] = FALSE;
  $db['default']['cachedir'] = '';
  $db['default']['char_set'] = 'utf8';
  $db['default']['dbcollat'] = 'utf8_general_ci';
  $db['default']['swap_pre'] = '';
  $db['default']['autoinit'] = TRUE;
  $db['default']['stricton'] = FALSE;
  
  Example: $this-&gt;db-&gt;query("TRUNCATE TABLE test");
  </code></pre>
  
  <p>I know I am using active records correctly as it works fine on localhost just don’t seem to understand what the problem is on live server. Thank you for your time and help guys. </p>