Transactions: Table doesn't exist on database when dumping meta-data for model

Question

Transactions: Table doesn't exist on database when dumping meta-data for model

arantir Feb '13

Created Feb '13	Last Reply Nov '15	Replies 3	Views 2060	Votes 3

arantir 32.5k

Feb '13

Why does this Phalcon\Exception: Table "someDatabaseName" doesn't exist on database when dumping meta-data for MyModelName appear in such line:

$someMyModelInstance->setTransaction($transaction);

?

I use exactly same way as in https://docs.phalcon.io/en/latest/reference/models.html#isolated-transactions Also in other cases model works fine (database name and etc. are correct).

3

Phalcon · Answer 1 · 2013-02-27T10:51:03-07:00

An isolated transaction creates a new connection that must be shared by every model involved in the transaction. This means that a transaction cannot be performed over models in different databases servers.

arantir · Answer 2 · 2013-02-27T10:57:07-07:00

Both models in transaction use the same DB. But it has different name from 'db' in dependency injection container. Maybe this is the reason? Should I use $manager->setDbService() to sen connection name? If yes, why doesn't it get the name from the affected model?

Phalcon · Answer 3 · 2013-02-27T11:17:12-07:00

Yes, you need to set the database service the transaction must use:

$di['transactionManager'] = function(){
     $tx = new \Phalcon\Mvc\Model\Transaction\Manager();
     $tx->setDbService('x');
     return $tx;
};

Author's posts aren't counted because they could be 'hey I found out more info about this bug' or 'this also happens here when I...', and these aren't replies so other forum members could think the post doesn't need an answer

Programmer · Answer 4 · 2015-11-06T22:14:14-07:00

I got the same error when on multi modules system through following commands : phalcon create-all-models --get-set --mapcolumn --directory apps\frontend\models In controller file along with this I got the error: $ForexRates = ForexRates::find(); print_r($ForexRates);

Got the error: Notice: Array to string conversion in C:\xampp\htdocs\testingtoday\apps\frontend\Module.php on line 78 Notice: Array to string conversion in C:\xampp\htdocs\testingtoday\apps\frontend\Module.php on line 78 Table 'forex_rates' doesn't exist in database when dumping meta-data for testingtoday\frontend\Models\ForexRates

And on following line changed the code : in testingtoday\apps\frontend Module.php

$di['db'] = function () use ($config) { // return new DbAdapter($config->toArray()); //}; To Replaces with : $di['db'] = function() use ($config) { // return new DbAdapter(array( "host" =>$config->database->host, "username" => $config->database->username, "password" => $config->database->password, "dbname" => $config->database->dbname )); };