Re: Adding a fixtures causes infinite error

I have partly resolved this by downloading the latest version of Debug Toolkit as that was not handling the underlying error properly (http://cakephp.lighthouseapp.com/projects/42880/tickets/91-serializing-pdo-instances). I now just need to learn more about using fixtures as it is causing a 'table already exists' error. Why would that happen if I've specified a fixture, or am I missing something fundamental?

On Friday, 3 August 2012 06:44:12 UTC+1, Jeremy Burns wrote:

To my shame, I haven't done much with testing but have taken the plunge and am adopting it for all future projects, starting now.

I have the seed of a site that has a database (normal and test version) and model/view/controller. I can access faq_categories/index when using either the normal or test database configuration.

I have a controller test and a model test, both work fine and pass. When I add in a fixture the site goes into an endless spiral. Not sure what I'm doing wrong - here's the model test, the fixture and the errors. Note that it works fine until uncomment the fixture.

// /app/Test/Case/Model/FaqCategoryTest.php

<?php

App::uses('FaqCategory', 'Model');

class FaqCategoryTest extends CakeTestCase {

    

    // public $fixtures = array('app.faq_category');

    

public function setUp() {

parent::setUp();

$this->FaqCategory = ClassRegistry::init('FaqCategory');

}

public function testEnabled() {

$result = $this->FaqCategory->enabled();

$expected = array(

array('FaqCategory' => array('id' => 1, 'name' => 'First Category')),

array('FaqCategory' => array('id' => 3, 'name' => 'Third Category'))

);

$this->assertEquals($expected, $result);

}

    

}

// /app/Test/Fixture/FaqCategoryFixture.php

<?php

class FaqCategoryFixture extends CakeTestFixture {

/* Optional. Set this property to load fixtures to a different test datasource */

public $useDbConfig = 'test';

public $fields = array(

'id' => array(

'type' => 'integer',

'length' => 3,

'key' => 'primary'

),

'name' => array(

'type' => 'string',

'length' => 255,

'null' => false,

'default' => ''

),

'display_order' => array(

'type' => 'integer',

'length' => 3,

'null' => false,

'default' => 255

),

'enabled' => array(

'type' => 'integer',

'length' => 1,

'null' => false,

'default' => 1

),

'created' => 'datetime',

'modified' => 'datetime'

);

public $records = array(

array(

'id' => 1,

'name' => 'First Category',

'display_order' => 10,

'enabled' => 1,

'created' => '2012-08-02 18:00:00',

'modified' => '2012-08-02 18:00:00'

),

array(

'id' => 2,

'name' => 'Second Category',

'display_order' => 20,

'enabled' => 0,

'created' => '2012-08-02 18:00:00',

'modified' => '2012-08-02 18:00:00'

),

array(

'id' => 3,

'name' => 'Third Category',

'display_order' => 30,

'enabled' => 1,

'created' => '2012-08-02 18:00:00',

'modified' => '2012-08-02 18:00:00'

)

);

}

// RESULTS

// without a fixture:

1/1 test methods complete: 1 passes, 0 fails, 1 assertions and 0 exceptions.

// with a fixture

// first error only occurs when I specify a db config - but then I would not expect a fixture to create a table - am I wrong? If so, I guess I need to use teardown?

2012-08-03 05:37:16 Error: Fixture creation for "faq_categories" failed "SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'faq_categories' already exists"

// next error (whether the first error is present or not)

#0 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Model/Datasource/DboSource.php(2919): PDOStatement->execute()

#1 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/Fixture/CakeTestFixture.php(254): DboSource->insertMulti('faq_categories', Array, Array)

#2 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/Fixture/CakeFixtureManager.php(215): CakeTestFixture->insert(Object(Mysql))

#3 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/CakeTestCase.php(76): CakeFixtureManager->load(Object(FaqCategoryTest))

#4 /usr/lib/php/pear/PHPUnit/Framework/TestSuite.php(772): CakeTestCase->run(Object(PHPUnit_Framework_TestResult))

#5 /usr/lib/php/pear/PHPUnit/Framework/TestSuite.php(745): PHPUnit_Framework_TestSuite->runTest(Object(FaqCategoryTest), Object(PHPUnit_Framework_TestResult))

#6 /usr/lib/php/pear/PHPUnit/TextUI/TestRunner.php(325): PHPUnit_Framework_TestSuite->run(Object(PHPUnit_Framework_TestResult), false, Array, Array, false)

#7 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/CakeTestRunner.php(57): PHPUnit_TextUI_TestRunner->doRun(Object(PHPUnit_Framework_TestSuite), Array)

#8 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/CakeTestSuiteCommand.php(111): CakeTestRunner->doRun(Object(PHPUnit_Framework_TestSuite), Array)

#9 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/CakeTestSuiteDispatcher.php(242): CakeTestSuiteCommand->run(Array)

#10 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/CakeTestSuiteDispatcher.php(99): CakeTestSuiteDispatcher->_runTestCase()

#11 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/TestSuite/CakeTestSuiteDispatcher.php(116): CakeTestSuiteDispatcher->dispatch()

#12 /Volumes/Data/jeremyburns/Sites/mysite/app/webroot/test.php(92): CakeTestSuiteDispatcher::run()

#13 {main}

2012-08-03 05:37:16 Error: Fatal Error (256): [PDOException] You cannot serialize or unserialize PDO instances

// and then this block repeats

#0 [internal function]: PDO->__sleep()

#1 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Cache/Engine/FileEngine.php(131): serialize(Array)

#2 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Cache/Cache.php(298): FileEngine->write('cake_toolbar_ca...', Array, 14400)

#3 /Volumes/Data/jeremyburns/Sites/mysite/app/Plugin/DebugKit/Controller/Component/ToolbarComponent.php(368): Cache::write('toolbar_cache5b...', Array, 'debug_kit')

#4 /Volumes/Data/jeremyburns/Sites/mysite/app/Plugin/DebugKit/Controller/Component/ToolbarComponent.php(233): ToolbarComponent->_saveState(Object(CakeErrorController), Array)

#5 [internal function]: ToolbarComponent->beforeRender(Object(CakeErrorController))

#6 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Utility/ObjectCollection.php(130): call_user_func_array(Array, Array)

#7 [internal function]: ObjectCollection->trigger(Object(CakeEvent))

#8 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Event/CakeEventManager.php(246): call_user_func(Array, Object(CakeEvent))

#9 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Controller/Controller.php(922): CakeEventManager->dispatch(Object(CakeEvent))

#10 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Error/ExceptionRenderer.php(297): Controller->render('error500')

#11 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Error/ExceptionRenderer.php(278): ExceptionRenderer->_outputMessageSafe('error500')

#12 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Error/ExceptionRenderer.php(257): ExceptionRenderer->_outputMessage('pdo_error')

#13 [internal function]: ExceptionRenderer->pdoError(Object(PDOException))

#14 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Error/ExceptionRenderer.php(170): call_user_func_array(Array, Array)

#15 /Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Error/ErrorHandler.php(127): ExceptionRenderer->render()

#16 [internal function]: ErrorHandler::handleException(Object(PDOException))

#17 {main} in [/Volumes/Data/jeremyburns/Sites/mysite/lib/Cake/Error/ErrorHandler.php, line 136]

2012-08-03 05:37:16 Error: [FatalErrorException] [PDOException] You cannot serialize or unserialize PDO instances

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php