DatabaseException
SQL Query Problem: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd046988c.mod_content' doesn't exist
SQL String
CREATE VIEW contents AS SELECT
  mod_content.id,
    mod_content.name,
    mod_content.created_at,
    mod_content.status,
    mod_content.content,
    mod_content.summary,
    mod_content.seo,
    mod_content.title,
    mod_content.keywords,
    mod_content.description,
    mod_content.gallery_id AS gallery_id,
    mod_content.acl_id AS acl_id,
    mod_content.deck,
    mod_content.image,
    mod_content.file_id AS file_id,
    mod_content.lang,
    mod_content.video,
    mod_category.name AS category_name,
    mod_category.seo AS category_seo,
    mod_category.id AS category_id,
    mod_user.username,
    mod_user.id AS user_id,
    mod_user.name AS u_name,
    mod_user.last_name AS u_last_name,
    mod_user_group.name AS group_name,
    ( SELECT count(mod_gallery.id) AS count
           FROM mod_gallery
          WHERE mod_content.id = mod_gallery.vid
          AND mod_gallery.mod_name='mod_content') AS gallery_count
   FROM mod_content
   LEFT JOIN mod_user ON mod_content.user_id = mod_user.id
   LEFT JOIN mod_user_group ON mod_user.group_id = mod_user_group.group_id
   LEFT JOIN mod_category ON mod_content.category_id = mod_category.id
Database Says
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd046988c.mod_content' doesn't exist
Error
File:/www/htdocs/w00ecc9d/site/lib/Database/Adapter/PDO_MYSQL.php
Line:94
Calling Files
Class:Amed
Function:__destruct
Args:Array
(
)

Trac String
#0 /www/htdocs/w00ecc9d/site/lib/Database/Database.php(126): Adapter_PDO_MYSQL->query('CREATE VIEW con...')
#1 /www/htdocs/w00ecc9d/site/lib/Database/Database.php(103): Database->_query()
#2 /www/htdocs/w00ecc9d/site/mod/mod_content/model/contents.model.php(81): Database->query('CREATE VIEW con...')
#3 /www/htdocs/w00ecc9d/site/mod/mod_content/model/contents.model.php(37): contents_model->ensureViewExists()
#4 /www/htdocs/w00ecc9d/site/lib/Load.class.php(214): contents_model->__construct()
#5 /www/htdocs/w00ecc9d/site/mod/index/indexBase.php(284): Load::model('mod_content.con...')
#6 /www/htdocs/w00ecc9d/site/mod/index/helper/mod_page.helper.php(32): indexBase->_related_content(NULL)
#7 /www/htdocs/w00ecc9d/site/mod/index/index.php(21): mod_page_helper->page('contact')
#8 /www/htdocs/w00ecc9d/site/lib/Run.class.php(31): index_mod->page('contact')
#9 /www/htdocs/w00ecc9d/site/lib/Amed.class.php(295): Run::calistir(Object(index_mod), 'page', Array)
#10 [internal function]: Amed->__destruct()
#11 {main}

DatabaseException
SQL Query Problem: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd046988c.mod_content' doesn't exist
SQL Query
CREATE VIEW contents AS SELECT
  mod_content.id,
    mod_content.name,
    mod_content.created_at,
    mod_content.status,
    mod_content.content,
    mod_content.summary,
    mod_content.seo,
    mod_content.title,
    mod_content.keywords,
    mod_content.description,
    mod_content.gallery_id AS gallery_id,
    mod_content.acl_id AS acl_id,
    mod_content.deck,
    mod_content.image,
    mod_content.file_id AS file_id,
    mod_content.lang,
    mod_content.video,
    mod_category.name AS category_name,
    mod_category.seo AS category_seo,
    mod_category.id AS category_id,
    mod_user.username,
    mod_user.id AS user_id,
    mod_user.name AS u_name,
    mod_user.last_name AS u_last_name,
    mod_user_group.name AS group_name,
    ( SELECT count(mod_gallery.id) AS count
           FROM mod_gallery
          WHERE mod_content.id = mod_gallery.vid
          AND mod_gallery.mod_name='mod_content') AS gallery_count
   FROM mod_content
   LEFT JOIN mod_user ON mod_content.user_id = mod_user.id
   LEFT JOIN mod_user_group ON mod_user.group_id = mod_user_group.group_id
   LEFT JOIN mod_category ON mod_content.category_id = mod_category.id
Database Error Message
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd046988c.mod_content' doesn't exist
Error Line and File
File:/www/htdocs/w00ecc9d/site/lib/Database/Adapter/PDO_MYSQL.php
Line:94
Error Trigerring Use
Class:Amed
Function:__destruct
Args:Array
(
)

Trac String
#0 /www/htdocs/w00ecc9d/site/lib/Database/Database.php(126): Adapter_PDO_MYSQL->query('CREATE VIEW con...')
#1 /www/htdocs/w00ecc9d/site/lib/Database/Database.php(103): Database->_query()
#2 /www/htdocs/w00ecc9d/site/mod/mod_content/model/contents.model.php(81): Database->query('CREATE VIEW con...')
#3 /www/htdocs/w00ecc9d/site/mod/mod_content/model/contents.model.php(37): contents_model->ensureViewExists()
#4 /www/htdocs/w00ecc9d/site/lib/Load.class.php(214): contents_model->__construct()
#5 /www/htdocs/w00ecc9d/site/mod/index/indexBase.php(284): Load::model('mod_content.con...')
#6 /www/htdocs/w00ecc9d/site/mod/index/helper/mod_page.helper.php(32): indexBase->_related_content(NULL)
#7 /www/htdocs/w00ecc9d/site/mod/index/index.php(21): mod_page_helper->page('contact')
#8 /www/htdocs/w00ecc9d/site/lib/Run.class.php(31): index_mod->page('contact')
#9 /www/htdocs/w00ecc9d/site/lib/Amed.class.php(295): Run::calistir(Object(index_mod), 'page', Array)
#10 [internal function]: Amed->__destruct()
#11 {main}