You are here: Re: Strange Database Error « PHP Programming Language « IT news, forums, messages
Re: Strange Database Error

Posted by ljb on 01/26/07 02:15

none@ofyourbusiness.com wrote:
>
> "ljb" <lbayuk@pobox.com.no.spam.> wrote in message
> news:ORUth.18552$X72.5278@newsread3.news.pas.earthlink.net...
>> none@ofyourbusiness.com wrote:
>>
>> Perhaps: script abort caused uncommitted database actions to be rolled
>> back?
>> Depends on which database (you didn't say) and if it was auto-committing
>> or
>> not, but it is possible.
>>
>
> It's a MySQL database. The rest of the page seemed to load up fine, even if
> the realplayer embed didn't quite work properly.
>
> When does a database action become committed?

If a database is doing "auto-commit", then each SQL statement is committed
as soon as it completes. If not in auto-commit mode, it takes an explicit
SQL "COMMIT" to actually apply the changes. With some databases, if the
connection is closed inside a transaction without a COMMIT, it acts like
you did ROLLBACK and undoes the changes. But it doesn't sound like this
will help. Also I don't know much about MySQL specifically.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация