Help,
I have a query in one of my PHPO scripts that updates a long_text field.
-------oOo-------
$insert_result2 = mysql_query("UPDATE calls
SET full_log = '$new_full_log'
WHERE dws_call_id = '$call_id'");
-------oOo-------
Sometimes this works, and once it has worked it will continue to work, but after you leave the system alone for a while, it doesn't work.
MySQL returns error number 0 (which to my knowledge means no error) and no error message.
If I then edit the record via the console or phpMyAdmin, I can use my script again quite happily.
This phenomenon only seems to happen when I have a query which updates long_text fields.
Is there something about the way you use long text fields that I don't know. I thought maybe there is some sort of pointer that I have to reference so the mysql doesn't lose it's place, but that's my only idea.
-- Nick Gushlow
I have a query in one of my PHPO scripts that updates a long_text field.
-------oOo-------
$insert_result2 = mysql_query("UPDATE calls
SET full_log = '$new_full_log'
WHERE dws_call_id = '$call_id'");
-------oOo-------
Sometimes this works, and once it has worked it will continue to work, but after you leave the system alone for a while, it doesn't work.
MySQL returns error number 0 (which to my knowledge means no error) and no error message.
If I then edit the record via the console or phpMyAdmin, I can use my script again quite happily.
This phenomenon only seems to happen when I have a query which updates long_text fields.
Is there something about the way you use long text fields that I don't know. I thought maybe there is some sort of pointer that I have to reference so the mysql doesn't lose it's place, but that's my only idea.
-- Nick Gushlow