Member Avatar for Harutyun

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.

  • 1 Contributor
  • 1 Reply
  • 62 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Harutyun
Member Avatar for Harutyun

It's solved now. Just added

mysql_query("COMMIT")

after update query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.