Hi All,
First time it happens when I install EE, just right after I delete the “installer” folder from “system” as usual, I get this error message:
A Database Error Occurred
Error Number: 1146
Table ‘db1279745_ceslectures.exp_sites’ doesn’t exist
SELECT * FROM (`exp_sites`) WHERE `site_id` = 1
Filename: core/EE_Config.php
Line Number: 211
Here’s my config.php file:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/* ExpressionEngine Configuration
-------------------------------------------------------------------*/
$config['app_version'] = "255";
$config['install_lock'] = "";
$config['license_number'] = "0856-5343-4065-8434";
$config['debug'] = "1";
$config['cp_url'] = 'http://www.ceslectureseries.org/admin.php';
$config['system_folder'] = "system";
$config['is_system_on'] = "y";
$config['allow_extensions'] = "y";
$config['site_label'] = 'CES Lecture Series';
$config['cookie_prefix'] = "";
$config['site_url'] = 'http://www.ceslectureseries.org/index.php';
$config['server_path'] = FCPATH;
$config['theme_folder_url'] = $config['site_url']."/themes/";
$config['theme_folder_path'] = $config['server_path']."/themes/";
$config['save_tmpl_files'] = "y";
$config['tmpl_file_basepath'] = $config['server_path']."/templates/";
/* CodeIgniter Configuration
-------------------------------------------------------------------*/
$config['base_url'] = $config['site_url'];
$config['uri_protocol'] = 'AUTO';
$config['language'] = 'english';
$config['charset'] = 'UTF-8';
$config['subclass_prefix'] = 'EE_';
$config['permitted_uri_chars'] = 'a-z 0-9~%.:_\\-';
$config['enable_query_strings'] = FALSE;
$config['directory_trigger'] = 'D';
$config['controller_trigger'] = 'C';
$config['function_trigger'] = 'M';
$config['log_threshold'] = 0;
$config['log_path'] = '';
$config['log_date_format'] = 'Y-m-d H:i:s';
$config['time_reference'] = 'local';
/* End of file config.php */
/* Location: ./system/expressionengine/config/config.php */and here’s my database.php file:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
$active_group = 'expressionengine';
$active_record = TRUE;
$db['expressionengine']['hostname'] = 'mysql1692int.cp.blacknight.com';
$db['expressionengine']['username'] = 'u1279745_ceslec';
$db['expressionengine']['password'] = 'Lectures2';
$db['expressionengine']['database'] = 'db1279745_ceslectures';
$db['expressionengine']['dbdriver'] = 'mysql';
$db['expressionengine']['pconnect'] = FALSE;
$db['expressionengine']['dbprefix'] = 'exp_';
$db['expressionengine']['swap_pre'] = 'exp_';
$db['expressionengine']['db_debug'] = TRUE;
$db['expressionengine']['cache_on'] = FALSE;
$db['expressionengine']['autoinit'] = FALSE;
$db['expressionengine']['char_set'] = 'utf8';
$db['expressionengine']['dbcollat'] = 'utf8_general_ci';
$db['expressionengine']['cachedir'] = '/path_to/system/expressionengine/cache/db_cache/';
/* End of file database.php */
/* Location: ./system/expressionengine/config/database.php */Obviously I tried opening EE_Config.php but I’m not a php developer, I’ve tried all the forums and blogs but I’m still stuck.
I’ve installed EE a million times and this has never happened!
Database is working fine (tested with dbtest.php), checked all URL’s, I’ve downloaded EE directly from my ellislab account, fresh install, fresh database creation on Blacknight.
Is there anybody out there who can help or who has bumped in the same problem?