Script terminated or some other problem?

[Chris]

Code: [Select]

ignore_user_abort(true);
mysql_query("INSERT INTO table_a ...");
mysql_query("UPDATE table_b ...");
I'm getting reports from players that would indicate that the UPDATE part very rarely is not executed. Neither I nor my testers could reproduce it.

Any idea what could be the cause? What theoretically could cause it?

[jack13580]

unless you show the full code can't help you here

[capturts]

One suggestion I could give is maybe the update statement might be something like this:

Code: [Select]

"update my_table set foo="bar" where baz = $something"
If $something doesn't always get set to what it should be because of some rarely occurring conflict, for example, the update statement won't update anything. I suggest the following:

Code: [Select]

$query="update blah blah blah".
mysql_query($query);
file_put_contents('query.log', $query, FILE_APPEND | LOCK_EX);

This will log the query each time into query.log (make sure it's writable by the script). After a while look through and see if there are any query's with missing bits or whatever.