954,600 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

InnoDB Database issue

Hello all.
I'm working on wiki development now and have some issue with MySQL. I am using InnoDB engine to store wiki data. Sometimes updating data with wiki Database class $dbw->update()
do not update my database data (I can see it via phpMyAdmin). When debbuging the code I've found that no sql errors occured and the final stage of function call mysql_query() returns true. But nothing changed in database. Whan executing the final sql in phpMyAdmin all is ok. And it's interesting that this issue never arises if i'm using MyIsam table engine. It may be table or row locking I think? Can anyone help me, please.

Harutyun
Newbie Poster
9 posts since Jan 2009
Reputation Points: 10
Solved Threads: 0
 

It's solved now. Just added

mysql_query("COMMIT")


after update query.

Harutyun
Newbie Poster
9 posts since Jan 2009
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You