Db2->Createcommand->Queryall Problem

kevkiwi · March 21, 2014, 2:16pm

Hi, I’m having problems getting data from a second database running on a sub-domain on the same web server.

My config:

‘dbnew’=>array(

'connectionString' =&gt; 'mysql:host=localhost;dbname=dbnew',


'emulatePrepare' =&gt; true,


'username' =&gt; 'admin',


'password' =&gt; 'password',


'charset' =&gt; 'utf8',


'enableProfiling' =&gt; false,


'enableParamLogging' =&gt; true,

),

‘dbold’=>array(

'connectionString' =&gt; 'mysql:host=localhost;dbname=dbold',


'emulatePrepare' =&gt; true,


'username' =&gt; 'admin',


'password' =&gt; 'password',


'charset' =&gt; 'utf8',


'enableProfiling' =&gt; false,


'enableParamLogging' =&gt; true,


'class' =&gt; 'CDbConnection',

),

I am trying to import new/changed products from dbold into a slightly new structure in dbnew.

dbold.products has 235 rows

When I run:

$oldproducts = Yii::app()->dbold->createCommand(‘SELECT id FROM products ORDER BY id ASC’)->queryAll();

echo count($oldproducts) . ’ products <br />’;

I get only 57 rows.

If I import the database table into dbnew and then run:

$products = Yii::app()->dbnew->createCommand(‘SELECT id FROM products ORDER BY id ASC’)->queryAll();

echo count($products) . ’ products <br />’;

I get all 235 rows?

Anyone have an idea of what’s going on here?

kevkiwi · March 21, 2014, 3:45pm

Problem solved. It turns out I was targeting an old copy of the DB. Apologies for wasting anyone’s time.