3 messages in com.mysql.lists.perlRe: phantom records| Subject: | Re: phantom records |
|---|---|
| From: | webmaster (webm...@simplemood.com) |
| Date: | 01/26/2003 09:56:49 AM |
| List: | com.mysql.lists.perl |
Thanks for your input. I'll try that suggertion. I know that there's bound to beissues with local/remote server stuf but thethingthat really gets me is that the records are not it in the actual table but theremote script sees them fust fine as if they were.
I was wondering if there is some kind of queue or something that remote requests get put in that would cause the remote script to see records it added but that havn't actually been put in the table yet.
Is there anything like that?
I'll see if I can't norrow it down and try script with just the code that is acting oddly. And go form there.
It would be helpful to see a snippet of your code. I have had cross-server problems in the past and mostly they were related to environmental issues (time zone, user authorization, etc) but it is not a fixed rule.
What I can suggest is to isolate the problem.
Make a test script with the minimum code that reproduces the problem using a freshly made test database with a newly defined user. If this does not give you a clue on where the problem lies, then publish your test code with the test database info (either at msql-mysql-modules or in www.perlmonks.org and I recommend the latter) so that somebody can reproduce your problem and give you a hint.
Good luck
gmax