Note the upgraded forum! If you are experiencing issues logging in, you may need to reset your password which should send an email. If the email doesn't arrive, be sure to check your spam folder just in case.

Database Error Occured

edited January 2011 in News & Announcements
Hi,

I am facing below error, while clicking on "validate" or "Page Analytics" Link.


A Database Error Occurred

Error Number: 1146

Table 'fuel.domain_main' doesn't exist

SELECT `domain_main`.* FROM (`domain_main`)


my table name is "aks_domain"
my module name is "domain"

Here is the code of config/domain_fuel_modules.php

$config['modules']['domain_main'] = array( 'module_name' => 'Sub Domain', 'module_uri' => 'domain/main', 'model_name' => 'domain_main_model', 'model_location' => 'domain', 'display_field' => 'sub_domain', 'preview_path' => 'domain/main/{id}', 'permission' => 'domain/main', 'instructions' => 'Manage Sub Domain', 'archivable' => TRUE, 'configuration' => array('domain' => 'domain'), 'nav_selected' => 'domain/main', 'sanitize_input' => array('template','php') );

config/domain.php

// tables for Ads $config['tables']['domain_main'] = 'aks_domain'; $config['tables']['domain_pages'] = 'aks_pages'; $config['tables']['domain_setting'] = 'aks_setting';


NOTE : Inside domain module all model is working perfectly, (Add/Edit/Delete all are working fine)

I am not getting why above error is coming? and from which file?

Comments

  • edited 8:46PM
    Can you send me the module and SQL so I can examine it locally?
  • edited 8:46PM
    Mail Sent
  • edited 8:46PM
    There is a second parameter you can pass in the constructor which is the module folder name (see for example any of the blog models). This tells it what config to load in that has the table names.
    function __construct() { parent::__construct('domain_main', 'domain'); }
  • edited 8:46PM
    Got it, Thanks !!!
Sign In or Register to comment.