I have a big problem using insert/update queries in mySQL 5.0.24
Sometimes it happens that an insert or update query is not written to the table (or the disc) at once. it seems that it hangs in some cache.
for example: i make an insert on a table (via the website), refresh the website and i can see the changes, but the row is not visible in phpmyadmin. i am also not possible to update the row via the website. it says, that the row does not exist.
after a server restart or a “flush tables” the row appears in phpmyadmin and every update via the website works fine.
where is the row? lost in a cache?
does the setting “flush tables after each SQL command” or “flush time” help?
[B]debug wrote on Fri, 19 September 2008 04:45[/B]
Can't it be some cache on webserver side or maybe phpmyadmin cached in browser? Can you see this new row using console MySQL client?
no it can´t as i try to update the inserted row with the same webpage and it says that the row is not existent.
in detail
it is a picture gallery. i add a picture using the website. the picture is displayed. then i open a page to update the data (like category, etc.) and the main data like pictureID and anything else is shown properly (which means that the select statement works and the row of the picture exists) but then i send up the form which sets an update-statement on this picture and i got an error, that the key (pictureID) does not exist. i look inside phpmyadmin and the row of the picture does not exist.
after i “flush tables” the row appears in phpmyadmin and the update of the picture works fine.