By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,046 Members | 1,244 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,046 IT Pros & Developers. It's quick & easy.

Strange Database Error

P: n/a
Okay, I've already managed to track down this bug and fix it. But the thing
is, I'm not quite sure why it happened and it's left me scratching my head.

I was setting up some scripts to display videos embedded in a webpage. The
program does some writing to a database to store captions and such. For
some reason, though, the database writing wasn't working. I'd tested out
the functions in other scripts and they went just fine. I wasn't sure what
was going on. So I tested out the script by stopping it at certain points.
If I stopped the script right after it wrote to the database, then the
database was updated perfectly. So doing this I narrowed down the source of
my problem.

For some reason, the place at fault was much farther down in my code, and it
had nothing to do with database access whatsoever. It was a part of my
script that I set up to embed RealPlayer to play .rm or .ram clips. It came
down to this code (which is part of a larger string to embed the player):

<EMBED src='$videofile' width='$vidwidth' height='$vidheight'
loop='0' type='audio/x-pn-realaudio-plugin' controls='imagewindow'
console='video' autostart='0'>

The problem was that I put in the wrong variable instead of $videofile. So
the player didn't get the right filename and couldn't really play the video.
Once I corrected that, the database problem disappeared.

But how is this code connected to the database in any way whatsoever?? I
just don't get it!
Jan 25 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a

"ljb" <lb**** in message
no** wrote:

Perhaps: script abort caused uncommitted database actions to be rolled
Depends on which database (you didn't say) and if it was auto-committing
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?
Jan 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.