Databases
StackOverflow2013
Postsdbo
POZend_Db_Table Base table or view not found
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POZend_Db_Table Base table or view not found
    primarykey
    data
    text
    <p>I have taken over an application written with the use of the Zend MVC and Zend_Db_Table for DB access. I am trying to add a new table but get the error:</p> <pre><code>Base table or view not found: 1146 Table 'maa_agencies.contact' doesn't exist </code></pre> <p>However maa_agcencies.contact very much DOES exists and is in the same DB as the rest of the tables being accessed.</p> <p>Here are my steps and code:</p> <p>Step 1:</p> <p>Create the Model Class</p> <p>file: application/models/DbTable/Contact.php</p> <pre><code>class Model_DbTable_Contact extends Zend_Db_Table_Abstract { protected $_name = 'contact'; } </code></pre> <p>Step 2:</p> <p>Instantiate the Class the same way it's done a dozen time in a controller (all other tables work) </p> <p>file: application/modules/agency/controllers/IndexController.php (also step 3)</p> <pre><code>$agency_contact = new Model_DbTable_Contact(); </code></pre> <p>Step 3:</p> <p>Write my data to my new table ($store_contact is an assoc array with key = column name value = value)</p> <pre><code>$agency_contact-&gt;insert($store_contact); </code></pre> <p>Is there some caching function in Zend I am unaware of? </p> <p>Some special thing I need to do to tell it I added a new table?</p> <p>All documentation I have come across says this is all that is required, and as I state above the file I am trying to access my table through is already accessing 2 other tables in the same DB, in fact the line just above where I instantiate my Contact model is this statement that works fine:</p> <pre><code>$sm = new Model_DbTable_SentEmail(); </code></pre> <p>The name space idea seems awesome! If this system wasn't some bastardization of the framework. Here is a currently working Model</p> <pre><code>/** * @category Model_DbTable * @package Model_DbTable_States class Model_DbTable_States extends Zend_Db_Table_Abstract { protected $_name = 'state_list'; } </code></pre> <p>Is there some vodoo in the commenting perhaps, I am unable to find anywhere in the code where a namespace is registered at all.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USZjoia
    1. USZjoia
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COperhaps there is a way to like reinitialize the DB connection and rebuild some hidden schema file somewhere? I wouldn't imagine it checks the DB schema each time a connection is made there has to be a cached version somewhere that can be refreshed.
      singulars
      1. POZend_Db_Table Base table or view not found
      1. USZjoia
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload