#1484: Sqlite transaction fail
------------------------------+---------------------------------------------
Reporter: quocbao | Owner: romanb
Type: defect | Status: new
Priority: blocker | Milestone: 1.0.3
Component: Query/Hydration | Version: 1.0
Resolution: | Keywords:
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Old description:
> I use doctrine with sqlite (version 1) and got a problem :
>
> definition
> {{{
> class MailMessage extends BaseModel
> {
> public function setup()
> {
>
> }
>
> public function setTableDefinition()
> {
> $this->setTableName('messages');
>
> $this->hasColumn('mid as Id','integer','4');
> $this->hasColumn('mail_from as From','string','250');
> $this->hasColumn('mail_to as To','string','250');
> $this->hasColumn('mail_subject as
> Subject','string','250');
> $this->hasColumn('mail_body as Subject','blob');
> }
>
> }
>
> }}}
>
> code run
>
> {{{
> $m = new MailMessage();
> $m->save();
> }}}
>
> exception
>
> {{{
> Thee error was :
>
> exception 'Doctrine_Transaction_Exception' with message 'Rollback failed.
> There is no active transaction.' in
> D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Transaction.php:319
> Stack trace:
> #0 D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Connection.php(1417):
> Doctrine_Transaction->rollback(NULL)
> #1
> D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Connection\UnitOfWork.php(127):
> Doctrine_Connection->rollback()
> #2 D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Record.php(1235):
> Doctrine_Connection_UnitOfWork->saveGraph(Object(MailMessage))
> #3 D:\xampp\htdocs\MegoCMS\trunk\cms.php(56): Doctrine_Record->save()
> #4 {main}
> }}}
>
> Got no idea what happened ?
New description:
I use doctrine with sqlite (version 1) and got a problem :
definition
{{{
class MailMessage extends BaseModel
{
public function setup()
{
}
public function setTableDefinition()
{
$this->setTableName('messages');
$this->hasColumn('mid as Id','integer','4');
$this->hasColumn('mail_from as From','string','250');
$this->hasColumn('mail_to as To','string','250');
$this->hasColumn('mail_subject as
Subject','string','250');
$this->hasColumn('mail_body as Subject','blob');
}
}
}}}
dsn
{{{
sqlite:/path-to-db/mail.sqlite
}}}
code run
{{{
$m = new MailMessage();
$m->save();
}}}
exception
{{{
Thee error was :
exception 'Doctrine_Transaction_Exception' with message 'Rollback failed.
There is no active transaction.' in
D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Transaction.php:319
Stack trace:
#0 D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Connection.php(1417):
Doctrine_Transaction->rollback(NULL)
#1
D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Connection\UnitOfWork.php(127):
Doctrine_Connection->rollback()
#2 D:\xampp\htdocs\MegoCMS\trunk\pear\Doctrine\Record.php(1235):
Doctrine_Connection_UnitOfWork->saveGraph(Object(MailMessage))
#3 D:\xampp\htdocs\MegoCMS\trunk\cms.php(56): Doctrine_Record->save()
#4 {main}
}}}
Got no idea what happened ?
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1484#comment:1>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
